473,380 Members | 1,121 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,380 software developers and data experts.

db2mtrk and instance crash

Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because this 20
Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc
Nov 12 '05 #1
8 4586
I've passed this along to the developers...will let you know what I find
out.

Jean-Marc Blaise wrote:
Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because this 20
Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc

Nov 12 '05 #2
del db2trc1.*
db2trc db2 on
db2mtrk -i
db2trc dmp db2trc1.dmp
db2trc off
db2trc fmt db2trc1.dmp db2trc1.fmt


I:\DB2USR>del db2trc1.*

I:\DB2USR>db2trc db2 on
Trace is turned on

I:\DB2USR>db2mtrk -i
Tracking Memory on: 2003/12/11 at 10:01:30

Memory for instance

appctlh appctlh appctlh appctlh appctlh utilh pckcacheh
16.0K 16.0K 16.0K 16.0K 80.0K 16.0K 480.0K

catcacheh bph bph bph bph bph bph
160.0K 7.9M 1.1M 592.0K 336.0K 208.0K 144.0K

lockh dbh monh other fcmbp
272.0K 3.2M 176.0K 52.4M 16.6M
I:\DB2USR>db2trc dmp db2trc1.dmp
Trace has been dumped to file "db2trc1.dmp"

I:\DB2USR>db2trc off
Trace is turned off

I:\DB2USR>db2trc fmt db2trc1.dmp db2trc1.fmt
Trace truncated : NO
Trace wrapped : NO
Total number of trace records : 9393
Number of trace records formatted : 9393

I:\DB2USR>findstr /i "fenced" db2trc1.fmt

I:\DB2USR>find /i "fenced" db2trc1.fmt

---------- DB2TRC1.FMT

I:\DB2USR>find /i "fmp" db2trc1.fmt

---------- DB2TRC1.FMT

I:\DB2USR>find /i "snap" db2trc1.fmt

---------- DB2TRC1.FMT
215 entry DB2 oper system services GetSnapshotBuffer fnc (1.3.15.25.0)
2430 exit DB2 oper system services GetSnapshotBuffer fnc (2.3.15.25.0)
2431 entry DB2 oper system services GetSnapshot fnc (1.3.15.24.0)
2440 entry DB2 database monitor sqm___sqlm_send_snapshot_db2ra fnc
(1.3.13.122.0)
5150 exit DB2 database monitor sqm___sqlm_send_snapshot_db2ra fnc
(2.3.13.122.0)
5155 exit DB2 oper system services GetSnapshot fnc (2.3.15.24.0)
5159 entry DB2 oper system services GetSnapshotBuffer fnc (1.3.15.25.0)
5849 exit DB2 oper system services GetSnapshotBuffer fnc (2.3.15.25.0)
5850 entry DB2 oper system services GetSnapshot fnc (1.3.15.24.0)
5859 entry DB2 database monitor sqm___sqlm_send_snapshot_db2ra fnc
(1.3.13.122.0)
8657 exit DB2 database monitor sqm___sqlm_send_snapshot_db2ra fnc
(2.3.13.122.0)
8662 exit DB2 oper system services GetSnapshot fnc (2.3.15.24.0)
DB2 SELECT ROUTINENAME FROM SYSCAT.ROUTINES WHERE FENCED='Y'

I see snapshots in fenced='y'.
Not sure if it's the db2mtrk or health monitor or something else that calls
them. (see in trace)
You can x-ref db2trc/routines with db2diag.log to see what happened.

I agree with you that an instance crash is not what one would expect.

btw, do you have (HEALTH_MON) = ON ?

PM
"Jean-Marc Blaise" <no****@nowhere.com> a écrit dans le message de
news:br**********@news-reader3.wanadoo.fr...
Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because this 20 Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc

Nov 12 '05 #3
PM, in my case, the db is not active. HEALTH_MON is OFF.
Cheers,

Jean-Marc

"PM (pm3iinc-nospam)" <PM(pm3iinc-nospam)@sympatico.ca> a écrit dans le
message de news:Uy*******************@news20.bellglobal.com.. .
del db2trc1.*
db2trc db2 on
db2mtrk -i
db2trc dmp db2trc1.dmp
db2trc off
db2trc fmt db2trc1.dmp db2trc1.fmt


