home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC63888 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* N/A                                                          * 
**************************************************************** 
* PROBLEM 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.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* NOne                                                         * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
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.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.10.2009
24.02.2010
24.02.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.0.,
9.1.
Problem behoben lt. FixList in der Version
9.7.0.1 FixList