db2 abend

Shyam Peri

db2 abend
Harold,
One possible reason could be file level locking, check for the file system
backup if it happened at the same time!!



On 1/1/07, Harold Pritchett <[login to unmask email]> wrote:
>
> Anyone have an idea why my db2 just died???
>
> Attached is extract from the event file
>
> Harold
> --
> Harold Pritchett
> [login to unmask email] +1.706.546.0692
> pgp public key: http://www.arches.uga.edu/~harold/pgpkey.html
>
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>
>
> 2006-12-30-14.00.21.078526-300 E439993299G465 LEVEL: Warning (OS)
> PID : 11411 TID : 3005749760 PROC : db2pclnr
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloLioAIOCollect, probe:100
> MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
> DIA8519C A file sharing violation has occurred, filename was "".
> CALLED : OS, -, unspecified_system_function OSERR: EAGAIN (11)
>
> 2006-12-30-14.00.21.340682-300 I439993765G399 LEVEL: Error
> PID : 11411 TID : 3005749760 PROC : db2pclnr
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion,
> probe:40
> RETCODE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
> DIA8519C A file sharing violation has occurred, filename was "".
>
> 2006-12-30-14.00.21.441974-300 I439994165G1251 LEVEL: Severe
> PID : 11411 TID : 3005749760 PROC : db2pclnr
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion,
> probe:300
> MESSAGE : *ioRequest =
> DATA #1 : Hexdump, 204 bytes
> 0xB3242A00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0xB3242A90 : 0000 0000 1A13 5DB4 3831 CE12 E429 24B3 ......].81...)$.
> 0xB3242AA0 : 0000 0000 0000 0000 0000 0200 0000 0000 ................
> 0xB3242AB0 : 0010 6913 0010 0000 3900 0000 0000 0000 ..i.....9.......
> 0xB3242AC0 : 0000 0000 0200 0000 1600 0F87 ............
>
> 2006-12-30-14.00.21.466866-300 I439995417G814 LEVEL: Severe
> PID : 11411 TID : 3005749760 PROC : db2pclnr
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion,
> probe:310
> MESSAGE : *curBPD =
> DATA #1 : Hexdump, 112 bytes
> 0x12EAB430 : 2000 0000 0100 2800 8000 0000 0000 0000 .....(.........
> 0x12EAB440 : 2000 0000 5D00 0000 0000 0000 70DD E812 ...].......p...
> 0x12EAB450 : 00CC 2100 0000 0100 FFFF FFFF 0000 0000 ..!.............
> 0x12EAB460 : 0000 0000 0301 0000 0100 0000 0000 0000 ................
> 0x12EAB470 : 0001 0000 20AA EA12 A0B4 EA12 0010 6913 .... .........i.
> 0x12EAB480 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 0x12EAB490 : 0000 0000 FFFF 0500 0000 0000 0000 00C0 ................
>
> 2006-12-30-14.00.21.466991-300 I439996232G522 LEVEL: Severe
> PID : 11411 TID : 3005749760 PROC : db2pclnr
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion,
> probe:320
> MESSAGE : pagehead =
> DATA #1 : Hexdump, 48 bytes
> 0x13691000 : 3000 D00F F506 0000 0004 1400 0216 7584 0.............u.
> 0x13691010 : 2000 0000 2800 8002 B68A C095 2000 0000 ...(....... ...
> 0x13691020 : 0100 0000 0000 0000 0000 0000 0000 0000 ................
>
> 2006-12-30-14.00.21.478467-300 I439996755G357 LEVEL: Severe
> PID : 11411 TID : 3005749760 PROC : db2pclnr
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
> MESSAGE : sqle_panic: Panic/sleep =
> DATA #1 : Hexdump, 4 bytes
> 0x1001C168 : 0000 0000 ....
>
> 2006-12-30-14.00.21.535728-300 E439997113G510 LEVEL: Severe
> PID : 11411 TID : 3005749760 PROC : db2pclnr
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
> MESSAGE : ADM0503C An unexpected internal processing error has
> occurred. ALL
> DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
> Diagnostic information has been recorded. Contact IBM Support
> for
> further assistance.
>
> 2006-12-30-14.00.21.535874-300 E439997624G903 LEVEL: Severe
> PID : 11411 TID : 3005749760 PROC : db2pclnr
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
> DATA #1 : Signal Number Recieved, 4 bytes
> 6
> DATA #2 : Siginfo, 128 bytes
> 0xBFFFB6C8 : 0600 0000 0000 0000 FAFF FFFF 932C 0000 .............,..
> 0xBFFFB6D8 : 6C00 0000 06C1 5BB7 0000 0000 9602 0000 l.....[.........
> 0xBFFFB6E8 : 008D 7EF5 9602 0000 E866 97C3 30F8 FDF7 ..~......f..0...
> 0xBFFFB6F8 : 30F8 FDF7 94BB 16C0 008D 7EF5 4044 97C3 0.........~.@D..
> 0xBFFFB708 : 008D 7EF5 4044 97C3 3564 15C0 00C4 C6CE ..~.@D..5d......
> 0xBFFFB718 : 0000 0000 0100 0000 0080 26E0 BDE2 12C0 ..........&.....
> 0xBFFFB728 : A89F 26E0 A09F 26E0 A89F 26E0 0000 0000 ..&...&...&.....
> 0xBFFFB738 : 0000 0000 0000 0000 0000 0000 0080 26E0 ..............&.
>
> 2006-12-30-14.00.21.681885-300 E439998528G874 LEVEL: Severe
> PID : 2074 TID : 3005749760 PROC : db2gds
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler, probe:50
> DATA #1 : <preformatted>
> Detected the death of an EDU with process id 11411
> The signal number that terminated this process was 6
> Look for trap files (t11411.*) in the dump directory
> CALLSTCK:
> [0] 0xB4AE7A89 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x94AA89
> [1] 0xB75D5F80 /lib/tls/libpthread.so.0 + 0xAF80
> [2] 0xB4AE896A /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x94B96A
> [3] 0xB4AE8286 sqloInitEDUServices + 0x15C
> [4] 0xB4AE3EFD sqloRunInstance + 0x5DD
> [5] 0x0804CA15 DB2main + 0x8C3
> [6] 0x08050993 main + 0x17
> [7] 0xB3DEC79A __libc_start_main + 0xDA
> [8] 0x0804BE05 sqlt_system_error + 0x31
> [9] 0x00000000 (nil) + 0x0
>
> 2006-12-30-14.00.21.730388-300 E439999403G508 LEVEL: Severe
> PID : 2074 TID : 3005749760 PROC : db2gds
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
> MESSAGE : ADM0503C An unexpected internal processing error has
> occurred. ALL
> DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
> Diagnostic information has been recorded. Contact IBM Support
> for
> further assistance.
>
> 2006-12-30-14.00.21.730567-300 E439999912G901 LEVEL: Severe
> PID : 2074 TID : 3005749760 PROC : db2gds
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
> DATA #1 : Signal Number Recieved, 4 bytes
> 6
> DATA #2 : Siginfo, 128 bytes
> 0xBFFFBAE8 : 0600 0000 0000 0000 FAFF FFFF 1A08 0000 ................
> 0xBFFFBAF8 : 0000 0000 EC0A 26C4 0020 27F2 903F 27F2 ......&.. '..?'.
> 0xBFFFBB08 : ECB9 FFBF 0000 0000 703F 27F2 3BEE 12C0 ........p?'.;...
> 0xBFFFBB18 : 1F00 0000 903F 27F2 0000 0000 4044 97C3 .....?'.....@D..
> 0xBFFFBB28 : 80A4 4BF4 4044 97C3 3564 15C0 00A9 A0F7 ..[login to unmask email]
> 0xBFFFBB38 : 0000 0000 0100 0000 0020 27F2 BDE2 12C0 ......... '.....
> 0xBFFFBB48 : A83F 27F2 A03F 27F2 A83F 27F2 0000 0100 .?'..?'..?'.....
> 0xBFFFBB58 : 0000 0000 0020 27F2 0400 0000 D0AD 11C0 ..... '.........
>
> 2006-12-30-14.00.26.467233-300 I440000814G361 LEVEL: Severe
> PID : 2070 TID : 3005749760 PROC : db2sysc
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:15
> MESSAGE : DiagData
> DATA #1 : Hexdump, 15 bytes
> 0x0805352C : 416E 2045 4455 2063 7261 7368 6564 2E An EDU crashed.
>
> 2006-12-30-14.00.26.483392-300 I440001176G349 LEVEL: Severe
> PID : 2070 TID : 3005749760 PROC : db2sysc
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:16
> MESSAGE : DiagData
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC534 : 1A08 0000 ....
>
> 2006-12-30-14.00.26.483484-300 I440001526G349 LEVEL: Severe
> PID : 2070 TID : 3005749760 PROC : db2sysc
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:17
> MESSAGE : DiagData
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC52C : 0101 0000 ....
>
> 2006-12-30-14.00.26.483569-300 I440001876G349 LEVEL: Severe
> PID : 2070 TID : 3005749760 PROC : db2sysc
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:18
> MESSAGE : DiagData
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC530 : FFFF FFFF ....
>
> 2006-12-30-14.00.26.483654-300 I440002226G349 LEVEL: Severe
> PID : 2070 TID : 3005749760 PROC : db2sysc
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:19
> MESSAGE : DiagData
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC528 : 88FC FFFF ....
>
> 2006-12-30-14.00.26.500168-300 I440002576G339 LEVEL: Severe
> PID : 2070 TID : 3005749760 PROC : db2sysc
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, base sys utilities, sqleSysCtlr, probe:10
> MESSAGE : DiagData
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC7D4 : 0100 0000 ....
>
> 2006-12-30-14.00.26.623013-300 E440002916G503 LEVEL: Severe
> PID : 2069 TID : 3005749760 PROC : db2wdog
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:490
> MESSAGE : ADM0503C An unexpected internal processing error has
> occurred. ALL
> DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
> Diagnostic information has been recorded. Contact IBM Support
> for
> further assistance.
>
> 2006-12-30-14.00.26.623761-300 I440003420G350 LEVEL: Severe
> PID : 2069 TID : 3005749760 PROC : db2wdog
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:500
> MESSAGE : DiagData
> DATA #1 : Hexdump, 8 bytes
> 0xBFFFCAC8 : 0201 0000 0900 0000 ........
>
> 2006-12-30-14.00.26.624180-300 I440003771G347 LEVEL: Severe
> PID : 2069 TID : 3005749760 PROC : db2wdog
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
> MESSAGE : DiagData
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC7D4 : 0201 0000 ....
>
> 2006-12-30-14.00.26.665243-300 I440004119G393 LEVEL: Warning
> PID : 2069 TID : 3005749760 PROC : db2wdog
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
> MESSAGE : Bringing down all db2fmp processes as part of db2stop
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC6A8 : 0000 0000 ....
>
> 2006-12-30-14.00.28.411537-300 I440004513G332 LEVEL: Severe
> PID : 2071 TID : 3005749760 PROC : db2ckpwd
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC6D0 : 4200 0F87 B...
>
> 2006-12-30-14.00.28.424882-300 I440004846G332 LEVEL: Severe
> PID : 2072 TID : 3005749760 PROC : db2ckpwd
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC6D0 : 4200 0F87 B...
>
> 2006-12-30-14.00.28.425221-300 I440005179G332 LEVEL: Severe
> PID : 2073 TID : 3005749760 PROC : db2ckpwd
> INSTANCE: db2inst1 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
> DATA #1 : Hexdump, 4 bytes
> 0xBFFFC6D0 : 4200 0F87 B...
>
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>
>
>


--
warm regards
Peri

The best way out of difficulty is through it. :)

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Harold Pritchett

Re: db2 abend
(in response to Shyam Peri)
Peri wrote:
> Harold,
> One possible reason could be file level locking, check for the file
> system backup if it happened at the same time!!

Thanks for all of the response. It appears that the answer is
APAR IY85772. I'm at FixPak 12, and this APAR is in FP 13.

http://tinyurl.com/y83vh8

Thanks again.

Harold

--
Harold Pritchett
[login to unmask email] +1.706.546.0692
pgp public key: http://www.arches.uga.edu/~harold/pgpkey.html

"The Internet is for porn.
The Internet is for porn.
Why you think the net was born?
Porn! Porn! Porn!"
Trekkie Monster
Avenue Q

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm