PM53350: IMPLEMENT INVOKING THE IMS DFSDBAU0 MODULE IN THE IMS BATCH REGION (ULU TYPE) TASK INSTEAD OF DBRC API FUNC=AUTH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Implement invoking the IMS DFSDBAU0 module in the IMS batch
  region (ULU type) task instead of DBRC API FUNC=AUTH.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IMS Index Builder for z/OS,     *
  *                 Version 3 Release 1 (FMID=H22O310)           *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixes the following problems: *
  *                      1. If the DBRC AUTH command/request is  *
  *                      not allowed to by IMS DBRC command      *
  *                      authorization with RACF, MSGIIUB063E    *
  *                      is issued:                              *
  *                       IIUB063E DBRC API ERROR: FUNC=AUTH     *
  *                       IIUB064I DBD=xxxxxxxx RSN=C1000100     *
  *                                                              *
  *                      2. If a prime DB or partition is        *
  *                      closed by /DBD DB command on an IMS     *
  *                      online subsystem and an Index Builder   *
  *                      job is started, MSGIIUB063E is issued:  *
  *                       IIUB063E DBRC API ERROR:FUNC=AUTH(RD)  *
  *                       IIUB064I DBD=xxxxxxx  RSN=C100020F     *
  *                      It's because the DB authorization is    *
  *                      requested as a recovery utility.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR fixes the problems listed in the Problem Description
  field.
  
  *********
  * HIPER *
  *********
  Some of the current behaviors of Index Builder have been
  adjusted by this APAR:
  
  1. Index Builder requests the IMS DBRC DB authorization through
  IMS Database Authorization module (DFSDBAU0), instead of DBRC
  API, in IMS Version 9 or later.
  The subsystem ID (SSID) is the jobname and the IIUB070I
  message indicates the SSID:
    IIUB070I DB AUTHORIZATION IS REQUESTED. SSID=jobname
  
  2. For each HALDB partition, all the data sets (for each data
  set group, primary index and ILDS) are allocated dynamically
  in main address spaces during the DFSDBAU0 process.
  
  3. If the RECOVERY NEEDED flag is turned on for a prime
  database or a HALDB partition, the DB authorization with
  Exclusive (EX) access is requested for it.
  
  4. If the DBRC DB authorization request fails, the Index
  Builder job ends with the DFS047A WTO message and the IIUB082E
  error message:
   DFS047A - UNABLE TO OBTAIN AUTHORIZATION FOR DATA BASE xxxxx.
             REASON CODE = yy.
   IIUB082E  DBRC AUTHORIZATION ERROR: DBD=dbdname  DDN=ddname
             CODE=xx RC=yyyyy
  For the detail of the error reason, see the explanation of
  IMS DFS047A message.
  
  5. The IIUB071I message is no longer printed.
    IIUB071I DB UNAUTHORIZATION IS REQUESTED. SSID=xxxxxxxx
  

Problem conclusion

• ========================
  = Documentation Change =
  ========================
  IBM IMS Index Builder for z/OS, V3R1, User's Guide
  (SC18-9101-03) should be changed as follows:
  
  ================================================================
  1.2 Configuring and activating IMS Index Builder
  1.2.4 Configuring for DBRC command authorization
  
  (Some resources are no longer needed, because DBRC API
  FUNC=AUTH is not issued by Index Builder.)
  
    If IMS DBRC command and API request authorization support
    with RACF is used, the master address space's user ID must
    have authorization to access the following resources so that
    IMS Index Builder can issue the DBRC commands and the DBRC
    API requests.
  
    Authorize the user ID for the following resources:
    For DBRC commands:
     - hlq.CHANGE.DB.dbname
     - hlq.CHANGE.DBDS.dbname
     - hlq.NOTIFY.REORG.dbname
     - hlq.NOTIFY.UIC.dbname  (if 'VIC YES' is specified)
  
   For DBRC API requests:
    - hlq.STDBRC
    - hlq.LIST.RECON
    - hlq.LIST.DB.dbname
  D - hlq.STDBRC.ssid   (Unless 'DBAUTH NO' is specified)
  D - hlq.AUTH.dbname  (Unless 'DBAUTH NO' is specified)
  D - hlq.LIST.SUBSYS.ssid  (Unless 'DBAUTH NO' is specified)
  
    The variables are:
     hlq
       The high-level qualifier of the resource name.
     dbname
      The name of the prime database, partition, or index.
  D  ssid
  D   The subsystem name, which is assigned as 'A000xxxx'.
  D   xxxx is the job ID of the main address space.
  
  For an instruction to authorize user IDs, see
  IMS Administration.
  ---------------------------------------------------
    2.2 JCL and input control statements
    2.2.2 IMS Index Builder input control statements
    2.2.2.2 Optional control statements
    2.2.2.2.a DBAUTH control statement
  
     The DBAUTH control statement specifies whether IMS Index
     Builder issues the IMS DBRC authorization request for the
     prime database and the indexes to prevent transactions and
     programs from update the database.
  
     - Read (RD) access is requested for the prime database or
       the prime HALDB partitions to be scanned.
       If DFSURWF1 or HPSRSIDX is input, no request is issued.
  
  |    If the RECOVERY NEEDED flag is on for the prime database
  |    or the prime HALDB partition, Exclusive (EX) access is
  |    requested.
  
     - Exclusive (EX) access is requested for each index or
       each PSINDEX partition to be built.
  
  ----------------------------------------------------------------
  3.3 IMS Index Builder reason codes
  3.3.2 IMS Index Builder initialization phase primary reason code
  
  | 154    SYNC WITH IMS BATCH REGION FAILURE
  | Explanation: Timeout occurred while waiting for the completion
  | of the initialization process in the IMS Batch region.
  | The maximum wait time is 30 minutes.
  | System Action: Processing stops.
  | User Response: There might be a performance degradation.
  | Wait a while and rerun the job.
  ----------------------------------------------------------------
  3.4 IMS Index Builder messages
  
  ----------------------------------------------------------------
    IIUB070I DB AUTHORIZATION IS REQUESTED. SSID=xxxxxxxx
  
    Explanation: The IMS DBRC authorization for the prime database
  | and indexes are requested. xxxxxxxx is
    the subsystem identification name that used for DBRC sign-on.
    System Action: Processing continues
    User Response: None, if the IIUB071I message is issued.
    Otherwise, the SUBSYS record and authorization might remain.
    User action described in the explanation of IIUB069E message
    is required.
  ----------------------------------------------------------------
  | IIUB082E DBRC AUTHORIZATION ERROR: DBD=dbdname  DDN=ddname
  |          CODE=xx RC=yyyyy
  |
  |Explanation: An error is received from the IMS DB
  |authorization module (DFSDBAU0). Here, dbdname, ddname, and xx
  |are passed to DFSDBAU0, and yyyyy is its return code.
  | xx is one of the caller's utility type codes:
  |   05: Database Serveyor utility
  |   06: Database Scan utility
  |   11: Database Recovery utility
  | System Action: Processing stops.
  | User Response: See the IMS DFS047A WTO message for the error
  | reason. Correct the error, and rerun the job.
  ----------------------------------------------------------------
  
  ================= End of Documentation Change ==================
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK75788

Modules/Macros

•    IIUBIBCD IIUBIDCM IIUBINIT IIUBMSGS IIUBPR91
  IIUBSTMS IIUIFS2A IIUIFS2B IIUIFS22 IIUIFS29 IIUIFS3A IIUIFS3B
  IIUIFS32 IIUIFS39 IIUMMSGR IIUPDBRC IIUSCA01 IIUSCA11 IIUSCA12
  IIUSIBCD IIUSTART IIUTMRXT
  

Fix information

• Fixed component name

  IMS INDEX BUILD

• Fixed component ID

  5655E2400

Applicable component levels

• R310 PSY UK75788

     UP12/01/31 P F201 Ž

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.