IBM Support

PI17756: FPA INDEXBLD ADDS SUPPORT FOR ONLINE RE-SYNCHRONIZATION OPTIONS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • FPA INDEXBLD adds options to synchronize the primary DEDB
    database and its secondary index databases, without having the
    databases offline.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of HPFPU Fast Path Advanced Tool   *
    *                 in Fast Path Solution Pack Version 1 Release *
    *                 3 (FMID: HAHQ130).                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: FPA Build Index function adds support   *
    *                      for online synchronization option.      *
    *                      Using this option, a DEDB and its       *
    *                      secondary index databases can be        *
    *                      synchronized without offline the        *
    *                      secondary index databases.              *
    *                                                              *
    *                      FPA Build Index function provides       *
    *                      options to store duplicate pointer      *
    *                      segments in data sets and control       *
    *                      the number of duplicate pointer         *
    *                      segments allowed before stop            *
    *                      processing.                             *
    ****************************************************************
    * RECOMMENDATION: Apply the maintenance for this APAR.         *
    ****************************************************************
    FPA Build Index function adds support for online synchronization
    option. This option synchronizes a DEDB and its secondary index
    databases. During the synchronization, all secondary index
    databases remain online.
    
    For online synchronization, the following four modes are
    supported. Updates to the secondary index databases are done by
    DL/I calls (ISRT and DLET).
     - Verify update mode: Scans the DEDB and secondary index
       databases and then updates the secondary index databases.
       Scan and update are done in one job.
     - Verify mode: Scans the DEDB and secondary index databases and
       then generates Resync Pointer Segment records. The records
       are used in Build Index jobs that run in update mode to
       update the secondary indexes.
     - Update mode: Reads Resync Pointer Segment records that were
       generated in a Build Index job that ran in verify mode and
       then updates the secondary index databases.
     - Direct update mode: Scans only the DEDB and then updates the
       secondary index databases. Scan and update are done in one
       job.
    
    By running the Build Index function with the IDXPROC=RESYNC,
    TOICTL=NONE, and IMSID=ims_id options, you can synchronize index
    pointer segments in secondary index databases with the pointers
    in the primary DEDB database without offline the secondary index
    databases.
    The RESYNCMODE keyword specifies the synchronization mode.
     - Verify update mode: RESYNCMODE=VERIFYUPDATE
     - Verify mode: RESYNCMODE=VERIFY
     - Update mode: RESYNCMODE=UPDATE
     - Direct update mode: RESYNCMODE=DIRECTUPDATE
    
    To specify Resync Pointer Segment data sets, you must either
    specify the data sets by providing the DD statements
    (S0nnnnnR DD) or following utility control statements.
     - RESYNCDSNMASK keyword
     - FILECTL subcommand
    
    After the online synchronization, the Secondary Index Resync
    report will be generated. This report provides information
    about the segments that were inserted to or deleted from the
    secondary index databases.
    
    The RESYNCDUMP keyword specifies whether to generate the
    Resync Pointer Segment Dump report. This report provides
    information about the segments that were or that will be
    inserted or deleted to synchronize the secondary index database
    with the primary DEDB database.
    The RESYNCDUMPMAX keyword specifies the maximum number of index
    pointer segments to be printed for each index database in the
    Resync Pointer Segment Dump report.
    
    The layout of Resync Pointer Segment records is provided.
    You can use the HFPZRPR macro in SHFPMAC0 library to map the
    Resync Pointer Segment records.
    
    The following figure shows an example JCL statements for
    synchronizing the DEDB areas and all of its secondary index
    databases by verify update mode.
    
    //HFP      EXEC PGM=HFPMAIN0
    //STEPLIB  DD DISP=SHR,DSN=HPFP.SHFPLMD0
    //         DD DISP=SHR,DSN=IMSVS.SDFSRESL
    //         DD DISP=SHR,DSN=IMSVS.PGMLIB
    //IMSACB   DD DISP=SHR,DSN=IMSVS.ACBLIB
    //IMSDALIB DD DISP=SHR,DSN=IMSVS.MDALIB
    //HFPSYSIN DD *
      GLOBAL DBRC=YES,
             IMSID=IMS1
      INDEXBLD DBD=DEDBJN22,
             IAREA=ALL,
             INDEXDBD=ALL,
             IDXPROC=RESYNC,
             TOICTL=NONE,
             RESYNCMODE=VERIFYUPDATE
    //
    
    FPA Build Index function provides options to store duplicate
    pointer segments in data sets.
    When performing the offline index build function to the index
    databases which have no overflow data set, this option saves
    segments with duplicate key in data sets as Duplicate Pointer
    Segment records.
    
    By running the Build Index function with the IDXPROC=BUILD and
    DUPKEYACT=SAVE options, you can save duplicate pointer segments
    in Duplicate Pointer Segment data sets.
    
    To specify Duplicate Pointer Segment data sets, you must either
    specify the data sets by providing the DD statements
    (S0nnnnnR DD) or following utility control statements.
     - DUPKEYDSNMASK keyword
     - FILECTL subcommand
    
    The layout of Duplicate Pointer Segment records is provided.
    Like Resync Pointer Segment records, you can use the HFPZRPR
    macro in SHFPMAC0 library to map the Duplicate Pointer Segment
    records.
    
    You can specify the number of duplicate pointer segments
    allowed before stop build processing by DUPKEYMAX keyword.
    If DUPKEYMAX=0 is specified, the build processing is not
    aborted by detecting the duplicate pointer segments.
    
    If build process detects duplicate pointer segments,
    the Secondary Index Duplicate Key Report will be generated.
    This report provides information about the key value of
    duplicate pointer segments.
    
    This APAR also fixes the FPX0208I message to print correct
    DBRLDIST value when DBRLDIST=xxx and LARGEREC_COUNT=(aaa,bbb)
    is specified.
    

