By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

Memory Heap Error

P: n/a
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

Feb 14 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Feb 14, 8:32*am, "Racerx" <p.paingan...@gmail.comwrote:
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.

Feb 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.