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

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

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