db6/db2 crash,help me plz

[Former Member]

enviroment: sap ecc6, db2 version 09.01.0004, windows

sympton: the db2 crash suddenly at 2010.07.05 22:29. No clear clue is shown in db2dialog.log. No useful log is shown in os log except message like db2 need to shutdown.

following is the db2diag.log.give me a hint plz. thx in advance.

2010-07-05-22.22.33.234000+480 I299767619F468 LEVEL: Event

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10

START : Invoking G:\db2\db2prd\db2_software
bin\db2cos.bat from oper system services sqloEDUExceptionFilter

2010-07-05-22.29.39.312000+480 I299768089F429 LEVEL: Event

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:20

STOP : Completed invoking G:\db2\db2prd\db2_software
bin\db2cos.bat

2010-07-05-22.29.39.312000+480 I299768520F515 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1

MESSAGE : Error in agent servicing application with coor_node:

DATA #1 : Hexdump, 2 bytes

0x0000000149938242 : 0000 ..

2010-07-05-22.29.39.312000+480 I299769037F522 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:2

MESSAGE : Error in agent servicing application with coor_agent_index:

DATA #1 : Hexdump, 2 bytes

0x0000000149938240 : 8906 ..

2010-07-05-22.29.39.328000+480 I299769561F518 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:3

MESSAGE : Error in agent servicing application with CLIENT PID:

DATA #1 : Hexdump, 4 bytes

0x0000000149938220 : 3339 3030 3900

2010-07-05-22.29.39.328000+480 I299770081F624 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:4

MESSAGE : Error in agent servicing application with INBOUND APPLICATION ID:

DATA #1 : Hexdump, 31 bytes

0x00000000097C195B : 3139 322E 3136 382E 322E 3136 302E 3338 192.168.2.160.38

0x00000000097C196B : 3632 2E31 3030 3730 3530 3531 3130 33 62.100705051103

2010-07-05-22.29.39.328000+480 I299770707F529 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:5

MESSAGE : Error in agent servicing application with INBOUND SEQUENCE NUMBER:

DATA #1 : Hexdump, 2 bytes

0x00000000097C199C : 8314 ..

2010-07-05-22.29.39.343000+480 I299771238F433 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:6

MESSAGE : Error in agent servicing application with OUTBOUND APPLICATION ID:

2010-07-05-22.29.39.343000+480 I299771673F434 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:7

MESSAGE : Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2010-07-05-22.29.39.343000+480 I299772109F618 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:8

MESSAGE : Error in agent servicing application with AUTHORIZATION ID:

DATA #1 : Hexdump, 31 bytes

0x000000000BE9990D : 5341 5050 5244 2020 0000 0000 0000 0000 SAPPRD ........

0x000000000BE9991D : 0000 0000 0000 0000 0000 0000 0000 00 ...............

2010-07-05-22.29.39.359000+480 I299772729F529 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:9

MESSAGE : Error in agent servicing application with PRODUCT SIGNATURE:

DATA #1 : Hexdump, 8 bytes

0x000000000BE9AC68 : 5351 4C30 3930 3134 SQL09014

2010-07-05-22.29.39.359000+480 I299773260F535 LEVEL: Error

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:10

MESSAGE : Error in agent servicing application with APPLICATION NAME:

DATA #1 : Hexdump, 13 bytes

0x000000000BE9AC3E : 6469 7370 2B77 6F72 6B2E 4558 45 disp+work.EXE

2010-07-05-22.29.39.609000+480 I299773797F444 LEVEL: Severe

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10

MESSAGE : DIA0505I Execution of a component signal handling function has begun.

2010-07-05-22.29.39.656000+480 I299774243F161 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: **** DRDA ASCB ****

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.656000+480 I299774406F166 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: **** DRDA CMNMGR CB ****

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.671000+480 I299774574F166 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: **** RECEIVE BUFFER ****

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.687000+480 I299774742F164 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: **** SEND BUFFERS ****

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.687000+480 I299774908F169 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: **** CONNECTION HANDLE ****

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.703000+480 I299775079F167 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: **** DRDA ATTRIBUTES ****

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.703000+480 I299775248F166 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: **** AS UCINTERFACE ****

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.718000+480 I299775416F161 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: *** INPUT SQLDD ***

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.734000+480 I299775579F458 LEVEL: Severe

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20