I:\DB2USR>del db2trc1.*

I:\DB2USR>db2trc db2 on
Trace is turned on

I:\DB2USR>db2mtrk -i
Tracking Memory on: 2003/12/11 at 10:01:30

Memory for instance

appctlh appctlh appctlh appctlh appctlh utilh pckcacheh
16.0K 16.0K 16.0K 16.0K 80.0K 16.0K 480.0K

catcacheh bph bph bph bph bph bph
160.0K 7.9M 1.1M 592.0K 336.0K 208.0K 144.0K

lockh dbh monh other fcmbp
272.0K 3.2M 176.0K 52.4M 16.6M
I:\DB2USR>db2trc dmp db2trc1.dmp
Trace has been dumped to file "db2trc1.dmp"

I:\DB2USR>db2trc off
Trace is turned off

I:\DB2USR>db2trc fmt db2trc1.dmp db2trc1.fmt
Trace truncated : NO
Trace wrapped : NO
Total number of trace records : 9393
Number of trace records formatted : 9393

I:\DB2USR>findstr /i "fenced" db2trc1.fmt

I:\DB2USR>find /i "fenced" db2trc1.fmt

---------- DB2TRC1.FMT

I:\DB2USR>find /i "fmp" db2trc1.fmt

---------- DB2TRC1.FMT

I:\DB2USR>find /i "snap" db2trc1.fmt

---------- DB2TRC1.FMT
215 entry DB2 oper system services GetSnapshotBuffer fnc (1.3.15.25.0)
2430 exit DB2 oper system services GetSnapshotBuffer fnc (2.3.15.25.0)
2431 entry DB2 oper system services GetSnapshot fnc (1.3.15.24.0)
2440 entry DB2 database monitor sqm___sqlm_send_snapshot_db2ra fnc
(1.3.13.122.0)
5150 exit DB2 database monitor sqm___sqlm_send_snapshot_db2ra fnc
(2.3.13.122.0)
5155 exit DB2 oper system services GetSnapshot fnc (2.3.15.24.0)
5159 entry DB2 oper system services GetSnapshotBuffer fnc (1.3.15.25.0)
5849 exit DB2 oper system services GetSnapshotBuffer fnc (2.3.15.25.0)
5850 entry DB2 oper system services GetSnapshot fnc (1.3.15.24.0)
5859 entry DB2 database monitor sqm___sqlm_send_snapshot_db2ra fnc
(1.3.13.122.0)
8657 exit DB2 database monitor sqm___sqlm_send_snapshot_db2ra fnc
(2.3.13.122.0)
8662 exit DB2 oper system services GetSnapshot fnc (2.3.15.24.0)
DB2 SELECT ROUTINENAME FROM SYSCAT.ROUTINES WHERE FENCED='Y'

I see snapshots in fenced='y'.
Not sure if it's the db2mtrk or health monitor or something else that calls them. (see in trace)
You can x-ref db2trc/routines with db2diag.log to see what happened.

I agree with you that an instance crash is not what one would expect.

btw, do you have (HEALTH_MON) = ON ?

PM
"Jean-Marc Blaise" <no****@nowhere.com> a écrit dans le message de
news:br**********@news-reader3.wanadoo.fr...
Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because this

20
Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc


Nov 12 '05 #4
FYI, we've reproduced this here, and fix is being put in for 8.2.

Sean McKeough wrote:
I've passed this along to the developers...will let you know what I find
out.

Jean-Marc Blaise wrote:
Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because
this 20
Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc

Nov 12 '05 #5
Thanks Sean.

What about the memory not accounted by db2mtrk ? If DB2_FMP_COMM_HEAPSZ is
not set, DB2 UDB will allocate a 20 Mb segment, and the execution of fenced
stored procedure will consume some memory. But the db2mtrk seems not report
increase of memory usage, except at the package cache and dbheap level.

Shouldn't this memory from DB2_FMP_COMM_HEAPSZ accounted somewhere, at the
instance level ?

Regards,

Jean-Marc

"Sean McKeough" <mc******@nospam.ca.ibm.com> a écrit dans le message de
news:br**********@hanover.torolab.ibm.com...
FYI, we've reproduced this here, and fix is being put in for 8.2.

Sean McKeough wrote:
I've passed this along to the developers...will let you know what I find
out.

