Teradata Connector Bulk Load Issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Nagasudheerkumar
Premium Member
Premium Member
Posts: 55
Joined: Tue Apr 24, 2007 1:26 am

Teradata Connector Bulk Load Issue

Post by Nagasudheerkumar »

Hi,

Please find the simple design.

Oracle connector--->Teradata Connector

I am reading oracle table data which is very huge like say 10 million data into the Teradata using Bulk mode to process the data within seconds.
With Immediate mode the above job ran for 4 hours. So went for Bulk mode

Details:
Teradata version : 14.0
Teradata connector:
Bulk mode

I am getting below error while running the above job with Bulk Mode.

RDBMS code 308: PXOPL_Open: shl_load error: No such file or directory

With Immediate mode it is running fine but I want to achieve performance as Immediate is taking so much time.

Please provide me the solutions for the above error.
Workarounds: When I goggled I have got the resolution that I need to set the below environment variables and I did that but still facing the same issue.

TWB_ROOT,SHLIB_PATH,NLS_PATH AND PATH

Thanks,
Sudheer
Nagasudheerkumar
Premium Member
Premium Member
Posts: 55
Joined: Tue Apr 24, 2007 1:26 am

Post by Nagasudheerkumar »

Any updates on the issue?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Apparently not. :(

Rather than continue to wait and hope someone with the requisite experience comes by, have you involved your official support provider?
-craig

"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Try job 1 Oracle to Data Set and job 2 Data Set to Teradata with bulk load.
Choose a job you love, and you will never have to work a day in your life. - Confucius
kcirtap24
Premium Member
Premium Member
Posts: 9
Joined: Tue Jan 15, 2013 7:47 pm
Location: South Carolina

Post by kcirtap24 »

1. Do other bulk jobs work?
2. What type of 'bulk' are you doing? Load/Update/Stream? (each one has different requirements and connector settings, make sure they are filled out correctly).
3. Add CC_MSG_LEVEL environment variable with value of 2.. you should get some more detail, hopefully helpful
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

To which file/directory does the "no such file" error pertain? Have you incorrectly named a path in the bulk load section?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply