Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    50

    Unanswered: unable to free tempary sqlcache stmt

    Hi All,

    See below for db2diag log message.
    can't find reference of it anywhere

    Dave

    2005-01-19-17.57.53.390000 InstanceB2 Node:000
    PID:385(db2syscs.exe) TID:623 Appid:none
    access_plan_manager sqlra_load_dyn_stmt Probe:40
    DIA9999E An internal error occurred. Report the following error code : "
    2".

    Data Title:unable to free tempary sqlcache stmt PID:385 TID:601 Node:000
    0000 0000 ....


    2005-01-19-17.59.17.125000 InstanceB2 Node:000
    PID:385(db2syscs.exe) TID:601 Appid:none
    access_plan_manager sqlra_load_dyn_stmt Probe:40
    DIA9999E An internal error occurred. Report the following error code : "
    2".

    Data Title:unable to free tempary sqlcache stmt PID:385 TID:623 Node:000
    0000 0000

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Interanl error codes should usually be reported to IBM support.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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