IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    LI74746

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-16

  • Closed date

    2010-02-24

  • Last modified date

    2010-02-24

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 February 2010