Jean-Marc Blaise wrote:
Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because
this 20
Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc

Nov 12 '05 #6
Yes, I'm expecting this should be part of the change...I'll confirm with
the developer.

Jean-Marc Blaise wrote:
Thanks Sean.

What about the memory not accounted by db2mtrk ? If DB2_FMP_COMM_HEAPSZ is
not set, DB2 UDB will allocate a 20 Mb segment, and the execution of fenced
stored procedure will consume some memory. But the db2mtrk seems not report
increase of memory usage, except at the package cache and dbheap level.

Shouldn't this memory from DB2_FMP_COMM_HEAPSZ accounted somewhere, at the
instance level ?

Regards,

Jean-Marc

"Sean McKeough" <mc******@nospam.ca.ibm.com> a écrit dans le message de
news:br**********@hanover.torolab.ibm.com...
FYI, we've reproduced this here, and fix is being put in for 8.2.

Sean McKeough wrote:
I've passed this along to the developers...will let you know what I find
out.

Jean-Marc Blaise wrote:
Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because
this 20
Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc


Nov 12 '05 #7
The developer is aware if this missing heap info, and is going to look
at adding it in a subesequent release...I have an internal defect open
to track the requirement with.

Sean McKeough wrote:
FYI, we've reproduced this here, and fix is being put in for 8.2.

Sean McKeough wrote:
I've passed this along to the developers...will let you know what I
find out.

Jean-Marc Blaise wrote:
Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because
this 20
Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc

Nov 12 '05 #8
Thanks for your feedback, Sean.
JM

"Sean McKeough" <mc******@nospam.ca.ibm.com> a écrit dans le message de
news:br**********@hanover.torolab.ibm.com...
The developer is aware if this missing heap info, and is going to look
at adding it in a subesequent release...I have an internal defect open
to track the requirement with.

Sean McKeough wrote:
FYI, we've reproduced this here, and fix is being put in for 8.2.

Sean McKeough wrote:
I've passed this along to the developers...will let you know what I
find out.

Jean-Marc Blaise wrote:

Hi,

I'm on Linux Intel, V8.1 / FP4. I have an instance crash.
The test case:

db2set DB2_FMP_COMM_HEAPSZ = 0
db2stop
db2start
db2mtrk -i -d -p -v ==> Instance is crashed.

Btw, we can say that the db2mtrk cannot be totally trusted, because
this 20
Mb shared memory used by DB2 is not tracked by the tool.

Regards,

Jean-Marc

Nov 12 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Krice | last post by:
Is it possible that construction of a global instance can fail? I'm suspecting this because the program seems to crash before main(). Is it a better practice to declare a pointer for the object...
2
by: nek | last post by:
Would someone care to comment the following results of DB2MTRK execution, thanks. The platform is W2K SP with DB2 V8.1, SP2. We have this result when running db2mtrk -i Appctlh ...
10
by: Philip Sherman | last post by:
SELECT columns FROM t1 JOIN t2
8
by: Lana Zapornikova | last post by:
We are using DB2 Workgroup Server, v. 8.1, fixpack 5 under Windows 2003 Standart Edition. There were series of similar instance crashes. At the begining, some errors appeared in the...
2
by: Mike | last post by:
Greetings, Having a major problem here. running version 8.2 on win2003 server. The problem I am having is backing up a database seems to get to the last part of the backup and then fails. This...
0
by: Zahni | last post by:
Win 2003 Enterprise, 14 GB RAM, /3GB and /PAE DB2_AWE=1,330000,40000 Simple test: wrote two batches: :10 db2 activate database ga db2 deactivate database ga goto 10
0
by: cbielins | last post by:
We are about to 'stress test' our DB2 environment. I've played with db2mtrk off and on, trying to figure out how it's mapping the memory to its components. If I have the following output: ...
2
by: truthinlife | last post by:
I am running the following commands on an AIX 5.2 server, using db2 udb v8.2.2. my ipcs -mb command gives me the following: IPC status from /dev/mem as of Mon Nov 20 12:47:25 EST 2006 T ID...
6
by: dunleav1 | last post by:
I have a db2 9 FP3a installation with one instance and one database installed. I have 4G of physical RAM and I have enabled the /3G switch in boot.ini. I am using STTM. If I run db2mtrk the...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.