DS mapping Error

raj_konig · Post by **raj_konig** » Sat Apr 22, 2006 7:55 am

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

koolnitz · Post by **koolnitz** » Sat Apr 22, 2006 8:08 am

Raj,

Perhaps your database user lacks SELECT privilege on the system tables. Check with your DBA.

raj_konig · Post by **raj_konig** » Sat Apr 22, 2006 8:32 am

Ya i even checked that. The user i am using for Datastage has all the privileges.

raj

koolnitz · Post by **koolnitz** » Sat Apr 22, 2006 8:38 am

The user i am using for Datastage has all the privileges.

Check the user which you are specifying in DB2 stage to connect to database, you did check DataStage user.

raj_konig · Post by **raj_konig** » Sat Apr 22, 2006 9:06 am

yes koolnitz, the user thru which i am connecting to the database has select, create all the privileges. and the user id i used to logon into the datastage has administrator privileges.

raj

raj_konig · Post by **raj_konig** » Sat Apr 22, 2006 9:25 am

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