PK15946: DBRC COMMAND CHANGE.DB REORGI|NOREORGI FOR FULL FUNCTION DATABASES

APAR status

• Closed as new function.

Error description

• Implement an 'Intent to Reorg' flag for full function databases
  (including HALDBs) that prevents subsequent reorganizations and
  batch access to the database.  Online IMS subsystems are allowed
  access to the database when the 'Intent to Reorg' flag is set.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IMS V9R1 users with full function        *
  *                 databases (including HALDBs) that run        *
  *                 online reorganizations.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Provide a command interface for online  *
  *                      reorganization products (other than     *
  *                      HALDB Online Reorganization) to inform  *
  *                      DBRC they are active to provide data    *
  *                      integrity for full function databases.  *
  *                                                              *
  *                      Implement an intent to reorg flag       *
  *                      for full function databases that        *
  *                      prevents subsequent reorganizations     *
  *                      and batch access to the database.       *
  ****************************************************************
  * RECOMMENDATION: INSTALL CORRECTIVE SERVICE FOR APAR/PTF      *
  ****************************************************************
  Implement an intent to reorganize flag for full function
  databases (including HALDBs) that prevents subsequent
  reorganizations and batch access to the database.  Online
  IMS subsystems are allowed access to the database when the
  intent to reorganize flag is set.
  

Problem conclusion

Temporary fix

Comments

• New parameters REORGI|NOREORGI are added to the
  CHANGE.DB DBD(xxxxx) command.
  -
  REORGI|NOREORGI parameters apply to full function databases
  only (including HALDBs).
  -
  If DBD is a HALDB master, all partition databases are changed.
  If the command fails for any partition database, it fails for
  all.  If a failure occurs, any remaining partition databases
  are not processed.
  -
  REORGI|NOREORGI parameters are not valid with the ALL parameter.
  -
   REORGI
   -
    Sets new 'intent to reorg' flag on in database record if the
    following conditions have been met:
   -
     - Database type is valid.  Must be full function
       (including HALDBs).
     - The 'intent to reorg' flag is off.
     - No batch jobs are authorized to the database.
     - HALDB Online Reorganization (OLR) cannot have cursor
       active set (OLREORG CURSOR ACTIVE=YES) or be owned by
       an IMS (OLRIMSID=imsid).
   -
   NOREORGI
   -
    Sets new 'intent to reorg' flag off in database record if the
    following conditions have been met:
   -
     - Database type is valid.  Must be full function
       (including HALDBs).
     - The 'intent to reorg' flag is on.
   -
  New message DSP1045E issued if the above conditions cause
  a failure.  Return code 12 is set.
  -
     DSP1045E REORG INTENT CHANGE IS NOT ALLOWED
              FOR DATABASE dbname
              REASON:  reason
  -
     Reasons:
       BATCH SUBSYSTEM AUTHORIZED <ssid>
       HALDB OLR ACTIVE
       INVALID DATABASE TYPE
       REORG INTENT IS ALREADY SET ON
       REORG INTENT IS ALREADY SET OFF
       NO SUBSYSTEM <ssid>
       ERROR LOCATING SUBSYSTEM <ssid>
  -
  Existing message DSP0222I is issued if REORGI|NOREORGI is
  included with the ALL parameter in a CHANGE.DB command.
  -
  The new field is listed in the database record.
  -
  DB
  DBD=POHIDKA MASTER DB=DBOHIDK5 IRLMID=*NULL CHANGE#=2 TYPE=PART
  USID=0000000004 AUTHORIZED USID=0000000004 HARD USID=0000000004
  RECEIVE USID=0000000004  RECEIVE NEEDED USID=0000000000
    DBRCVGRP=**NULL**
    DSN PREFIX=IMSTESTS.DBOHIDK5              PARTITION ID=00001
    PREVIOUS PARTITION=**NULL**    NEXT PARTITION=POHIDKB
    OLRIMSID=**NULL**    ACTIVE DBDS=M-V
    FREE SPACE:
      FREE BLOCK FREQ FACTOR=0    FREE SPACE PERCENTAGE=0
    PARTITION HIGH KEY/STRING (CHAR):               (LENGTH=5  )
      K2000
    PARTITION HIGH KEY/STRING (HEX):
      D2F2F0F0F0404040404040404040404040404040404040404040404040
    OSAM BLOCK SIZE:
      A = 4096
      B = 4096
    FLAGS:                         COUNTERS:
      BACKOUT NEEDED        =OFF   RECOVERY NEEDED COUNT      =0
      READ ONLY             =OFF   IMAGE COPY NEEDED COUNT    =0
      PROHIBIT AUTHORIZATION=OFF   AUTHORIZED SUBSYSTEMS      =0
                                   HELD AUTHORIZATION STATE   =0
                                   EEQE COUNT                 =0
      TRACKING SUSPENDED    =NO    RECEIVE REQUIRED COUNT     =0
      OFR REQUIRED          =NO    OLR ACTIVE HARD COUNT      =0
      PARTITION INIT NEEDED =NO    OLR INACTIVE HARD COUNT    =0
      OLREORG CURSOR ACTIVE =NO
      PARTITION DISABLED    =NO
      ONLINE REORG CAPABLE  =YES
      REORG INTENT          =OFF
  -
  Authorization for batch jobs fail if 'intent to reorg' flag
  is set on. Existing message DFS047A is issued with a new
  reason code of 40.
  -
    DFS047A RC40  The intent to reorganize flag is set on
                  (REORG INTENT = ON) for the database.
                  The database is being reorganized.
                  Authorization to this database fails.
  -
  HALDB Online Reorganization (OLR) set owner call fails with
  RC04 RS32 if 'intent to reorg' flag is set on.  Existing message
  DFS2971W is issued.
  -
  NOTE:  Prior to using the REORG INTENT flag, this maintenance
  must be applied to all IMS Version 9 reslibs accessing the RECON
  There is no coexistence support provided for releases prior to
  IMS Version 9.  Lower releases must not access the RECON if
  using the REORG INTENT flag.
  -
  New Message
  -
  DSP1045E REORG INTENT CHANGE IS NOT ALLOWED FOR DATABASE dbname
                      REASON:  reason
  -
  Explanation: A CHANGE.DB REORGI or NOREORGI command was
  issued for the database to indicate either the database is
  going to be reorganized or has just completed reorganization.
  The database listed is the database name of used in the
  command.   One of the following reasons was reported:
  -
   BATCH SUBSYSTEM AUTHORIZED <ssid>
     A batch subsystem is currently authorized to the
     database.  The database cannot be reorganized if it
     authorized to any batch subsystems.  When all batch
     jobs have successfully finished processing, the
     command may be retried. Ssid is optional and is not
     listed if a HALDB is being processed.
   HALDB OLR ACTIVE
     HALDB OLR (Online Reorganization) is currently running
     and the following status is set for the Partition
     database in RECON:
         - OLREORG CURSOR ACTIVE = YES  or
         - OLRIMSID=imsid  (an IMS owns the OLR)
   INVALID DATABASE TYPE
     The valid database types are full function databases
     including HALDBs.
   REORG INTENT IS ALREADY SET ON
     The REORG INTENT flag is already set on.
   REORG INTENT IS ALREADY SET OFF
     The REORG INTENT flag is already set off.
   NO SUBSYSTEM <ssid>
     A subsystem record was not found for a subsystem listed
     as authorized for the database. Ssid is optional and is
     not listed if a HALDB is being processed.
   ERROR LOCATING SUBSYSTEM <ssid>
     An i/o error was detected attempting to locate a
     subsystem record for a subsystem listed as
     authorized for the database.  Ssid is optional and
     is not listed if a HALDB is being processed.
  -
  System Action: The command fails.  If the DBD is a HALDB,
  the command  has failed for all the Partition databases
  for this HALDB.  Any subsequent commands or Partition
  databases are not processed.
  -
  User Response: Correct the error conditions and reissue
  the command if appropriate.
  -
  Problem Determination: 2, 3, and listings of the RECON
  data sets.
  -
  Module:  DSPURM10
  -
  Changed Messages
  -
  DSP0222I SPECIFIED PARAMETERS CONFLICT
  -
  Explanation: DBRC command processing discovered one of the
  following errors:
  
  - The CHANGE.DB command was specified with the ALL keyword
    and one or more of the of the following disallowed keywords
    was also included:
          PINIT or NOPINIT
          REORGI or NOREORGI
          NONRECOV,  USERRCOV, or RECOVABL
          ICREQ or NOICREQ
          PARTSEL or HIKEY
  - The CHANGE.DB command was issued with the GSGNAME and
    NOTCOVER parameter. These are mutually exclusive.
  - The CHANGE.DB command was specified with the UNAUTH keyword,
    and some other keyword besides DBD, AREA, or ACTIVE|TRACKING
    was also specified.
  - The INIT.DB command was specified with the NOICREQ keyword
    but without the NONRECOV or USERRCOV keyword.
  - The INIT.DB command was specified with the USERRCOV keyword
    but without TYPEFP.
  - The INIT.DBDS or CHANGE.DBDS command was issued with both the
    NOPREO and the PRELOAD parameters. A VSO area can only be
    preloaded if it has been preopened.
  - The LIST.DBDS DBD(dbd) DDN(ddn) command
      - A DDN parameter was specified, but the DBDS is a DEDB.
      - The AREA keyword was specified, but the DBDS is a
        DL/I DBDS.
  -
  System Action: For the LIST.DBD command, processing continues
  with this message. For the other commands,  processing fails
  and any subsequent commands are not processed.
  -
  User Response: For the LIST.DBD command, no action is required.
  For the other commands,  correct the parameters and reissue
  the command.
  -
  Problem Determination: 2, 3, 8, and listings of the RECON data
  sets.
  -
  DFS047A UNABLE TO OBTAIN AUTHORIZATION FOR DATA BASE xxxxxxxx.
          REASON CODE   = zz. PSB= psbname.
  -
  Explanation: IMS was unable to obtain database authorization
  for the named database which appears in one of the DB PCBs
  contained in the named PSB during PSB scheduling. The PSB
  name only appears in the message text if the IMS is an
  online control region.
  -
  Code (Hex) Meaning (add reason code 40)
    40
       Batch jobs are not allowed authorization when the
       REORG INTENT = ON is set for the database.  The database
       is currently being reorganized. Online image copy also
       fails authorization.
  -
  
  DFS2971W OLR INITIALIZATION FAILED FOR NAME=partname
           RC=xx RS=yy
  -
  Explanation: First format of the message: For the reason
  indicated by the return and reason codes, the HALDB online
  reorganization did not complete the OLR initialization
  process to either start or resume the OLR.
  -
  RC=04       RS 32   Set ownership call failed.  Possible
                      errors:
  -
                      - Partition database is not capable of
                        having OLR run against it.
                      - The REORG INTENT flag is set on in the
                        partition database.  The partition
                        is being reorganized.
  -
   The following correction also is made for the OLRRGON
   and OLRRGOFF parameters for the CHANGE.DB command:
   -
   These parameters are valid only for a partition database.
   -
  The IMS Release Planning Guide Version 9 is updated in
  Chapter 1 to include this DBRC enhancement:
  -
  New Keywords for DBRC CHANGE.DB Commands
  -
  This enhancement implements new keywords REORGI|NOREORGI
  for the CHANGE.DB DBRC command that provides a command
  interface for online reorganization products (other than HALDB
  Online Reorganization) to inform DBRC they are active to provide
  data integrity for full function databases.  When the new intent
  to reorganize flag is set on, authorization fails for other
  reorganization products, batch access, and online image copy.
  

APAR Information

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

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

  UK16656

Modules/Macros

• DFSORP00 DSPAPCON DSPAPQDB DSPAPQHP DSPAPQ20
  DSPAPQ22 DSPCM3RC DSPCM8   DSPDBHRC DSPECONS DSPEXTFM DSPIXL
  DSPKWTBL DSPOLRSO DSPPDSCT DSPPPQDB DSPPPQHP DSPSAUTH DSPUCLA0
  DSPURCM8 DSPURCM9 DSPURLB2 DSPURM10 DSPURU80 DSPUSTB2 DSPXDLC0
  DSPXDLIL DSP91RCD
  

Fix information

• Fixed component name

  IMS V9

• Fixed component ID

  5655J3800

Applicable component levels

• R900 PSY UK16656

     UP06/08/04 P F608