Show TOC

Database Administration for IBM DB2 for iLocate this document in the navigation structure

Use

You need to perform various tasks to administer your IBM DB2 for i database in an SAP environment.

Getting Started

If you are new to IBM DB2 for i, see the SAP Database Guide: IBM DB2 for i.

Tools

You can use the following SAP and IBM tools for the administration of IBM DB2 for i:

  • CCMS for IBM DB2 for i

  • Backup Recovery and Media Services. For more information, see the IBM documentation.

Tasks on Demand

The table below shows tasks that you need to perform when required:

Reason

Task

More Information

Database recovery after data loss

Backup and Recovery

SAP Note 825473 Information published on SAP site

Analysis of space consumption by database objects

  • Finding Database Storage Problems (IBM DB2 for i)

  • Perform Deleted Records Analysis (IBM DB2 for i)

None

Inconsistencies between ABAP Dictionary and database

Consistency Check (IBM DB2 for i)

None

Database performance analysis

Database Monitor (IBM DB2 for i)

For more information about database performance analysis, see the IBM documentation.

Maintain access to other systems, such as a BW source system

  • For information about how to connect from an IBM i, Windows and Linux PPC to an IBM DB2 for i database, see SAP Note 146624 Information published on SAP site.

  • For information about how to connect from an IBM i with a BW system to a non-SAP database on IBM i, see SAP Note 523381 Information published on SAP site.

None

New database release

Database upgrade

For more information, see the IBM documentation.

Install software fixes

  • Order, load and apply program temporary fixes (PTF's) for IBM i

  • Download qxdaedrs.dll for Windows: SAP Note 751451 Information published on SAP site

  • Update JDBC drivers: SAP Note 654800 Information published on SAP site

For more information, see the IBM documentation.

System copy required

System copy

Password change required

On IBM i, sign on as QSECOFR and use command CHGUSRPRF for all instance users ( SID<nn>) on all servers.

For more information on changing passwords on a Windows operating system, see SAP Note 705886 Information published on SAP site.

For more information about authority concept for SAP on IBM i, see SAP Note 173579. Information published on SAP site

Periodic Tasks

The table below shows tasks that you need to perform periodically:

Frequency

Task

Recommended Tool

Daily / weekly

Run database backup

SAP System Save Strategies

Daily / weekly

Verify database backup

Backup Overview (IBM DB2 for i)

Daily

Check disk space

State on Disk (IBM DB2 for i)