PK22614: IPR UNLOAD SUPPORTS MULTI-PARTITION NAMES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR enables IPR Unload Utility to accept two or more
  HALDB partition names in the PARTITION control statement as:
    PARTITION=(part1,part2,....,partN)
  Non-sequential partitions can be specified.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IMS High Performance Unload for *
  *                 OS/390 Release 1 (FMID=H1IN110)              *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR includes the following        *
  *                      enhancements and fixes.                 *
  *                      1. IPR Unload utility allows            *
  *                         a name list of non-sequntial HALDB   *
  *                         partitions in the PARTITION control  *
  *                         statement.                           *
  *                      2. FABHURG1 and IPR Unload utility      *
  *                         issues MSGFABH0273I or MSGHPSU3280I  *
  *                         for an empty HALDB partition.        *
  *                      3. IPR Unload utility prints            *
  *                         the segment count summary report     *
  *                         for each partition.                  *
  *                      4. IPR Unload task under IPR Driver     *
  *                         sets the REORG NUMBER stored in      *
  *                         the RECON data set                   *
  *                         in the partition trailer record.     *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  This APAR enables IPR Unload utility to accept a name list
  of HALDB partitions in the PARTITION control statement as
     PARTITION=(part1,part2,.....,partN)
  to unload non-sequntial partitions.
  
  This APAR includes the fixes for the following problems;
  1. FABHURG1 does not issue MSGFABH0273I;
      FABH0273I 0 DB RECORDS RETRIEVED - DBD=dbdname PART=partname
     and IPR Unload utility does not issue MSGHPSU3280I;
      HPSU3280I 0 DB RECORDS RETRIEVED - DBD=dbdname PART=partname
    for the HALDB partition from which no database record
    is retrieved.
  
  2. IPR Unload utility do not print the segment count summary
     report for each HALDB partition even if PARTSTAT=YES.
  

Problem conclusion

Temporary fix

Comments

• ========================
  = DOCUMENTATION CHANGE =
  ========================
  IMS Parallel Reorganization for z/OS Version 3 Release 1
  User's Guide (SC18-9228-01) should be modified as follows.
  
  ================================================================
  3.0 The IPR Unload utility
  3.3 Restrictions
  
   :
   The IPR Unload utility supports PHDAM or PHIDAM partitions
   that are defined as capable of HALDB Online Reorganization
   (OLR). If one or more partitions are in the following HALDB
   OLR status, the IPR Unload utility cannot process the HALDB:
  
   - HALDB OLR is currently running.
  
   - HALDB OLR is stopped prior to the completion for
     the partition and one of the following options is specified:
     - DECOMPESS=NO
     - User exit
     - *CS format for PHDAM
     - *A1 format
  |  - PARTITION=partlist
     :
  ================================================================
  
  3.8.3 Control statements for unload function
  
    Table 12. Control statements for unload function
    ____________________________________________________________
   | Keyword | Acceptable values | Default | description        |
   |_________|___________________|_________|____________________|
   |PARTITION| (partname,num),   | *ALL    | Specifies which    |
   |------------------------------------------------------------|
  
  ================================================================
  3.8.3.8 PARTITION control statement
  
  |Specifies which HALDB partitions are to be unloaded.
  
   This control statement is optional. If you do not explicitly
   specify this control statement, PARTITION=*ALL will be used.
  
     __________________________________________________________
    |                      _*ALL______________________         |
    | >>__ _PARTITION=_ __|_partname__________________|_____>< |
    |     |_PART=______|  |               _,1____     |        |
    |                     |_(__partname__|_______|__)_|        |
    |                     |              |_,nnnn_|    |        |
    |                     |                           |        |
  | |                     |_partlist _________________|        |
    |                                                          |
     ----------------------------------------------------------
   *ALL
  |  Unloads all the partitions (entire database unload).
  
   partname
  |  Specifies the name of a partition or the first partition
  |  of several sequential partitions to be unloaded.
  
   nnnn
     Specifies the number of sequential partitions to be unloaded.
  |  The unloading order of the partitions depends on either
  |  the HALDB partition selection exit routine or
  |  the HALDB high key values, and not on the partition names.
     If this parameter is not specified, the default value of 1
     is assumed.
  
     Notes: The following statements have the same meaning:
         PARTITION=PARTA
         PARTITION=(PARTA)
         PARTITION=(PARTA,1)
  
  |partlist
  |  Specifies a list of the partition names to be unloaded.
  |  The names must be separated by commas and enclosed
  |  in parentheses. You can specify up to 1001 names
  |  separated into multiple statement as follows:
  |    PARTITION=(part1,part2,part3,part4,part5)
  |    PARTITION=(part6,part7,part8,part9,part10)
  |
  |  The unloading order of the partitions depends on this list,
  |  not on the HALDB partition selection exit routine
  |  or the HALDB high key values.
  |  You can specify non-sequntial partitions.
  |
  |  Note: If PARTITION=partlist is specified and one or more
  |  partitions of PHDAM or PHIDAM are in a HALDB OLR cursor-activ
  |  status, the IPR Unload utility ends abnormally.
  ================================================================
  10.0 Messages and codes
  10.3 Messages
  10.3.5 HPSU messages
  
  (HPSU3159E and HPSU3292E are modifie, and HPSU3291E is added)
  ----------------------------------------------------------------
   HPSU3159E UNSUPPORTED OPTION FOR OLR ACTIVE PARTITIONS: option
  
   Explanation: The option (option) is specified, but this is
   one of the following options with which HSSR Engine cannot
   process the HALDB when the Online Reorganization (OLR) is
   active for one or more partitions of the HALDB:
   - DECOMPRESS=NO
   - User exit
   - *CS format for PHDAM
   - *A1 format
  |- PARTITION=partlist
   System Action: The IPR Unload ends abnormally.
   Programmer Response: Remove this option or rerun after HALDB
   OLR for all the partitions are  completed.
  ----------------------------------------------------------------
  | HPSU3291E DUPLICATE PARTITION NAMES SPECIFIED
  | Explanation: The IPR Unload detected duplicate partition
  | names on one or more PARTITION control statements.
  | System Action: The IPR Unload issues message HPSU3360E
  | and ends with a return code of 8.
  | Programmer Response: Correct the error, and rerun
  | the IPR Unload job.
  ----------------------------------------------------------------
   HPSU3276E SYNTAX ERROR IN PARTITION STATEMENT: reason
   Explanation: An incorrect PARTITION statement is specified
   in the HPSIN data set. reason indicates the reason of
   the error as listed as follows:
     reason Description
  |  NOT POSITIVE NUMBER
  |   Zero or a negative number is not allowed for the second oper
  |  TOO MANY PARTNAMES
  |    If *ALL is specified once, no partition name can be
  |    specified.
  |    If the number of the partitions is specified
  |    in the second operand, two or more partition names cannot
  |    be specified.
  |    If a list of the partition names is specified,
  |    more than 1001 partition names cannot be specified.
  
   System Action: The IPR Unload issues message HPSU3360E
   and ends with a return code of 8.
   Programmer Response: Correct the error, and rerun
   the IPR Unload job.
  ----------------------------------------------------------------
   HPSU3281E ERROR IN PARTITION STATEMENT: reason
   Explanation: An incorrect PARTITION statement is specified
   in the HPSIN data set. reason indicates the reason of
   the error listed as follows:
    reason Description
    NON-PARTITIONED DB
     The PARTITION control statement is specified for a nonpartiti
    TOO LONG NAME
     The specified name is too long for a partition name.
    THE NUMBER IS TOO LARGE
     The number of partitions, specified as the second operand,
     is larger than what is allowed for the database.
   System Action: The IPR Unload ends abnormally.
   Programmer Response: Correct the error, and rerun the job.
  ======================= End of Doc-Change ======================
  

APAR Information

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

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

  UK14038

Modules/Macros

•    FABHAP0  FABHC00  FABHFCKR FABHJCB  FABHJCB0
  FABHPNT  FABHPSL  FABHPSL8 FABHPSL9 FABHTCB  FABHTCBU FABHURG8
  FABHURG9 FABH001  FABH0208 FABH0209 FABH060  FABH550  FABH560
  HPSUFCB0 HPSUHFCB HPSUPTRD HPSUPTRW HPSUSTMT HPSUURG8 HPSUURG9
  HPSU015  HPSU015A
  

Fix information

• Fixed component name

  IMS HIGHPERF UN

• Fixed component ID

  5655E0600

Applicable component levels

• R110 PSY UK14038

     UP06/04/29 P F604

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.