Database
Administration for IBM DB2 for i5/OS
You need to perform various tasks to administer your IBM DB2 for i5/OS in an SAP environment.
Getting Started
If you are new to IBM DB2 for i5/OS, see SAP Database Guide: IBM DB2 for i5/OS . For detailed information, see the IBM Information Center for System i at publib.boulder.ibm.com/iseries.
Tools
You can use the following SAP and IBM tools for the administration of IBM DB2 for i5/OS:
● CCMS: IBM DB2 for i5/OS
●
Backup
Recovery and Media Services for System i
For detailed information, see the IBM Information Center for System i at publib.boulder.ibm.com/iseries and
select your version and ,for example, in V5R5 go to section Systems management → Backup and recovery → Backup, Recovery and Media Services. (BRMS).
(Prior to V5R3, select your language and
version combination.)
Tasks on Demand
The table below shows tasks that you need to perform when required:
Reason |
Task |
Information |
Database recovery after data loss |
Backup and Recovery |
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 Information Center for System i at publib.boulder.ibm.com/iseries. |
|
Maintain access to other systems, such as a BI system |
● Connection from DB2 for i5/OS: SAP Note 146624 ● Connection from a Windows application server to DB2 for i5/OS: SAP Note 445872 ● Connection from a BI system on i5/OS to a non-SAP database on i5/OS: SAP Note 523381 |
None |
New database release
|
Database upgrade
|
For detailed information, see the IBM Information Center for System i at publib.boulder.ibm.com/iseries and select your version and ,for example, in V5R5 go to section i5/OS and related software → Upgrading or replacing i5/OS and related software. (Prior to V5R3, select your language and version combination.) |
Install software fixes |
● Order, load and apply program temporary fixes (PTFs) for System i ● Update XDA Database Client (Windows/Linux): SAP Note 751451 ● Update JDBC drivers: SAP Note 654800 |
For detailed information, see the IBM Information Center for System i at publib.boulder.ibm.com/iseries and select your version and ,for example, in V5R5 go to section i5/OS and related software → Maintain and manage i5/OS and related software → Use software fixes. (Prior to V5R3, select your language and version combination.) |
System copy required
|
System copy required
|
● For more information, see SAP Service Marketplace at service.sap.com/instguides. ● SAP Note 585277 |
Password change required |
ABAP For
more information on changing passwords on a Windows operating system, see SAP Note 705886.
|
For more information about authority concept for SAP on System i, see SAP Note 834218. |
Finding Database
Storage Problems (System i)
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 |
|
Daily |
Check disk space |