Hi folks,
I am getting following error when i try to run the mapping. i am not even able to import the table also.
"[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553
SQLTables: Error retrieving system catalog information for requested tables(s)."
I tried even changing the DSN.
Thanks in advance
raj
DS mapping Error
Moderators: chulett, rschirm, roy
Hi Koolnitz,
I solved the issue.
This is due to the communication problem between the database and datastage.
When ever we create a DSN for the datastage we bind the ODBC / CLI connections to the database.
Previously my connections were binded and my datastage was running fine. For maintainance we restarted the Data stage and Database. After this we started facing this error. After the restart the connections were not binded. so we manually deleted the prevailing connections and rebinded them. This has to be done at the DB side. Once this is done everything is working fine.
Thanks for the support.
raj
I solved the issue.
This is due to the communication problem between the database and datastage.
When ever we create a DSN for the datastage we bind the ODBC / CLI connections to the database.
Previously my connections were binded and my datastage was running fine. For maintainance we restarted the Data stage and Database. After this we started facing this error. After the restart the connections were not binded. so we manually deleted the prevailing connections and rebinded them. This has to be done at the DB side. Once this is done everything is working fine.
Thanks for the support.
raj