DSXchange

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

Any updates on the issue?

Apparently not.

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

Try job 1 Oracle to Data Set and job 2 Data Set to Teradata with bulk load.

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

To which file/directory does the "no such file" error pertain? Have you incorrectly named a path in the bulk load section?