Dear All,
I am facing an issue with my ETL job and the details are as follows:
The job is retrieving data from DB2 table and writing to a hash file. There is 3 links which executes 3 different SELECT query from 3 diff tables and writes to 3 different hash files.
Scenario:
2 of the links manage to finish but the last one keeps on waiting and then aborts. There are few other diff jobs running parallely with this jobs.
Error Logs:
BTR31VDDSBTM02..SG_SRC_X_AR_2.IDENT3: SQLFetch: Error retrieving results from server.
BTR31VDDSBTM02..SG_SRC_X_AR_2.IDENT3: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
Thank you in advance.
Regards,
Kalyana
[CLI Driver]CLI0125E Function sequence error.SQLSTATE=HY010
Moderators: chulett, rschirm, roy
We have the same issue at our client site, we get that for the jobs which have both odbc and db2 enterprise stages(db2 on remote server).BTR31VDDSBTM02..SG_SRC_X_AR_2.IDENT3: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
This is a bug in Datastage, we contacted IBM support for this they even sent us a patch which worked fine for about a week and now we are back to the same error message.
Here is the solution sent by IBM
set the environment variable OSH_PRELOAD_LIBS to orchodbc:orchdb2op8.
After setting this we still get that error in the log but the job runs just fine.
Just so you know I am not sure if this solution is valid in your case.
Oops Just realised the post is in server forum. I got this problem in parallel environment dont know if it matters.
IHTH
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson