How Do I? Tips and Tricks for OnLine Engines
by Joe Lumbley
Informix DBA Survival Guide, Second Edition
- 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
Chapter 12. How Do I? Tips and Tricks for OnLine Engines
This chapter consists mostly of scripts, programs, and techniques for accomplishing specific tasks that often cause problems for DBAs for Versions 5 and older OnLine engines. This chapter has not been changed significantly first edition of the book.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.