Carlton Doe's long awaited IDS book is near completion. It is so near completion that you can find it listed on amazon.com now... with a hefty pre-order discount:
Administering Informix Dynamic Server: Building the FoundationList Price: $59.95Price: $37.77 & this item ships for FREE with Super Saver Shipping. You Save: $22.18 (37%)
Carlton's previous published books, Informix Dynamic Server Handbook and Administering Informix Dynamic Server on Windows NT are 11 and 9 years old, respectively.
Except for the two "flashbooks" that Carlton published via IBM, no other IDS books have made it to the bookstores! You'll be happy to learn that there is a certification guide in the works as well as a possible second book from Carlton (with more advanced material).
Here is an online version of the first flashbook that introduced IDS 11: IBM Informix Dynamic Server 11: The Next Generation in OLTP Data Server Technology. The second smaller one that introduced 11.5 will be available for free at the IOD Conference.
What's in the new book:
Geared towards database server administrators who need to get a server up and running in a short amount of time, this guide focuses on the basic skills required to administer and maintain the Informix Dynamic Server (IDS) data server. Each of the major functional areas of the database server are reviewed, including designing, initializing, monitoring, building availability layers, securing data, and the data processing environment. This book reviews how the IDS works, how to install it, how to configure a database environment, back up, recovery, and includes an introduction to monitoring instance operations, making it useful to current IDS users who need to upgrade from earlier versions of the data server as well as those who have never used IDS before.
Table of Contents:Chapter 1 – Introduction to Informix Dynamic ServerThis chapter covers the general design of the IDS data server. Terms and keywords used extensively throughout the rest of the book are introduced and defined here.
Chapter 2 – An Introduction to ExtensibilityThis chapter explores the object-relational features and capabilities of Informix Dynamic Server.
Chapter 3 – Preparing for InitializationIn this chapter, Carlton covers many of the topics you need to address from a design perspective when planning for the implementation of an IDS environment. For the most part, the discussion is general in scope because there are few hard and fast rules to follow when building a database environment. Where rules do exist, they are stated. At the close of the chapter, Carlton explains the required environment variables, files, and other objects as well as how to set them up.
Chapter 4 – Installing and Initializing IDSThis chapter covers all the steps and configuration parameters for creating an IDS database environment or instance, with specific recommendations given for the most critical configuration parameters. At the end, Carlton introduces the system-level databases that manage and control an IDS environment.
Chapter 5 – Basic Administrative TasksIn this chapter, Carlton explains most of the general day-to-day, or occasional, instance-oriented administrative tasks. These include adding or dropping disk space, starting up or shutting down the instance, and killing user sessions in the instance. The major graphical administration tools are introduced as an alternative to performing many of these tasks using the command line.
Chapter 6 – Building a Database EnvironmentIn this chapter, Carlton trades his DSA’s hat for that of a DBA and covers building and populating databases in IDS instances. The chapter explains features such as table and index partitioning, constraints, logging, database and table population utilities, and a collection of IDS-specific SQL statements that Carlton thinks are interesting to know about and use.
Chapter 7 – Backing Up and RestoringOne of the least glamorous, but still important, functions of operating a database environment is backing up what’s on disk to tape. In this chapter, Carlton covers a couple of backup strategies and their relative strengths and weaknesses. He explains how Informix Dynamic Server can execute moment-in-time backup and restore operations with the database environment online and fully functioning. The process of executing backup and restore operations using the ontape utility, as well as the ON-Bar utility suite in conjunction with the Informix Storage Manager (ISM), is covered in great detail.
Chapter 8 – Monitoring the InstanceThroughout the book, discussions make reference to, and include illustrations of, output generated by the various IDS monitoring commands. In this chapter, Carlton focuses exclusively on those commands and some of the more commonly monitored activities of a database environment. He concentrates primarily on IDS’s command-line utilities as well as the functionality available in the new OpenAdmin Tool for IDS (OAT).
For those of you who don't know Carlton, here's his bio and website:
Carlton Doe is one of the five founders of the International Informix Users Group (IIUG) and has served as the IIUG president. He is the author of Administering Informix Dynamic Server on Windows NT and Informix: OnLine Dynamic Server Handbook. He lives in Dallas, Texas.
Congratulations Carlton! The entire IDS community will be proud of this book!
The developerWorks Connections platform will be sunset on January 2, 2020. This blog will no longer be available unless an extension has been requested. More details available on our FAQ.