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

trap in snapshot table fonction V8 FP4

P: n/a
Dear all,

It seems there is a problem with some snapshot table functions, if you try
to divide by some element that is unset or equal to 0. This generates a trap
file with the db2fmp.exe process, that keeps going on, until your disk is
full. I'm on W2K, DB2 UDB 8.1 FP4.

Test case:

db2start
db2 connect to sample
db2 "select POOL_ASYNC_DATA_READS / POOL_ASYNC_DATA_READ_REQS from table
(snapshot_database('sample',-1)) as t"

and you get the trap file.

Besides, I wish there be a link to each table function in the Information
Center; page admin/r0006117.htm. You get there a table with no link ...

Snapshot monitor SQL table functions
There are a number of different snapshot monitor SQL table functions
(referred to as snapshot table functions) available, each returning monitor
data about a specific area of the database system. For example, the
SNAPSHOT_BP snapshot table function captures a snapshot of buffer pool
information. The following table lists each available snapshot monitor table
function:
Table 500. Snapshot Monitor SQL Table Functions
Monitor level SQL table function Information returned
Database manager SNAPSHOT_DBM Database manager level information.
Database manager SNAPSHOT_FCM Database manager level information
regarding the fast communication manager (FCM).
Database manager SNAPSHOT_FCMNODE Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCHES Database manager monitor switch
settings.
....

And in the page regarding the SNAPSHOT_DATABASE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.

Best regards,

Jean-Marc
Nov 12 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
I'll look into this, but would really appreciate it if you contact IBM
support and open a PMR.

Jean-Marc Blaise wrote:
Dear all,

It seems there is a problem with some snapshot table functions, if you try
to divide by some element that is unset or equal to 0. This generates a trap
file with the db2fmp.exe process, that keeps going on, until your disk is
full. I'm on W2K, DB2 UDB 8.1 FP4.

Test case:

db2start
db2 connect to sample
db2 "select POOL_ASYNC_DATA_READS / POOL_ASYNC_DATA_READ_REQS from table
(snapshot_database('sample',-1)) as t"

and you get the trap file.

Besides, I wish there be a link to each table function in the Information
Center; page admin/r0006117.htm. You get there a table with no link ...

Snapshot monitor SQL table functions
There are a number of different snapshot monitor SQL table functions
(referred to as snapshot table functions) available, each returning monitor
data about a specific area of the database system. For example, the
SNAPSHOT_BP snapshot table function captures a snapshot of buffer pool
information. The following table lists each available snapshot monitor table
function:
Table 500. Snapshot Monitor SQL Table Functions
Monitor level SQL table function Information returned
Database manager SNAPSHOT_DBM Database manager level information.
Database manager SNAPSHOT_FCM Database manager level information
regarding the fast communication manager (FCM).
Database manager SNAPSHOT_FCMNODE Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCHES Database manager monitor switch
settings.
...

And in the page regarding the SNAPSHOT_DATABASE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.

Best regards,

Jean-Marc


Nov 12 '05 #2

P: n/a
Jean-Marc Blaise wrote:
Dear all,

It seems there is a problem with some snapshot table functions, if you try
to divide by some element that is unset or equal to 0. This generates a trap
file with the db2fmp.exe process, that keeps going on, until your disk is
full. I'm on W2K, DB2 UDB 8.1 FP4.

Test case:

db2start
db2 connect to sample
db2 "select POOL_ASYNC_DATA_READS / POOL_ASYNC_DATA_READ_REQS from table
(snapshot_database('sample',-1)) as t"

and you get the trap file.

Besides, I wish there be a link to each table function in the Information
Center; page admin/r0006117.htm. You get there a table with no link ...

Snapshot monitor SQL table functions
There are a number of different snapshot monitor SQL table functions
(referred to as snapshot table functions) available, each returning monitor
data about a specific area of the database system. For example, the
SNAPSHOT_BP snapshot table function captures a snapshot of buffer pool
information. The following table lists each available snapshot monitor table
function:
Table 500. Snapshot Monitor SQL Table Functions
Monitor level SQL table function Information returned
Database manager SNAPSHOT_DBM Database manager level information.
Database manager SNAPSHOT_FCM Database manager level information
regarding the fast communication manager (FCM).
Database manager SNAPSHOT_FCMNODE Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCHES Database manager monitor switch
settings.
...

And in the page regarding the SNAPSHOT_DATABASE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.

Best regards,

Jean-Marc


Jean-Marc:

Ugh, nasty trap; I'm sorry I can't help you there.

But you've made some excellent suggestions for improvement to the DB2
Information Center. I'll pass them on to the responsible writer--thanks!

Good luck,
Dan

Nov 12 '05 #3

P: n/a
Thank you for reporting the problem. After we reproduced it, we
correlated it to a problem another customer found. An APAR will be
opened soon. The other customer problem is PMR 13210,422,000.

Jean-Marc Blaise wrote:
Dear all,

It seems there is a problem with some snapshot table functions, if you try
to divide by some element that is unset or equal to 0. This generates a trap
file with the db2fmp.exe process, that keeps going on, until your disk is
full. I'm on W2K, DB2 UDB 8.1 FP4.

Test case:

db2start
db2 connect to sample
db2 "select POOL_ASYNC_DATA_READS / POOL_ASYNC_DATA_READ_REQS from table
(snapshot_database('sample',-1)) as t"

and you get the trap file.

Besides, I wish there be a link to each table function in the Information
Center; page admin/r0006117.htm. You get there a table with no link ...

