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 IC89672 Status: Geschlossen

-901 ERROR MAY OCCUR DURING CREATE TABLE DDL OPERATION AND FODC_APPERR
DIRECTORY GENERATED

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
-901 error may occur during create table DDL functions, and 
FODC_AppErr directory is generated in db2dump directory. The 
instance is not crashed. 
 
Here is what may be seen in db2diag.log: 
 
2013-01-10-11.17.44.251507-300 I196253782E590      LEVEL: Error 
PID     : 14204                TID  : 46919657187648PROC : 
db2sysc 1 
INSTANCE: nyqxt040             NODE : 001          DB   : 
PHOENIX 
APPHDL  : 1-23556              APPID: 
10.163.214.107.52121.1301101617 
AUTHID  : ECPROD 
EDUID   : 17046                EDUNAME: db2agent (PHOENIX) 1 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging func, probe:0 
MESSAGE : sqlr_obj_type_to_aud_type: Unrecognized object type! 
DATA #1 : Hexdump, 1 bytes 
0x00002AAC557F1D20 : 47 
G 
 
2013-01-10-11.17.44.574120-300 I196254373E590      LEVEL: Error 
PID     : 14204                TID  : 46919657187648PROC : 
db2sysc 1 
INSTANCE: nyqxt040             NODE : 001          DB   : 
PHOENIX 
APPHDL  : 1-23556              APPID: 
10.163.214.107.52121.1301101617 
AUTHID  : ECPROD 
EDUID   : 17046                EDUNAME: db2agent (PHOENIX) 1 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging func, probe:0 
MESSAGE : sqlr_obj_type_to_aud_type: Unrecognized object type! 
DATA #1 : Hexdump, 1 bytes 
0x00002AAC557EBAE0 : 47 
G 
 
......... 
 
2013-01-10-11.18.46.441601-300 I196256146E576      LEVEL: Severe 
 
PID     : 14204                TID  : 46919602661696PROC : 
db2sysc 1 
INSTANCE: nyqxt040             NODE : 001          DB   : 
PHOENIX 
APPHDL  : 1-23456              APPID: *N1.nyqxt040.130110162306 
 
AUTHID  : NYQXT040 
 
EDUID   : 17352                EDUNAME: db2agent (PHOENIX) 1 
 
FUNCTION: DB2 UDB, relation data serv, sqlrr_recreate_ddl, 
probe:200 
MESSAGE : Recreate table DDL failed because the statement is 
empty 
DATA #1 : Hexdump, 4 bytes 
 
0x00002AAC523EB018 : 0000 0000 
.... 
 
 
2013-01-10-11.18.46.490679-300 E196256723E775      LEVEL: Error 
 
PID     : 14204                TID  : 46919602661696PROC : 
db2sysc 1 
INSTANCE: nyqxt040             NODE : 001          DB   : 
PHOENIX 
APPHDL  : 1-23456              APPID: *N1.nyqxt040.130110162306 
 
AUTHID  : NYQXT040 
 
EDUID   : 17352                EDUNAME: db2agent (PHOENIX) 1 
 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:10 
 
MESSAGE : ADM14005E  The following error occurred: "AppErr". 
First 
Occurrence 
 
          Data Capture (FODC) has been invoked in the following 
mode: 
          "Automatic".  Diagnostic information has been recorded 
in the 
          directory named 
 
 
"/var/ibmdb2/nyqxt040/sqllib/db2dump/FODC_AppErr_2013-01-10- 
11.18.46.482904_14204_17352_001/". 
 
 
 
2013-01-10-11.18.46.491861-300 I196259390E885      LEVEL: Severe 
 
PID     : 14204                TID  : 46919602661696PROC : 
db2sysc 1 
INSTANCE: nyqxt040             NODE : 001          DB   : 
PHOENIX 
APPHDL  : 1-23456              APPID: *N1.nyqxt040.130110162306 
 
AUTHID  : NYQXT040 
 
EDUID   : 17352                EDUNAME: db2agent (PHOENIX) 1 
 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 56 
 
 sqlerrmc: Recreate table DDL failed because the statement is 
empty 
 sqlerrp : SQLRR0CB 
 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFF06      (6) 
0x00000001 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 
 sqlstate: 
 
 
 
With the call-stacks info from generated FODC_AppErr directory: 
 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloDumpDiagInfoHandler 
4        send 
5        pthread_kill 
6        sqloDumpEDU 
7        sqldDumpContext 
8        sqlrr_dump_ffdc 
9        sqlzeDumpFFDC 
10       sqlzeSqlCode 
11       sqlrrSqlCode 
12       sqlrr_recreate_ddl 
13       sqlesrvr 
14       sqleMappingFnServer 
15       sqlerKnownProcedure 
16       sqlerCallDL 
17       sqljs_ddm_excsqlstt 
18       sqljsParseRdbAccessed 
19       sqljsParse 
20       sqlnq_qtb 
21       sqlnq_ftb::delchildrels 
22       sqlnq_ftb::drop 
23       sqljsDrdaAsDriver 
24       sqeAgent::RunEDU 
25       sqzEDUObj::EDUDriver 
26       sqlzRunEDU 
27       sqloEDUEntry 
28       __free_stacks 
29       clone
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP9                                      * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Fixed in DB2 V9.7 FP9
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
21.01.2013
17.12.2013
17.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList