Building skills in IDS 11
svisser1 2700018UK9 Visits (2493)
Test 918 - System Administration for IBM Informix Dynamic Server V11. Oh yea, I also had another proposal for an IDS book...
So the questions is.... is there really a market for all these books? I hope so. All of the published books that you can currently find on amazon.com are nearly 10 years old. I'm sure many of you saw the IDS 11 Flashbook IBM Informix Dynamic Server 11: The Next Generation in OLTP Data Server Technology, written by Carlton: IBM has been handing this book out at events since June and the feedback has been amazing! The success of this book showed everyone that there is extreme hunger in the market for new and relevant information.
So, in addition to the IBM Redbooks, articles, tutorials, and courses, I'm hoping to see three full retail books published. Interested?
Here is a current list of the training options that you have for IDS 11:
IBM Informix Dynamic Server 11 System Administration Certification Preparation Tutorial SeriesThis series of eight tutorials has been developed to help you prepare for the IBM Informix Dynamic Server 11 System Administration Certification Exam (918). These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. After a quick registration, you can begin a tutorial. Currently parts 1 and 2 are available in this series of eight. Each tutorial should take less than two hours to complete. You can take the tutorials online, or download a PDF.
Informix Dynamic Server 11 Systems Administration - Instructor Led OnlineThis online course is designed for Informix Dynamic Server system administrators and is 4 days in length. Travel arrangements are not necessary for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
After completing this course, students will be able to:* Describe the components of a database server.* Install IBM Informix Dynamic Server.* Configure and initialize a database server.* Configure the server to allow both local and remote connections.* Use Dynamic Server utilities to monitor server activity.* Describe the components of shared memory and configure the component sizes.* List, describe, and configure the different classes of virtual processors.* Identify the components of the database server disk architecture.* Create dbspaces, blobspaces, and sbspaces and add chunks to these spaces.* Explain the purpose of physical and logical logs and monitor log activity.* View the individual transactions that are written to the logical log files.* Describe the importance of checkpoints on the server.* Describe the importance of fast recovery.* Perform backups of the database server and logical logs.* Use different methods to restore a database server from backup.* Explain the purpose of temporary spaces used by the server.* Configure the database server to operate more efficiently using parallel operations.* Monitor the resources used by individual user sessions.* Configure the server to respond to specific events by executing an alarm program.* Use various troubleshooting techniques to identify and resolve common problems.
Informix Dynamic Server 11 Extending Availability and ReplicationIn this IBM Redbooks publication, we provide an overview of the high availability and Enterprise Replication features of Informix Dynamic Server (IDS) Version 11, which can simplify and automate enterprise database deployment. Version 11 offers patent-pending technology that virtually eliminates downtime and automates many of the tasks associated with deploying mission-critical enterprise systems. The high availability capability can reduce or eliminate costly downtime through, for example, the introduction of online index rebuild, the capability to create and drop indexes online without locking tables, and point-in-time table level restore. Enhanced Enterprise Replication provides solutions for those customers requiring reliable and quick distribution of data across a global organization. The replicated data can also participate in the high availability environment with capabilities such as seamless online resynchronization of Enterprise Replication (ER) nodes at startup, for example. There is also enhanced capability for high-availability disaster recovery customers in the form of the ability to resend primary server indexes to HDR secondary servers without requiring a rebuild of the index on the primary server. These capabilities enable faster, easier, and reliable distribution and high availability of data, enabling improved access and use throughout the enterprise. For improved availability and data replication, you need IDS 11.
Informix Dynamic Server 11: Advanced Functionality for Modern BusinessIn this IBM Redbooks publication, we provide an overview of Informix Dynamic Server (IDS) 11. IDS is designed to help businesses leverage their existing information assets as they move into an on demand business environment. Requirements here call for a flexible data server that can accommodate growth, in applications, data volume, and numbers of users. And it offers the capability to minimize downtime and to provide the high availability required today. A new suite of business availability functionality provides greater flexibility and performance, automated statistical and performance metric gathering, improvements in administration, and reductions in operating costs. The IDS technology enables efficient use of existing hardware and software, including single and multiprocessor architectures. And it helps you keep up with technological growth, including such things as the use of nontraditional data types. Built on the IBM Informix Dynamic Scalable Architecture™ (DSA), IDS provides a next-generation parallel data server architecture that delivers mainframe-caliber scalability; manageability and performance; minimal operating system overhead; and automatic workload distribution. IDS delivers a lower total cost of ownership (TCO) by leveraging its well-regarded general ease of use and systems administration. It enables customers to use information in new and more efficient ways to create business advantage.
Informix Dynamic Server V10: Superior Data Replication for Availability and DistributionThis book provides an overview of the high availability and enterprise replication features of Informix Dynamic Server (IDS) Version 10, which can simplify and automate enterprise database deployment. Version 10 offers patent-pending technology that virtually eliminates downtime and automates many of the tasks associated with deploying mission-critical enterprise systems. The high availability capability can reduce or eliminate costly downtime through, as examples, the introduction of online index rebuild, the capability to create and drop indexes online without locking tables, and point-in-time table-level restore. Enhanced enterprise replication provides solutions for those customers requiring reliable and quick dissemination of data across a global organization. The replicated data can also participate in the high availability environment with capabilities such as seamless online resynchronization of enterprise replication nodes at startup, for example. There is also enhanced capability for high-availability disaster recovery customers in the form of the ability to resend primary server indexes to HDR secondary servers without requiring a rebuild of the index on the primary server. These significant and powerful capabilities can enable you to intelligently replicate (distribute) your enterprise data to improve the availability of that data to better service the requirements of your enterprise.
Use the Informix Dynamic Server scheduler and SQL APIWith the release of IBM IDS 11, a new set of highly anticipated features form the foundation for a self-managing RDBMS. These tools allow the DBA to collect server information and adjust the database server using SQL as a remote administration tool. Additionally, a scheduler allows those same SQL API commands to be scheduled for execution, much like a UNIX® cron job. IBM IDS further extends its value by adding reduced costs for administration and problem determination to its already lauded reputation as the administration-free database.
IDS CheetahLink to articles, tutorials, blogs, forums, and other resources to learn about IDS Cheetah, the next version of IBM Informix Dynamic Server.
Grant Hutchison hosted a webinar with Guy Bowerman earlier this week, but I'm not sure if it was recorded.... If someone knows, please post a comment.