Database Administration for IBM DB2 for i 
You need to perform various tasks to administer your IBM DB2 for i in an SAP environment.
Getting Started
If you are new to IBM DB2 for i, see 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: IBM DB2 for i
Backup Recovery and Media Services for IBM i. For more information, see the IBM documentation.
Tasks on Demand
The table below shows tasks that you need to perform when required:
Reason |
Task |
Information |
|---|---|---|
Database recovery after data loss |
SAP Note 825473 |
|
Analysis of space consumption by database objects |
None |
|
Inconsistencies between ABAP Dictionary and database |
None |
|
Database performance analysis |
For more information about database performance analysis, see the IBM documentation. |
|
Maintain access to other systems, such as a BI system |
None |
|
New database release |
Database upgrade |
For more information about database performance analysis, see the IBM documentation. |
Install software fixes |
For more information about database performance analysis, see the IBM documentation. |
|
System copy required |
System copy required |
|
Password change required |
ABAP On IBM i, sign on as QSECOFR and enter 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. Java SAP Note 907733 |
For more information about the authority concept for SAP on IBM i, see SAP Note 834218. |
Periodic Tasks
The table below shows tasks that you need to perform periodically:
Frequency |
Task |
Recommended Tool |
|---|---|---|
Daily / weekly |
Run database backup |
|
Daily / weekly |
Verify database backup |
|
Daily |
Check disk space |