DB2 Universal Database and SAP R/3 Version 4
SAP R/3 V.4 and IBM's DB2 UDB Version 5 work together beautifully -- and nearly seamlessly. This comprehensive guide shows exactly how to deploy and manage them together -- plus, it's the best preparation you can get for IBM's new certification exam covering DB2 and SAP R/3! Walk step-by-step through planning and implementing DB2 and SAP R/3 together on several leading platforms -- and how to make sure you get maximum performance from the start. Then, learn R/3 Version 4 system administration from a DB2 DBA's perspective, using DB2's exciting new graphical tools. Understand key system roles, including the SAP client; and importing/exporting between R/3 systems. Learn how to start and stop R/3; monitor and control users; analyze and tune system performance; perform R/3 backups and restores; and manage system security. Understand key differences in terminology between R/3 and DB2; master practical R/3 and DB2 troubleshooting techniques; and much more. All IT professionals working with SAP R/3 and IBM's DB2 database, especially those pursuing IBM DB2 certification.
- Paperback | 514 pages
- 185.42 x 231.14 x 35.56mm | 771.1g
- 18 Feb 1999
- Pearson Education (US)
- IBM Press
- Armonk, United States
- w. numerous figs.
About Jonathan Cook
Diane D. Bullock, Jonathan Cook, Stephen Deedes-Vincke, Robert Harbus, Luke Nardone and Rudolfo Neuhausare software professionals at IBM's International Technical Support Organization, Austin, TX.
Table of contents
1. Introduction. What Will SAP R/3 Do For Me? DB2 Universal Database (DB2 UDB). DB2 UDB Components. SAP R/3 V4.2. Pre-Installation Planning and Preparation. Pre-Installation Activities. R/3 Installation Hardware Requirements. Operating System Software. SAP R/3 and DB2 UDB Directories. Table Spaces. R/3 Naming Conventions. Communications Requirements. Presentation Servers. OSS.3. Installing and Configuring R/3 and DB2 UDB on AIX. Operating System Prerequisites. Installing DB2 UDB. Filesystems and AIX Configuration. Installing SAP R/3 on AIX. Configuring the DB2 Administration Server. Installing SAP R/3 UNIX Frontend.4. Installing SAP R/3 and DB2 UDB on Windows NT. Windows NT Setup and Configuration. Installing DB2 UDB. Installing SAP R/3.5. Installation Procedures Common to Both NT and AIX. DB2 on the Administrator Workstation. Installing the SAP R/3 Frontend. Installing the R/3 On-line Documentation.6. Post-Installation Tasks. Installing a SAP License. SAP Administration Users. Configuring the Transport System. Enabling DB2 UDB Archival Logging. Setting up a New Client. Printing from SAP. Connecting to OSS Using SAProuter. Applying Hot Packages.7. Administration in the R/3 DB2 UDB Environment. Starting the db2 DB2 Instance. Stopping DB2. The DB2 Process Model. Starting R/3. Stopping SAP R/3. R/3 Work Processes. DB2 UDB Storage Methods. User Maintenance and Security.8. R/3 Database Maintenance. R/3 Database Maintenance Architecture. DB2 UDB Logging Considerations. Backing Up the R/3 Database. Moving Offline Log Files to Other Media. Recovery of the R/3 Database. Generating Statistics and Reorganizing Tables. Index Maintenance. Table Space Maintenance.9. Monitoring and Tuning the R/3 System. Monitoring the R/3 System. R/3 Alert Monitors. R/3 Performance Monitors. Tuning SQL Statements.10. Troubleshooting. DB2 UDB Information Resources. R/3 Information Resources. DB2 UDB Logs. R/3 Logs. The DB2 Trace Facility. R/3 Traces. DB2 UDB Common Problems. R/3 Common Problems.Appendix A: R/3 and DB2 Userids. Appendix B: R/3 and DB2 Installation Checklist. Appendix C: R/3 and DB2 Control Center Tasks. Appendix D: IBM and SAP Web Sites. Appendix E. Related Publications. Index.