- Copyright
- Foreword to the Second Edition
- The Database Administrator: Doing the Job
- Inside the Black Box: Engine Architecture
- How to Read This Chapter
- Understanding the Data Flow
- Tracking the Flow of Data
- Understanding OnLine 's Physical Architecture
- How OnLine Manages Shared Memory
- Understanding IDS's Physical Architecture
- Components of the Informix Dynamic Server
- How UNIX Manages Memory
- Contents of OnLine Shared Memory and IDS Resident Shared Memory
- Understanding Logging
- Understanding Archives
- Principles of Debugging
- Informix Dynamic Server on Windows NT
- The Graphical Client Utilities on Windows
- Informix Connectivity Products
- Client and Server on the Same System
- Clients and Servers on Separate Hosts
- Remote Connections over TCP/IP
- Managing Sqlhosts with Setnet
- Network Security and Trust Relationships
- Registry Use with Windows NT Clients
- Connection Options
- Testing Connectivity with Ilogin
- Common Informix-Connect Errors
- Informix-CLI: ODBC for Informix
- Understanding the OnLine Utilities
- The Onstat Utility in IDS
- Exploring the Sysmaster Database
- Exploring the SMI Database
- A Practical Example: Who is Using What Database
- How the Sysmaster Database is Created
- Supported SMI Tables
- Differences from Other Databases
- Server Information
- Dbspace and Chunk Information
- Database and Table Information
- User Session Information
- Some Unsupported Extras
- Conclusion
- The HTML Version of the Sysmaster Documentation
- How Do I? Tips and Tricks for OnLine Engines
- Can I Use these Scripts with IDS?
- OnLine-Specific Scripts
- Run SQL from the Command Line
- Find out how much Space is Being Used by Tables
- Find Duplicate Values in a Table
- Clean out Tables
- Re-create a Table with the Same Parameters as the Original
- Clean Selected Data out of a Table
- Know if OnLine is Running
- Convert Table Numbers to Table Names
- Find Database Names from a Script
- Find Database Names from an ESQL/C Program
- Maintain a Current UPDATE STATISTICS
- Get Table Information
- Make a Fast Recovery go Faster
- Know What a Certain User is Doing
- Translate a UNIX User ID to a Real Name
- Run an Archive in the Background and Monitor it
- Locate Areas of High Disk Activity
- Tell if Continuous Backup of Logfiles is Running
- Kill a Backend
- Identify Temporary Tables
- Know When System is in a Checkpoint
- Monitor and Report on Table Sizes
- Fight Table Proliferation
- The Status Script
- Common DBA Tasks
- The Database Tuneup
- Problem Fixes for Informix Dynamic Server
- Bufwaits
- Disk Devices
- Tables
- Determining Locales
- DBSPACETEMP and Temporary Spaces
- Archiving And Temporary Spaces
- Update Statistics
- Multiprocessors
- Tuning
- Network Performance
- Using The Violations Tables
- Varchars Versus Char Data Types
- Connections
- Set Explain
- Stored Procedures
- ESQL/C
- Triggers
- Archives and Logs
- Time Calculations
- Building Manageable Client/Server Projects
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.