DB2 may abend at the end of load during file closure with
SIGSEV.
FODC Trap will be created and stack dump may look as follows:
Stack #1 Signal #11 Timestamp
2013-06-04-12.19.46.971129
0 strlen
1 _doprnt
2 vsnprintf
3 ossSnprintf
4 pdFormat_SQLO_FHANDLE
5 pdFormatArg
6 pdInvokeFmtFnc
7 @132@formatPDType
8 @132@pdTypeFormatOrDump
9 @132@pdLogInternal
10 pdLogInternal
11 pdLogSysRC
12 sqloSystemErrorHandler
13 sqloSystemErrorHandler@glue7CE
14 sqlodelete
15 sqloDeleteNamedPipe
16 sqluCSerializablePipeBase::iClose
17 sqluCSerializablePipeBase::iCleanUp
18 sqluCSerializablePipe::iCleanUp
19 @88@sqluCleanupUserExitPipes
20 sqluCleanupUserExitCB
21 sqluAppCbCleanup
22 sqluCommitCallBack
23 sqlrr_tran_router
24 sqlrr_subagent_router
25 sqleSubRequestRouter
26 sqleProcessSubRequest
27 sqeAgent::RunEDU
28 sqzEDUObj::EDUDriver
29 sqloEDUEntry
Memory may be also consumed fully during this abend. Core dump
may be generated as well.
db2diag.log may look as follows:
2013-06-04-12.19.47.171008-240 I43934143A490 LEVEL: Warning
PID : 12780076 TID : 265047 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :sample
APPHDL : 1-15207 APPID: *N1.db2inst1.130604132421
AUTHID : LOADPROD
EDUID : 265047 EDUNAME: db2agnta (EDWDBP01) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdEDUIsInDB2KernelOperation, probe:600
DATA #1 : String, 13 bytes
ossSnprintf
DATA #2 : String, 3 bytes
oss
2013-06-04-12.19.47.172227-240 I43934634A566 LEVEL: Severe
PID : 12780076 TID : 265047 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :sample
APPHDL : 1-15207 APPID: *N1.db2inst1.130604132421
AUTHID : LOADPROD
EDUID : 265047 EDUNAME: db2agnta (EDWDBP01) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdResilienceIsSafeToSustain, probe:800
DATA #1 : String, 37 bytes
Trap Sustainability Criteria Checking
DATA #2 : Hex integer, 8 bytes
0x0000000302001849
DATA #3 : Boolean, 1 bytes
false
2013-06-04-12.21.45.561356-240 E43981275A1383 LEVEL: Error
(OS)
PID : 12780076 TID : 22963 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :sample
APPHDL : 1-15866 APPID: *N1.db2inst1.130604161934
AUTHID : LOADPROD
EDUID : 22963 EDUNAME: db2agnta (EDWDBP01) 0
FUNCTION: DB2 UDB, oper system services, sqlodelete, probe:50
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
CALLED : OS, -, unlink
OSERR : ENOENT (2) "No such file or directory"
DATA #1 : File name, 137 bytes
/gpfs/dba/db2utlgn/edwdbp01/s41f400n01/temp_files/cdwdba.lda_tas
er_txns_ltr_tags_daily/DB200041.PID/DB200597.OID/db2loadpipe3974
7.000.000
DATA #2 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 125829120
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = Yes
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = Yes
Write-through Mode = Yes
File Not Tracked = No
DATA #3 : unsigned integer, 4 bytes
1
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry
for further
self-diagnosis of this problem.
2013-06-04-12.21.45.561868-240 E43982659A526 LEVEL: Error
PID : 12780076 TID : 22963 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :sample
APPHDL : 1-15866 APPID: *N1.db2inst1.130604161934
AUTHID : LOADPROD
EDUID : 22963 EDUNAME: db2agnta (EDWDBP01) 0
FUNCTION: DB2 UDB, oper system services, sqloDeleteNamedPipe,
probe:10
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found. |
