IBM Support

PM37150: SUPPORT INDEXED DEDB AND FP SECONDARY INDEX

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • This APAR enables followings:
    -  DBD/PSB/ACB Compare/Mapper/Reversal utility and Consistency
    Checker can process indexed DEDB and FP Secondary Index.
    
     -  Integrity Checker can generate RDE for indexed DEDDB and FP
    Secondary Index when running under FPA and DRF.
    
     -  Integrity Checker can verify logic change of Partition
    Selection Exit specified by DEDB.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: IMS Library Integrity Utilities for z/OS,    *
    *                 Version 2 Release 1 (FMID=H27P210) users     *
    *                 and IMS High Performance Fast Path           *
    *                 Utilities of IMS Fast Path Solution Pack     *
    *                 Version 1 Release 1 (FMID=HAHQ110) users who *
    *                 use the Fast Path Advanced Tool or IMS       *
    *                 Recovery Solution Pack for z/OS, Version 1   *
    *                 Release 1 (FMID=HAHM110) users who use the   *
    *                 IMS Database Recovery Facility.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides new functions for    *
    *                      Library Integrity Utilities to support  *
    *                      indexed DEDB and FP secondary index.    *
    ****************************************************************
    * RECOMMENDATION: Apply the maintenance for this APAR.         *
    ****************************************************************
    This APAR includes the following enhancements to support
    indexed DEDB and FP secondary index:
    
    1. DBD/PSB/ACB Compare/Mapper/Reversal utility and Consistency
       Checker supports indexed DEDB and FP secondary index.
    
     - DBD/PSB/ACB Compare can report differences between two
       control blocks (DBDs, PSBs, or ACBs) of indexed DEDB and FP
       secondary index database definition and referencing PSBs.
     - DBD/PSB/ACB Mapper can produce a map and reports of indexed
       DEDB and FP secondary index database definition and
       referencing PSBs.
     - DBD/PSB/ACB Reversal can convert DBD/PSB/ACB control blocks
       of indexed DEDB and FP secondary index database definition
       and referencing PSBs back into IMS DBDGEN and IMS PSBGEN
       utility control statements.
     - Consistency Checker can verify consistency of indexed DEDB
       and FP secondary index database definition and referencing
       PSBs.
    
    2. When the INDEXBLD function of Fast Path Advanced Tool (FPA)
       of IMS High Performance Fast Path Utilities succeeds,
       Integrity Checker creates new RDEs for the FP secondary
       index and its primary DEDB area and records name/date/time
       of the subsystem.
    
    3. When IMS Database Recovery Facility (DRF) of IMS Recovery
       Solution Pack performs a time-stamp recovery of FP secondary
       index and its primary DEDB area, Integrity Checker restores
       the RDEs that was valid at the specified recovery time and
       uses that RDEs for DMB verification.
    
    4. Integrity Checker provides a new option to verify logic
       change of a user partition selection exit specified by DEDB
       with a user data partition group of the FP secondary index.
    

Problem conclusion

Temporary fix

