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.
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