In a DPF environment FODC_AppErr_ directories are
generated in the db2dump directory.
Might see -901 errors once formatted. Is associated with
FODC_AppErr_ generated which include apm.bin,
dump.bin and dgtt.txt files.
The trap file will show sqlrl_userTempxxx functions
db2dump directory will have files like:
-rw-r--r-- 1 db2inst1 pdxdb2 12361024 Jan 30 21:24
12517416.38546.000.apm.bin
-rw-r----- 1 db2inst1 pdxdb2 1600 Jan 30 02:34
12517416.38546.000.cos.txt
-rw-r--r-- 1 db2inst1 pdxdb2 3408 Jan 30 02:34
12517416.38546.000.dgtt.txt
-rw-r--r-- 1 db2inst1 pdxdb2 14467228 Jan 30 21:24
12517416.38546.000.dump.bin
-rw-r--r-- 1 db2inst1 pdxdb2 78665 Jan 30 02:34
12517416.38546.000.stack.txt
-rw-r--r-- 1 db2inst1 pdxdb2 4074000 Jan 30 02:34
db2diag.log file shows:
2019-02-02-17.43.47.789069-300 I1854982E728 LEVEL:
Severe
PID : 42721 TID : 140635172497152 PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
sample
APPHDL : 1-19494 APPID:
10.98.70.195.54321.190212164433
AUTHID : xxxx HOSTNAME: bugdbug
EDUID : 30231 EDUNAME: db2agent (sample) 1
FUNCTION: DB2 UDB, buffer pool services, sqlbReleaseFileToken,
probe:10
DATA #1 : String, 84 bytes
Error: ReleaseFileToken was called to release a token that was
not already allocated
DATA #2 : String, 9 bytes
PoolID =
DATA #3 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
19
DATA #4 : String, 8 bytes
Token =
DATA #5 : unsigned integer, 2 bytes
314
2019-02-02-17.43.47.804581-300 I1861339E609 LEVEL:
Severe
PID : 42721 TID : 140635172497152 PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
Sample
APPHDL : 1-19494 APPID:
10.98.70.195.54321.190212164433
AUTHID : xxxx HOSTNAME: bugdbug
EDUID : 30231 EDUNAME: db2agent (Sample) 1
FUNCTION: DB2 UDB, catalog services, sqlrl_dump_userTemps,
probe:25
MESSAGE : User temp table info dumped. Check
/var/ibmdb2/nypxt070/sqllib/db2dump/42721.140635172497152.001.dg
tt.txt for additional data. |