Snapshot monitor SQL table functions
There are a number of different snapshot monitor SQL table functions
(referred to as snapshot table functions) available, each returning monitor
data about a specific area of the database system. For example, the
SNAPSHOT_BP snapshot table function captures a snapshot of buffer pool
information. The following table lists each available snapshot monitor table
function:
Table 500. Snapshot Monitor SQL Table Functions
Monitor level SQL table function Information returned
Database manager SNAPSHOT_DBM Database manager level information.
Database manager SNAPSHOT_FCM Database manager level information
regarding the fast communication manager (FCM).
Database manager SNAPSHOT_FCMNODE Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCHES Database manager monitor switch
settings.
...

And in the page regarding the SNAPSHOT_DATABASE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.

Best regards,

Jean-Marc


Nov 12 '05 #4

P: n/a
Fix now identified by APAR JR19347. Targetted for Fixpak 5.

Jean-Marc Blaise wrote:
Dear all,

It seems there is a problem with some snapshot table functions, if you try
to divide by some element that is unset or equal to 0. This generates a trap
file with the db2fmp.exe process, that keeps going on, until your disk is
full. I'm on W2K, DB2 UDB 8.1 FP4.

Test case:

db2start
db2 connect to sample
db2 "select POOL_ASYNC_DATA_READS / POOL_ASYNC_DATA_READ_REQS from table
(snapshot_database('sample',-1)) as t"

and you get the trap file.

Besides, I wish there be a link to each table function in the Information
Center; page admin/r0006117.htm. You get there a table with no link ...

Snapshot monitor SQL table functions
There are a number of different snapshot monitor SQL table functions
(referred to as snapshot table functions) available, each returning monitor
data about a specific area of the database system. For example, the
SNAPSHOT_BP snapshot table function captures a snapshot of buffer pool
information. The following table lists each available snapshot monitor table
function:
Table 500. Snapshot Monitor SQL Table Functions
Monitor level SQL table function Information returned
Database manager SNAPSHOT_DBM Database manager level information.
Database manager SNAPSHOT_FCM Database manager level information
regarding the fast communication manager (FCM).
Database manager SNAPSHOT_FCMNODE Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCHES Database manager monitor switch
settings.
...

And in the page regarding the SNAPSHOT_DATABASE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.

Best regards,

Jean-Marc


Nov 12 '05 #5

P: n/a
In article <bq**********@hanover.torolab.ibm.com>, badamache@
2muchspam.yahoo.com says...
Fix now identified by APAR JR19347. Targetted for Fixpak 5.

I thought this problem was already fixed before GA last year?

Take a look at the reported error on your newsserver
( msgid MP************************@news.software.ibm.com )
Nov 12 '05 #6

P: n/a
Symptoms look different to me - you got an SQL0444N - the APAR below
causes either an ever-growing trap file or SQL0430N.

Gert van der Kooij wrote:
In article <bq**********@hanover.torolab.ibm.com>, badamache@
2muchspam.yahoo.com says...
Fix now identified by APAR JR19347. Targetted for Fixpak 5.


I thought this problem was already fixed before GA last year?

Take a look at the reported error on your newsserver
( msgid MP************************@news.software.ibm.com )


Nov 12 '05 #7

P: n/a
Thank you Blair, that's quick !

"Blair Adamache" <ba*******@2muchspam.yahoo.com> a écrit dans le message de
news:bq**********@hanover.torolab.ibm.com...
Fix now identified by APAR JR19347. Targetted for Fixpak 5.

Jean-Marc Blaise wrote:
Dear all,

It seems there is a problem with some snapshot table functions, if you try to divide by some element that is unset or equal to 0. This generates a trap file with the db2fmp.exe process, that keeps going on, until your disk is full. I'm on W2K, DB2 UDB 8.1 FP4.

Test case:

db2start
db2 connect to sample
db2 "select POOL_ASYNC_DATA_READS / POOL_ASYNC_DATA_READ_REQS from table (snapshot_database('sample',-1)) as t"

and you get the trap file.

Besides, I wish there be a link to each table function in the Information Center; page admin/r0006117.htm. You get there a table with no link ...

Snapshot monitor SQL table functions
There are a number of different snapshot monitor SQL table functions
(referred to as snapshot table functions) available, each returning monitor data about a specific area of the database system. For example, the
SNAPSHOT_BP snapshot table function captures a snapshot of buffer pool
information. The following table lists each available snapshot monitor table function:
Table 500. Snapshot Monitor SQL Table Functions
Monitor level SQL table function Information returned
Database manager SNAPSHOT_DBM Database manager level information. Database manager SNAPSHOT_FCM Database manager level information
regarding the fast communication manager (FCM).
Database manager SNAPSHOT_FCMNODE Database manager level information for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCHES Database manager monitor switch settings.
...

And in the page regarding the SNAPSHOT_DATABASE (admin/r0007092.htm) table function, there is no link back to the "snapshot monitor SQL table
functions" page.

Best regards,

Jean-Marc

Nov 12 '05 #8

P: n/a
In article <bq**********@hanover.torolab.ibm.com>, badamache@
2muchspam.yahoo.com says...
Symptoms look different to me - you got an SQL0444N - the APAR below
causes either an ever-growing trap file or SQL0430N.


Yes, sorry. Things got mixed up.

I posted the same kind of error in

http://makeashorterlink.com/?K58421AA6 in june 2003

but thought it was posted in the beta newsgroup.

It must be the age :)

Nov 12 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.