SAP Solutions on IBM DB2 UDB V8.2.2 Handbook.

Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Acknowledgements -- Become a published author -- Comments welcome -- Chapter 1. DB2 UDB and SAP -- 1.1 Executive summary -- 1.2 DB2 UDB V8.2.2 features for SAP systems at a glance -- 1.2.1 New features in DB2 UDB V8.2 -- 1.2.2 New features in DB2 UDB V8.2.2 -- 1.3 SAP release matrix with DB2 UDB platforms -- Chapter 2. DB2 UDB architecture from SAP's point of view -- 2.1 DB2 UDB server process model -- 2.1.1 Fault monitor facility -- 2.1.2 A practical view of the process model -- 2.2 DB2 UDB server memory architecture -- 2.2.1 Database manager shared memory and FCM shared memory -- 2.2.2 Database shared memory -- 2.2.3 Application group shared memory -- 2.2.4 Agent private memory -- 2.2.5 DB2 memory architecture summary -- 2.3 Storage concept basics -- 2.3.1 Table space types -- 2.3.2 DB2 UDB V8.2.2 storage management advancements -- 2.3.3 Directory structure for DB2 UDB in SAP environments -- 2.4 DB2 UDB partitioning concepts -- 2.4.1 Benefits of using the database partitioning feature -- 2.4.2 Using database partitioning feature in SAP systems -- 2.5 Database client and SAP database layer -- 2.5.1 Interaction between the database interface layer and DB2 UDB -- 2.6 Terminology mapping with DB2 UDB -- 2.6.1 DB2 UDB terms -- 2.6.2 Terminology mapping for Oracle databases -- 2.6.3 Terminology mapping for IBM Informix Dynamic Server databases -- 2.6.4 Terminology mapping for MySQL MaxDB databases -- Chapter 3. Installing SAP NetWeaver 2004s with DB2 UDB V8.2.2 -- 3.1 Test environment -- 3.1.1 Software configuration -- 3.1.2 Hardware configuration -- 3.2 SAP installation guides -- 3.3 System preparation -- 3.3.1 The Prerequisites Checker Tool -- 3.3.2 Checking conditions -- 3.3.3 Running modes.

3.4 Considerations: Installing SAP NetWeaver 2004s with DB2 UDB V8.2.2 -- 3.4.1 Features that are automatically switched on -- 3.4.2 Storage management and table spaces: considerations -- 3.4.3 Database Partitioning Feature (DPF) considerations -- 3.5 Post installation activities: a DB2 UDB view -- 3.6 Considerations: Installing older SAP systems with DB2 UDB V8.2.2 -- Chapter 4. Storage management in depth -- 4.1 DB2 UDB logical and physical database objects -- 4.1.1 Tables, indexes, and views -- 4.1.2 Table spaces -- 4.1.3 Table space containers -- 4.2 Working with SMS and DMS table spaces -- 4.2.1 SMS table spaces -- 4.2.2 File based DMS table spaces -- 4.2.3 Device based DMS table spaces -- 4.3 SAP data classes (TABARTs) -- 4.4 Space reclamation strategies -- 4.4.1 Offline table and index reorganization -- 4.4.2 Inplace table and index reorganization -- 4.4.3 Criteria for reorganization -- 4.4.4 High water mark -- 4.5 Best practices for intelligent storage subsystems -- 4.5.1 Database stored on single SSA/SCSI disks -- 4.5.2 Database stored on RAID-5 arrays -- 4.6 Moving tables and indexes using DB6CONV -- 4.6.1 Principle of moving tables and indexes using DB6CONV -- 4.6.2 Example: Moving table PCL2 to improve performance -- Chapter 5. DB2 UDB configuration from SAP's perspective -- 5.1 DB2 UDB's approach to database parameters -- 5.2 DB2 UDB database manager configuration -- 5.2.1 SAP recommended database manager configuration settings -- 5.3 DB2 UDB database configuration -- 5.3.1 SAP recommended database configuration -- 5.4 DB2 profile registry -- 5.4.1 DB2 registry variables and recommended settings -- Chapter 6. SAP database administration -- 6.1 Architectural overview -- 6.2 Local and remote monitoring -- 6.2.1 Concept of remote monitoring -- 6.2.2 Configuration for remote system monitoring -- 6.3 Screen management -- 6.3.1 Common fields.