MESSAGE : DIA0506I Execution of a component signal handling function is

complete.

2010-07-05-22.29.39.734000+480 I299776039F441 LEVEL: Severe

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:50

MESSAGE : DIA0505I Execution of a component signal handling function has begun.

2010-07-05-22.29.39.734000+480 I299776482F154 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: RDS AGENT CB

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.750000+480 I299776638F147 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: SQLCA

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.750000+480 I299776787F153 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: RDS UCINTFC

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.765000+480 I299776942F157 LEVEL: Severe

PID:1992 TID:4144 NODE:000 Title: RDS UCINTFC PID

Dump File:
prd\db2dumpPRD\19924144.000

2010-07-05-22.29.39.781000+480 I299777101F499 LEVEL: Severe

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0

MESSAGE : RDS UCINTFC: pCurrentPID->rdbcolidLen =

DATA #1 : Hexdump, 2 bytes

0x0000000008747348 : 0800 ..

2010-07-05-22.29.39.781000+480 I299777602F512 LEVEL: Severe

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0

MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =

DATA #1 : Hexdump, 8 bytes

0x000000000874736A : 4E55 4C4C 4944 2020 NULLID

2010-07-05-22.29.39.781000+480 I299778116F578 LEVEL: Severe

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0

MESSAGE : RDS UCINTFC: pCurrentPID->rdbname =

DATA #1 : Hexdump, 18 bytes

0x0000000008747358 : 5052 4420 2020 2020 2020 2020 2020 2020 PRD

0x0000000008747368 : 2020

Edited by: tao pan on Jul 6, 2010 5:23 AM

[Former Member · Accepted solution]

i'm so sorry for the bad format of my question. i just copy them from db2diag.log to here. it's right format when it's in editing stauts, but the format is wrong after i post it.could someone kindly tell me how to post in correct format?

the db2diag.log so too long that it cann't be post once. could i uploade it as a attachment?

[paul_power · Accepted solution]

Dear Tao Pam,

Without going to in-depth into the crash occurence, was there any trap files or FODC folders created at the time of the crash?

Could you post the first 3 pages of the trap file?

I would recommend that you update to the latest fixpack for your release, 9.1 FP 8 is currently certified and available from the service marketplace.

I suspect you have encountered either APAR IZ58997 or similar.

ps Fixpack 9 is due for release in the coming weeks.

Kind regards,

Paul

[Former Member · Accepted solution]

hi, paul

i found files like 19924144.000, a19924144.000, db2cos19924144.0, DB19924144.TRP, l39131.000 and stmm.765.log in sapdump directory.

i'll reformat DB19924144.TRP later. sorry. too busy.

[paul_power · Accepted solution]

Hi Tao,

DB19924144.TRP would be the one of most interest. Check if it was created around the time of the crash.

Because it is a Windows system, the trap files are in binary format.

db2xprt <trap file name>.TRP <trap file name>.out

Once this has been performed please send the created *.out files.

If the above command should fail, please use

db2xprt <trap file name>.TRP <trap file name>.FMT

and send us the FMT files.

Details about db2xprt.exe can be found:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.

ibm.db2.udb.admin.doc/doc/r0023738.htm

The <stack> section is of most interest.

Regards,

Paul

[Former Member · Accepted solution]

hi,paul

following is the first part of trap file.

<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet href="http://raspd.torolab.ibm.com/db2trapfile.xsl" type="text/xsl"?>

<DB2TrapFile version="1.0">

<Trap>

<Header>

DB2 build information: DB2 v9.1.400.2873 SAP_19276 SQL09014

timestamp: 2010-07-05-22.22.33.171000

uname: S:Windows

comment: WR21398_19276

process id: 1992

thread id: 4144

</Header>

<SystemInformation>

Number of Processors: 16

Processor Type: AMD64 Family 6 Model 15 Stepping 11

OS Version: Microsoft Windows 2003 Family, Service Pack 2 (5.2)

Current Build: 3790

</SystemInformation>

<MemoryInformation>

<Usage>

Physical Memory: 28670 total, 17741 free.

Virtual Memory : 8388607 total, 8383420 free.

