Memory Heap Error
in [DB2]
|
From: Racerx on 14 Feb 2007 10:32 Hi All: I use db2 v8.1 fixpack 3 on AIX 5.1. I used to get a memory heap error few months ago. I sorted it out by setting the NUM_POOLAGENTS and MAXAGENTS equal. Also there was an issue with the event monitor reaching max space limits which was sorted out. Now there is no issues with the parameters or the event monitor file space but still i get the following error in my DIAGLOG:::::::::::::::::::::: 2007-02-14-16.45.02.549066 Instance:db2inst1 Node:000 PID:1515714(db2agent (HAPDB) 0) TID:1 Appid:GA010302.B261.0110BFEC54A9 database monitor sqm.gen_dlconn_events Probe:10 Database:HAPDB DIA8300C A memory heap error has occurred. ZRC=0x8B0F0000 2007-02-14-16.47.18.560367 Instance:db2inst1 Node:000 PID:1794206(db2agent (HAPDB) 0) TID:1 Appid:GA010302.B18F. 0110BFE9E539 database monitor sqm.gen_dlconn_events Probe:10 Database:HAPDB DIA8300C A memory heap error has occurred. ZRC=0x8B0F0000 2007-02-14-18.43.29.632981 Instance:db2inst1 Node:000 PID:1065148(db2agent (HAPDB) 0) TID:1 Appid:C0A80ABB.N504.0191C4142146 relation data serv sqlrr_call_implicitClose Probe:20 Database:HAPDB DIA0001E An internal error occurred. Report the following error code : "ZRC=0x00000000". PID:1065148 TID:1 Node:000 Title: SQLCA sqlcaid : SQLCA sqlcabc: 136 sqlcode: 100 sqlerrml: 0 sqlerrmc: sqlerrp : SQLRIEXT⬠sqlerrd : (1) 0x80040001 (2) 0x00000001 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 02000 Can someone plz help me on this . Is there something that I must look into or go for a fixpack upgradation ???????? Regards, Racerx
From: Mark A on 14 Feb 2007 13:08 On Feb 14, 8:32 am, "Racerx" <p.paingan...(a)gmail.com> wrote: > Hi All: > I use db2 v8.1 fixpack 3 on AIX 5.1. > > I used to get a memory heap error few months ago. > I sorted it out by setting the NUM_POOLAGENTS and MAXAGENTS equal. > Also there was an issue with the event monitor reaching max space > limits which was sorted out. > > Now there is no issues with the parameters or the event monitor file > space but still i get the following error in my > DIAGLOG:::::::::::::::::::::: > > 2007-02-14-16.45.02.549066  Instance:db2inst1  Node:000 > PID:1515714(db2agent (HAPDB) 0)  TID:1 > Appid:GA010302.B261.0110BFEC54A9 > database monitor  sqm.gen_dlconn_events Probe:10  Database:HAPDB > > DIA8300C A memory heap error has occurred. > ZRC=0x8B0F0000 > > 2007-02-14-16.47.18.560367  Instance:db2inst1  Node:000 > PID:1794206(db2agent (HAPDB) 0)  TID:1  Appid:GA010302.B18F. > 0110BFE9E539 > database monitor  sqm.gen_dlconn_events Probe:10  Database:HAPDB > > DIA8300C A memory heap error has occurred. > ZRC=0x8B0F0000 > > 2007-02-14-18.43.29.632981  Instance:db2inst1  Node:000 > PID:1065148(db2agent (HAPDB) 0)  TID:1 > Appid:C0A80ABB.N504.0191C4142146 > relation data serv  sqlrr_call_implicitClose Probe:20  Database:HAPDB > > DIA0001E An internal error occurred. Report the following error > code : > "ZRC=0x00000000". > > PID:1065148 TID:1 Node:000 Title: SQLCA >  sqlcaid : SQLCA   sqlcabc: 136  sqlcode: 100  sqlerrml: 0 >  sqlerrmc: >  sqlerrp : SQLRIEXT⬠>  sqlerrd : (1) 0x80040001    (2) 0x00000001    (3) 0x00000000 >       (4) 0x00000000    (5) 0x00000000    (6) 0x00000000 >  sqlwarn : (1)    (2)    (3)    (4)     (5)    (6) >       (7)    (8)    (9)    (10)     (11) >  sqlstate: 02000 > > Can someone plz help me on this . > Is there something that I must look into or go for a fixpack > upgradation ???????? > > Regards, > Racerx I would upgrade to the latest fixpack.
|
Pages: 1 Prev: LOGARCHMETH1 Next: SQL1477N Table "<table-name>" cannot be accessed |