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 |
SAP Note 825473 |
|
Analysis of space consumption by database objects |
|
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 |
None |
|
New database release |
Database upgrade |
For more information, see the IBM documentation. |
Install software fixes |
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 . |
For more information about authority concept for SAP on IBM i, see SAP Note 173579. |
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 |