Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC89672 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
-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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP9                                      * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
Fixed in DB2 V9.7 FP9
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
21.01.2013
17.12.2013
17.12.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.9 FixList
9.7.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.