Configuring IBM DB2 for z/OS 

We recommend that you complete the following steps before you use your database with the SAP system.

Unless otherwise noted, all sections listed here can be found in
http://service.sap.com/instguidesnw → <SAP version> → Operations → Database-Specific Guides → SAP DBA Guide: DB2 for z/OS.)

       1.      Plan your database configuration.

For more information, see Planning the Configuration Structure in http://service.sap.com/instguidesnw → → <SAP version> → Operations → Database-Specific Guides → SAP Planning Guide: DB2 for z/OS.

       2.      Plan your backup and restore strategy.

For more information, see Backup and Recovery Options.

       3.      Check your DB2 setup.

For more information, see DB2 Setup and Performance Tuning Considerations.

       4.      Check the authorization profiles for the users in your system.

For more information, see Authorization Profiles.

       5.      Set up the PTF (Program Temporary Fixes) check for your z/OS system.

For more information, see PTF Check.

       6.      Plan your high availability system set-up.

For more information, see:

http://service.sap.com/instguidesnw → < SAP version> → Installation → 2 – Installation – SAP NetWeaver Systems  → <installation guide for your SAP system>

ftp://ftp.software.ibm.com/eserver/zseries/software/sap/HA_SAP_Autonomic_SC33-8206-01.pdf

       7.      Set up automated database administration in your DBA Planning Calendar or DBA Cockpit:

○       Backup

of tablespaces, objects

○       Recovery

of tablespaces, indexes

○       Rebuild

of an index

○       Online reorganization

of tablespaces, indexes

○       Update statistics

RUNSTATS for objects

For more information, see DBA Planning Calendar.

       8.      Check your DB2 performance and maintenance settings.

For more information, see Central Navigation Tool.