Comments

  • ========================
    = DOCUMENTATION CHANGE =
    ========================
    IMS Library Integrity Utilities for z/OS Version 2 Release 1
    User's Guide (Document Number: SC19-2479-01) should be changed
    as follows.
    ================================================================
    --------------------------------------------------------------
    1.5           Functional enhancements in IMS Library Integrity
                  Utilities Version 2
    --------------------------------------------------------------
    The following description is added:
    
    Integrity Checker
    
    Enhancement of the verification option
          You can set the CHECKRV verification option for
         database recovery jobs by specifying the CHECKRV
         option in global option modules or in RDEs. For
         details, see "JCL requirements for the FABLPGEN
         program" in topic 3.5.1.1 and "INIT.DB command"
         in topic 3.8.3.
    |    You can set the CHKFPSEL verification option to
    |    verify changes in a DEDB partition selection
    |    exit routines by specifying the CHKFPSEL option
    |    in global option modules or in RDEs. For details,
    |    see "JCL requirements for the FABLPGEN program"
    |    in topic 3.5.1.1 and "INIT.DB command" in topic
    |    3.8.3. This option is provided by APAR PM37150.
    
    -------------------------------------------------------------
    3.5           Activating Integrity Checker
    3.5.1         Creating global option modules
    3.5.1.1       JCL requirements for the FABLPGEN program
    --------------------------------------------------------------
    The following description is added:
    
    Control statement keywords
    
       CHKRAND=
       CHKCOMP=
       CHKPSEL=
    |  CHKFPSEL=
             Specifies the option values that are to be used in
             creating a new RDE. The system default value for these
             parameters is N. For the meaning of the keywords, see
             the description of the INIT.DB command.
    
    --------------------------------------------------------------
    3.8           LICON utility reference
    3.8.1         JCL requirements for the LICON utility
    3.8.2         Input for the LICON utility
    3.8.3         INIT.DB command
    --------------------------------------------------------------
    The following description is added:
    
    Syntax
      _____________________________________________________________
     |                                                             |
    ||_ ____________________ ______________________________________|
    || |_CHKFPSEL(_ _Y_ _)_ |                                      |
    ||             |_N_|                                           |
     |_____________________________________________________________|
    
    Parameters
    
    |  CHKFPSEL (Y or N)
    |        Specifies the option to determine whether to verify
    |        changes in a DEDB partition selection exit routines
    |        by checksum. You can specify the following options:
    |
    |        Y    Check.
    |
    |        N    Do not check.
    |
    |        If CHECKON, CHECKBAT, CHECKLD, CHECKIC, or CHECKRV is
    |        set to Y, this specification is effective in each IMS
    |        environment.
    
    --------------------------------------------------------------
    3.8.5         CHANGE.DB command
    --------------------------------------------------------------
    The following description is added:
    
    Syntax
      _____________________________________________________________
     |                                                             |
    ||_ ____________________ ______________________________________|
    || |_CHKFPSEL(_ _Y_ _)_ |                                      |
    ||             |_N_|                                           |
     |_____________________________________________________________|
    
    Parameters
    
    |  CHKFPSEL (Y or N)
    |        Specifies the option to determine whether to verify
    |        changes in a DEDB partition selection exit routines
    |        by checksum. You can specify the following options:
    |
    |        Y    Check.
    |
    |        N    Do not check.
    |
    |        If CHECKON, CHECKBAT, CHECKLD, CHECKIC, or CHECKRV is
    |        set to Y, this specification is effective in each IMS
    |        environment.
    
    --------------------------------------------------------------
    3.8.12        Output from the LICON utility
    --------------------------------------------------------------
    The following description is added:
    
    Report field descriptions
    
    CONTROL SECTION:
    
    |  CHECK OPTION FOR FP PSEL
    |        Check option used for a DEDB partition selection exit
    |        routine.
    
    --------------------------------------------------------------
    4.0           Consistency Checker utility
    4.6           Output from Consistency Checker
    4.6.2         SYSPRINT data set
    4.6.2.2       PSB Check report
    --------------------------------------------------------------
    The title row of DBPCB INFORMATION of Figure 21 is changed to
    add (D) after PROCSEQ as follows:
    
     Figure 21. PSB Check report (Part 2 of 2)
     ----------------------- PSBLIB / ACBLIB -------------------
    |DBDNAME PCBNAME SENSEGS KEYLN PROCOPT PROCSEQ(D) VIEW  LIST
     ------- ------- ------- ----- ------- ---------- ----- ----
    
    The Following description is changed:
    
    |PROCSEQ(D)
     The name of a secondary index that is used to process a
     database through a secondary processing sequence
    |or the name of the primary DEDB database that the PCB needs to
    |access segments from using the secondary index.
    
    --------------------------------------------------------------
    5.0           DBD/PSB/ACB Compare utility
    5.5           Control statements for DBD/PSB/ACB Compare
    --------------------------------------------------------------
    The following rows of Table 5 are changed:
    
      Table 5. DBD and PSB fields that are not compared when
      NOCOMP=IMSREL is specified
      +------------+-------+-----------------+----------------+
      |Function    |Section|Field description|Added or removed|
    | +------------+-------+-----------------+----------------+
    | |DBD Compare |DIR    |DBDGEN DONE ON   |Added by IMS    |
    | |            |       |IMSV12 OR LATER  |Version 12      |
    | |            +-------+-----------------+----------------+
      ...
    | +------------+-------+-----------------+----------------+
    | |PSB Compare |PRFX   |IMS V12 FLAG     |Added by IMS    |
    | |            |       |                 |Version 12      |
    | |            +-------+-----------------+----------------+
    
    --------------------------------------------------------------
    5.7           Output from DBD/PSB/ACB Compare
    5.7.2         SYSPRINT data set
    5.7.2.1       Control statements for DBD/PSB/ACB Compare
    --------------------------------------------------------------
    The following rows are added as bottom rows of Table 9.
    
     Table 9. Sections in ACB Compare reports
    |+-------+----------------------------------------------------+
    ||CRTE   |Contains DEDB secondary index cross reference table |
    ||       |entries information.                                |
    |+-------+----------------------------------------------------+
    ||CRTEXD |Contains INDEX record partitioning information.     |
    |+-------+----------------------------------------------------+
    
    --------------------------------------------------------------
    6.0           DBD/PSB/ACB Mapper utility
    6.7           Output from DBD/PSB/ACB Mapper
    6.7.2         SYSPRINT data set
    6.7.2.1       DBD map
    --------------------------------------------------------------
    The following description is changed:
    
     VAR or SXD in the top line of a box shows whether the segment
     is variable-length or has secondary index fields. The segment
     code is placed in the bottom line of each box.
    |MULT in the top line of a box shows whether the segment has
    |multiple secondary index.
    
    --------------------------------------------------------------
    6.7.2.2       DBD report
    --------------------------------------------------------------
    Report field description for the database information part is
    changed as follows:
    
     If the exit parameter is specified on the DBD statement, the
     following information is printed:
     o The exit name
     o KEY or NOKEY
     o DATA or NODATA
     o PATH or NOPATH
     o CASCADE or NOCASCADE
     o LOG or NOLOG or none
    |o DELT or NODLET or none
    |o BEFORE or NOBEFORE or none
    
    Report field description for the segment information part is
    changed as follows:
    
     If the CASCADE option is specified, the following information
     is printed next to the CASCADE:
     o KEY or NOKEY
     o DATA or NODATA
     o PATH or NOPATH
     and the following information is printed on the next line:
     o LOG or NOLOG
    |o DELT or NODLET or none
    |o BEFORE or NOBEFORE or none
    
    Report field description for the field information part is
    changed as follows:
    
     The following lines for the segment specify segment type,
     segment field, or both:
     - If the identification is for a segment, the lines contain:
      o The segment type:
       *PR* describes a paired segment
       *LC* describes a logical child
       *LP* describes a logical parent
      o The segment name
      o The name of the database that contains this segment
    |  - If this segment has multiple secondary index, all of the
    |    name of the index database is printed.
      o The type of pointer:
    
     Following the XFD line could be the following:
     o SUBSEQUENCE shows that there are subsequence fields.
     o SYMBOLIC shows that the pointers are symbolic.
     o **SRCSEG** is printed along with the segment name. If the
       source segment is same as the target segment, **SAME** is
       printed.
     o CONSTANT=X'xx' is printed if a constant xx is specified in
       the definition of the XDFLD statement.
     o *NULLEXIT* is printed if a null value or an exit routine has
       been specified in the XDFLD statement:
      - The null value is printed as NULL=X'xx'.
      - The exit routine is printed as EXIT-name.
    |o **PSELRTN** is printed if PSELRTN= is specified in the XDFLD
    |   statement and PSELOPT shows that the partition selection
    |   option. Its default value is MULT.
     o For other index field types, the following is printed:
      - **SEARCH**
      - **SUBSEQ**
      - **SOURCE**
    
    --------------------------------------------------------------
    7.0           DBD/PSB/ACB Reversal utility
    7.7           Output from DBD/PSB/ACB Reversal
    7.7.5         SYSPRINT data set
    7.7.5.7       PCB PROCOPT report
    --------------------------------------------------------------
    The title row of Figure 75 is changed to add (D) after PROCSEQ
    as follows:
    
     Figure 75. PCB PROCOPT report
                PCB        REF DBD
    |PSBNAME     NO  TYPE  / LTERM   PROCOPT  PROCSEQ(D)
     --------  ----  ----  --------  -------  --------
    
    Report field descriptions is changed as follows:
    
    |PROCSEQ(D)
      This field shows the secondary index DBD name that is
    | specified in the PCB PROCSEQ= or PROCSEQD= statement of the
      PSBGEN utility.
    ×**** PE11/08/26 PTF IN ERROR. SEE APAR PM46494  FOR DESCRIPTION
    ×**** PE13/10/28 FIX IN ERROR. SEE APAR PI04892  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PM37150

  • Reported component name

    IMS LIBR INTEG

  • Reported component ID

    5655I4200

  • Reported release

    210

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2011-04-15

  • Closed date

    2011-06-28

  • Last modified date

    2013-11-06

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

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

    UK69298

Modules/Macros

  • FABLACBC FABLAGOP FABLAI2  FABLAPID FABLAPIP
    FABLARCN FABLASCD FABLBDFC FABLBDF0 FABLCMPD FABLCMPP FABLDBDT
    FABLDBD0 FABLDMBC FABLECHK FABLEDBD FABLEDMA FABLEDMB FABLEDMC
    FABLEDM0 FABLEDM9 FABLEDSC FABLEPAA FABLEPAB FABLEPAC FABLEPA0
    FABLEPA9 FABLEPCT FABLEPRP FABLEPSB FABLERCN FABLERPT FABLGEN
    FABLICCC FABLICC0 FABLIL10 FABLISI0 FABLLOAD FABLPGIN FABLPSBT
    FABLPSB0 FABLTAPI FABLTC30 FABLVAI0 FABLVDVC FABLVDV0 FABLVMNC
    FABLVMN0 FABLVRCC FABLVRC0 FABLVRDE FABLVTBC FABLVTBL FABMAMAP
    FABMBASE FABMBMAP FABMDBD1 FABMDBD4 FABMDBLC FABMDCNC FABMDCVC
    FABMDMAP FABMDMBC FABMICB  FABMPCNC FABMPMAP FABMPSB1 FABMPSB2
    FABNCHKP FABNCNST FABNCODE FABNDACK FABNDACM FABNDBLC FABNDCNC
    FABNDCTL FABNDCVC FABNDEDB FABNDMBC FABNDMY0 FABNDST0 FABNICB
    FABNINDX FABNLCH0 FABNPCNC FABNPCTL FABNPDBD FABNPPCB FABNPPSB
    FABNSDBD FABNSPSB FABNTLES FABNXREF FABUARCN MMIDBD   MMPSBD
    

Publications Referenced
SC19247901    

Fix information

  • Fixed component name

    IMS LIBR INTEG

  • Fixed component ID

    5655I4200

Applicable component levels

  • R210 PSY UK69298

       UP11/06/30 P F106

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCX89N","label":"IMS Library Integrity Utilities"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
06 November 2013