LI74746: IN DB2 V9.1, USERS CAN GET SQL901 WHILE RUNNING QUERY AND DB2DIAG LOG SHOWS SQL901 MESSAGE.

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In DB2 v9.1, users can get SQL901 while running query and
  db2diag log shows SQL901 message.
  
  2009-02-24-00.02.22.709833+000 I64087124E407      LEVEL: Severe
  PID     : 10061                TID  : 47415451162896PROC :
  db2agent (IBMDB2) 0
  INSTANCE: db2inst1             NODE : 000         DB   : IBMDB2
  APPHDL  : 0-1436               APPID:
  10.131.14.98.41363.090223145059
  AUTHID  : PAPPADM
  FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:20
  RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown"
  
  2009-02-24-00.02.22.709951+000 I64087532E806      LEVEL: Severe
  PID     : 10061                TID  : 47415451162896PROC :
  db2agent (IBMDB2) 0
  INSTANCE: db2inst1             NODE : 000         DB   : IBMDB2
  APPHDL  : 0-1436               APPID:
  10.131.14.98.41363.090223145059
  AUTHID  : PAPPADM
  FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
   sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 28
   sqlerrmc: Failure to fetch buffer page
   sqlerrp : SQLRI1E2
   sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
  0x00000000
             (4) 0x00000000      (5) 0xFFFFFF06      (6)
  0x00000000
   sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
             (7)      (8)      (9)      (10)        (11)
   sqlstate:
  
  
  Trap shows:
  
  0        ossDumpStackTrace
  1        OSSTrapFile::dump
  2        sqlo_trce
  3        sqloDumpDiagInfoHandler
  4        __open64
  5        kill
  6        sqloDumpEDU
  7        sqldDumpContext
  8        sqlrr_dump_ffdc
  9        sqlzeDumpFFDC
  10       sqlzeSqlCode
  11       sqlrrSqlCode
  12       sqlri_buffer_disk_read
  13       sqlri_scalag
  
  Fix for this APAR will have more information to be put in to
  db2diag.log.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * N/A                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IN DB2 V9.1, USERS CAN GET SQL901 WHILE RUNNING QUERY AND    *
  * DB2DIAG LOG SHOWS SQL901 MESSAGE.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * None                                                         *
  ****************************************************************
  

Problem conclusion

• IN DB2 V9.1, USERS CAN GET SQL901 WHILE RUNNING QUERY AND
  DB2DIAG LOG SHOWS SQL901 MESSAGE.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  LI74307

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSY

     UP

• R950 PSY

     UP