Knowledge Collection: SQL0805N
This Knowledge Collection is a focused compilation of links to documents for the SQL0805N error message issues for DB2.
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.
 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.
 SQL0805N Package SYSLH203 was not found
 SQL0805N Package SYSLH21E was not found
 SQL0805N Package SYSLH31E was not found
 SQL0805N Package SYSLN303 was not found
SQL0805 messages for other packages:
 SQL0805N Package SQLLF000 was not found
 SQL0805N Package DB2ADVCA was not found
 SQL0805N Package SQLC2G13 was not found
 SQL0805N Package SQLC2G15 was not found.
 SQL0805N for a GSE* package names
 SQL0805N - Update Anywhere SQL Replication Scenario
 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.
More support for:
DB2 for Linux, UNIX and Windows
OTHER - Uncategorised
Software version: 9.1, 9.5, 9.7
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1358478
Modified date: 16 March 2016