SAP R/3 for the Informix DBA

SAP R/3 for the Informix DBA

By (author) 

List price: US$53.51

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Throughout 2000, look to Prentice Hall PTR for the hottest new books written for technical professionals. Each month, the PH PTR Technology Focus will highlight some of today's most important technologies and the PTR titles which will help you get the job done! These key books will be supported at conventions, in magazine space ads, on the WWW, and in partnership with the finest bookstores throughout the country.
show more

Product details

  • Paperback | 304 pages
  • 176.02 x 233.43 x 19.81mm | 571.52g
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 0130225541
  • 9780130225542

Table of contents

I. INTRODUCTION AND GETTING STARTED.

1. Enterprise Resource Planning Software.


Why Do Companies Choose SAP? Market for SAP with Informix.

2. SAP R/3 Introduction.


What Is SAP R/3? Where Does the Informix Database Administrator Fit In? 1-, 2-, and 3-Tier Architecture. R/3 Landscape. R/3 Repository. R/3 Client Overview.

3. Informix Introduction.


Dynamic Scalable Architecture (DSA) and Multithreading. Context Switching. Threads and Queues.

4. SAP R/3 Installation.


Installation Information for R/3 with Informix. Informix Networking. Directories and Files. Disk Layout, INSTINF.PFL, and BUILDINF.PFL. Upgrade Information. Profile Information.

5. Logging on and Maneuvering Through SAP R/3.


R/3 Logon. R/3 Screen Basics. R/3 System Screen.

6. SAP R/3 Online Service System (OSS).


Overview. Logon and Inbox. Note Search. Registration. Administration. Service.

II. ADMINISTRATION.

7. Informix Basics for SAP R/3.


ONCONFIG. Initialization Parameters. Diagnostic Parameters. Tape Parameters. Performance Parameters. Shared Memory Parameters. Parallel Database Queries and Fragmentation. Database Replication (DR) and Other Miscellaneous Parameters. Shared Memory. Logging. Virtual Processes and Work Processes. Database Updates.

8. Informix Administration and Housekeeping for SAP R/3.


Tasks and Activities. Initial Database Setup and Maintenance Planning. Daily Checks and Tasks. Weekly Checks and Tasks. Monthly or Quarterly Checks and Tasks. Prior to Heavy Load Activity and Client Transports. After Heavy Load Activity, Client Transports, and Client Deletes. As-Required Activities. Tools. Client Copies. Database Copies. Database Growth.

9. Informix Database Archives and Backups via SAP R/3.
10. SAP R/3 SAPDBA.


Changing the Server Mode/Starting and Stopping the Informix Database. Dbspaces. Analyzing Dbspaces. Maintaining Dbspaces. Reorganization. Analyzing Tables and Indexes. Reorganizing Tables and Indexes. Data Consistency Checks. Update Statistics. Update Statistics Analysis. Performing Update Statistics. Logging Mode. Data Recovery Report for Informix Onarchive. Configuration and Performance Checks. System Information.

11. Informix Administration Tasks via SAP R/3.


DBA Planning Calendar-DB13. Background Jobs-M37. Onarchive Backup Logs-DB12. Database Configuration Checks-DB16 and DB17. Maintaining Optimizer Statistics-DB20 and DB21. Analyze Tables and Indexes-DB02.

III. MONITORING AND TUNING.

12. Monitoring and Tuning Informix via SAP R/3.


SAP/Informix Database Monitor Overview-ST04. SAP/Informix Database Monitor Detail Analysis-ST04. Exclusive Lockwait Monitor-DB01. Enqueue and Update Monitors-SM12 and SM13. Informix Database Performance Alerts-AL02 and RZ06. SQL Trace-ST05. Exception Analysis-SM21 and ST22.

13. Monitoring and Tuning Informix via Informix.


onstat -p. onstat -m. onstat -l. onstat -R. onstat -F. onstat -g glo. onstat -u. onstat -x. onstat -g ses. onstat -g ses (session id). onstat -g sql. onstat -g seg. onstat -g ath. onstat -d. onstat -g iof. onstat -D. onstat -g ioq. oncheck.

14. Informix Database Features for SAP R/3.


Fragmentation. Detached Indexes. Informix High Availability-HDR and EBR.

Appendix A: Useful SAP R/3 Transactions.
Appendix B: Useful SAP R/3 Menu Paths.
Appendix C: Useful SAP R/3 OSS Notes.
Appendix D: Useful Informix Commands.
Appendix E: Glossary.
Bibliography.
Index.
show more

About Sari Nathans

Sari Nathans is a Technical Solutions Consultant for Strategic Applications Resources, Inc., Tampa, FL. Nathans has more than 15 years of experience working with enterprise database software.
show more