Preparations for Using the DBA Planning Calendar 

All database administration tasks must be secure. Therefore, authorization checks must be made for certain operations in the SAP System, in the database system and on the z/OS host.

·        SAP System

In the SAP System, a user needs authorization for database administration and background job scheduling to use the DBA Planning Calendar.

The administrator must have the authorizations S_RZL_ADMIN and S_BTCH_ALL, which are included in the operator profile S_A.ADMIN.

·        Database System

The user must be authorized to run the DB2 utility corresponding to a certain administration task.

You need to have set up the Stored Procedures according to the instructions Installing Control Center Procedures Using WLM in the SAP DBA Guide for DB2.

See the IBM DB2 UDB for z/OS documentation Utility Guide and Reference for more information.

·        z/OS Host

See JES Interface in the SAP DBA Guide for DB2 for information on how to set up z/OS specifics.

You must maintain all your profile parameters with the JES Interface (transaction DB2J, button Profile parameters).

Depending on your security setup, you may need to provide user and password in JES Interface (transaction DB2J, button Password)

Jobs generated from the DBA Planning Calendar are partly based on the data from the table and index monitors (DB02). Make sure that the table and index monitor data is regularly updated. The size information gathered by transaction DB02 is used for data set allocation, for example, in REORG and COPY jobs.