Today I'm thinking about IDS... I just had a phone meeting with Ron Flannery and Paul Watson about a possible book. I'm also working with Carlton Doe on two new projects I'm pursuing a study guide for the new 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.
The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
Keep on Learning
From archive: December 2007 X
From reading this article Database Vendors Improve XML Handling it is clear that at least the database vendors are thinking about XML!
I've been thinking about XML as well. With my job, I try to anticipate learning needs and attempt to have books published in order to help specifically with these needs. Up till now, publishers are reluctant to sign on new XML books as they feel that the market is saturated with good books already, and nothing more is needed. According the publisher, "There must be a gazillion books on XML." One of the best sellers is XML for the World Wide Web, but this published in 2000... can it really be useful to someone who stores and accesses XML from a relational database? I assume that there is some overlap, but is this book sufficient?
When I was selling books in Athens, one of the best selling books was XML Demystified. Personally I think that the only reason we sold out of this book was because it was the only book we had that had XML prominently in the title!
Pat Selinger was our keynote speaker for the conference, and the two recommendations she made to the attendees was for them to learn XML and Content Manager. Immediately after her session ended, there was a line up of people at the bookstore looking for books on both of these topics. So, it wasn't a surprise to me that people went for the book with XML in the title even though some of the other books contained more relevant XML information for this audience.
Matthias Nicola, one of IBM's XML experts, did a quick review of several books regarding the XML content that they contained. For starters, he wasn't very impressed with the TOC of the Demystified book saying that much of it wasn't applicable or pertinent for a database user.
DB2 9 New Features, has limited coverage of DB2 pureXML but doesn't cover DB2 9.5 features. It has four chapters on XML: Chapter 1 is a general introduction to what XML is, and chapter 2 compares XML to relational, etc. That leaves chapter 3 for an introduction of some of the key concepts of DB2 pureXML, more like a overview. Chapter 3 gives you a basic understanding of pureXML and gets you started. Chapter 4 presents 11 performance guidelines.
DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep limits XML coverage to one chapter.
The soon-to-be-published book Understanding DB2: Learning Visually with Examples has about 90 pages covering XML. It spends the first 25 pages introducing XML, namespaces, XML schemas, comparing XML to relational, and discussing the old V8 options for managing XML. The remaining 65 pages are condensed but cover most of the relevant pureXML features, including 9.5 features. However, due to the limited length, this chapter does lack depth in some areas, such as XML updates, SQL/XML publishing, and others topics.
So... when I hear this analysis of the existing XML information, it leads me to believe that a book IS needed to help people learn what they need to know to store and access XML using DB2... and perhaps other databases as well. Let me know what you think. Should I fight for such a book to be published? I'd like to hear from you to know what you think.
Beyond published books, IBM has provided many articles and IBM Redbooks on XML, including:
DB2 9 pureXML GuideThis IBM Redbook discusses the pureXML data store, hybrid database design, and administration. It describes XML schemas, industry standards, and how to manage schemas. Also covered are SQL/XML, XQuery, and XPath using easy-to-understand examples. Lastly, the book shows how to use XML technology efficiently in business applications.
DB2 9: pureXML Overview and Fast StartThis IBM Redbook serves as an introduction to the hybrid XML data services in DB2 9 for Linux, UNIX, and Windows. It also provides data server professionals a fast start for using and exploring pureXML capabilities in DB2 9 and get them started with leveraging XML information for maximum return.
DeveloperWorks Articles including:
* A performance comparison of DB2 9 pureXML and CLOB or shredded XML storage * Get started with Industry Formats and Services with pureXML * Using industry standard data formats with WebSphere ESB and DB2 Version 9 pureXML * DB2 and Ruby on Rails, Part 2: DB2 and pureXML with Ruby on Rails * Document-level security using DB2 9 pureXML and LBAC* 15 best practices for pureXML performance in DB2 9 * Generate Web services for DB2 9 pureXML* XML data solutions with xfy and DB2 9, Part 1: Use pureXML to get the full value of your data * pureXML in DB2 9: Which way to query your XML data?
Now there is no better time to build your technical reference library of IBM Press books. Until December 31, 2007 you can save 35% off your order when you make a purchase at the IBM Press Bookstore. PLUS you can receive FREE ground shipping in the U.S. To take advantage of this special offer, simply visit the IBM Press Bookstore, select your books and enter case-sensitive coupon code SAVEDB2 at Step 3 during checkout.
Here are some titles that published this year that you may want to consider:
Understanding DB2 9 Securityby Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry ChanUnderstanding DB2 9 Security is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. Direct from a DB2 Security deployment expert and the IBM DB2 development team, this book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security.
Mining the Talk: Unlocking the Business Value in Unstructured Informationby Scott Spangler, Jeffrey Kreulen Written by IBM researchers, and describes, techniques used in research assets used internally at IBM and by IBM consultants on customer service engagements. IBM Alphaworks provides a free demonstration copy of one of the early text-mining tools called IBM Unstructured Information Modeler as an adjunct to this book.
DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prepby George Baklarz and Paul ZikopoulosEverything a DBA needs to know about DB2 9... from installation to XML to security.
Have you been checking out this latest gadget: Amazon Kindle? I must admit... I do love gadgets, but rarely buy them until the kinks are worked out and the price comes down. While the kinks are being worked out, I read whatever feedback is available from all the early adopters.
I usually have 3-5 books on the go at any one time... and it isn't very practical to carry a stack of books with me....so the Kindle appeals to me so that I can keep track of all the books I'm currently reading and perhaps I'll have a better chance of actually finishing them... rather than have the books fall into a huge unmanageable pile!
The first thing I don't like about the Kindle is it's name. In the past couple of weeks, I think I've butchered the name into kimble, wimble, and several other unmentionables! Do you think the next edition of this gadget could come up with a more suitable name?
I enjoyed reading this article Why Amazon's Kindle is such a revolutionary e-book reader by Mike Elgan. Mike says I've always been skeptical about e-books, but Amazon has made a believer -- and a customer -- out of me. and did an amazing job of describing the pros and cons of the Kindle and going deeper into details as to how the Kindle works.
I've been told that all IBM Press books are already in the right format to be used with the Kindle, and I assume that the DB2 books published by other publishers are ready as well. One of the things I'd like to look into for the new year is to have Kindles loaded with DB2 books available in some way.
It would be great to get one of these for Christmas, but I doubt that I'll be that lucky. I'll keep reading the reviews about this device and will save my pennies so I can perhaps get one in the future!
svisser1 2700018UK9 4,699 Views
Here are some of the IBM classes that were recently updated for the DB2 9 for z/OS platform:
DB2 9 for z/OS Programming Using JavaCG140 or CG14GAcquire the skills you need to produce application programs in Java that manipulate DB2 for z/OS databases. Also, learn how to take advantage of advanced programming techniques to access DB2 for z/OS database servers in the workstation environment. Emphasize using the Java Database Connectivity (JDBC) to connect DB2 from a Java program and embedding static SQL statements using SQL for Java (SQLJ). Also, learn how to write Java stored procedures from a remote station using the Development Center tool.
DB2 9 for z/OS Stored ProceduresCG730 or CG73GLearn how to recognize when an IBM stored procedure is the correct solution for an application. Also learn how to: * Set up the environment to support stored procedures * Use the DB2 Development Center * CALL a stored procedure * Create a stored procedure using Data Definition Language (DDL) * Troubleshoot a stored procedure This course is taught using classroom lectures and machine lab exercises. Your workstation is on a Windows platform. The database server is a DB2 for z/OS system. You utilize the facilities of the DB2 Development Center, create COBOL stored procedures, and troubleshoot stored procedures using the DB2 Development Center.
DB2 9 for z/OS Implementation WorkshopCV860This course is for installers of DB2 UDB for z/OS V8 and/or migration to DB2 9 for z/OS using the Install CLIST. You will be involved in lectures to understand DB2 UDB for z/OS and DB2 9 Components and pointer and the processes involved to install and or migrate DB2. To reinforce the lectures a series of labs are provided to give you hands-on experience installing DB2 UDB V8 and migrating to DB2 9 for z/OS.
PS.. I reposted this entry with corrected links.[Read More]
Are you aware of the IDUG Online Learning Center?
IDUG Learning Center offerings are download-on-demand streaming media files featuring original presenter audio synchronized with presentation slides, along with some audio only offerings. Using standard desktop controls within an Internet browser, users can pause, rewind, fast-forward, stop and resume sessions from the Learning Center at their convenience. Offerings from the IDUG Online Learning Center session can be viewed an unlimited number of times for three months from the date of purchase.
Select offerings from the Online Learning Center are available at no cost. For others, IDUG Membership is required to access. (Basic Membership in IDUG is free-of-charge, requiring only completion of our membership application.) The majority of Learning Center offerings are available at a cost of $5 per (USD) for Premier Members and $10 per for Basic Members. IDUG Premier Members also enjoy complimentary access to keynote presentations, spotlight sessions and panel discussions hosted in the Learning Center, while these sessions are available for a fee to Basic Members.
The IDUG Online Learning Center is a leading-edge resource to make technical education from IDUG events available anytime, anywhere through your Web browser. Experience the Learning Center with a free introductory sample of the Best User Presentation from IDUG 2007 - North America.
The IDUG Online Learning Center library features more than 220 in-depth sessions captured at IDUG 2007 - North America, which took place May 6-10 in San Jose, California, U.S.A. The sessions captured at IDUG Europe 2007 - Athens will be added to the library very soon.
Among the titles now available in the Learning Center are the following:
Session F13/G10: Magic of V8 RebindBonnie Baker, Bonnie Baker Corporation
Session F03: Hard Lesson Learned when OO Meets RelationalJohn Campbell, IBM DB2 for z/OS Development
Session F06: Put a Smile on Your DBA's Face - Performance for the Developer (and You Know It All DBA's)Rob Crane II and Marc Costa, FedEx Freight System
Session C02: Application Performance Tuning in DB2 9 for z/OSGene Fuh, IBM Silicon Valley Lab
Session E10/E11: A Sneak Peak at the Next Release of DB2 Linux, Unix and WindowsMatt Huras and Aamer Sachedina, IBM Toronto Lab
Session B08: Top 10 Ways to Waste CPUSusan Lawson and Daniel Luksetich, YL&A
Session A03: The Effect of Distribution and Correlation Statistics on the DB2 OptimizerTom Moulder, TREX Associates, Inc.
Session G06: More Ways to Challenge the DB2 z/OS OptimizerTerry Purcell, IBM Silicon Valley LabVoted Best Overall Presenter at IDUG 2007 - North America
Session B01: Availability Enhancements in DB2 for z/OSHaakon Roberts, IBM DB2 for z/OS DevelopmentBest attended session at IDUG 2007 - North America
Session J01: IBM DB2 Utilities: What's New in DB2 9 and Often Overlooked Features Before 9Bryan Smith, IBM Silicon Valley Lab
To commemorate the launch of this vital new resource and to encourage use of the Online Learning Center, IDUG is pleased to make the session voted Best User Presentation (as selected conference by attendees) available free-of-charge for a limited time. To access the file, simply click on the session title below:
DB2 9 for z/OS: John Deere's Early Ship Pilot (ESP) ExperiencePresenter: Bryan Paulsen, John Deere
IDUG invites you to benefit from this new, exciting program as we extend the organization's boundaries as the worldwide DB2 user community. Enjoy!
There are a couple more coming, but here is a list of the IBM Redbooks that you can read and benefit from right now.
High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windows
Informix Dynamic Server 11 Extending Availability and Replication
DB2 9 for z/OS Performance Topics
Dynamic Warehousing: Data Mining Made Easy
Index Compression with DB2 9 for z/OS
Informix Dynamic Server 11: Advanced Functionality for Modern Business
Database Partitioning, Table Partitioning, and MDC for DB2 9
Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows
Best Practices for SAP BI using DB2 9 for z/OS
Working with IBM Records Manager
SOA Solutions Using IBM Information Server
DB2 9 for z/OS Technical Overview
DB2 for z/OS Administration Tools for Enhanced Change Management
Getting Started with Commerce Module for OmniFind Discovery Edition Customization 101
IBM OmniFind Enterprise Edition Version 8.4 Configuration and Implementation Scenarios
Informix Dynamic Server V10: Superior Data Replication for Availability and Distribution
IBM Enterprise Content Management and DR550 for e-mail Archiving and Records Management, Management: Overview
DB2 9 pureXML Guide
As always, thanks to the talented and dedicated ITSO team that pulls these books together, and to the residents who take time off their job to write about something they hope is valuable to you the reader.
If you are interested in suggesting a topic for an IBM Redbook or wish to become a resident who writes part of the book, see this site: Residencies.
Do you want to buy a bound copy of one of these books? You can order one or more of them from this site: How to Buy.
Reader feedback is very valuable... so if you've read one or more of these books, make sure you come back to give other readers your opinion as to the books value.