Paging File : 88860 total, 67581 free.

Ext. Virtual : 0 free.

</Usage>

</MemoryInformation>

<EnvironmentVariables>

<![CDATA[

[e] DB2DBDFT=PRD

[e] DB2PATH=G:\db2\db2prd\db2_software\

[g] DB2_EXTSECURITY=YES

[g] DB2PATH=G:\db2\db2prd\db2_software\

[g] DB2INSTDEF=DB2PRD

]]></EnvironmentVariables>

<SignalDetails>

Exception C0000005 Occurred

Exception Address = 0000000001D02B60

Other Unknown access fault

</SignalDetails>

<Registers>

GS : 002B FS : 0053 ES : 002B DS : 002B

RDI : 00000000B1F68338 RSI : 00000000CCCA14C0 RAX : 0000000000000000 RBX : 0000000013F984E0

RCX : 00000000B1F68338 RDX : 0000000114ACEF80 R8 : 0000000000000000 R9 : 0000000000000000

R10 : 0000000114ACEF88 R11 : 0000000000000001 R12 : 0000000000000001 R13 : 00000000B807C800

R14 : 0000000000000000 R15 : 000000014AEEDBA0

RBP : 0000000148E91C80 RIP : 0000000001D02B60 EFLG: 0000000000010202 RSP : 00000001499392E8

CS : 0033 SS : 002B

</Registers>

<ProcessObjects>

(00000000003D0000 - 00000000003E4000) DB2WINT64.dll [trp=Wed Dec 19 03:06:53 2007 dbg=n/a]

(00000000003F0000 - 00000000003FD000) DB2INSTALL64.dll [trp=Wed Dec 19 02:54:48 2007 dbg=n/a]

(0000000000400000 - 0000000000420000) db2syscs.exe [trp=Wed Dec 19 12:39:18 2007 dbg=n/a]

(00000000004C0000 - 00000000004D4000) DB2LOCALE64.dll [trp=Wed Dec 19 02:55:58 2007 dbg=n/a]

(00000000004E0000 - 0000000000726000) DB2OSSE64.dll [trp=Wed Dec 19 05:38:59 2007 dbg=n/a]

(0000000000730000 - 0000000000742000) DB2TRCAPI64.dll

(0000000000750000 - 0000000000D56000) DB2G11N64.dll [trp=Wed Dec 19 09:44:21 2007 dbg=n/a]

(0000000000D60000 - 0000000000D9B000) DB2GENREG64.dll [trp=Wed Dec 19 01:21:36 2007 dbg=n/a]

(0000000000DA0000 - 0000000000E8A000) msvcp60.dll

(0000000000E90000 - 0000000003275000) DB2ENGN.dll [trp=Wed Dec 19 09:40:11 2007 dbg=n/a]

(0000000003280000 - 0000000003397000) DB2QG.dll [trp=Wed Dec 19 09:46:17 2007 dbg=n/a]

(00000000033A0000 - 000000000340E000) DB2DLNK.dll [trp=Wed Dec 19 02:43:59 2007 dbg=n/a]

(0000000003410000 - 000000000348F000) DB2LICM64.dll [trp=Wed Dec 19 09:45:03 2007 dbg=n/a]

(0000000003490000 - 0000000003BCC000) DB2APP64.dll [trp=Wed Dec 19 09:33:20 2007 dbg=n/a]

(0000000003BD0000 - 0000000003BF0000) DB2DASCMN64.dll [trp=Wed Dec 19 08:03:47 2007 dbg=n/a]

(0000000003BF0000 - 0000000003C0A000) DB2OSSE_DB264.dll [trp=Wed Dec 19 11:07:36 2007 dbg=n/a]

(0000000003C10000 - 0000000003CE4000) DB2DSTF.dll [trp=Wed Dec 19 01:21:25 2007 dbg=n/a]

(0000000003CF0000 - 0000000003DA7000) DB2DL.dll [trp=Wed Dec 19 09:34:29 2007 dbg=n/a]

(0000000003DB0000 - 0000000003DCA000) DB2XML4CMessages5_6.dll

(0000000003DD0000 - 00000000045A6000) DB2xslt4c_1_10.dll

(00000000045B0000 - 00000000045B6000) DB2XalanMessages_1_10.dll

(00000000045C0000 - 000000000472D000) icuindb232.dll

(0000000004730000 - 000000000476D000) DB2PSMD.dll [trp=Wed Dec 19 02:58:55 2007 dbg=n/a]

(0000000005750000 - 0000000005766000) icclib.dll

(0000000005770000 - 000000000577B000) IBMOSgroups64.dll

(0000000005780000 - 000000000578C000) IBMOSauthserver64.dll

(0000000006150000 - 000000000624A000) libeay32.dll

(0000000006460000 - 0000000006534000) DB2SQNX.dll [trp=Wed Dec 19 09:47:00 2007 dbg=n/a]

(0000000006540000 - 0000000006551000) db2tcpl.DLL [trp=Wed Dec 19 09:53:06 2007 dbg=n/a]

(00000000082C0000 - 00000000082CC000) IBMOSauthclient64.dll

(000000000A010000 - 000000000A02B000) db2tcp64.DLL [trp=Wed Dec 19 03:06:36 2007 dbg=n/a]

(0000000010000000 - 00000000102B5000) DB2SYS64.dll [trp=Wed Dec 19 09:50:04 2007 dbg=n/a]

(0000000012000000 - 000000001253D000) DB2xml4c_5_6.dll

(000000004A800000 - 000000004A929000) icuucdb232.dll

(000000004AD00000 - 000000004B658000) icudtdb232.dll

(0000000078C00000 - 0000000078D0B000) USER32.dll

(0000000078D10000 - 0000000078EAC000) kernel32.dll

(0000000078EB0000 - 0000000078FFB000) ntdll.dll

(0000000101FD0000 - 0000000101FDD000) DB2SEC64.dll [trp=Wed Dec 19 11:07:22 2007 dbg=n/a]

(0000000101FE0000 - 0000000101FED000) DB2DASKRB64.dll [trp=Wed Dec 19 08:04:55 2007 dbg=n/a]

(00000001112F0000 - 000000011130E000) DB2STRUC.dll [trp=Wed Dec 19 03:00:35 2007 dbg=n/a]

(00000001166D0000 - 0000000116729000) DB2DASAPI64.dll [trp=Wed Dec 19 08:03:41 2007 dbg=n/a]

(0000000116970000 - 00000001169B9000) DB2HREC.dll

(00000001169C0000 - 00000001169CA000) DB2XMLINIT531.dll [trp=Sat Dec 15 14:38:40 2007 dbg=n/a]

(0000000116EF0000 - 000000011706F000) db2dbroutext.DLL [trp=Wed Dec 19 07:31:08 2007 dbg=n/a]

(00000001181C0000 - 00000001181FE000) db2clifn.dll [trp=Wed Dec 19 09:33:58 2007 dbg=n/a]

(0000000118F10000 - 0000000118F2B000) db2adminListHist.DLL [trp=Wed Dec 19 07:30:57 2007 dbg=n/a]

(0000000121DC0000 - 0000000121EE6000) sfcfiles.dll

(000007FF5FCC0000 - 000007FF5FE6E000) syssetup.dll

(000007FF60240000 - 000007FF60388000) vssapi.dll

(000007FF60910000 - 000007FF60E5B000) xpsp2res.dll

(000007FF64BD0000 - 000007FF64BE8000) ntfrsapi.dll

(000007FF688B0000 - 000007FF688C0000) MfcSubs.dll

(000007FF69580000 - 000007FF6958D000) LPK.DLL

(000007FF6D470000 - 000007FF6D500000) hnetcfg.dll

(000007FF72750000 - 000007FF7288E000) dbghelp.dll

(000007FF74AD0000 - 000007FF74AF4000) certadm.dll

(000007FF74E00000 - 000007FF74F10000) catsrvut.dll

(000007FF76E90000 - 000007FF76EA6000) SAMLIB.dll

(000007FF76EB0000 - 000007FF76EBB000) wshtcpip.dll

(000007FF76EF0000 - 000007FF76F6C000) MSWSOCK.dll

(000007FF76FF0000 - 000007FF76FFC000) WSOCK32.dll

(000007FF77010000 - 000007FF77031000) MPR.dll

