Database Administration for IBM Db2 for i

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
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 . 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 .	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 Update JDBC drivers: SAP Note 654800	For more information, see the IBM documentation.
System copy required	System copy	For more information, see the SAP Help Portal. SAP Note 585277
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: