INFORMIX : Power Reference

By (author) 

List price: US$53.49

Currently unavailable

Add to wishlist

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

Try AbeBooks


This is the most complete, convenient and up-to-date reference for all Informix database professionals. It presents an overview of the entire Informix database product line, and introduces the overall Informix database architecture, covering shared memory, internal multi-threading, scalability and other common elements, as well as architectural elements unique to Online Dynamic Server, Extended Parallel Server, and Informix Universal Server. The book walks through the installation of each Informix database, and includes detailed, practical coverage of Informix database administration, monitoring and tuning -- using both GUI-based and command-line based tools. Three convenient reference sections present Informix-SQL syntax, character-based and GUI tools commands.
show more

Product details

  • Hardback | 528 pages
  • 175.5 x 233.4 x 37.1mm | 1,104.77g
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 0130809063
  • 9780130809063

Table of contents

1. Informix Product Overview.

History of Informix Products. Informix Product Architecture. Parallel Database Operations. Chapter Summary. Next Chapter.

2. Informix Basic Concepts and Server.

IDS Basic Concepts. Chunks and dbspace. Informix Data Types. Smallfloat. System Reserved Pages. Root dbspace. System Catalog. The sysmaster Database. Informix Server Architecture. Tracing a Query Through the Engine. Parallel Data Query and PDQ Priority. IDS Options and Extensions. Chapter Summary. Next Chapter.

3. Installation and Configuration of the Informix Dynamic Server.

IDS Configuration. Installation Preparation. IDS Environment Variables. The onconfig File. Timeout. Summary. Next Chapter.

4. Managing the IDS Disk.

The IDS View of Disk. Creating Database Tables. Using Data Distributions. Monitoring Disk Usage. Summary. Next Chapter.

5. Monitoring and Tuning the IDS Engine.

Tuning Strategies for IDS. Monitoring IDS Using the onstat Utility. Using the onstat Utility to Identify Resource Bottlenecks. Using Operating System Resource Monitors. Addressing CPU Resource Problems. Monitoring IDS Memory Usage. Monitoring Disk Activity. Log Activity in the IDS Engine. Evaluating and Tuning Physical Log Activity. Evaluating and the LRU Queue. Evaluating and Tuning Checkpoints. Tuning Queries and Applications. Addressing System Resource Problems. Tuning a Query. The Query and the Query Plan. Tuning the Query. Using Table Fragmentation for Query Tuning. Chapter Summary. Next Chapter.

6. Database Administration in the Informix Dynamic Server.

Starting and Stopping the Database. Online Engine Modifications. Adding and Removing CPU Resources. DSS Parameter Changes. Using onmode to Alter Shared Memory Parameters. Miscellaneous onmode Commands. IDS Database Security. Managing IDS Logs. Archiving and Recovery. Chapter Summary. Next Chapter.

7. The Relational Database and Informix-SQL.

History of the Relational Database. Relational Database Concepts. The Structured Query Language in IDS. Creating Data Storage-The DDL Statements. Column Integrity and Referential Constraints. Accessing Data-DML Statements. The insert Statement. Miscellaneous SQL. Informix Stored Procedure Language. IDS Database Triggers. IDS String Manipulation Functions. New Version 7.3 Features. Chapter Summary. Next Chapter.

8.Introduction to INFORMIX-4GL.

The INFORMIX-4GL Language. Parts of a 4GL Application. Modular Programming with INFORMIX-4GL. Informix Data Types and Operators. Data Conversion in Assignments. Language Constants. Flow of Control Statements in INFORMIX-4GL. Conditional Expressions in INFORMIX-4GL. The Concatenation Operator. Using SQL in INFORMIX-4GL Applications. Chapter Summary. Next Chapter.

9.Screen Forms and Reports.

Managing Screen Size. Screen Form Programming. Database Binding in Screen Forms. formonly Screens. Manipulating the Screen Form in INFORMIX-4GL. Modularity and Screen Form Interaction. Managing Multiple Windows. display Statement. input Statement. Termcap Issues. INFORMIX-4GL Reports. The acct_totals Report. Table-Driven Dynamic Report. Chapter Summary. Next Chapter.

10.Functions and Error Handling in INFORMIX-4GL.

Error Handling and Help Messages in INFORMIX-4GL. Chapter Summary.

show more

About Art Taylor

Art Tayloris author of several leading guides to Informix, including Informix-NewEra: A Programmer's Guide, and Advanced Informix Programming. He has more than six years experience consulting for Informix Software.
show more