IC89502: SQLMTABLEITERATOR::EXECUTE SQLM_RC_MON_BUFFER_FULL ERROR MESSAGE SHOULD NOT BE RAISED IN DB2DIAG.LOG

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This message can be seen in the db2diag.log :
    
    FUNCTION: DB2 UDB, database monitor, sqlmTableIterator::execute,
    probe:453
    CALLED  : DB2 UDB, database monitor, sqlmTableIterator::execute
    RETCODE : ZRC=0x850D008C=-2062745460=SQLM_RC_MON_BUFFER_FULL
              "The Database System Monitor output buffer is full"
    
     This message is written to the db2diag.log when a snapshot was
    requested from the server side and the supplied buffer size was
    not
    sufficient to contain the full snapshot.
    This is expected behaviour and translates to a message :
    
    SQL1606W  The Database System Monitor output buffer is full.
    
    sent to the client.
    The client code ( e.g. CLP ) normally then chooses to resubmit
    the snapshot request with a bigger buffer size, hence the issue
    should be transparent to the user.
    
    The error message should hence not be written to the db2diag.log
    as it leads to confusion.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the database server to V10.1 Fix Pack 3              *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in DB2 V10.1 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89502

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-14

  • Closed date

    2013-10-21

  • Last modified date

    2013-10-21

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC91698

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC89502

Modified date:

2013-10-21

Translate my page

Machine Translation

Content navigation