Hi,
We installed Datastage 7.5.2 on UNIX (AIX box of version 5.3) and Source & target database is DB2 version v8.1.1.96.
In intial stage , we run the job in the database of 32 bit.
We reverted the DB to 64 bit from 32 bit and try to run the jobs.
But at present with the 64 bit, we cant able to run the job successfully.
Its gving the following error for all the jobs:
[IBM][CLI Driver][DB2/AIX64] SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-727". SQLSTATE=38553
SQLTables: Error retrieving system catalog information for requested tables(s).
Will any one please give me idea why this error occured.
Thanks for the help.
Error retrieving system catalog information for requested ta
Moderators: chulett, rschirm, roy
Error retrieving system catalog information for requested ta
Raji
Nothing is impossible because impossible itself
says I'm Possible
Nothing is impossible because impossible itself
says I'm Possible
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage is a 32-bit application. You MUST use 32-bit libraries with DataStage, even if these are accessing a 64-bit capable instance of DB2.
Verify that the 32-bit library is referred to first in the shared library search path set up in the dsenv script.
Ask your DBA for information about what the DB2 error codes mean.
Another possibility is that you lack SELECT privilege on the system table referred to in the message.
Verify that the 32-bit library is referred to first in the shared library search path set up in the dsenv script.
Ask your DBA for information about what the DB2 error codes mean.
Another possibility is that you lack SELECT privilege on the system table referred to in the message.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
And if after using the 32bit libraries you still get the "SQL0443N Routine "SYSIBM.SQLTABLES"" you should talk to your DBA's... it's a known problem in DB2 and it requires them to set some extra access rights for your user.
In theory there's no difference between theory and practice. In practice there is.
Read the readme file of your DB2 installation... it will contain something like this which should be executed on the server.
So go to your DBA's, they will need to do this... and apparently are not aware of this :DTo bind db2schema.bnd on the server, execute one of these command
sequences:
At a command prompt:
db2 terminate
db2 CONNECT TO <dbname>
db2 BIND <path>/db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror continue
db2 terminate
or,
At the DB2 command line:
TERMINATE
CONNECT TO <dbname>
BIND <path>/db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror continue
TERMINATE
where <dbname> represents the name of a database to which the utilities
should be bound, and where <path> is the full path name of the directory
where the bind files are located.
In theory there's no difference between theory and practice. In practice there is.