Were you one of the very happy readers of the first edition of this book? If you check this book out on amazon.com... you'll see that the first edition of the book had 17 extremely positive reviews of the book. People liked the way the material was presented in a graphical, visual way... the case studies.... and the review questions. On top of that, the authors know there stuff and spend much of their working life talking to customers and helping them understand how to use the product and the benefits each feature is likely to bring.
From the publisher:
Understanding DB2, Second EditionBy Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
IBM DB2 9 and DB2 9.5 provide breakthrough capabilities forproviding Information on Demand, implementing Web servicesand Service Oriented Architecture, and streamlininginformation management. Understanding DB2: Learning Visuallywith Examples, Second Edition, is the easiest way to masterthe latest versions of DB2 and apply their full power toyour business challenges.
Written by four IBM DB2 experts, this book introduces keyconcepts with dozens of examples drawn from the authors'experience working with DB2 in enterprise environments.Thoroughly updated for DB2 9.5, it covers new innovationsranging from manageability to performance and XML support toAPI integration. Each concept is presented witheasy-to-understand screenshots, diagrams, charts, andtables. This book is for everyone who works with DB2:database administrators, system administrators, developers,and consultants. With hundreds of well-designed reviewquestions and answers, it will also help professionalsprepare for the IBM DB2 Certification Exams 730, 731, or736.
Special Offer: Use the Coupon Code for this bookdescription to receive a 35% discount (coupon codes are casesensitive). Plus, FREE shipping in the US for every order.Coupon Code: CHONG0183
THANKS and CONGRATULATIONS to the author team! Another fantastic job![Read More]
Keep on Learning
I have been blog tagged by Willie Favero. Don't worry, its not as painful as it sounds!
Basically, blog-tagging is a game, of sorts, that has been crawling its way through the blogosphere for awhile now. The way it works, when you are tagged by another blogger, you have to write a blog posting about yourself, with 8 things that others might not know. . . and then tag 8 other bloggers.
So here goes:
1. I grew up in a very large family.... I'm the 4th of 8 kids; my mom is the oldest of 13 kids, and my dad is the oldest of 9. I have hundreds of cousins.... many of whom I don't know very well; when my maternal grandma died last year, it was noted that she was the mother of 13, grandmother of 47 and great-grandma of 61 (and counting)! Much of my personality, and therefore of my life experiences are as a result of being part of a very large family.
2. My parents were raised in Europe (dad from Holland, mom from Belgium) and met in Canada when both families immigrated in the 50s. Many of the people living in the Stratford / Kitchener / London area were Dutch, Belgian, German, etc, so I grew up with many European customs and therefore feel very comfortable when visiting Europe.
3. I love dogs! My first dog as an adult was a yellow lab named Ginger. She died at 12 of bone cancer. Zoe is a 3 year old Giant Poo (golden retriever / standard poodle mix, actually called Labradoodle or Golden Poo, but I call her Giant Poo... since, well, she's giant compared to most dogs). I recently got a kitten... my first as an adult, and she's now 5 months old and she and Zoe get along famously. Hard to believe given the size difference, but I'm not kidding.
4. I have a 9-year old son who is gifted and and gorgeous! He's in a french school to ensure that he stays challenged in his school work and I'm about to volunteer to help enrich the education of my son and a few other gifted kids from his school. I'm thinking of teaching them to create a custom book through lulu.com or blurb.com, maybe the DB2 Detective game, tips on searching google, and a few other things. If you have suggestions, let me know!
5. I graduated from University of Waterloo and have worked at IBM my entire career (more than 18 years now)! I had a Mac in school, so didn't think I'd fit into IBM this long, but I have... and must say that I absolutely love my job!
6. I've written one book on my own, updated it with a co-author, but have helped publish 50 other books.
7. I thrive on learning... and to prove it, here are a few things that I've learned in the past 2 years: how to drive a standard, how to set up a wireless network, how to drive a seadoo, how to drive an ATV, how to ski, how to appreciate wine, and how to be alone!
8. I love to cycle, but don't do it often enough! My preference is to go on cycling trips in foreign countries. So far I've cycled in the following countries: Portugal, Spain, Italy, and am planning a cycling trip in Holland and Belgium for the spring.
I didn't think I'd get 8 points, but I did! And I didn't even get a chance to say that I love photography, reading and music as well!
OK, I guess that means I now have to tag eight others, but I can only come up with 5! So I'll tag Jeff Jonas, Chris Anderson, Leon Katsnelson, Grant Hutchison , and Ellice Uffer.You folks are now "it"...[Read More]
The IBM Education Pack can be used to attend IBM Technical conferences, such as
Lotusphere 2008 - Orlando, Florida, USAImpact 2008 - Las Vegas, NVAutomated Operations Technical Council - New Orleans, Louisiana, USAIBM Pulse 2008 (a new Tivoli Technical User Conference) - Orlando, Florida, USAIBM Rational Software Development Conference 2008 - Orlando, Florida, USAIBM System System Storage and Storage Networking Symposium - San Diego, California, USAIBM System x & BladeCenter Technical Conference - San Diego, California, USAIBM System z Expo - Las Vegas, Nevada, USAIBM Information On Demand 2008 - Las Vegas, Nevada, USA
IBM Education Pack - online account overview
The IBM Education Pack - online account is an electronic debit system which you fund and use to pay for designated IBM Training offerings. It is ideal for companies that need to train multiple employees on limited budgets.
Q: What is the Education Pack – online account? A: The IBM Education Pack – online account is a convenient way for customers to purchase IBM Training offerings. The Education Pack – online account an electronic account that you can use to purchase IBM Training’s public or onsite class offerings and IBM Technical Conferences in the U.S. You may also purchase IBM Self-Paced Virtual Classes with this account. Q: How does it work? A: The IBM Education Pack – online account functions as an electronic debit account, funded with training dollars you designate for IBM Training offerings. The account can be funded in values of $2,500, $5,000, $10,000,$15,000 and $25,000. The account can also be funded in precise $100 increments with a minimum $1,000 account value. Q: What discounts do I get when I purchase my account in $100 increments? A: When you purchase training with the IBM Education Pack – online account in $100 increment , you receive a discount of up to 10% off the retail cost of IBM training. You receive:
· Values of $1,000-$4,900 at $95 per increment (5% discount)· Values of $5,000-$9,900 at $92 per increment (8% discount)· Values of $10,000 or more at $90 per increment (10% discount) Q: What is the minimum IBM Education Pack -online account I can purchase? A: A minimum $1,000 value IBM Education Pack - online account is required to receive a discount. Q: How do the IBM Education Pack - online account pre-set values save me money? A: When you purchase training with the IBM Education Pack – online account, you receive a discount of up to 10% off the retail cost of IBM training. You receive:
· $2,500 value for retail price of $2,375· $5,000 value for retail price of $4,595· $10,000 value for retail price of $8,995· $15,000 value for retail price of $13,500· $25,000 value for retail price of $22,500 Q: Can the IBM Education Pack – online account be used by more than one person in my company? A: Yes. The funds in the account can be used to purchase training from IBM for any employee in the company. Q: How do I purchase an IBM Education Pack – online account? A: There are two ways to purchase an IBM Education Pack – online account:
· On the IBM Training Web site, or· Through your authorized IBM Business Partner Q: When does the IBM Education Pack – online account start and expire? A: Your account is activated the day IBM Training receives the application and billing information, unless an alternate start date is provided at the time the application is submitted. A start date of up to 60 days from the date of the application may be selected if indicated on the order form. The IBM Education Pack – online account will expire 12 months from the activation date. Q: What denominations can I use from my IBM Education Pack – online account? A: That’s one of the great features of the IBM Education Pack - online account! It’s not limited by specific denominations. The IBM Education Pack – online account lets you debit your account with a voucher for the exact amount of training dollars that you want to spend. Q: What is an IBM Education Pack – online account voucher? A: The IBM Education Pack – online account voucher is your online transaction record that is applied against your purchase. Q: Do I have to take the IBM Education Pack – online account voucher with me to class? A: No. You create and submit an online voucher to IBM through your IBM Education Pack – online account.
Special OfferFrom October 9, 2007 – February 15, 2008, save up to $10,000!
Now, during our score more savings event, when you purchase $25,000 worth of training in an IBM Education Pack – online account, you pay only $22,500 and receive an additional $2,000 worth of training posted to your account. That’s $27,000 worth of training for just $22,500!
When you purchase $50,000 worth of training for just $45,000, you’ll also score an extra $5,000 in training dollars! That’s $55,000 worth of training for just $45,000!
Susan PS. Be sure to check out PlanetDB2.com if you haven't already done so.[Read More]
Ten years ago when I wrote my first book, I didn't have very much guidance or people who I could approach who could help me with the many questions I had. Now that I'm on the other side and have the job to help people get technical books published, I'm hoping that new authors have a radically different experience than I did.
Last year I was involved in having 14 new books published, so in terms of credentials and experience, I continue to build on both each day. In terms of online information to help interested authors get started, I'd recommend the following sites that were created by my IBM Press colleagues Tara Woodman and Ellice Uffer:
Blog by Ellice that covers various publishing-related topics.Website maintained by Tara that covers the procedures for getting a book published via IBM Press.
If you've read my blog occasionally, you may have noticed that I do post some information regarding how to get published (including this entry) but I also present to internal audiences to give them guidance as well. I'll continue to post tips for authoring in this blog, but if you have specific questions, please contact me directly.
Pre-order the latest book by Phil Gunning and receive a 40% discount! Book to ship in February.
DB2 for Developersby Phil Gunning
Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database.
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.
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 3,167 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!