(000007FF77040000 - 000007FF7704C000) WS2HELP.dll

(000007FF77050000 - 000007FF77080000) WS2_32.dll

(000007FF770B0000 - 000007FF77149000) NETAPI32.dll

(000007FF77300000 - 000007FF7730F000) ntdsbcli.dll

(000007FF77F70000 - 000007FF77F8A000) ntmsapi.dll

(000007FF78BD0000 - 000007FF78C5E000) USP10.dll

(000007FF7A870000 - 000007FF7A87C000) POWRPROF.dll

(000007FF7B6B0000 - 000007FF7B70F000) certcli.dll

(000007FF7C390000 - 000007FF7C495000) USERENV.dll

(000007FF7CD50000 - 000007FF7CE60000) urlmon.dll

(000007FF7D020000 - 000007FF7D04C000) MSASN1.dll

(000007FF7D050000 - 000007FF7D1AD000) CRYPT32.dll

(000007FF7D1B0000 - 000007FF7D1CA000) WINSTA.dll

(000007FF7D1E0000 - 000007FF7D219000) IMM32.DLL

(000007FF7D2A0000 - 000007FF7D6ED000) msi.dll

(000007FF7D790000 - 000007FF7D974000) SETUPAPI.dll

(000007FF7D9C0000 - 000007FF7D9CC000) SHFOLDER.DLL

(000007FF7DF60000 - 000007FF7DF7C000) ATL.DLL

(000007FF7E040000 - 000007FF7E046000) sfc.dll

(000007FF7E0C0000 - 000007FF7E0D0000) PSAPI.DLL

(000007FF7E140000 - 000007FF7E190000) WINTRUST.dll

(000007FF7E190000 - 000007FF7E1C4000) sfc_os.dll

(000007FF7E1D0000 - 000007FF7E1E3000) imagehlp.dll

(000007FF7E1F0000 - 000007FF7E21E000) AuthZ.dll

(000007FF7E220000 - 000007FF7E25B000) NTMARTA.DLL

(000007FF7E670000 - 000007FF7E6BF000) DNSAPI.dll

(000007FF7E6D0000 - 000007FF7E6DB000) WTSapi32.dll

(000007FF7E6E0000 - 000007FF7E746000) WLDAP32.dll

(000007FF7E750000 - 000007FF7E772000) Secur32.dll

(000007FF7E780000 - 000007FF7E78B000) winrnr.dll

(000007FF7E790000 - 000007FF7E797000) rasadhlp.dll

(000007FF7E7A0000 - 000007FF7E87E000) CLBCatQ.DLL

(000007FF7E880000 - 000007FF7E9DA000) COMRes.dll

(000007FF7E9E0000 - 000007FF7EAF6000) OLEAUT32.dll

(000007FF7EB00000 - 000007FF7ED85000) ole32.dll

(000007FF7ED90000 - 000007FF7EE2B000) SHLWAPI.dll

(000007FF7F030000 - 000007FF7F1B7000) comctl32.dll

(000007FF7F1C0000 - 000007FF7FBA8000) SHELL32.dll

(000007FF7FBF0000 - 000007FF7FBFB000) VERSION.dll

(000007FF7FC00000 - 000007FF7FC86000) msvcrt.dll

(000007FF7FC90000 - 000007FF7FD2C000) GDI32.dll

(000007FF7FD30000 - 000007FF7FEC9000) RPCRT4.dll

(000007FF7FED0000 - 000007FF7FFE6000) ADVAPI32.dll

</ProcessObjects>

<POFDisassembly>

<![CDATA[

Failing instruction at 0000000001D02B60 offset: 0000000000026A46 in <?sqlns_qgs@@YAHPEAVsqlnq_qur@@W4sqlnq_requestType@@PEAD@Z> <NotFound:-1>

]]></POFDisassembly>

<StackTrace>

