Discussion:
DB2 v8 saps all memory and traps on Windows m/c
(too old to reply)
l***@us.ibm.com
2007-09-18 20:13:34 UTC
Permalink
Hello,

I have a DB2 v8 installation on a windows machine and even though the applications (FileNet) is not doing much, db2sysc eventually takes up all 3+ GB of memory and then crashes. The formated trap file is shown below.

Is this a known problem with a fixpack or is there a fix somewhere ?

Thanks.

Lipyeow

-------------------Memory Usage Information (in MB)-------------------

Physical Memory: 3711 total, 572 free.
Virtual Memory : 2047 total, 7 free.
Paging File : 5603 total, 2181 free.
Ext. Virtual : 0 free.

------------------DB2 Registry/Environment Variables-----------------

[e] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2_EXTSECURITY=YES
[g] DB2SYSTEM=EXTTECHTEST4
[g] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00

The following information is for pid <1432> tid <5344>

Exception C0000005 Occurred
Exception Address = 6CA75885
Invalid linear address 00000000

Register dump:
---------------

GS : 0000 FS : 003B ES : 0023 DS : 0023
EDI : 00000010 ESI : FFFFFFF0 EAX : 00000000 EBX : 00000000
ECX : 05D7FFA8 EDX : 00000000
EBP : 05D7DE18 EIP : 6CA75885 EFLG: 00010246 ESP : 05D7DE18
CS : 001B SS : 0023

The EXE is <C:\PROGRA~1\IBM\SQLLIB\bin\db2syscs.exe>


DLL Addresses:
--------------



WARNING: DLL details might not be complete or stale.

