A fix is available
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 number
PM53350
Reported component name
IMS INDEX BUILD
Reported component ID
5655E2400
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-12-01
Closed date
2012-01-29
Last modified date
2012-02-02
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
SC18910103 |
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.
[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCX89M","label":"IMS Index Builder"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0"}]
Document Information
Modified date:
04 October 2020