Publisher's Synopsis
The complete Informix-Dynamic Server reference for every DBA and developer! Informix administrators and developers now have an authoritative single source for database architecture, development, administration, monitoring and tuning. Informix Power Reference brings together all the essential skills and knowledge every Informix database professional needs to maximize reliability and performance. Understand shared memory, internal multi-threading, and other architectural elements that directly impact performance. Discover how to simplify administration through static database fragmentation; supercharge Informix-SQL for database access; work with stored procedures and database triggers; enhance data integrity through constraints; and more. Coverage includes: A comprehensive overview of the Informix database engine. High-performance Informix-Dynamic Server (IDS) installation and configuration. Managing IDS physical and logical disk layouts. Identifying resource bottlenecks, including CPU, memory, disk, LRU queues, and more. Building and tuning queries for maximum effectiveness.;Youll find extensive practical guidance on database administration, including online engine modifications, DSS parameter changes, onmode commands, database security, managing logs, archiving and recovery. Expert tips and examples help you create better screen forms and reports and make the most of Informix-4GL. Complete, convenient, and up-to-date, Informix Power Reference is an invaluable resource for DBAs and developers alike. CD-ROM included! The accompanying CD-ROM brings together a comprehensive library of Informix-related tools, resources and white papers for both DBAs and developers.
