Prev: db2admin server doesn't start, SQL1042C on AIX
Next: Error formatting event log
From: Adman on 25 Oct 2006 15:56
All,

I am experiencing an issue that has confused me, albiet this is not
difficult to do. Any help anyone could provide would be greatly
appreciated.

After our jdbc calls received the following error:
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031

I created additional packages using the following command:
db2 "bind @db2cli.lst blocking all grant public clipkg 30"

I have verified that the SYSLH203 package now exists:

$ db2 "select pkgname from syscat.packages where pkgname like
'SYSLH20%'"

PKGNAME
-------------------------------------------------------------------------------------------------------------------------
SYSLH200
SYSLH201
SYSLH202
SYSLH203
SYSLH204
SYSLH205
....

However, now I am receiving the following error, I assume when the user
is attempting to execute the package:
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -551, SQLSTATE:
42501, SQLERRMC: WH2;EXECUTE;NULLID.SYSLH203

I have executed the following commands according to the IBM
documentation but they did not seem to help.

db2 "bind @db2ubind.lst blocking all grant public"
db2 "bind @db2cli.lst blocking all grant public"

I am running DB2 v8.1 Fix Pack 11 on an IBM AIX server running AIX 5.3.
Here is the version of IBM Java that is installed on the server.

$ ./java -version

java version "1.4.2"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2)

Classic VM (build 1.4.2, J2RE 1.4.2 IBM AIX build ca142-20050929a (SR3)
(JIT enabled: jitc))


I hope I have provided enough information but please let me know if I
left anything out. Any suggestions would be helpful. Are there any
specific grants I need to perform to allow the user to utilize the new
package?

From: Mark A on 25 Oct 2006 19:47
"Adman" <ad_man620(a)yahoo.com> wrote in message
news:1161806176.330883.36660(a)b28g2000cwb.googlegroups.com...
> All,
>
> I am experiencing an issue that has confused me, albiet this is not
> difficult to do. Any help anyone could provide would be greatly
> appreciated.
>
> After our jdbc calls received the following error:
> com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
> 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031
>
> I created additional packages using the following command:
> db2 "bind @db2cli.lst blocking all grant public clipkg 30"
>
> I have verified that the SYSLH203 package now exists:
>
> $ db2 "select pkgname from syscat.packages where pkgname like
> 'SYSLH20%'"
>
> PKGNAME
> -------------------------------------------------------------------------------------------------------------------------
> SYSLH200
> SYSLH201
> SYSLH202
> SYSLH203
> SYSLH204
> SYSLH205
> ...
>
> However, now I am receiving the following error, I assume when the user
> is attempting to execute the package:
> com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -551, SQLSTATE:
> 42501, SQLERRMC: WH2;EXECUTE;NULLID.SYSLH203
>
> I have executed the following commands according to the IBM
> documentation but they did not seem to help.
>
> db2 "bind @db2ubind.lst blocking all grant public"
> db2 "bind @db2cli.lst blocking all grant public"
>
> I am running DB2 v8.1 Fix Pack 11 on an IBM AIX server running AIX 5.3.
> Here is the version of IBM Java that is installed on the server.
>
> $ ./java -version
>
> java version "1.4.2"
>
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2)
>
> Classic VM (build 1.4.2, J2RE 1.4.2 IBM AIX build ca142-20050929a (SR3)
> (JIT enabled: jitc))
>
>
> I hope I have provided enough information but please let me know if I
> left anything out. Any suggestions would be helpful. Are there any
> specific grants I need to perform to allow the user to utilize the new
> package?
>

Try this:

db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG 5

Note: CLIPKG 5 will create 5 large packages, and will give you the package
that your application is looking for, as well as one more in this case. (The
default is 3).

However, the root cause is most likely that your application programs are
not closing cursors as often as they should.


From: Gregor Kova? on 26 Oct 2006 03:46
Adman wrote:

> All,
>
> I am experiencing an issue that has confused me, albiet this is not
> difficult to do. Any help anyone could provide would be greatly
> appreciated.
>
> After our jdbc calls received the following error:
> com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
> 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031
>
> I created additional packages using the following command:
> db2 "bind @db2cli.lst blocking all grant public clipkg 30"
>
> I have verified that the SYSLH203 package now exists:
>
> $ db2 "select pkgname from syscat.packages where pkgname like
> 'SYSLH20%'"
>
> PKGNAME
> -------------------------------------------------------------------------------------------------------------------------
> SYSLH200
> SYSLH201
> SYSLH202
> SYSLH203
> SYSLH204
> SYSLH205
> ...
>
> However, now I am receiving the following error, I assume when the user
> is attempting to execute the package:
> com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -551, SQLSTATE:
> 42501, SQLERRMC: WH2;EXECUTE;NULLID.SYSLH203
>
> I have executed the following commands according to the IBM
> documentation but they did not seem to help.
>
> db2 "bind @db2ubind.lst blocking all grant public"
> db2 "bind @db2cli.lst blocking all grant public"
>
> I am running DB2 v8.1 Fix Pack 11 on an IBM AIX server running AIX 5.3.
> Here is the version of IBM Java that is installed on the server.
>
> $ ./java -version
>
> java version "1.4.2"
>
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2)
>
> Classic VM (build 1.4.2, J2RE 1.4.2 IBM AIX build ca142-20050929a (SR3)
> (JIT enabled: jitc))
>
>
> I hope I have provided enough information but please let me know if I
> left anything out. Any suggestions would be helpful. Are there any
> specific grants I need to perform to allow the user to utilize the new
> package?

Hi!

When I get this error I run:
db2jdbcbind.exe -url jdbc:db2:DATABASE -user DB_USER -password DB_PASS -size
300

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
 | 
Pages: 1
Prev: db2admin server doesn't start, SQL1042C on AIX
Next: Error formatting event log