By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,453 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

SQLSTATE 38553

P: n/a

Hai everyone....

When i am trying to access the DB2 from Crystal reports
10.0 in windows Operating system it is giving me the following
Error................

"Query Engine error: [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"

Can anyone pls help me out how to resolve the issue ...........

Regards
Kamal..............

Aug 9 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

Gladiator wrote:
Hai everyone....

When i am trying to access the DB2 from Crystal reports
10.0 in windows Operating system it is giving me the following
Error................

"Query Engine error: [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"

Can anyone pls help me out how to resolve the issue ...........

Regards
Kamal.............

Hey .... Problem Solved....\
I used the Following commands .......

c:\SQLLIB\bnd>DB2 connect to dbname
c:\SQLLIB\bnd>DB2 bind @db2ubind.lst blocking all grant public
c:\SQLLIB\bnd>DB2 bind @db2cli.lst blocking all grant public
c:\SQLLIB\bnd>DB2 bind db2schema.bnd blocking all grant public

Its working fine........... That was the problem with fixpack
upgradation ......

For more info .........

http://publib.boulder.ibm.com/infoce...G_ITM61168.htm
Regards.....
Kamal.................

Aug 9 '06 #2

P: n/a
Gladiator wrote:
>
Gladiator wrote:
>Hai everyone....

When i am trying to access the DB2 from Crystal reports
10.0 in windows Operating system it is giving me the following
Error................

"Query Engine error: [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"

Can anyone pls help me out how to resolve the issue ...........
-805 is a timestamp conflict between application and packages.
c:\SQLLIB\bnd>DB2 connect to dbname
c:\SQLLIB\bnd>DB2 bind @db2ubind.lst blocking all grant public
c:\SQLLIB\bnd>DB2 bind @db2cli.lst blocking all grant public
c:\SQLLIB\bnd>DB2 bind db2schema.bnd blocking all grant public

Its working fine........... That was the problem with fixpack
upgradation ......
Apparently, you skipped the README. ;-)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Aug 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.