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_datab ase('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_FCMNOD E Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCH ES Database manager monitor switch
settings.
....
And in the page regarding the SNAPSHOT_DATABA SE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.
Best regards,
Jean-Marc
8  2983 
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_datab ase('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_FCMNOD E Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCH ES Database manager monitor switch
settings.
...
And in the page regarding the SNAPSHOT_DATABA SE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.
Best regards,
Jean-Marc
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_datab ase('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_FCMNOD E Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCH ES Database manager monitor switch
settings.
...
And in the page regarding the SNAPSHOT_DATABA SE (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
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_datab ase('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_FCMNOD E Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCH ES Database manager monitor switch
settings.
...
And in the page regarding the SNAPSHOT_DATABA SE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.
Best regards,
Jean-Marc
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_datab ase('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_FCMNOD E Database manager level information
for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCH ES Database manager monitor switch
settings.
...
And in the page regarding the SNAPSHOT_DATABA SE (admin/r0007092.htm) table
function, there is no link back to the "snapshot monitor SQL table
functions" page.
Best regards,
Jean-Marc
In article <bq**********@h anover.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************* ***********@new s.software.ibm. com )
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**********@h anover.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************* ***********@new s.software.ibm. com )
Thank you Blair, that's quick !
"Blair Adamache" <ba*******@2muc hspam.yahoo.com > a écrit dans le message de
news:bq******** **@hanover.toro lab.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_datab ase('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_FCMNOD E Database manager level
information for a partition regarding the fast communication manager (FCM).
Database manager SNAPSHOT_SWITCH ES Database manager monitor
switch settings.
...
And in the page regarding the SNAPSHOT_DATABA SE (admin/r0007092.htm)
table function, there is no link back to the "snapshot monitor SQL table
functions" page.
Best regards,
Jean-Marc
In article <bq**********@h anover.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 :) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Philippe Mesmeur |
last post by:
J'ai eu une longue discussion hier au sujet des parametres de fonction
const.
La personne etait pour mettre "const" devant TOUS les parametres ne devant
pas etre modifies.
A mon avis, il faut le faire que SI le parametre est un pointeur ou une
référence.
int fct1(const int* i);
|
by: John Gibson |
last post by:
Hi, all.
I have a table which is continually updated with the latest totals. I
would like to take snapshots of some of the data in that table and store
it in a second table to run statistics on it later. What might some
ways of doing this be?
Illustrative (I hope) example using fruit-qty-on-hand at a grocery store:
Fruit_table ...
|
by: Prince Kumar |
last post by:
Is there anyway to display the partition number while taking snapshot
on all the partitions (-2) using the snapshot function?
ex,
select TABLESPACE_NAME, TOTAL_PAGES from table(SNAPSHOT_TBS_CFG ( ' ',
-2 )) as snap.
Is there anyway, I can get the partition number for which the data is
being retrieved?.
|
by: Civilian_Target |
last post by:
Is there any way in DB2 to automate the taking of a snapshot, for
example, a function that will cause a db2 snapshot to be taken every 5
minutes and written to a uniquely named file?
Am I better off attempting to do this with my poor knowledge of dos
batch files?
I'm running UDB 8.2 on Windows 2000.
Thanks.
|
by: Ina Schmitz |
last post by:
Hello,
I would like to get the logical and physical reads for every sql statement
executed.
Thatfore, I used the command "db2 get snapshot for dynamic sql on
<mydatabase>". There, I could see the logical and physical reads from
bufferpool for every statement monitored. Am I right?
But now, I would like to read these results out of a table...
| | |
by: bluedolphin |
last post by:
Hello All:
I have been brought onboard to help on a project that had some
performance problems last year. I have taken some steps to address
the issues in question, but a huge question mark remains.
Last year, all of the tables and reports were stored in Access. The
database was put online so that end users could access the reports...
|
by: veffen |
last post by:
Hello all,
I'm trying to call the snapshot table function SNAP_GET_TBSP via a jdbc
connection using the following query:
SELECT * FROM TABLE(SNAP_GET_TBSP(CAST(NULL AS VARCHAR(1), -1)) AS T
In CLP this works properly, but when I execute it from java, I get the
following SQL exception:
|
by: Bill Hutchison |
last post by:
I have a query that returns different results (3508 rows for snapshot,
6288 for dynaset) and that is the only thing I change to get the
different results. When I try to make a table from the query, it
makes 3508 rows. I also know that there are 6288 unique rows in the
results. Is there some configuration choice that is causing the
snapshot...
|
by: MPD |
last post by:
Hi
How can I create a job in sql agent to create a new snapshot every hour?
I have, for eg a T-SQL that does it manually.
create database Snapshotter_snap_20070418_1821 on
( name = Snapshotter, filename =
'c:\temp\Snapshotter_snap_20070418_1821.ss')
as snapshot of Snapshotter
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