<![CDATA[

-

---

RBP--

---

RIP

---

ARGS--

---

00000001499392E0 0000000001D02B60 0000000000000001 0000000114ACEF60 000000420000000A 0000000000000000 offset: 0000000000026A46 in <?sqlns_qgs@@YAHPEAVsqlnq_qur@@W4sqlnq_requestType@@PEAD@Z> <NotFound:-1>

0000000149939AC0 0000000001FC66FE 0000000000000000 0000000000000000 0000000000000009 0000000002EDB8A0 offset: 000000000002D36E in <sqlra_get_inc_bind_sect> <NotFound:-1>

0000000149939C40 0000000001EE5466 0000000000000000 0000000000000000 0000000000004E7C 0000000000000010 offset: 0000000000001A6C in <?sqlrr_open@@YAHPEAUdb2UCinterface@@PEAUdb2UCCursorInfo@@@Z> <NotFound:-1>

0000000149939DA0 00000000013BC5FB 0000000148D10080 00000000097E4F80 0000000000000000 0000000000000000 offset: 000000000003CD07 in <?sqljsRollbackBeforeConnectReset@@YAXPEAUUCconHandle@@@Z> <NotFound:-1>

0000000149939F60 00000000013A49CD 0000000005566D20 000000000137F739 0000000000000028 0000000000000066 offset: 00000000000250D9 in <?sqljsRollbackBeforeConnectReset@@YAXPEAUUCconHandle@@@Z> <NotFound:-1>

000000014993A060 000000000137E8BD FFFFFFFF81360012 0000000000000000 000000000000FFFF 0000000000000064 offset: 000000000000444D in <?sqljsDrdaAsCbGwCopyStreamLob@@YAHPEAUdb2UCinterface@@@Z> <NotFound:-1>

000000014993A100 000000000137E607 0000000000000000 0000000000000000 0000000000000000 0000000000000000 offset: 0000000000004197 in <?sqljsDrdaAsCbGwCopyStreamLob@@YAHPEAUdb2UCinterface@@@Z> <NotFound:-1>

000000014993A1A0 000000000137C8CC 0000000000000000 0000000000000000 0000000000000000 0000000000000000 offset: 000000000000245C in <?sqljsDrdaAsCbGwCopyStreamLob@@YAHPEAUdb2UCinterface@@@Z> <NotFound:-1>

000000014993F930 000000000137C65D DB22FFF88FFF22B8 00000000000000C0 0000000000000000 0000000008746AD0 offset: 00000000000021ED in <?sqljsDrdaAsCbGwCopyStreamLob@@YAHPEAUdb2UCinterface@@@Z> <NotFound:-1>

000000014993FC90 00000000011ED33D 0000000000000003 0000000100000001 0000000000000000 000000001008F22C offset: 0000000000005F9F in <?sqleGetAgent@@YAHHPEAUsqlcc_init_struct@@HPEAUsqlz_app_hdl@@PEAUsqlkdRqstRplyFmt@@H@Z> <NotFound:-1>

000000014993FF70 000000001008F48D 0000000006D5F400 0000000000000000 0000000000000000 000000014993FFA8 offset: 0000000000000859 in <sqloSpawnEDU> <NotFound:-1>

000000014993FFA0 0000000078D3B71A 0000000000000000 0000000000000000 0000000000000000 0000000000000000

]]></StackTrace>

<StackDump>

<Frame num="1">

[Former Member · Accepted solution]

hi paul.

i found the following line in db2diag.log:

2010-07-05-22.29.39.906000+480 I299782233F775 LEVEL: Severe

PID : 1992 TID : 4144 PROC : db2syscs.exe

INSTANCE: DB2PRD NODE : 000 DB : PRD

APPHDL : 0-1673 APPID: 192.168.2.160.3862.100705051103

AUTHID : SAPPRD

FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0

DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes

sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0

sqlerrmc:

sqlerrp : SQL09014

sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000

(4) 0x00000000 (5) 0x00000000 (6) 0x00000000

sqlwarn : (1) (2) (3) (4) (5) (6)

(7) (8) (9) (10) (11)

sqlstate:

i found sap note 1173256 according to the key word 'SQL09014'.it's seems to be a bug of FP4SAP and i need apply newer Fix Pack.i also check note 977845 and 101809.should i apply FP8SAP v9.1.800.3604 ? thanks for u opinion in advance.

[Former Member · Accepted solution]

finally i chose to apply FP5.for every fp has several bugs, no fp is an exception. i chose the fp with less bugs.

thanks for everyone again!

[sunny_pahuja2]

Hi

Check below thread:

Thanks

Sunny