IBM Support

Knowledge Collection: SQL0805N

Question & Answer


Question

This Knowledge Collection is a focused compilation of links to documents for the SQL0805N error message issues for DB2.

Answer

SQL0805N Package "<package-name>" was not found.

Explanation: The statement cannot complete because the necessary package was not
found in the catalog.

The following document links discuss varying issues when encountering the SQL0805N error.

SQL0805 messages for "SYSS[HN]xyy" packages:

The SQL0805 NULLID.SYSS[HN]xyy error is normally reported when an application has exhausted all available statement handles. The number of statement handles available to an application depends on the number of small packages the application has defined and is limited by overall system resources. By default 3 small packages are created. Each small package allows a maximum of 64 statements per connection, giving a total of 192 statement handles.

[1115245] SQL0805N Package SYSSH203 was not found

SQL0805 messages for SYSL[HN]xyy packages:

The SQL0805 NULLID.SYSL[HN]xyy error is normally reported when an application has exhausted all available statement handles. The number of statement handles available to an application depends on the number of larger packages the application has defined and is limited by overall system resources. By default 3 large packages are created. Each large package allows a maximum of 384 statements per connection, giving a total of 1,152 statement handles.

[1208123] SQL0805N Package SYSLH203 was not found
[1366855] SQL0805N Package SYSLH21E was not found
[1501076] SQL0805N Package SYSLH31E was not found
[1504334] SQL0805N Package SYSLN303 was not found


SQL0805 messages for other packages:
[1223958] SQL0805N Package SQLLF000 was not found
[1441733] SQL0805N Package DB2ADVCA was not found
[1441427] SQL0805N Package SQLC2G13 was not found
[1501837] SQL0805N Package SQLC2G15 was not found.

Related Topics:
[1296530] SQL0805N for a GSE* package names
[1229502] SQL0805N - Update Anywhere SQL Replication Scenario
[1253024] SQL0805N - CLI packages in DB2 v8 or DB2 v9 are not being rebound automatically

Bind File and Package Name List
DB2 v9.1, v9.5, v9.7, v10.1

Download DB2 Bind files for v10.1, v9.7, v9.5, v9.1 and v8 Fix Packs

Definition of a Knowledge Collection

A Knowledge Collection is a focused compilation of links to documents that share a common theme. Knowledge Collections are navigation aids that organize content to help users quickly find relevant information. Knowledge Collections are not designed to be an all-inclusive list of all documents dealing with the specific theme.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21358478