Problem conclusion

Temporary fix

Comments

  • ========================
    = DOCUMENTATION CHANGE =
    ========================
    The IMS Fast Path Solution Pack for z/OS Version 1 Release 3
    IMS High Performance Fast Path Utilities User's Guide
    (SC19-4010-01).
    
    For the documentation changes made by this APAR, see
    http://www-304.ibm.com/support/docview.wss?uid=swg27041865
    

APAR Information

  • APAR number

    PI17756

  • Reported component name

    IMS FP SOLUTION

  • Reported component ID

    5655W1400

  • Reported release

    130

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2014-05-12

  • Closed date

    2014-12-08

  • Last modified date

    2015-01-02

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

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

    UI23683

Modules/Macros

  •    FPXAURT0 FPXUPPE0 HAHQ130J HFPAS1R0 HFPA1RP0
    HFPA5BI0 HFPA5BP0 HFPA5000 HFPBARS0 HFPBLBF0 HFPBLDS0 HFPBLIL0
    HFPBLIN0 HFPBLMN0 HFPBLNI0 HFPBLRI0 HFPBLRO0 HFPBLRR0 HFPBLRS0
    HFPBLSI0 HFPBLTR0 HFPBLVS0 HFPBPMN0 HFPBRCP0 HFPBRDC0 HFPBRDDB
    HFPBRDDC HFPBRDDD HFPBRDI0 HFPBRDMB HFPBRDMC HFPBRDMD HFPBRDO0
    HFPBRDU0 HFPBRDV0 HFPBRIN0 HFPBRMN0 HFPBRNS0 HFPBRRN0 HFPBRSB0
    HFPBRSC0 HFPBRSD0 HFPBRTR0 HFPBRVR0 HFPBSBF0 HFPBSBI0 HFPBSQI0
    HFPBUDS0 HFPCCDT0 HFPCDDT0 HFPCDEF0 HFPCFLC0 HFPCFNL0 HFPCOFT0
    HFPCSAI0 HFPCSFI0 HFPCTSK0 HFPCXCS0 HFPCXCT0 HFPDFMN0 HFPDIMD0
    HFPFATI0 HFPFINA0 HFPFIXA0 HFPFIXL0 HFPFIXS0 HFPFMAN0 HFPFSFA0
    HFPFSFR0 HFPFTTT0 HFPLCC10 HFPLCC20 HFPLCC30 HFPLDBR0 HFPLINI0
    HFPLLCT0 HFPLMAN0 HFPLOFT0 HFPLSIA0 HFPLSID0 HFPLSIK0 HFPLSIM0
    HFPLSIN0 HFPLSIP0 HFPLSIQ0 HFPLSIR0 HFPLSIS0 HFPMXEL0 HFPOA500
    HFPRCDB0 HFPSGDMB HFPSGDMC HFPSGDMD HFPSGIMB HFPSGIMC HFPSGIMD
    HFPTCXM0 HFPTCXPB HFPTCXPC HFPTCXPD HFPTDRC0 HFPTREXB HFPTREXC
    HFPTREXD HFPTRIF0 HFPTRMN0 HFPULIS0 HFPUMSK0 HFPUMVT0 HFPUROB0
    HFPUSNC0 HFPWMTB0 HFPWMTC0 HFPWMTF0 HFPWMTT0 HFPXDBR0 HFPXIBRB
    HFPXIBRC HFPXIBRD HFPXMAN0 HFPXTRM0 HFPXTRS0 HFPY2710 HFPZRPR
    

Publications Referenced
SC19401001    

Fix information

  • Fixed component name

    IMS FP SOLUTION

  • Fixed component ID

    5655W1400

Applicable component levels

  • R130 PSY UI23683

       UP14/12/16 P F412

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.

[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCV35A","label":"IMS Fast Path Solution Pack"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"130"}]

Document Information

Modified date:
03 October 2020