Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

what about jobs?(DB13)

hi gurus,

plz send me brief explenetion about jobs & DB13.

regards,

balaram

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question