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 . For detailed information, see the IBM Information Center at http://publib.boulder.ibm.com/iseries.

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 detailed information, see the IBM Information Center at http://publib.boulder.ibm.com/iseries and select your version and ,for example, in V6R1 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	Finding Database Storage Problems (IBM i) Perform Deleted Records Analysis (IBM i)	None
Inconsistencies between ABAP Dictionary and database	Consistency Checks (IBM i)	None
Database performance analysis	Monitoring the Database (IBM i)	For more information about database performance analysis, see the IBM Information Center at http://publib.boulder.ibm.com/iseries.
Maintain access to other systems, such as a BI system	Connection from DB2 for i: SAP Note 146624 Connection from a Windows application server to DB2 for i: SAP Note 445872 Connection from a BI system on IBM i to a non-SAP database on IBM i: SAP Note 523381	None
New database release	Database upgrade	For detailed information, see the IBM Information Center at http://publib.boulder.ibm.com/iseries and select your version and ,for example, in V6R1 go to section i5/OS and related software Installing, Upgrading or deleting 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 IBM i Update XDA Database Client (Windows/Linux): SAP Note 751451 Update JDBC drivers: SAP Note 654800	For detailed information, see the IBM Information Center at http://publib.boulder.ibm.com/iseries and select your version and ,for example, in V5R5 go to section i5/OS and related software Maintaining and managing i5/OS and related software Using 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 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	SAP System Save Strategies
Daily / weekly	Verify database backup	Backup Overview (IBM i)
Daily	Check disk space	State on Disk (IBM i)