Error accessing Package SYSLH203

[Adman]

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?

[Mark A]

"Adman" <ad*******@yahoo.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.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.

[Gregor Kova�]

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