(00260000 - 0026C000) C:\PROGRA~1\IBM\SQLLIB\bin\db2locale.dll [trp=Fri Aug 13 09:50:28 2004 dbg=n/a]
(00270000 - 002D8000) C:\PROGRA~1\IBM\SQLLIB\bin\db2g11n.dll [trp=Fri Aug 13 11:06:17 2004 dbg=n/a]
(002E0000 - 00307000) C:\PROGRA~1\IBM\SQLLIB\bin\db2genreg.dll
(00310000 - 00317000) C:\PROGRA~1\IBM\SQLLIB\bin\db2install.dll [trp=Sun Aug 15 19:30:50 2004 dbg=n/a]
(00320000 - 00335000) C:\PROGRA~1\IBM\SQLLIB\bin\db2dascmn.dll
(00340000 - 00368000) C:\PROGRA~1\IBM\SQLLIB\bin\db2osse_db2.dll
(00370000 - 00378000) C:\PROGRA~1\IBM\SQLLIB\bin\db2sec.dll
(00380000 - 00389000) C:\PROGRA~1\IBM\SQLLIB\bin\db2trcapi.dll
(00390000 - 00397000) C:\PROGRA~1\IBM\SQLLIB\bin\db2icuglue.dll [trp=Fri Aug 13 11:06:32 2004 dbg=n/a]
(00400000 - 00419000) C:\PROGRA~1\IBM\SQLLIB\bin\db2syscs.exe [trp=Fri Aug 13 11:41:37 2004 dbg=n/a]
(00420000 - 004E8000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2QG.dll [trp=Fri Aug 13 11:07:51 2004 dbg=n/a]
(004F0000 - 0057E000) C:\PROGRA~1\IBM\SQLLIB\bin\db2dstf.dll [trp=Fri Aug 13 10:04:34 2004 dbg=n/a]
(00580000 - 0064B000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2SQLIN.dll [trp=Fri Aug 13 09:51:20 2004 dbg=n/a]
(011B0000 - 011FC000) C:\PROGRA~1\IBM\SQLLIB\bin\db2licm.DLL [trp=Fri Aug 13 11:07:01 2004 dbg=n/a]
(02800000 - 028D1000) C:\PROGRA~1\IBM\SQLLIB\bin\dbghelp.dll
(10000000 - 10021000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2SYSP.dll [trp=Fri Aug 13 21:03:55 2004 dbg=Sun Aug 15 20:33:22 2004]
(4A800000 - 4A880000) C:\PROGRA~1\IBM\SQLLIB\bin\icuuc26db2engn.dll
(4AD00000 - 4B4D5000) C:\PROGRA~1\IBM\SQLLIB\bin\icudt26ldb2engn.dll
(60020000 - 60030000) C:\WINDOWS\system32\MSVCIRT.dll
(6C010000 - 6C6B5000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2APP.dll
(6C9F0000 - 6CB52000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2SYS.dll
(6CB60000 - 6CCFA000) C:\PROGRA~1\IBM\SQLLIB\bin\db2osse.dll
(6CD00000 - 6EAE6000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2ENGN.dll
(6EB20000 - 6EB2C000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2WINT.dll [trp=Fri Aug 13 11:08:48 2004 dbg=n/a]
(6EB30000 - 6EB77000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2SUBA.dll
(6EBA0000 - 6EC03000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2DLNK.dll [trp=Fri Aug 13 11:08:49 2004 dbg=n/a]
(71B20000 - 71B61000) C:\WINDOWS\System32\mswsock.dll
(71BF0000 - 71BF8000) C:\WINDOWS\system32\WS2HELP.dll
(71C00000 - 71C17000) C:\WINDOWS\system32\WS2_32.dll
(71C40000 - 71C97000) C:\WINDOWS\system32\NETAPI32.dll
(766D0000 - 766D9000) C:\WINDOWS\system32\SHFOLDER.DLL
(76ED0000 - 76EFA000) C:\WINDOWS\system32\DNSAPI.dll
(76F10000 - 76F3E000) C:\WINDOWS\system32\WLDAP32.dll
(76F50000 - 76F63000) C:\WINDOWS\system32\Secur32.dll
(76F70000 - 76F77000) C:\WINDOWS\System32\winrnr.dll
(76F80000 - 76F85000) C:\WINDOWS\system32\rasadhlp.dll
(77380000 - 77411000) C:\WINDOWS\system32\USER32.dll
(77420000 - 77523000) C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.3959_x-ww_D8713E55\comctl32.dll
(77670000 - 777A9000) C:\WINDOWS\system32\ole32.dll
(77B90000 - 77B98000) C:\WINDOWS\system32\VERSION.dll
(77BA0000 - 77BFA000) C:\WINDOWS\system32\MSVCRT.dll
(77C00000 - 77C48000) C:\WINDOWS\system32\GDI32.dll
(77C50000 - 77CEF000) C:\WINDOWS\system32\RPCRT4.dll
(77D00000 - 77D8B000) C:\WINDOWS\system32\OLEAUT32.dll
(77DA0000 - 77DF2000) C:\WINDOWS\system32\SHLWAPI.dll
(77E00000 - 77E21000) C:\WINDOWS\system32\NTMARTA.DLL
(77E40000 - 77F42000) C:\WINDOWS\system32\kernel32.dll
(77F50000 - 77FEB000) C:\WINDOWS\system32\ADVAPI32.dll
(7C800000 - 7C8C0000) C:\WINDOWS\system32\ntdll.dll
(7E020000 - 7E02F000) C:\WINDOWS\system32\SAMLIB.dll

++++++++++++++++++++++++++++++++++++++++++++
Failing instruction at 6CA75885 offset: 00000019 in <?sqloCrashBecauseOfMemoryCorruption@@YAXXZ> <sqlommgt.C:1035>
++++++++++++++++++++++++++++++++++++++++++++

0x6ca75865 JNL 6CA75857H
0x6ca75867 MOV ESP,EBP
0x6ca75869 POP EBP
0x6ca7586a RET
0x6ca7586b NOP
0x6ca7586c PUSH EBP
0x6ca7586d MOV EBP,ESP
0x6ca7586f MOV EAX,DWORD PTR DS:[+6CAB71A8H]
0x6ca75874 MOV EAX,DWORD PTR [EAX]
0x6ca75876 TEST EAX,EAX
0x6ca75878 JZ 6CA7587CH
0x6ca7587a MOVZX EAX,WORD PTR [EAX+33B2H]
0x6ca75881 TEST EAX,EAX
0x6ca75883 JNZ 6CA75871H
0x6ca75885 MOV DWORD PTR DS:[+0],5 <<<<
0x6ca7588f MOV ESP,EBP
0x6ca75891 POP EBP
0x6ca75892 RET
0x6ca75893 MOV ESI,ESI
0x6ca75895 LEA EDI,DWORD PTR [EDI]
0x6ca7589c PUSH EBP
0x6ca7589d MOV EBP,ESP
0x6ca7589f SUB ESP,+10H
0x6ca758a2 MOV DWORD PTR [EBP-0CH],EDI

++++++++++++++++++++++++++++++++++++++++++++

Stack calling chain:
--EBP -----EIP-----ARGS--
05D7DE18 6CA75885 820F0002 6CA7400A 6CA75B7D 014747C0 offset: 00000019 in <?sqloCrashBecauseOfMemoryCorruption@@YAXXZ> <sqlommgt.C:1035>
05D7DF28 6CAB265E 00000000 00000000 00000000 0410C040 offset: 0000002E in <__VInfreq__sqlofmblkEx> <cryptICCplatform.C:-1>
05D7DF40 6CA0EF10 05DBC058 00000000 6CAF9C40 05D7DFB8 offset: 00000030 in <_sqloTermVectoredIO> <NT/sqlofmgt.C:2888>
05D7DF78 6D467185 0410C040 05DBC040 00000000 00000000 offset: 00000099 in <?sqlbPFTermPrefetcher@@YAHPAUsqledbcb@@PAUSQLB_pfMisc@@***@Z> <sqlbpfchr.C:2308>
05D7E300 6D465D2C 05D7FF50 0000000C 00000000 6CAAAF23 offset: 000002F0 in <?sqlbPFPrefetcherEntryPoint@@***@Z> <sqlbpfchr.C:1844>
05D7FFB8 6CA3E71B 0B7F1C10 00000000 00000000 0B7F1C10 offset: 0000029F in <?sqloEDUEntry@@***@Z> <sqloedu.C:2537>
05D7FFEC 77E64829 6CA3E47C 0B7F1C10 00000000 00000000
Blair Kenneth Adamache
2007-09-19 14:00:21 UTC
Permalink
Move to the latest fixpack:

http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg21256235
Post by l***@us.ibm.com
Hello,
I have a DB2 v8 installation on a windows machine and even though the applications (FileNet) is not doing much, db2sysc eventually takes up all 3+ GB of memory and then crashes. The formated trap file is shown below.
Is this a known problem with a fixpack or is there a fix somewhere ?
Thanks.
Lipyeow
-------------------Memory Usage Information (in MB)-------------------
Physical Memory: 3711 total, 572 free.
Virtual Memory : 2047 total, 7 free.
Paging File : 5603 total, 2181 free.
Ext. Virtual : 0 free.
------------------DB2 Registry/Environment Variables-----------------
[e] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2_EXTSECURITY=YES
[g] DB2SYSTEM=EXTTECHTEST4
[g] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00
The following information is for pid <1432> tid <5344>
Exception C0000005 Occurred
Exception Address = 6CA75885
Invalid linear address 00000000
---------------
GS : 0000 FS : 003B ES : 0023 DS : 0023
EDI : 00000010 ESI : FFFFFFF0 EAX : 00000000 EBX : 00000000
ECX : 05D7FFA8 EDX : 00000000
EBP : 05D7DE18 EIP : 6CA75885 EFLG: 00010246 ESP : 05D7DE18
CS : 001B SS : 0023
The EXE is <C:\PROGRA~1\IBM\SQLLIB\bin\db2syscs.exe>
--------------
WARNING: DLL details might not be complete or stale.
(00260000 - 0026C000) C:\PROGRA~1\IBM\SQLLIB\bin\db2locale.dll [trp=Fri Aug 13 09:50:28 2004 dbg=n/a]
(00270000 - 002D8000) C:\PROGRA~1\IBM\SQLLIB\bin\db2g11n.dll [trp=Fri Aug 13 11:06:17 2004 dbg=n/a]
(002E0000 - 00307000) C:\PROGRA~1\IBM\SQLLIB\bin\db2genreg.dll
(00310000 - 00317000) C:\PROGRA~1\IBM\SQLLIB\bin\db2install.dll [trp=Sun Aug 15 19:30:50 2004 dbg=n/a]
(00320000 - 00335000) C:\PROGRA~1\IBM\SQLLIB\bin\db2dascmn.dll
(00340000 - 00368000) C:\PROGRA~1\IBM\SQLLIB\bin\db2osse_db2.dll
(00370000 - 00378000) C:\PROGRA~1\IBM\SQLLIB\bin\db2sec.dll
(00380000 - 00389000) C:\PROGRA~1\IBM\SQLLIB\bin\db2trcapi.dll
(00390000 - 00397000) C:\PROGRA~1\IBM\SQLLIB\bin\db2icuglue.dll [trp=Fri Aug 13 11:06:32 2004 dbg=n/a]
(00400000 - 00419000) C:\PROGRA~1\IBM\SQLLIB\bin\db2syscs.exe [trp=Fri Aug 13 11:41:37 2004 dbg=n/a]
(00420000 - 004E8000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2QG.dll [trp=Fri Aug 13 11:07:51 2004 dbg=n/a]
(004F0000 - 0057E000) C:\PROGRA~1\IBM\SQLLIB\bin\db2dstf.dll [trp=Fri Aug 13 10:04:34 2004 dbg=n/a]
(00580000 - 0064B000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2SQLIN.dll [trp=Fri Aug 13 09:51:20 2004 dbg=n/a]
(011B0000 - 011FC000) C:\PROGRA~1\IBM\SQLLIB\bin\db2licm.DLL [trp=Fri Aug 13 11:07:01 2004 dbg=n/a]
(02800000 - 028D1000) C:\PROGRA~1\IBM\SQLLIB\bin\dbghelp.dll
(10000000 - 10021000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2SYSP.dll [trp=Fri Aug 13 21:03:55 2004 dbg=Sun Aug 15 20:33:22 2004]
(4A800000 - 4A880000) C:\PROGRA~1\IBM\SQLLIB\bin\icuuc26db2engn.dll
(4AD00000 - 4B4D5000) C:\PROGRA~1\IBM\SQLLIB\bin\icudt26ldb2engn.dll
(60020000 - 60030000) C:\WINDOWS\system32\MSVCIRT.dll
(6C010000 - 6C6B5000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2APP.dll
(6C9F0000 - 6CB52000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2SYS.dll
(6CB60000 - 6CCFA000) C:\PROGRA~1\IBM\SQLLIB\bin\db2osse.dll
(6CD00000 - 6EAE6000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2ENGN.dll
(6EB20000 - 6EB2C000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2WINT.dll [trp=Fri Aug 13 11:08:48 2004 dbg=n/a]
(6EB30000 - 6EB77000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2SUBA.dll
(6EBA0000 - 6EC03000) C:\PROGRA~1\IBM\SQLLIB\bin\DB2DLNK.dll [trp=Fri Aug 13 11:08:49 2004 dbg=n/a]
(71B20000 - 71B61000) C:\WINDOWS\System32\mswsock.dll
(71BF0000 - 71BF8000) C:\WINDOWS\system32\WS2HELP.dll
(71C00000 - 71C17000) C:\WINDOWS\system32\WS2_32.dll
(71C40000 - 71C97000) C:\WINDOWS\system32\NETAPI32.dll
(766D0000 - 766D9000) C:\WINDOWS\system32\SHFOLDER.DLL
(76ED0000 - 76EFA000) C:\WINDOWS\system32\DNSAPI.dll
(76F10000 - 76F3E000) C:\WINDOWS\system32\WLDAP32.dll
(76F50000 - 76F63000) C:\WINDOWS\system32\Secur32.dll
(76F70000 - 76F77000) C:\WINDOWS\System32\winrnr.dll
(76F80000 - 76F85000) C:\WINDOWS\system32\rasadhlp.dll
(77380000 - 77411000) C:\WINDOWS\system32\USER32.dll
(77420000 - 77523000) C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.3959_x-ww_D8713E55\comctl32.dll
(77670000 - 777A9000) C:\WINDOWS\system32\ole32.dll
(77B90000 - 77B98000) C:\WINDOWS\system32\VERSION.dll
(77BA0000 - 77BFA000) C:\WINDOWS\system32\MSVCRT.dll
(77C00000 - 77C48000) C:\WINDOWS\system32\GDI32.dll
(77C50000 - 77CEF000) C:\WINDOWS\system32\RPCRT4.dll
(77D00000 - 77D8B000) C:\WINDOWS\system32\OLEAUT32.dll
(77DA0000 - 77DF2000) C:\WINDOWS\system32\SHLWAPI.dll
(77E00000 - 77E21000) C:\WINDOWS\system32\NTMARTA.DLL
(77E40000 - 77F42000) C:\WINDOWS\system32\kernel32.dll
(77F50000 - 77FEB000) C:\WINDOWS\system32\ADVAPI32.dll
(7C800000 - 7C8C0000) C:\WINDOWS\system32\ntdll.dll
(7E020000 - 7E02F000) C:\WINDOWS\system32\SAMLIB.dll
++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++
0x6ca75865 JNL 6CA75857H
0x6ca75867 MOV ESP,EBP
0x6ca75869 POP EBP
0x6ca7586a RET
0x6ca7586b NOP
0x6ca7586c PUSH EBP
0x6ca7586d MOV EBP,ESP
0x6ca7586f MOV EAX,DWORD PTR DS:[+6CAB71A8H]
0x6ca75874 MOV EAX,DWORD PTR [EAX]
0x6ca75876 TEST EAX,EAX
0x6ca75878 JZ 6CA7587CH
0x6ca7587a MOVZX EAX,WORD PTR [EAX+33B2H]
0x6ca75881 TEST EAX,EAX
0x6ca75883 JNZ 6CA75871H
0x6ca75885 MOV DWORD PTR DS:[+0],5 <<<<
0x6ca7588f MOV ESP,EBP
0x6ca75891 POP EBP
0x6ca75892 RET
0x6ca75893 MOV ESI,ESI
0x6ca75895 LEA EDI,DWORD PTR [EDI]
0x6ca7589c PUSH EBP
0x6ca7589d MOV EBP,ESP
0x6ca7589f SUB ESP,+10H
0x6ca758a2 MOV DWORD PTR [EBP-0CH],EDI
++++++++++++++++++++++++++++++++++++++++++++
--EBP -----EIP-----ARGS--
05D7DF28 6CAB265E 00000000 00000000 00000000 0410C040 offset: 0000002E in <__VInfreq__sqlofmblkEx> <cryptICCplatform.C:-1>
05D7DF40 6CA0EF10 05DBC058 00000000 6CAF9C40 05D7DFB8 offset: 00000030 in <_sqloTermVectoredIO> <NT/sqlofmgt.C:2888>
05D7FFEC 77E64829 6CA3E47C 0B7F1C10 00000000 00000000
Loading...