Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011
    Posts
    4

    Cool Unanswered: MQ/MB Error on Db2

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2011
    Posts
    4
    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

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by Optimus_Prime View Post
    (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 '

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


    There is no APAR for v8 but try the workaround

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •