search cancel

ALLOCATION OF DATABASE DD STATEMENTS FROM JCL, DBRC and MDALIB.

book

Article ID: 53847

calendar_today

Updated On:

Products

CA Distributed Database Management CA Database Analyzer for DB2 for Oracle Database Analyzer (IMS Tools) Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC Compress Data Compression (IMS Tools) Database Analyzer for IMS for z/OS Database Copier for IMS for z/OS Database Organizer for IMS for z/OS Mainframe Extended Terminal Manager (IMS Tools) High Performance Recovery for IMS for z/OS Database Organizer (IMS Tools) Mainframe Program Restart Manager for IMS for z/OS Secondary Index Builder for IMS for z/OS Secondary Index for IMS for z/OS

Issue/Introduction

Description:

How does Database Organizer (DBO) allocate Database DD statements from JCL, DBRC RECON datasets and Dynamic Allocation Library (MDALIB)?

Solution:

The following conditions apply for DBO to select the Database DD statement(s) either from the JCL, or from DBRC RECON, or from IMS MDALIB:

1. DD statement always will be used from JCL if it is coded here                                     
    - (neither DBRC nor MDALIB will be checked)                 
                                                                
2. DD statement will be used from DBRC                          
    - if NOT coded in the JCL                                      AND    
    - if option DBRC=Y is used                                     AND    
    - if DD statement is defined in the RECON dataset           
                                                                
3. DD statement will be used from MDALIB                        
    - if NOT present in the JCL                                    AND    
    - if MDA member is present in the MDALIB                       AND    
    - if option DBRC=Y, but DD statement NOT in RECON              OR       
    - if option DBRC=N and DBALLOC=Y           

The job abends with database allocation error in all other cases.

Environment

Release:
Component: DBO