Hi Balaram reddy
If u need to perform various tasks to administrate DB2 UDB for z/OS in an SAP environment. You may use SAP CCMS (which is part of the SAP standard delivery) to perform various administrative tasks.
We are aware that there is a wide variety of other tools that are available which you probably use to work with DB2. However, in this description we will concentrate on the tools available in SAP CCMS.
Getting Started:
If you are new to DB2 UDB for z/OS, see the following guides at:
service.sap.com/OperationsNW70
● SAP Database Administration Guide for SAP NetWeaver on IBM DB2 UDB for z/OS (SAP DBA Guide for DB2)
● SAP Planning Guide for SAP NetWeaver on IBM DB2 UDB for z/OS (SAP Planning Guide for DB2)
Tasks on Demand:
The table below shows tasks that you need to perform when required:
Reason : Database start or stop
Task : Use the commands START DB2, STOP DB2 on the Tspanel.
More Information : SAP DBA Guide for DB2
Reason : Database failure with data loss
Task : DB13
More Information: SAP DBA Guide for DB2
Reason : Tablespace or data file management
Task : SE14
More Information: SAP DBA Guide for DB2
Reason : Table or index management
Task : SE14
More Information: SE11
SAP DBA Guide for DB2
1) Performance problem:
Use transaction ST04 to tune the following:
● DB2 Subsystem Activity
● Thread Activity
● Cached Statements Statistics
● Global Times
● Data Set Statistics
● Installation Parameters
See the following sections in the SAP DBA for DB2:
● DB2 Subsystem Activity
● Thread Activity
● Cached Statements Statistics
● Global Times
● Data Set Statistics
● Installation Parameters
2) Access required to other systems, such as a BW source system:
Multiconnect with DDF
I BM DB2 UDB for z/OS: Installation Guide
3) Database version maintenance
● Apply PTFs, ++APARs, USERMODs
● Migrate to higher DB2 version
For PTFs: IBM SMP/E Guide
For PTF Check: SAP report RSDB2FIX
For all other tasks, see IBM DB2 UDB for z/OS: Installation Guide
Periodic Tasks:
The table below shows tasks that you need to perform periodically:
Whenever possible, use the DBA Planning Calendar for these tasks. You can choose from a range of predefined action patterns that include the tasks listed here.
Task:
Recommended Tool:
Run database system check
DB System Check (transaction DB16)
Run database backup
DBA Planning Calendar (transaction DB13)
Monitor the DB2 for z/OS database
CCMS Monitor Set (transaction RZ20)
Check the results of database administration tasks in the DBA Planning Calendar
DBA Planning Calendar (transaction DB13)
Run update statistics
DBA Planning Calendar (transaction DB13)
Reorg for space-saving and defragmentation
DBA Planning Calendar (transaction DB13)
DB2 Backup
DBA Planning Calendar (transaction DB13)
DB2 Repair
(DB2 native tools. For more information, see the IBM DB2 UDB for z/OS Utility Guide.)
Recalculate DB2 catalog sizes
Extent Monitor (transaction DB02) in conjunction with REORG in DBA Planning Calendar (transaction DB13)
Homogeneous System Copy
(DB2 native tools. For more information, see the IBM DB2 UDB for z/OS Administration Guide.)
A) Scheduling a Backup Job from SAP GUI front end:
1) Log into SAP and go to transaction DB13. The screen will show a calendar.
2) Double-click on the day you want to schedule a backup. A menu will appear as shown to the right here; choose the backup scheme you want to use, and enter the time of day you want to begin the backup job.
Press “Continue”
3) Enter the name(s) of the volume(s) to use for backup (e.g. P01B13). The name(s) must match the name in the header of the tape in the tape drive (see Check tape header information).
4) Press “Continue”
5) SAP will prompt for additional parameter information. Enter this information until the screen returns to the calendar. There will be an entry on the day the job was scheduled
6)Make sure the first tape to be used for backup is in the tape drive when the job starts
B) Changing a Scheduled Backup job from SAP GUI front end:
1) Log into SAP and go to transaction DB13. The screen will show a calendar.
2) Double-click on the top line (for example, line “Thu 25”) of the day for which the backup job is scheduled. A popup box will show a list of jobs for that day:
3)Click on the job for which you want to check volumes needed.
4)Press “Change” and enter the new job parameters.
C) Checking the Volumes Needed from the SAP GUI front end:
1)Log into SAP and go to transaction DB13. The screen will show a calendar.
2)Double-click on the top line (for example, line “Thu 25”) of the day for which the
3)backup job is scheduled. A popup box will show a list of jobs for that day:
4)Click on the job for which you want to check volumes needed.
5)Press “Volumes Needed”. The system will check the space required and the volumes entered in the job.
6)Respond to any error messages by changing the parameters of the job (see Changing a Scheduled Backup job from SAP GUI front end)
Offline backup with Microsoft Cluster Server (MSCS) is not possible using the DBA Planning Calendar in the Computer Center Management System (CCMS), that is, with transaction DB13. The problem is that BRBACKUP calls SVRMGR to stop the database, but SQLPLUS is not allowed in the MSCS environment.
Reward if useful to u
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.