Discussion:
NULLID.SYSLH203 -805 Solaris 8,1FP3
(too old to reply)
Friedmar Moch
2004-04-28 19:48:25 UTC
Permalink
Hallo!

We got DB2 Error -805 saying that package NULLID.SYSLH203 is missing.
With db2jdbcbuild ... -size 20 we created additional packages. This
helped for a while, but did not solve the problem.

Could anybody please tell me what this packages are for? I guess, the
reasen for that behaviour is in the application.


Tank you in advance

friedmar
PM (pm3iinc-nospam) CGO
2004-05-02 21:47:08 UTC
Permalink
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=SYSLH203+OR+SYSSH203+group%3Acomp.databases.ibm-db2&meta=group%3Dcomp.databases.ibm-db2

PM
Post by Friedmar Moch
Hallo!
We got DB2 Error -805 saying that package NULLID.SYSLH203 is missing.
With db2jdbcbuild ... -size 20 we created additional packages. This
helped for a while, but did not solve the problem.
Could anybody please tell me what this packages are for? I guess, the
reasen for that behaviour is in the application.
Tank you in advance
friedmar
Friedmar Moch
2004-05-04 21:17:52 UTC
Permalink
I did this befor I posted!!!!!!!!!!!!
Post by PM (pm3iinc-nospam) CGO
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=SYSLH203+OR+SYSSH203+group%3Acomp.databases.ibm-db2&meta=group%3Dcomp.databases.ibm-db2
PM
Post by Friedmar Moch
Hallo!
We got DB2 Error -805 saying that package NULLID.SYSLH203 is missing.
With db2jdbcbuild ... -size 20 we created additional packages. This
helped for a while, but did not solve the problem.
Could anybody please tell me what this packages are for? I guess, the
reasen for that behaviour is in the application.
Tank you in advance
friedmar
PM (pm3iinc-nospam) CGO
2004-05-05 02:54:08 UTC
Permalink
No need to yell btw.

Some description here.
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/ad/r0007866.htm?resultof=%22%70%61%63%6b%61%67%65%20%6e%61%6d%65%73%22%20

Did you really read all the threads in posted earlier?
Specifically this one :
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=475a2480.0305262316.2f03be41%40posting.google.com&rnum=9&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3DSYSLH203%2BOR%2BSYSSH203%2Bgroup%253Acomp.databases.ibm-db2%26meta%3Dgroup%253Dcomp.databases.ibm-db2

cli and jdbc share more than before, did you bind/rebind the db2cli and
db2ubind .lst files?
Can you list some syslh* with db2 list packages for all?
If you need help, can you avoid using "..." except where needed to protect
the innocent. (user, password)

Anything special in your setup? package versionning/special registers
setting/collection/packageset/etc. ?
Aything special in db2 select * from syscat.packageauth where
pkgname='SYSLH203'
Did you try the CLIPK setting?
What db2 "client" platform/version are you using? (if not locally on the
server)


PM
Post by Friedmar Moch
I did this befor I posted!!!!!!!!!!!!
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=SYSLH203+OR+SYSSH203+group%3Acomp.databases.ibm-db2&meta=group%3Dcomp.databases.ibm-db2
Post by Friedmar Moch
PM
Post by Friedmar Moch
Hallo!
We got DB2 Error -805 saying that package NULLID.SYSLH203 is missing.
With db2jdbcbuild ... -size 20 we created additional packages. This
helped for a while, but did not solve the problem.
Could anybody please tell me what this packages are for? I guess, the
reasen for that behaviour is in the application.
Tank you in advance
friedmar
xixi
2004-05-05 17:01:13 UTC
Permalink
hi, we are running db2 udb v8.1 fp3 on windows 64 bit , we have the
same error, i do increase applheapsz to 60000 (the max), increase
maxappls to 60, do DB2Binder with size 70 (number of packages), i
don't find a package name SYSLH203 under syscat.packageauth. and the
db2cli.cli file has this content


; Comment lines start with a semi-colon.

[tstcli1x]
uid=userid
pwd=password
autocommit=0
TableType="'TABLE','VIEW','SYSTEM TABLE'"

[tstcli2x]
; Assuming dbalias2 is a database in DB2 for MVS.
SchemaList="'OWNER1','OWNER2',CURRENT SQLID"

[MyVeryLongDBALIASName]
dbalias=dbalias3
SysSchema=MYSCHEMA


so what should i do with CKIPK setting? we don't have db2 client
installed, all the application is using jdbc driver to connect to the
remote server. the driver is trype 4 jcc driver. after i put the fix
pack, i have done this

C:\Program Files\IBM\SQLLIB\bnd>db2 bind @db2cli.lst blocking all
grant public

LINE MESSAGES FOR db2cli.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.

so i still don't understand why i still have missing packages error
Tomas Hallin
2004-05-08 00:24:39 UTC
Permalink
Default bind:

yellow$ db2 bind @db2cli.lst blocking all grant public

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

PKGNAME
----------
SYSLH200
SYSLH201
SYSLH202

Bind using clipkg parameter:

yellow$ db2 bind @db2cli.lst blocking all grant public clipkg 20

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

PKGNAME
----------
SYSLH200
SYSLH201
SYSLH202
SYSLH203
SYSLH204
SYSLH205
SYSLH206
SYSLH207
SYSLH208
SYSLH209
SYSLH20A
SYSLH20B
SYSLH20C
SYSLH20D
SYSLH20E
SYSLH20F
PM (pm3iinc-nospam) CGO
2004-05-13 01:55:35 UTC
Permalink
Just to add a little,
CLIPKG cli-packages
An integer between 3 and 30 specifying the number of CLI large packages to
be created when binding CLI bind files against a database. For more
information on CLI bind files and packages see the CLI Guide and Reference.



PM

Loading...