Database Administration for IBM DB2 UDB for iSeries (SAP Library

Database Administration for IBM DB2 UDB for iSeries

You need to perform various tasks to administer your IBM DB2 UDB for iSeries database in an SAP environment.

Getting Started

If you are new to IBM DB2 UDB for iSeries, see SAP Database Guide: IBM DB2 UDB for iSeries. For detailed information, see the IBM Information Center for iSeries at publib.boulder.ibm.com/pubs/html/as400/infocenter.html.

Tools

You can use the following SAP and IBM tools for the administration of IBM DB2 UDB for iSeries:

CCMS for iSeries ( Cockpit for iSeries)
Backup Recovery and Media Services for iSeries
For detailed information, see the IBM Information Center for iSeries at publib.boulder.ibm.com/pubs/html/as400/infocenter.html select your region, language and release level and for example in V5R3 go to section Systems management → Backup and recovery → Backup, Recovery and Media Services.

Tasks on Demand

The table below shows tasks that you need to perform when required:

Reason	Task	More Information
Database recovery after data loss	Restore and Recovery	SAP Note 825473
Analysis of space consumption by database objects	· Finding Database Storage Problems (iSeries) · Perform Deleted Records Analysis (iSeries)	None
Inconsistencies between ABAP Dictionary and database	Consistency Checks (iSeries)	None
Database performance analysis	Monitoring the Database (iSeries)	For more information about database performance analysis, see the IBM Information Center for iSeries at publib.boulder.ibm.com/pubs/html/as400/infocenter.html
Maintain access to other systems, such as a BW source system	· Connection from iSeries to an iSeries database: SAP Note 146624 · Connection from a Windows application server to an iSeries database: SAP Note 445872 · Connection from an iSeries with a BW system to a non-SAP database on iSeries: SAP Note 523381	None
New database release	Database upgrade	For detailed information, see the IBM iSeries Information Center at publib.boulder.ibm.com/pubs/html/as400/infocenter.html select your region, language and release level and for example in V5R3 go to section OS/400 and related software → Upgrade or replace OS/400 and related software
Install software fixes	· Order, load and apply program temporary fixes (PTF’s) for iSeries · Download qxdaedrs.dll for Windows: SAP Note 751451 · Update JDBC drivers: SAP Note 654800	For detailed information, see the IBM iSeries Information Center at publib.boulder.ibm.com/pubs/html/as400/infocenter.html select your region, language and release level and for example in V5R3 go to section OS/400 and related software → Maintain and manage OS/400 and related software → Use software fixes
System copy required	Database copy	· For more information, see SAP Service Marketplace at service.sap.com/nw04installation ® SAP Web AS ® SAP Web AS 6.40 SR1 Installation and Related Documentation ® Homogeneous and Heterogeneous System Copy · SAP Note 585277
Password change required	On iSeries, 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 iSeries, 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	SAP System Save Strategies
Daily / weekly	Verify database backup	Backup Overview (iSeries)
Daily	Check disk space	State on Disk (iSeries)