6.3.2 Buttons in the navigation frame -- 6.3.3 Monitoring settings -- 6.3.4 Authorization and permission -- 6.3.5 Lock on DBA Cockpit -- 6.4 Monitoring -- 6.4.1 Database monitoring -- 6.4.2 Schema monitoring -- 6.4.3 Buffer pool monitoring -- 6.4.4 Table space monitoring -- 6.4.5 Table monitoring -- 6.4.6 Application monitoring -- 6.4.7 SQL cache analysis -- 6.4.8 Lock waits and deadlock analysis -- 6.4.9 Inplace table reorganization monitoring -- 6.5 Space management -- 6.5.1 Table spaces -- 6.5.2 Containers -- 6.5.3 Tables and indexes -- 6.5.4 Single table analysis -- 6.5.5 History -- 6.6 Backup management -- 6.6.1 Backup Overview -- 6.7 Log file management -- 6.8 Configuration -- 6.8.1 Database Manager -- 6.8.2 Database -- 6.8.3 Parameter Changes -- 6.8.4 Database partitioning group -- 6.8.5 Buffer Pools -- 6.8.6 Special RUNSTATS settings and volatile tables -- 6.8.7 CLP Command Execution -- 6.8.8 File Systems -- 6.8.9 Data Classes -- 6.8.10 Monitoring Tool Settings -- 6.9 Scheduling DBA tasks -- 6.9.1 DBA Planning Calendar -- 6.9.2 DBA Log -- 6.9.3 CLP Script Maintenance -- 6.10 Using the alert monitor -- 6.10.1 Alert Configuration -- 6.10.2 Alert Message Log -- 6.11 Diagnostics -- 6.11.1 Missing Tables and Indexes -- 6.11.2 Help -- 6.11.3 Control Panel -- 6.11.4 Single System Check -- 6.11.5 Explain -- 6.11.6 Cumulative SQL Trace -- 6.11.7 DBSL Trace Directory -- 6.11.8 Trace Status -- 6.11.9 Database Notification Log -- 6.11.10 Database Diag Log -- 6.11.11 Dump directory -- 6.12 Partition Integration wizard -- Chapter 7. Protecting your SAP data -- 7.1 Log file management -- 7.1.1 Basic logging concepts -- 7.1.2 SAP log management -- 7.1.3 DB2 UDB V8.2 log management -- 7.1.4 Comparison of legacy and DB2 V8.2 log file management -- 7.1.5 Migration from legacy to DB2 log file management -- 7.2 DB2 UDB backup and recovery.

7.2.1 Setting up the backup media -- 7.2.2 Performing backups -- 7.2.3 Recovering the database -- 7.2.4 Redirected restore of the database -- 7.2.5 Database relocation -- 7.2.6 Throttling the backup utility -- 7.3 Advanced Backup technology for a large database -- 7.3.1 DB2 UDB functions for a large database backup/restore -- 7.3.2 Back up and restore a large database -- 7.3.3 Creating a hot standby database -- 7.3.4 Taking a normal DB2 UDB backup -- 7.3.5 Creating a database clone -- 7.3.6 Special considerations for IBM ESS Flash Copy on AIX platform -- 7.3.7 Offline backup image and recovery -- 7.4 Monitoring backup, restore and recovery progress -- 7.5 High availability -- 7.5.1 High Availability Disaster Recovery (HADR) -- 7.5.2 Log file shipping -- 7.5.3 Clustered solutions -- Chapter 8. Database problem diagnostics -- 8.1 Introduction to PD/PSI -- 8.1.1 What is PD/PSI? -- 8.1.2 Problem types -- 8.2 Tools and diagnostic data collection -- 8.2.1 DB2 data collection and diagnostic tools -- 8.2.2 SAP tools for diagnostic purposes -- 8.3 Support Integration of SAP and DB2 -- 8.4 Problem research resources -- Chapter 9. Using features of DB2 UDB V8.2 and V8.2.2 with older SAP systems -- 9.1 Upgrading DB2 UDB to V8.2.2 -- Chapter 10. Using SAP NetWeaver 2004s Business Intelligence with DB2 UDB -- 10.1 SAP BI technical overview -- 10.1.1 SAP BI information model -- 10.2 Clustering support in DB2 UDB V8.2.2 -- 10.2.1 Index clustering -- 10.2.2 Multi-dimensional clustering (MDC) -- 10.3 Clustering support in SAP NetWeaver 2004s BI -- 10.3.1 Persistent Staging Area (PSA) -- 10.3.2 DataStore objects -- 10.3.3 InfoCube fact tables -- 10.3.4 Aggregates -- 10.3.5 Defining clustering for InfoCubes -- 10.3.6 Defining MDC for DataStore objects -- 10.4 Re-clustering InfoCubes and DataStore objects -- 10.4.1 Re-clustering for InfoCubes.

10.4.2 Re-clustering for DataStore objects -- 10.4.3 Monitoring re-clustering requests -- 10.4.4 Data copy -- 10.5 InfoCube compression -- 10.6 Data deletion with new SQL DELETE statement -- 10.7 Use of sampled statistics -- 10.8 Migration of SAP BI systems to DB2 UDB -- 10.8.1 Migration procedure -- 10.8.2 Generation of the DDL for the target database platform -- 10.8.3 Exporting the source database -- 10.8.4 Creating and importing the target database -- 10.8.5 SAP BI migration post processing -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover.