If you are working with IBM DB2 for Linux, Unix, and Windows, you’re responsible for maintaining the Rolls Royce of the SAP-certified database systems. This book helps you keep it shiny and up to speed: you’ll find all of the unique, powerful administrator’s tools, tasks, and strategies that IBM and SAP have developed. From setup and sizing to troubleshooting the database, you’ll find the information you need for a smooth ride.

1. SAP and IBM DB2 for LUW Architecture Understand how different systems are structured, and learn how to use data models and SQL queries to design your database.

2. Getting the Most out of Your System See the results of using common SAP tools and components in your IBM DB2 for LUW system, including configuration of SAP NetWeaver BW with DB2 for LUW.

3. Administrative Tools Get the database commands, file and storage locations, log files, and tablespaces you need to effectively manage your system’s performance (SAP and non-SAP).

4. Administrative Strategies Find in-depth discussion of planning for and managing different sized systems, working with different data loss prevention options and methods, and more.

5. Manage the Lifecycle Learn the steps and tools you need for everything from planning installation, applying patches and updates, and performing backup and restore, to uninstalling the system.

Highlights include:

• DB2 for LUW database
• DBA Cockpit
• SAP system landscapes and architecture
• Online data backup, restore, and recovery
• Operational monitoring
• Data and tablespace management
• SAP Solution Manager
• Event Monitor
• Database Partitioning Feature
• pureScale
• Change and Transport System
• Monitoring
• Recovery
• High Availability Disaster Recovery (HADR)
• Transport Management System