trap in snapshot table fonction V8 FP4

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jean-Marc Blaise
    #1

    trap in snapshot table fonction V8 FP4

    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


    Tags: None
    • Blair Adamache
      #2
      Re: trap in snapshot table fonction V8 FP4

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

      Jean-Marc Blaise wrote:
      [color=blue]
      > 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
      >
      >[/color]

        Comment

        • Dan Scott
          #3
          Re: trap in snapshot table fonction V8 FP4

          Jean-Marc Blaise wrote:
          [color=blue]
          > 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
          >
          >[/color]

          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

            Comment

            • Blair Adamache
              #4
              Re: trap in snapshot table fonction V8 FP4

              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:
              [color=blue]
              > 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
              >
              >[/color]

                Comment

                • Blair Adamache
                  #5
                  Re: trap in snapshot table fonction V8 FP4

                  Fix now identified by APAR JR19347. Targetted for Fixpak 5.

                  Jean-Marc Blaise wrote:[color=blue]
                  > 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
                  >
                  >[/color]

                    Comment

                    • Gert van der Kooij
                      #6
                      Re: trap in snapshot table fonction V8 FP4

                      In article <bq84nh$di3$1@h anover.torolab. ibm.com>, badamache@
                      2muchspam.yahoo .com says...[color=blue]
                      > Fix now identified by APAR JR19347. Targetted for Fixpak 5.
                      >[/color]


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

                      Take a look at the reported error on your newsserver
                      ( msgid MPG.17c77906ce3 4555f989693@new s.software.ibm. com )

                        Comment

                        • Blair Adamache
                          #7
                          Re: trap in snapshot table fonction V8 FP4

                          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:[color=blue]
                          > In article <bq84nh$di3$1@h anover.torolab. ibm.com>, badamache@
                          > 2muchspam.yahoo .com says...
                          >[color=green]
                          >>Fix now identified by APAR JR19347. Targetted for Fixpak 5.
                          >>[/color]
                          >
                          >
                          >
                          > I thought this problem was already fixed before GA last year?
                          >
                          > Take a look at the reported error on your newsserver
                          > ( msgid MPG.17c77906ce3 4555f989693@new s.software.ibm. com )[/color]

                            Comment

                            • Jean-Marc Blaise
                              #8
                              Re: trap in snapshot table fonction V8 FP4

                              Thank you Blair, that's quick !

                              "Blair Adamache" <badamache@2muc hspam.yahoo.com > a écrit dans le message de
                              news:bq84nh$di3 $1@hanover.toro lab.ibm.com...[color=blue]
                              > Fix now identified by APAR JR19347. Targetted for Fixpak 5.
                              >
                              > Jean-Marc Blaise wrote:[color=green]
                              > > Dear all,
                              > >
                              > > It seems there is a problem with some snapshot table functions, if you[/color][/color]
                              try[color=blue][color=green]
                              > > to divide by some element that is unset or equal to 0. This generates a[/color][/color]
                              trap[color=blue][color=green]
                              > > file with the db2fmp.exe process, that keeps going on, until your disk[/color][/color]
                              is[color=blue][color=green]
                              > > 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[/color][/color]
                              table[color=blue][color=green]
                              > > (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[/color][/color]
                              Information[color=blue][color=green]
                              > > 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[/color][/color]
                              monitor[color=blue][color=green]
                              > > 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[/color][/color]
                              table[color=blue][color=green]
                              > > function:
                              > >
                              > >
                              > > Table 500. Snapshot Monitor SQL Table Functions
                              > > Monitor level SQL table function Information returned
                              > > Database manager SNAPSHOT_DBM Database manager level[/color][/color]
                              information.[color=blue][color=green]
                              > > Database manager SNAPSHOT_FCM Database manager level information
                              > > regarding the fast communication manager (FCM).
                              > > Database manager SNAPSHOT_FCMNOD E Database manager level[/color][/color]
                              information[color=blue][color=green]
                              > > for a partition regarding the fast communication manager (FCM).
                              > > Database manager SNAPSHOT_SWITCH ES Database manager monitor[/color][/color]
                              switch[color=blue][color=green]
                              > > settings.
                              > >
                              > >
                              > > ...
                              > >
                              > > And in the page regarding the SNAPSHOT_DATABA SE (admin/r0007092.htm)[/color][/color]
                              table[color=blue][color=green]
                              > > function, there is no link back to the "snapshot monitor SQL table
                              > > functions" page.
                              > >
                              > > Best regards,
                              > >
                              > > Jean-Marc
                              > >
                              > >[/color]
                              >[/color]


                                Comment

                                • Gert van der Kooij
                                  #9
                                  Re: trap in snapshot table fonction V8 FP4

                                  In article <bq89jh$18h$1@h anover.torolab. ibm.com>, badamache@
                                  2muchspam.yahoo .com says...[color=blue]
                                  > Symptoms look different to me - you got an SQL0444N - the APAR below
                                  > causes either an ever-growing trap file or SQL0430N.
                                  >[/color]

                                  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 :)

                                    Comment

                                    Previous template Next
                                    Working...