Prev: DB2 Connection Problem
Next: Reducing Pages HIGHWATER mark
From: Gladiator on 9 Aug 2006 04:05

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..............

From: Gladiator on 9 Aug 2006 05:59

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/infocenter/tivihelp/v3r1/index.jsp?topic=/com.ibm.itm.doc/PDG_ITM61168.htm


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

From: Knut Stolze on 9 Aug 2006 08:28
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
 | 
Pages: 1
Prev: DB2 Connection Problem
Next: Reducing Pages HIGHWATER mark