IBM Support

IC68914: GET_DBSIZE_INFO WRONG, DATABASECAPACITY SHOWS INCORRECT VALUE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When using the GET_DBSIZE_INFO procedure databasecapacity may
    not be correct.
    >db2 "call get_dbsize_info(?,?,?,0)"
    
    
    Value of output parameters
    
    --------------------------
    
    Parameter Name : SNAPSHOTTIMESTAMP
    
    Parameter Value : 2010-03-01-12.34.59.537249
    
    
    
    Parameter Name : DATABASESIZE
    
    Parameter Value : 78913536
    
    
    
    Parameter Name : DATABASECAPACITY
    
    Parameter Value : 33521660          <------------Is an incorrect
    value and is less than the databasesize
    
    
    
    Return Status = 0
    
    This comes from the function running as a fenced process, and
    the fenced user doesn't have the correct permissions to access
    the sms tablespace containers.
    

Local fix

  • Assign read and write on the sms container directories to the
    fenced user.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using V9.7 fix pack 2 and earlier                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When using the GET_DBSIZE_INFO procedure databasecapacity    *
    * may                                                          *
    * not be correct.                                              *
    *                                                              *
    * >db2 "call get_dbsize_info(?,?,?,0)"                         *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * Value of output parameters                                   *
    *                                                              *
    *                                                              *
    *                                                              *
    * --------------------------                                   *
    *                                                              *
    *                                                              *
    *                                                              *
    * Parameter Name : SNAPSHOTTIMESTAMP                           *
    *                                                              *
    *                                                              *
    *                                                              *
    * Parameter Value : 2010-03-01-12.34.59.537249                 *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * Parameter Name : DATABASESIZE                                *
    *                                                              *
    *                                                              *
    *                                                              *
    * Parameter Value : 78913536                                   *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * Parameter Name : DATABASECAPACITY                            *
    *                                                              *
    *                                                              *
    *                                                              *
    * Parameter Value : 33521660          <------------Is an       *
    * incorrect                                                    *
    * value and is less than the databasesize                      *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * Return Status = 0                                            *
    *                                                              *
    *                                                              *
    *                                                              *
    * This comes from the function running as a fenced process,    *
    * and                                                          *
    * the fenced user doesn't have the correct permissions to      *
    * access                                                       *
    * the sms tablespace containers.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to fix pack 3                                        *
    ****************************************************************
    

Problem conclusion

Temporary fix

  • Assign read and write on the sms container directories to the
    fenced user.
    

Comments

APAR Information

  • APAR number

    IC68914

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-28

  • Closed date

    2011-01-27

  • Last modified date

    2011-01-27

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

    IZ76703

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

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC68914

Modified date: 27 January 2011