-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 |
