IBM Support

PK87348: ENABLE BASIC ROW FORMAT FOR UNIVERSAL TABLE SPACES

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ENABLE BASIC ROW FORMAT FOR UNIVERSAL TABLE SPACES
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS users                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 9 Basic Row Format and Reordered    *
    *                      Row Format Support                      *
    ****************************************************************
    * RECOMMENDATION: Apply PTF when available                     *
    ****************************************************************
    This apar provides additional support for Basic Row Format (BRF)
    and Reordered Row Format (RRF) on DB2 9 for z/OS.
    The summary of changes are as follows:
    
    1. SPRMRRF
    Hidden DSNZPARM SPRMRRF will be converted to an opaque, online
    changeable DSNZPARM.  Default value will remain SPRMRRF=ENABLE.
    
    2. CREATE TABLESPACE
    When SPRMRRF=ENABLE in DB2 9 NFM, newly created table spaces
    will be in RRF; otherwise BRF when SPRMRRF=DISABLE.  This
    includes Universal Table Spaces (UTS - PBR or PBG), with the
    exception that XML table spaces will always be created in RRF
    regardless of SPRMRRF setting.
    
    3. ALTER TABLE ADD PARTITION and PBG Growth
    When SPRMRRF=ENABLE in DB2 9 NFM, newly added partition(s) by
    ALTER ADD PARTITION or PBG growth will be created in RRF;
    otherwise BRF when SPRMRRF=DISABLE.
    With the following exceptions :
    - For an existing BRF table space containing table(s) with
      editproc, a newly created partition will always be in BRF
      regardless of SPRMRRF setting.  The same is true for existing
      RRF table space with editproc, where new partitions will be
      created in RRF format
    - Newly created partitions of a XML table space will always be
      in RRF format
    
    4. REORG TABLESPACE and LOAD REPLACE
    REORG TABLESPACE and LOAD REPLACE will honor the SPRMRRF setting
    in DB2 9 NFM as follows:
    - When SPRMRRF=ENABLE, eligible table space will be converted
      from BRF to RRF
    - When SPRMRRF=DISABLE, eligible table space will not be
      converted from BRF to RRF. That is, if the table space is in
      BRF prior to LOAD or REORG, it will remain in BRF after
      utility completes; similarly if the table space is in RRF, it
      will stay in RRF.
    - Compression attribute of the table space is no longer
      considered for row format conversion.  That is, a COMPRESS YES
      or COMPRESS NO BRF table space can be converted to RRF in
      DB2 9 NFM by LOAD or REORG when SPRMRRF=ENABLE.
    - a new utility keyword, ROWFORMAT, is introduced to enable user
      to choose the output format of the table space or partition(s)
      being load replaced or reorganized.
    
    ----------------------------------------------------------------
    
    The Utility Guide and Reference has been updated to add the
    new ROWFORMAT option:
    
    updated SYNTAX DIAGRAM:
    
             .-DATA-.  .-INDDN--SYSREC-.
    >>-LOAD--+------+--+---------------+--+---------------+---->
                       |-INDDN--ddname-|  |-ROWFORMAT BRF-|
                                          |-ROWFORMAT RRF-|
    
    
    >>-REORG TABLESPACE--+-------+-+-------+-+----------------->
                         |-CLONE-| |-REUSE-| |-ROWFORMAT BRF-|
                                             |-ROWFORMAT RRF-|
    
    DESCRIPTION: ROWFORMAT
    
    Specifies the output row format in the affected table space
    or partition.  This keyword only affects utility behavior
    in DB2 9 NFM, and overrides the existing SPRMRRF setting when
    specified.  This keyword has no effect on LOB, catalog,
    directory, XML and Universal Table Spaces participating in
    a CLONE relationship.
    
      BRF - specifies that the table space or partition(s)
            being reorganized or replaced will be converted to
            or remained in Basic Row Format (BRF).
      RRF - specifies that the table space or partition(s)
            being reorganized or replaced will be converted to
            or remained in Reordered Row Format (RRF).
    
    ----------------------------------------------------------------
    
    The Messages and Codes book will be updated to add the
    following messages:
    
    | DSNU1173I
    |   csect-name TABLE SPACE dbname.tsname WILL BE CONVERTING
    |              FROM row-format1 TO row-format2
    
    | Explanation:
    | REORG TABLESPACE or LOAD REPLACE is converting the row
    | format of the affected table space or partition(s) as
    | specified.
    
    | Severity: 0 (informational)
    
    | System action:  Processing continues.
    
    | User Response: No action is required.
    
    ________________________________________________________
    
    | DSNU1174I
    |   csect-name TABLE SPACE dbname.tsname WILL REMAIN IN
    |              row-format DUE TO explanation
    
    | Explanation:
    | REORG TABLESPACE or LOAD REPLACE will keep the existing
    | format of the table space or partition(s) due to the
    | character string explanation provided in the message.
    
    | Severity: 0 (informational)
    
    | System action:  Processing continues.
    
    | User Response: No immediate action is required.  If user
    | attempts to change the row format of the affected table
    | space or partition via keyword ROWFORMAT, refer to the
    | provided reason as to why utility cannot perform the
    | conversion as requested.
    
    ----------------------------------------------------------------
    
    This PTF converts hidden DSNZPARM SPRMRRF to an opaque,
    online-changeable DSNZPARM called RRF.  The RRF parameter is
    meaningful only in V9 NFM.  It can be set to either ENABLE
    or DISABLE.
    
    - ENABLE, the default, means that:
    Newly created table spaces, or newly added partitions on
    Partitioned By Growth (PBG) table space and by ALTER ADD
    PARTITION, will be created in RRF, with the exceptions noted
    further below.  Existing BRF table spaces will be converted
    to RRF by LOAD REPLACE or REORG TABLESPACE
    
    - DISABLE means that
    Newly created table spaces, including Universal Table Spaces
    (UTS), and newly added partitions on PBG and by ALTER ADD
    PARTITION, will be created in BRF.  Existing BRF table spaces
    will not be converted to RRF by LOAD REPLACE/REORG TABLESPACE
    
    For either setting:
    - Newly created partitions for existing BRF table spaces that
    contain table(s) with an editproc will always be in BRF;
    similarly, existing RRF table spaces with editproc will always
    have new partitions created in RRF
    - XML table spaces will always be in RRF
    - Existing RRF table spaces will not be converted to BRF
    by LOAD REPLACE/REORG TABLESPACE except when requested
    explicitly with the ROWFORMAT keyword
    - Universal Table Spaces (UTS) involved in a CLONE
    relationship will never be converted from BRF to RRF or vice
    versa by LOAD REPLACE or REORG TABLESPACE regardless of the
    SPRMRRF or utility keyword settings
    

Problem conclusion

  • Code has been modified to provide further support on BRF and RRF
    on DB2 9 for z/OS.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK87348

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2009-05-26

  • Closed date

    2009-09-23

  • Last modified date

    2009-11-04

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

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

    UK50411 UK50412

Modules/Macros

  • DSNDQWPZ DSNDSPRM DSNDUSMF DSNDUSMM DSNFMDIR
    DSNFUDRA DSNFUDRB DSNFUDRC DSNFUDRD DSNFUDRE DSNTIDXA DSNTIJUZ
    DSNTINST DSNUGDDF DSNUGDDM DSNUGMST DSNUGPRT DSNUGTTF DSNUGTTM
    DSNUMSGA DSNUMSGB DSNUMSGC DSNUMSGD DSNUMSGE DSNURFIT DSNURWI
    DSNWZIF9 DSNXIAB6 DSNXICTS DSNXIPGA DSN6SPRC DSN6SPRM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK50411

       UP09/10/14 P F910

  • R910 PSY UK50412

       UP09/10/14 P F910

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.



Document information

More support for: DB2 for z/OS

Software version: 9.1

Reference #: PK87348

Modified date: 04 November 2009


Translate this page: