PM31076: ADD THE LASTAUTHFLAG CONTROL STATEMENT TO SET THE AUTHORIZATION FLAGS IN RECON BACK TO THE ORIGINAL STATE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When LASTAUTHFLAG=ORIGINAL is specified, Reorganization Manager
  issues the CHANGE.DB command to set the authorization flags in
  RECON back to the original state after ending the
  post-reorganization processing.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IMS Database Reorganization     *
  *                 Expert for z/OS Version 4 Release 1          *
  *                 (FMID=H25N410) who use the Smart Reorg       *
  *                 utility.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds the support for the      *
  *                      LASTAUTHFLAG control statement for the  *
  *                      Smart Reorg utility.                    *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  This APAR adds the support for the LASTAUTHFLAG control
  statement for the Smart Reorg utility.
  
  After post-reorganization processing ends successfully,
  Reorganization Manager automatically issues the CHANGE.DB AUTH
  READOFF command by default. When LASTAUTHFLAG=ORIGINAL is
  specified, Reorganization Manager issues the CHANGE.DB command
  to restore the authorization flags (READ ONLY and PROHIBIT AUTH)
  in RECON to the original state.
  
  This enhancement is being implemented for the FITS requirement
  MR0806103858.
  

Problem conclusion

Temporary fix

Comments

• ========================
  = DOCUMENTATION CHANGE =
  ========================
  The IBM IMS Database Reorganization Expert for z/OS User's Guide
  Version 4 Release 1 Suffix 1 (SC19-1137-01)
  
  ----------------------------------------------------------------
  
  > 3.0 Reorganizing a database
  >> 3.3 Parallel Reorganization Service
  >>> 3.3.1 What is Parallel Reorganization Service?
  >>>> 3.3.1.2 Reorganization Manager
  
  The third and the fourth bullets in the following list are
  changed as follows:
  
  Automated DBRC authorization and unauthorization processing
  
  If you specify DBRCAUTHCMD=YES, Reorganization Manager does the
  following automatically:
  
   - At the beginning of the reorganization, Reorganization
     Manager issues either a CHANGE.DB READON command or a
     CHANGE.DB NOAUTH command depending on the DBSHARE option.
     The CHANGE.DB READON command changes the READ ONLY flag of
     the database in RECON and the CHANGE.DB NOAUTH command
     changes the PROHIBIT AUTHORIZATION flag of the database in
     RECON. Further authorization for the database is prohibited.
   - During data set name swapping, Reorganization Manager
     automatically issues a CHANGE.DB NOAUTH command.
   - After post-reorganization processing ends successfully,
     Reorganization Manager automatically issues the CHANGE.DB
     AUTH READOFF command unless LASTAUTHFLAG=ORIGINAL is
     specified.
     If you specify LASTAUTHFLAG=ORIGINAL, Reorganization Manager
     automatically issues the CHANGE.DB command to restore the
     authorization flags in RECON to the original state. For
     details, see "LASTAUTHFLAG control statement".
   - Before the Smart Reorg job terminates abnormally due to an
     error, Reorganization Manager automatically issues the
     CHANGE.DB command to restore the authorization flags in
     RECON to the original state. For details, see "Automated
     DBRC processing for restoring authorization flags".
  
  
  >> 3.5  Smart Reorg JCL statements
  >>> 3.5.2 Control statements for Smart Reorg
  >>>> 3.5.2.2 Control statements for the Smart Reorg Driver
  
  A new keyword, LASTAUTHFLAG, is added to the following table:
  
  Table. Control statements for the Smart Reorg Driver
  (Table 11 in PDF and BookManager formats)
  
  +------------+-------------------------------------------------+
  |Keyword     |Acceptable|Default    |Description               |
  |            |values    |           |                          |
  +------------+----------+-----------+--------------------------+
  |LASTAUTHFLAG|OFF or    |OFF if DBRC|Specifies the state of the|
  |            |ORIGINAL  |is active. |READ ONLY flag and the    |
  |            |          |           |PROHIBIT AUTHORIZATION    |
  |            |          |No default |flag in RECON after the   |
  |            |          |if DBRC is |post-reorganization       |
  |            |          |not active.|processing has ended.     |
  |            |          |           | See "LASTAUTHFLAG control|
  |            |          |           |statement".               |
  +------------+----------+-----------+--------------------------+
  
  
  >>>> 3.5.2.2 Control statements for the Smart Reorg Driver
  
  A new topic, LASTAUTHFLAG control statement, is added:
  
  LASTAUTHFLAG control statement
  
  Specifies the state of the READ ONLY flag and the PROHIBIT
  AUTHORIZATION flag in RECON after the post-reorganization
  processing has ended.
  
  This control statement is optional. If you do not explicitly
  specify this control statement, LASTAUTHFLAG=OFF is used.
  
  +--------------------------------------------------------------+
  |                       __OFF_______                           |
  | >>____LASTAUTHFLAG=__|__ORIGINAL__|_____><                   |
  |                                                              |
  +--------------------------------------------------------------+
  
  If you specify LASTAUTHFLAG=OFF, the Smart Reorg utility
  automatically issues the CHANGE.DB AUTH READOFF command to turn
  off all the authorization flags.
  If you specify LASTAUTHFLAG=ORIGINAL, the Smart Reorg utility
  issues the CHANGE.DB command to restore the authorization flags
  to the original state.
  
  Notes:
  1. When NAMESWAP=NO is specified, the Smart Reorg utility does
     not do post-reorganization processing automatically. However,
     the CHANGE.DB command that is influenced by the LASTAUTHFLAG
     specification is printed in the DBRC Notification Command
     Stream report.
  2. In the following cases where additional manual
     post-reorganization is required, the Smart Reorg utility does
     not issue the CHANGE.DB command. Therefore, the LASTAUTHFLAG
     control statement is ignored.
      - NEWDBD control statement is specified (message HPSG0371I
        is issued)
      - ILDSBLD=NO is specified though ILDS needs to be rebuilt
        (message HPSG0374W is issued)
      - Manual prefix resolution and update are needed because
        the database has either external logical relationships
        or HISAM internal logical relationships (message HPSG0379W
        is issued)
      - PREFIXRES=NO is specified though prefix resolution and
        update are needed (message HPSG0377I is issued)
  3. When the database has secondary indexes and INDEXBLD=NO is
     specified (message HPSG0372I is issued) the Smart Reorg
     utility does not issue the CHANGE.DB command for the
     secondary indexes after reorganization. Therefore, the
     LASTAUTHFLAG control statement has no effect on the secondary
     indexes.
  
  ----------------------------------------------------------------
  

APAR Information

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

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

  UK65698

Modules/Macros

• HPSGCM00 HPSGCM20 HPSGCSC1 HPSGGIOB HPSGGIO0
  HPSGGRMB HPSGGRM0 HPSGRS00 HPSGRS30 HPSGSTMT
  

Fix information

• Fixed component name

  IMS DB REORG EX

• Fixed component ID

  5655F7400

Applicable component levels

• R410 PSY UK65698

     UP11/03/18 P F103

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.