DB2 Universal Database and SAP R/3 Version 4
Published on 9. March 1999
Book
Paperback/Softback
514 pages
978-0-13-082426-4 (ISBN)
Description
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.
More details
Language
English
Place of publication
Armonk
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 233 mm
Width: 177 mm
Thickness: 34 mm
Weight
1012 gr
ISBN-13
978-0-13-082426-4 (9780130824264)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
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.
Content
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.
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.