Error message: DB2 SQL error: SQLCODE: -973,STATE:57011, SQLERRMC:PCKCACHESZ

You receive this error when opening a panel in the IBM Spectrum® Control user interface that requires information from the database repository. For example, when you generate a report or view a list of devices managed by CIMOMs.

Problem

When you open a panel that requires information from the database repository, you might receive the following error:

Server: server_name           Status: 0
SQLSTATE: 57011, Vendor error code: -973
DB2 SQL error: SQLCODE: -973, SQLSTATE: 57011,
SQLERRMC: PCKCACHESZ

This message indicates an error related to the PCKCACHESZ configuration setting in Db2®. This parameter is allocated out of the database shared memory, and is used for caching of sections for static and dynamic SQL and XQuery statements on a database.

Action

Increase the value for PCKCACHESZ until the error in the user interface is resolved. Initially, increase the value of PCKCACHESZ to 78525. If that does not resolve the error, increase the value in 10% increments until the error is resolved.

To increase the value for PCKCACHESZ, complete the following steps:

Check the current value for PCKCACHESZ by running the following commands at the Db2 prompt:
```
db2 connect to tpcdb
db2 get db cfg show detail | grep PCKCACHESZ
```
Increase PCKCACHESZ to 78525:
```
db2 update db cfg for TPCDB using PCKCACHESZ 78525
```
Note: If PCKCACHESZ is set to AUTOMATIC, all applications must disconnect from the Db2 in order for the change to take effect.
If increasing PCKCACHESZ to 78525 does not resolve the problem, increase the value by 10% increments until the error condition is resolved:
```
db2 update db cfg for TPCDB using PCKCACHESZ NEW_VALUE
```
where the initial NEW_VALUE is 10% greater than 78525.