Package "NULLID.SYSLN30F 0X5359534C564C3031" was not found.

[Prassi]

Hi All,

I am getting this error Package "NULLID.SYSLN30F 0X5359534C564C3031"
was not found in my application, Application is a Websphere portet and
we normally get this error after executing a specific SQL from the
application.

How do I add this specific package, I have used the db2 bind and
db2rbind but these still do not create the package needed by this
application.

Please help

thanks
Prassi

[Jan M. Nelken]

Prassi wrote:

Hi All,

I am getting this error Package "NULLID.SYSLN30F 0X5359534C564C3031"
was not found in my application, Application is a Websphere portet and
we normally get this error after executing a specific SQL from the
application.

How do I add this specific package, I have used the db2 bind and
db2rbind but these still do not create the package needed by this
application.

SYSLN30F

Large statement package
Cursor withOUT hold
Isolation level RS

Assuming that packahe SYSLM30E is present and SYSLN30F is absent -
somebody issued:

DB2 BIND @DB2CLI.LST CLIPKG 15
You can increase CLIPKG up to 30 to generate larger number of packages -
but the real issue here is there is a STATEMENT HANDLE LEAK in the
code.

Investigate from the CODE point of view.
Jan M. Nelken

[Jan M. Nelken]

Prassi wrote:

I am getting this error Package "NULLID.SYSLN30F 0X5359534C564C3031"
was not found in my application, Application is a Websphere portet and
we normally get this error after executing a specific SQL from the
application.

How do I add this specific package, I have used the db2 bind and
db2rbind but these still do not create the package needed by this
application.

SYSLN30F

tells us that:

package is for large number of sections
cursor with NO HOLD
Isolation level is RS

Assuming that package SYSLN30E is present and package SYSLN30F is absent
- this means that somebody issued following bind command:

db2 bind @db2cli.lst ... CLIPKG 15
You can increase number of generated large CLI packages up to 30, bur
real problem appears to be STATEMENT HANDLE leak in your code.

I strongly advise to examine carefully your application code.
Jan M. Nelken