Dear Folks ,

I need help for one of my Db2 Legacy system running on V8 FP 16
the MQ/MB Logs return a error as follows :

(0x03000000):Text = '[IBM][CLI Driver][DB2/6000] SQL0727N An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-2025", SQLSTATE " " and message tokens "accessing a file used for collecting explain snapshot in". SQLSTATE=56098 '

This exception has been thrown only once for a several run of MQ/MB Over the database

Can some one kinldy advise on the above error

Thanks
Optimus Prime

Appears to be a filesystem issue - disk full ???

IBM DB2 9.7 for Linux, UNIX and Windows Information Center

IBM DB2 9.7 for Linux, UNIX and Windows Information Center

HTH

The Disk space is fine we have ample space left out

My Notification log has the following

ADM4500W A package cache overflow condition has occurred. There is no error
but this indicates that the package cache has exceeded the configured maximum
size. If this condition persists, you may want to adjust the PCKCACHESZ DB
configuration parameter.


initially my PCKCACHESZ was configured automatic , i went ahead to change it to 3200 ( as a reference from other instances in the same BOX )

should this help to solve the issues ,

Basically im failing to understand wat this issue is and what causes it

Please Advise

Could be related to:
https://www-304.ibm.com/support/docv...id=swg1JR32131


There is no APAR for v8 but try the workaround