PI12594: IN PITR MODE DISPLAY GROUP DETAIL INCORRECTLY SHOWS SPT01 INLINE LENGTH OF 0 AND PLACES SPT01 INTO AREOR STATUS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 v11 (CM) or DB2 V11 (NFM) in Point In Time Recovery
  (PITR) mode
  
  a DISPLAY GROUP DETAIL command incorrectly shows SPT01 INLINE
  LENGTH 0 when it is not zero.
  After the recovery SPT01 is incorrectly placed into AREOR
  status.
  

Local fix

• During the recovery do not issue a DISPLAY GROUP DETAIL
  command.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 10 for z/OS and DB2 11 for z/OS users of *
  *                                                              *
  *                   -DISPLAY GROUP                             *
  *                                                              *
  *                 command when the DB2 system is in            *
  *                 Point In Time Recovery (PITR) state.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the DB2 is in PITR,                *
  *                                                              *
  *                      -DISPLAY GROUP                          *
  *                                                              *
  *                      shows SPT01 INLINE LENGTH 0 even        *
  *                      though the inline length has not        *
  *                      been changed.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Directory and Catalog is not accessible when the DB2
  system is in PITR state. The information of SPT01 INLINE
  LENGTH therefore is not available.
  
  The message from DISPLAY GROUP should state that the resource
  is unavailable and should include the reason code, resource
  type and resource name that is not available instead of
  displaying the inline length 0.
  

Problem conclusion

• DB2 has been modified so that the message DSN7100I indicates
  the SPT01 INLINE LENGTH is not available and including
  the reason code, type of object and the object name when DB2
  is in PITR state.
  
  Additionally, when DB2 is in ENFM mode, DSN7100I also
  displays the mew function mode enablement information of
  each catalog and directory table space when DETAIL(*)
  option is specified in the DISPLAY GROUP command.
  This information is also unavailable when DB2 is in PITR
  state.
  
  DSN7100I message is modified as follows:
  
  1. When the DB2 is in PITR state, the SPT01 INLINE LENGTH
  information is replaced with :
  
  SPT01 INLINE LENGTH INFORMATION NOT AVAILABLE
            REASON 00C9000A
            TYPE 00000200
            NAME DSNDB01.DBD01
  
  2. When the DB2 is in ENFM mode and PITR state, the table
  space information is replaced with :
  
  TABLE SPACE NEW FUNCTION ENABLEMENT INFORMATION NOT AVAILABLE
            REASON 00C9000A
            TYPE 00000200
            NAME DSNDB01.DBD01
  
  Additional Keywords:  MSGDSN7100I RC00C9000A
  

Temporary fix

Comments

APAR Information

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

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

  UI18806 UI18807

Modules/Macros

• DSNFCDIR DSNFMDIR DSNF7DIR DSNUECMJ DSN7GCMD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI18806

     UP14/06/28 P F406

• RB10 PSY UI18807

     UP14/06/28 P F406

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.