CA Repository for z/OS r7.2 WebStation Option Admin Console DB2 SQL -805 Error clicking XSD Generation

Products

• Repository

Issue/Introduction

Issue:

When clicking on the XSD generation tab in the CA Repository for zOS r7.2 WebStation Option Admin console, the following error is displayed at the top of the screen.   The error is also captured in the WSOAdminConsoleYYYY-MM-DD.log file.

-DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=xxxxx.NULLID.SYSLH20A.5359534C564C3031;DISTSERV;04, processTypesOfSelectedDialog(): The exception occurred while getting the attributes,header caption and screen row position of the selected types

 

Cause:

SYSLH2xxx packages are reserved for statements with CURSORHOLD on and isolation level cursor stability.  If there are not enough SYSLH2xxx packages available then DB2 will issue the -805 error to any remote client applications.

 

Resolution:

You can create more packages on the server by connecting to the database and issuing the following bind command from the /sqllib/bnd directory.  In this example CLIPKG 5 is specified to indicate that 5 large packages should be created. 

db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG 5

 

Additional Information:

Refer to the IBM technote located here

 

 

 

 

Environment

Release: DATASH00200-7.2-Repository-Webstation Option
Component: