SearchDataManagement.com and Roger Sanders are continuing their series of sample questions to help prepare people to pass Exam 730: DB2 9 Family Fundamentals.
Here is the latest in the series:
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions No. 5 and No. 6
Just a reminder that publisher MC Press is the first time publisher of DB2 Certification Study Guides and will have 5 in the series. One book was published earlier this year, three more will publish in the next month, and the fifth one will publish early next year. Here are the titles and the links:
DB2 9 Fundamentals Certification Study Guide (MC Press) by Roger Sanders. On Sale: $37.77
DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 (MC Press) by Susan Lawson and Dan Luksetich - October - On Sale: $40.92
DB2 9 Database Administration Certification Study Guide for Exam 731 (MC Press) by Roger Sanders - October. On Sale: $38.95
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 (MC Press) by Roger Sanders. On Sale: $24.95
The fifth one in the series is a group effort by Roger Sanders and Dwaine Snow and will cover the material you need to pass Exam 734: DB2 9 Advanced Database Administration. Roger tells me that he and Dwaine are nearly finished writing and will soon be able to get the book into editing, indexing, and all the other steps that are part of the book publishing process.
Keep on Learning
svisser1 2700018UK9 3,154 Views
I know that it is very difficult for some people to arrange to go to a conference at their company's expense. Even IBMers who are trying to attend an IBM conference, it can be challenging. It seems that the rule is to now have 2 presentations or more accepted at the conference. Maybe this is a requirement for many other companies as well. If it's tough to get approval if you volunteer to be a speaker at the conference, you can imagine how difficult it is to get approval to attend the conference to be educated.
A friend of mine suggested that we look into providing a scholarship to one or more people that would entail a free registration to the conference. I like the idea and will promote this idea for future conferences where I can. As I was thinking of this, I came across this news item:
Got 10 minutes? Enter the DB2 9 Compression ChallengeThe DB2 9 Compression Challenge is less than a month away from closing and we need your entry. There is no purchase necessary and it takes only 10 minutes to enter. You don’t need to be running any version of DB2 to participate. First Prize - Full-event registration to one of IDUG's 2008 events. Second Prize – Upgrade Membership for the same eventsIDUG 2008 - Australia (March 2008 in Sydney, Australia) IDUG 2008- North America (May 5-10, 2008, in Dallas, Texas) IDUG 2008 - Europe (Dates/Location TBD)
So a "scholarship" to attend an IDUG conference in 2008 is possible! All you have to do is to enter this challenge. My friend is working at a shop that isn't running DB2... yet, so I like the caveat that You don’t need to be running any version of DB2 to participate.
I hope this gives an opportunity to one or two people who have not been able to go to conferences... and would like to. Conferences are a great way to keep up to date on a large variety of related topics. It helps you network with people who can help you in many different ways. And, perhaps most obvious of all, going to a conference gives you an opportunity to earn several certifications.... normally the tests are $150 US, regardless if you pass or fail, so taking exams is a very easy way to justify attending a conference.
But, if you are still unable to go a conference, don't despair. IBM provides many learning opportunities that you can take part in, either for free or inexpensively. I'll use books as an example... see our Bookstore Page for links to excellent books that can be used for self-study.... and we try to point to the lowest cost provider of the books. The other book example is of course the IBM Redbooks. For free you can download PDF versions of technical books that are excellent references as well as self-study resources. DeveloperWorks is another example where you can find a variety of helpful technical documents... free of charge. As for classroom education, our new ILO offerings are an excellent way to take award-winning education, right at your desk.
We all know how important database security is -- no one wants to hear that their precious data was hacked or compromised in anyway. According to the article The Job of Securing the Database published on DATE: 21-SEP-2007 by Deborah Perelman, a Forrester Research study shows that DBAs are only able to spend 7% of their time ensuring that data is secure.
The worst message in the article is that DBAs are so overworked in their day to day duties that they are typically unable to spend more time on addressing security issues AND they are unlikely to have time to upgrade their skills in this area.
I have some good news for you if you are in this situation. Earlier this year, Rebecca Bond and three database security experts from the Toronto lab published a book about database security. The book, Understanding DB2 9 Security, is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. 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.
Those who have read the book have found it very beneficial. Buy the book... you won't be disappointed and you'll be able to quickly expand your knowledge of security issues. If you are one of the lucky DBAs who is attending the IBM IOD Conference, October 14 - 19, 2007 Mandalay Bay Resort, Las Vegas, you'll be able to buy this book at a 20% discount, and you'll be able to attend one or more of the following sessions related to DB2 Security:
BTC-2125 Secure Your Data before It Leaves Your Data CentersDr. Arvind Sathi, IBM, Associate Partner, IBM Global ServicesTUESDAY, 02:30–03:30PM— MBCC SOUTH: JASMINE AData security is a major concern in today’s virtual environment, where leakageof sensitive customer data could cause major economic and legal repercussions.At the same time, the need is growing to share this data withresellers, suppliers and outsourcers. This presentation discusses data maskingas a solution for protecting confidential data. Approaches to data maskingand related case studies are also discussed. ••
TLU-1033 A Sneak Peek at the Next Version of DB2 (in Two Parts)Matthew Huras, IBM, Distinguished EngineerWEDNESDAY, 09:30–10:30AM— MBCC NORTH: ISLANDER E;WEDNESDAY, 10:45–11:45AM— MBCC NORTH: ISLANDER EThis two-part presentation (consisting of two 60-minute sessions) providesan in-depth, behind-the-scenes, technical look at the features and capabilitiesof the next version of DB2® on Linux®, UNIX® and Windows® (the next versionafter DB2 9). Topics include new advancements in high availability, storagemanagement, concurrency, compression, backup and recovery, security, andperformance. Each topic includes key information about how to use the feature,its key internal design points, and expected best practices. ••
TDZ-1019 Best Practices in DB2 SecurityRoger Miller, IBM, DB2 for z/OS evangelistTUESDAY, 01:15–02:15PM— MBCC SOUTH: SOUTH SEAS G;FRIDAY, 09:30–10:30AM— MBCC SOUTH: SOUTH SEAS GSecurity is in the headlines and growing much more important. This sessiondiscusses various practices for security and how you can make improvements.We’ll include various security objectives. Most sites have a range ofneeds and objectives. For some situations, basic security is adequate. Forothers, better or standard security techniques are needed. In other cases,best security practices are demanded. Our tools range from very-tight systemsecurity to basic techniques. Application security techniques are moreflexible, but require much more work by more people, so they are generallyweaker. Choices and guidelines will be our primary points, discussing howto provide improved security for your situation. ••
TDZ-1346 A Deep Dive into the Mechanisms of DB2 9 for z/OS Security EnhancementsDave Romack, IBMTHURSDAY, 04:00–05:00PM— MBCC SOUTH: SOUTH SEAS IDB2® Version 9.1 for z/OS® added some significant security functionality toaddress key customer requests such as providing better access control fromapplication servers, removing object dependency from users, and audit ofSYSADM/DBADM users. This session contains detailed information aboutthese new functions and includes a discussion of where these functions canapply in your environment. ••
TOD-1159 Data Security for SOAErrol M. Back-Cunningham, IBM, IM ArchitectWEDNESDAY, 09:30–10:30AM— MBCC NORTH: TROPICS BData Security poses one of the biggest challenges to implementing a secure,auditable, end-to-end SOA environment. In this presentation, we will look atData Security standards, requirements, methods of implementing DataSecurity and the solutions and tools that IBM can provide in order to do so.We will cover Data and Service Classification Schemes, Audit Trails, IdentityManagement, Access Control and the ability to retrofit Data Security to SOAenvironments. ••
HOL-1959 Security and Label-Based Access Control (LBAC)Laura Hammond, IBM, Program Co-ordinator of "Ready for IBM DB2 data server software" validationTUESDAY, 01:15–04:15 PM— MBCC SOUTH: BREAKERS ALabel-based access control (LBAC) greatly increases the control you haveover who can access your data. LBAC lets you decide exactly who has writeaccess and who has read access to individual rows and individual columns.During this hands-on lab you will learn to: Grant the SECADM authority;Define components of various structures; Define a policy that includes multiplecomponents; Define labels; Grant labels to users; Grant exemptions tothe db2lbacrules to users; Protect a table with a policy; and, Protect columnsof a table. ••
HOL-2613 Database Security on LinuxSpencer Shimko, Tresys Technology, Senior Security EngineerTHURSDAY, 01:15–04:15 PM— MBCC SOUTH: BREAKERS E"Tresys Razor™ makes it economical to enhance the security of DB2 withSELinux. DB2 is a complex environment, but the components interact in apredictable manner. Tresys, partnered with IBM, analysed DB2 and created atightly confined SELinux policy that builds a “firewall” around each systemprocess. Tresys Razor protects the system from unexpected attacks on theapplication or other services running on the system.The management GUI is designed to be familiar to DB2 admins, allowing theSELinux configuration to be customized with no specialized knowledge ofSELinux. This lab session will discuss the benefits of SELinux in an enterpriseapplication environment, describe and provide a hands-on opportunityto use Tresys Razor for DB2. " ••[Read More]
Thanks to Susan Dykman for setting me straight on the details of the upgrade exams. I'm passing the information onto you so hopefully you'll have less confusions as to which exam you are to take to upgrade to the DB2 9 Database Administrator for Linux, UNIX, and Windows Certification.
IBM Information Management Certification offers many ways to become a certified DB2 9 Database Administrator for Linux, UNIX, and Windows, including an upgrade exam, Exam 736. However, to maintain the integrity of our industry-recognized certification program, restrictions on who is eligible to take this upgrade exam are necessary. These restrictions include:
• Individuals who took Exam 706 to upgrade from DB2 UDB V7 DBA certification to DB2 UDB V8 DBA certification are not eligible to take Exam 736.• Individuals who attained a DB2 UDB V8.1 DBA certification without taking exam 700 are not eligible to take Exam 736.• Individuals who hold a DB2 UDB V7 DBA certification and did not upgrade to V8 are not eligible to take Exam 736.
The following chart details the tests required to attain a DB2 9 DBA for Linux, UNIX, and Windows certification depending on previous exams taken and passed. Exams you've previously taken and passed: 512, 513 Certification earned: DB2 UDB v7.1 DBA Exams you must take to upgrade to DB2 9 DBA Certification: One of 700 or 730, and 731
Exams you've previously taken and passed: 512, 701 Certification earned: DB2 UDB v8.1 DBA Exams you must take to upgrade to DB2 9 DBA Certification: One of 700 or 730, and 731
Exams you've previously taken and passed: 700, 701 Certification earned: DB2 UDB v8.1 DBA Exams you must take to upgrade to DB2 9 DBA Certification: 736 (or exam 731)
Exams you've previously taken and passed: 512, 513, 706Certification earned: DB2 UDB v8.1 DBA Exams you must take to upgrade to DB2 9 DBA Certification: One of 700 or 730, and 731
Exams you've previously taken and passed: None Certification earned: None Exams you must take to upgrade to DB2 9 DBA Certification: 730, 731
• Exam 512: DB2 UDB V7.1 Family Fundamentals• Exam 513: DB2 UDB V7.1 for Linux, UNIX, and Windows Database Administration• Exam 700: DB2 UDB V8.1 Family Fundamentals• Exam 701: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration• Exam 706: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Upgrade• Exam 730: DB2 9 Fundamentals• Exam 731: DB2 9 DBA for Linux, UNIX and Windows• Exam 736: DB2 9 Database Administrator for Linux UNIX and Windows Upgrade
Here are a couple of new books that you may be interested in reading:
Reaching The Goal: How Managers Improve a Services Business Using Goldratt's Theory of Constraints by John Ricketts
Managing services is extremely challenging, and traditional “industrial” management techniques are no longer adequate. In Reaching the Goal, Dr. John Arthur Ricketts presents a breakthrough management approach that embraces what makes services different: their diversity, complexity, and unique distribution methods. Ricketts draws on Eli Goldratt’s Theory of Constraints (TOC), one of this generation’s most successful management methodologies...thoroughly adapting it to the needs of today’s professional, scientific, and technical services businesses. He reveals how to identify the surprising constraints that limit your organization’s performance, execute more effectively within those constraints, and then loosen or even eliminate them. This book’s relentlessly practical techniques reflect several years of advanced IBM research and consulting with enterprise clients. Step-by-step, Ricketts shows how to apply them throughout your most crucial business functions...from project management to finance, process improvement to sales and marketing.
Do It Wrong Quickly: How the Web Changes the Old Marketing Rules by Mike Moran
For decades, marketers have been taught to carefully plan ahead because “you must get it right–it’s too expensive to change.” But, in the age of the Web, you can know in hours whether your strategy’s working. Today, winners don’t get it right the first time: they start fast, change fast, and relentlessly optimize their way to success. They do it wrong quickly…then fix it, just as quickly! In this book, Internet marketing pioneer Mike Moran shows you how to do that–step-by-step and in detail. Drawing on his experience building ibm.com into one of the world’s most successful sites, Moran shows how to quickly transition from “plan then execute” to a non-stop cycle of refinement. You’ll master specific techniques for making the Web’s “two-way marketing conversation” work successfully, productively, and profitably. Next, Moran shows how to choose the right new marketing tools, craft them into an integrated strategy, and execute it…achieving unprecedented efficiency, accountability, speed, and results.
The links above go to amazon.com where excellent discounts are offered. The books may also be purchased at other bookstores / websites. For IBM employees, you may want to look at these sites:
IBM Learning Bookstore
IBM Learning Website with a link to Books 24x7
Both of these books are brand new, so be one of the first to read them and to comment on them. Word of mouth feedback drives the sales of books and can help make them best-sellers.
Have you had a chance to see any of these highly rated IBM Redbooks? Here are the most popular downloads, along with a reader comment about each book:
Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows"It's very useful to reference, most of all, the features between DB2 and Oracle."
DB2 9 pureXML Guide "This is a great book! Why don't you attach it to or recommend it when someone purchases DB2 Express-C."
Working with IBM Records Manager"Very informative! I never knew that there were so many record management standards and industry specific legal requirements."
svisser1 2700018UK9 2,790 Views
Building an Intelligent Web: Theory and Practice will be available in October. The book is intended to be a textbook, so the price is higher than other books that I mention.
Here are the details:
The World Wide Web has become an extremely popular way of publishing and distributing electronic resources. Though the Web is rich with information, collecting and making sense of this data is difficult because it is rather unorganized. Building an Intelligent Web introduces students and professionals to the state-of-the art development of Web Intelligence techniques and teaches how to apply these techniques to develop the next generation of intelligent Web sites. Each chapter contains theoretical bases, which are also illustrated with the help of simple numeric examples, followed by practical implementation. Students will find Building an Intelligent Web to be an active and exciting introduction to advanced Web mining topics.
Topics covered include Web Intelligence, Information Retrieval, Semantic Web, Classification and Association Rules, SQL, Database Theory, Applications to e-commerce and Bioinformatics, Clustering, Modeling Web Topology, and much more!
Includes IBM DB2 Express-C, a data server used in the development and deployment of applications including: XML, C/C++, Java, .NET, PHP, and more.
If you are a professor or curriculum developer, request a sample copy from the publisher. We're very pleased that the authors and publisher of this book decided to include DB2 Express-C on the CD that is shipped with the book. Most publishers are reluctant to ship CDs with their books any longer, but it can be very important, especially for students.
svisser1 2700018UK9 3,021 Views
I've recently read the following articles about the pressure IT people have to continuously upgrade their skills in order to remain employable and valuable to their employers:
IT Workers Battle to Keep Skills CurrentDATE: 04-SEP-2007By Deborah Perelman
Back To School: Funding An Ongoing EducationSeptember 2007 - Daniel Margolis New instructor-led online (ILO) training
My team, WW Data Servers Education & Enablement, is either directly or indirectly involved in the creation of many of the training resources that are available to you in the Data Servers area. Our mission is to establish Education as a business driver for our customer’s and partner’s success. We do this by offering you a variety of ways for you to develop your skills, either as a first time user of database products, or as an established expert who wishes to stay abreast of key changes. Here are some of the things that we offer:
* IBM Training- traditional classroom educationOur excellent instructors, high quality materials and hands-on labs combine for an experience that keeps students coming back. In fact, according to our after-class surveys 93% of our students say they will come back to IBM for more training and 97% are extremely satisfied with their instructor.
Here are some of the courses you may want to consider:DB2 9 for z/OS Application Performance and Tuning (CV960)DB2 9 for z/OS Transition Workshop (CV300)DB2 9 for LUW Advanced Database Recovery (CF492)DB2 9 for LUW Multiple Partition DBA Workshop (CF242)DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs (CG242)
- instructor-led online (ILO) educationILO courses are taught by a live instructor on a specific date and time. These courses are exactly the same as their classroom equivalent, including the course length, content and student materials. Students receive their course materials in advance by mail. To participate on the day of the class, all you need is a high-speed Internet connection. This allows you to connect to a virtual classroom enabling you to interact directly with the instructor to ask questions or clarify material...just as you would in a physical classroom.
Here are some of the courses you may want to consider:DB2 9 Database Administration Workshop for UNIX - Instructor Led Online (3L210)DB2 9 Database Administration Workshop for Windows - Instructor Led Online (3L230)DB2 9 for LUW Quickstart for Experienced Relational DBAs - Instructor Led Online (3L480)DB2 for z/OS Data Sharing Implementation - Instructor Led Online (3V210)DB2 UDB for z/OS Data Sharing Recovery and Restart - Instructor Led Online (3V920)
* CertificationEarning a certification from IBM is a way for you to demonstrate your expertise to the world. It validates your skills and demonstrates your proficiency in the latest IBM technology and solutions. The certification requirements are tough, but it's not rocket science, either. It's a rigorous process that differentiates you from everyone else.
Here are some of the exams that you may want to consider:
Exam 730: DB2 9 FundamentalsExam 731: DB2 9 DBA for Linux UNIX and WindowsExam 732: DB2 9 DBA for z/OSExam 733: DB2 9 Application DeveloperExam 734: DB2 9 Advanced Database Administrator for Linux UNIX and WindowsExam 736: DB2 9 Database Administrator for Linux UNIX and Windows Upgrade
* BooksBooks are wonderful resources to both build and refresh skills. They provide a wonderful opportunity for self-paced learning while becoming a handy reference guide for use on-the-job. IBM offers many great resources to build your library of technical and business skills - two of which are IBM Retail Books and IBM Redbooks.
- Retail books about IBM products are technologies are growing in number. Hopefully you are able to find some in physical bookstores or when searching online bookstores. For a complete list of those available for Information Management, see Information Management Retail books.
Here are some you may want to consider:Understanding DB2 9 Security (IBM Press) by Rebecca Bond, Kevin Yeung-Kuen See (IBM), Carmen Ka Man Wong (IBM), Yuk-Kuen Henry Chan (IBM).
IBM DB2 9 New Features (McGraw-Hill) by Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton (all IBM)
DB2 9 Fundamentals Certification Study Guide (MC Press) by Roger Sanders
DB2 9 for Linux, Unix, and Windows: DBA Guide, Reference and Exam Prep (IBM Press) by George Baklarz (Author), Bill Wong (Author), Paul C. Zikopoulos (Author)- Sixth Edition of our most popular book EVER!
DB2 for Developers (MC Press) by Phil Gunning - expected in December.... SPECIAL 37% PRE-ORDER DISCOUNT!
DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 (MC Press) by Susan Lawson and Dan Luksetich - October - SPECIAL 30% DISCOUNT ON PRE-ORDERS!
DB2 9 Database Administration Certification Study Guide for Exam 731 (MC Press) by Roger Sanders - October
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 (MC Press) by Roger Sanders
- IBM Redbooks are well-known to long time IBM customers, but if they are new to you, essential IBM Redbooks are developed and published by the IBM International Technical Support Organization, ITSO. The ITSO develops and delivers skills, technical know-how, and materials to IBM technical professionals, Business Partners, clients, and the marketplace in general. Most people read IBM Redbooks electronically or by printing out sections of the PDF files that may be downloaded, but did you know that you can also order a printed copy? It is called Print on Demand.
Some that you may want to consider: DB2 9 for z/OS Performance TopicsDatabase Partitioning, Table Partitioning, and MDC for DB2 9Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows
* Tutorials and articlesAlthough you should be able to find tutorials and articles about DB2 in many locations, we focus on ensuring that the DB2 portal of developerWorks is kept up to date with a variety of learning materials.
Here are some you may want to consider:DB2 9 Fundamentals certification 730 prep seriesDB2 9 Database administration 731 certification prep seriesDB2 9 Application Development 733 certification prep series
If my team doesn't create it, we still try to promote it.... like conferences, newsletters, podcasts, etc. If you have some education that you'd like me to know about, make a comment.
I hope that you're able to find something in this list of options to help you keep your skills current!
Two more books by Roger Sanders are ready to preorder and will ship in October! If you are going to be at the IOD conference, you'll also have an opportunity to buy the book at the bookstore onsite. Your choice!
Expert Preparation for Exam 731: DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study GuideAuthor: Roger E. SandersPrice: $64.95On Sale: $38.95
Roger E. Sanders—one of the world's leading DB2 authors and an active participant in the development of IBM's DB2 certification exams—covers everything a reader needs to know to pass the DB2 9 DBA Certification exam (Exam 731). This comprehensive study guide steps you through all of the topics that are covered on the test, including Server Management, Data Placement, Database Access, Analyzing DB2 Activity, DB2 Utilities, High Availability, Security, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.
Taking and passing the DB2 9 UDB DBA Certification exam (Exam 731) provides validation that you have mastered the next level of DB2 9. Passing this exam also earns you the IBM Certified Database Administrator certification.
The book includes sample questions in each chapter and a complete practice test of 150 questions that closely models the actual exam along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in passing the exam.
Expert Preparation for Exam 736: DB2 9 for Linux, UNIX, and Windows Database Administration Certification Upgrade Exam Study GuideAuthor: Roger E. SandersPrice: $34.95On Sale: $24.95
Roger covers everything a reader needs to know to pass the short—but notoriously challenging—DB2 9 for LUW DBA Certification Upgrade exam (Exam 736).
This specialized study guide steps you through all of the topics that are covered on the exam, including server management, data placement, XML concepts, activity analysis, high availability, database security, and much more. Everything new to DB2 9 that you will need to know in order to successfully pass the exam is covered in this book.
Taking and passing the DB2 9 for LUW DBA Upgrade Certification exam (Exam 736) provides validation that you have mastered DB2 9. Passing this exam also earns you the IBM Certified Database Administrator certification.
This concentrated guide includes an extensive set of practice questions in each chapter that closely model the actual exam, along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in passing the exam.
Most of the work-related blogs that I read these days are found on PlanetDB2.com. I must say that Willie Favero's blog entries are quite entertaining... as well as informative. His entry yesterday was about a series of 4 new IBM commercials that were recently launched. Since I rarely watch TV these days, I had Willie give me the URL so I could watch them. They are entertaining!
The overall message is that IBM can help other people / companies win at innovation, so "Stop Talking, Start Doing".
The URL that I have is on an internal IBM website... so for IBMers, here are the four commercials. For the rest of you... try watching more TV to see these ads! I'll post them here if I find them on an external site.
Message: Talking about innovation is great. A manager giving a presentation quickly discovers that doing innovation is better.
Message: There’s nothing wrong with “ideating” a few “out-of-the-box” ideas. But if that’s all you’re doing to innovate, then, well...“good luck,” as one astute businessman puts it.
Message: A business guy is tasked with “firing up” the troops for innovation. Innovation is good. But what about implementation?
Message: A company embraces the trappings of innovation. They create a special room where people can come to innovate. Now what?
A total of 19 Technical Education sessions are being offered at the IOD conference on Sunday October 14 in Las Vegas. The sessions are spread across the following segments:
Information Platform & Solutions (3)Enterprise Content Management (3)Data Servers (12)Support (1)
The fee for these classes is set at $399.00 which is the same price as offered at last year's conference.
I've listed most of the available sessions in this entry. Click on the link to see the list and to register for the class.
Successfully Transitioning with DB2 9 for z/OSConsidering an implementation of DB2 9 for z/OS? Then you won't want to miss this 1-day course. Designed to provide you with technical information on the new features, you'll learn what's required for a successful implementation. 9:00 AM / 4:30 PM Mark Wilson
Spotlight on IDS 11 - Transition TopicsThe newest addition to the Informix Dynamic Server family, IDS 11 boasts a wealth of new functions and features. This 1-day course will take a deep dive into the technical information behind these features, providing a better understanding of and ensuring a smooth transition to this new product. 9:00 AM / 4:30 PM Jeff Bohm**
DB2 9 for Linux, UNIX, and Windows DBA Certification Crammer (Exam 731)This high level certification preparation review is intended to help you take IBM Certification Test 731. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Bob Schwan **
DB2 9 for z/OS DBA Certification Crammer (Exam 732) This high level certification preparation review is intended to help you take IBM Certification Test 732. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Susan Lawson
DB2 9 Fundamentals Certification Crammer (Exam 730) This high level certification preparation review is intended to help you take IBM Certification Test 730. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Roger Archambault **
Getting to Know DB2 WarehouseThis 1-day course is a must for those wanting to understand the components of DB2 Warehouse. Topics for the class include an overview on the SQL Warehouse Tool, DB2 Intelligent Miner, Cube Views, and their common interface, the Design Studio. 9:00 AM / 4:30 PM Warren Pettit
Preparation is Key: DB2 9 for Linux, UNIX, and Windows Advanced Recovery TopicsRecovery is top of mind for many businesses today. In this 1-day lecture you'll gain a deeper understanding of how DB2 9 for Linux, UNIX, and Windows addresses the issue with its many advanced recovery features. Topics may include recovery log management, dropped table recovery, table space recovery, crash recovery, disaster recovery, incremental backup & recovery, redirected restore, and additional recovery facilities. 9:00 AM / 4:30 PM Melanie Stopfer**
Unleash the Knowledge: An Introduction to Data Sharing Learn the basic purpose, justification, and planning considerations for employing DB2 data sharing in your enterprise IT system. This 1-day class will also cover the basic knowledge of the architecture and major components of DB2 data sharing and provide an overview of the steps to implement a DB2 data sharing environment. 9:00 AM / 4:30 PM Wayne Cope
Informix Dynamic Server System Administration - A Beginner's LookThis 1-day class will enable you to develop the skills necessary to successfully administer one or more database servers. You will learn how to configure and initialize a database server instance, configure and test client connectivity, configure and manage memory and disk usage, plan and implement system maintenance tasks, and configure the server for optimal Online Transaction Processing (OLTP) or decision support. 9:00 AM / 4:30 PM John Zucchero
Maximize Your Optimizer: A Guide to DB2 9 for Linux, UNIX, and Windows OptimizerThis 1-day class will enable users to understand optimizer's decision making process, influence optimizer decisions, identify problems from optimizer access plans and most importantly, fix them. By the end of this 1-day course, participants should be able to leverage fully DB2 optimizer for best query performance. 9:00 AM / 4:30 PM Yasir Warraich
Architecting the Dynamic Warehouse - a How to Guide Are you interested in dynamic warehouses but don't know the first thing about how to build one? This 1-day class is your answer. The course offers practical methods and techniques for designing and constructing a dynamic warehouse. Whether you intend to create one or just want to learn more, this class will broaden your understanding of the data warehouse 9:00 AM / 4:30 PM Joe Cullen
Behind the XML Buzz: Querying & Using XML with DB2 9Much noise has been made about the XML features in DB2 9 and this 1-day class will show you why. The course introduces participants to XML found in DB2 9 for LUW and provides a lightening tour of the fundamentals. From XPath/XQuery to defining/building indexes on XML data to sophisticated queries using combinations of SQL and XML data, you won't want to miss this engaging look at one of DB2 9's most popular components. 9:00 AM / 4:30 PM Glen Mules
None of the sessions are full at this point, but demand is increasing. If you are interested in attending one of these sessions, be sure to register soon.
svisser1 2700018UK9 2,784 Views
Every now and again, it is useful to have a list of valuable links..... Here is a list that I was quickly able to put together.
* IBM DB2 product support on-line
* For IBM DB2 Version 9 product documentation (HTML)
* For IBM DB2 Version 9 product documentation (PDF)
* DB2 9 Home Page
* Information Management Training and Certification – Certification, training, retail books, offers, and more
* DB2 9 Information Center
* DB2 9 Support Home Page
* DB2 9 Manuals and Documentation
* The DB2ZONE
* Blog on DB2 LUW
* IDUG DB2-L Listserver
* IBM developerWorks - DB2 portal
* LAZYDBA Listserver
* comp.databases.ibm-db2 Google Newsgroup
* IBM Redbooks
* Planet DB2 - a blog aggregator that combines DB2 blogs from around the world.
* IDUG – International DB2 User’s Group
* DB2 Magazine Online
I hope you find it useful. If there are other links that you'd like me to be aware of, make a comment. We often use these links as part of promoting our skills resources.
IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology was written by one of the industry's foremost authorities on IDS 11, Carlton Doe. The availability of this book is very limited... but one way you can guarantee yourself a copy is through our latest promotion.
Attend one of the following IDS classes between now and December 31, 2007 you will receive a copy of this book:
IBM Informix Stored Procedures and Triggers (FN335)IBM Informix Structured Query Language (FN613)IBM Informix Advanced Structured Query Language (FN757)Managing and Optimizing IBM Informix Dynamic Server Databases (FN848)IBM Informix Dynamic Server Administration (L1846)IBM Informix Dynamic Server Enterprise Replication (L2615)Troubleshooting IBM Informix Dynamic Server (L2880)Informix Dynamic Server 11 Systems Administration (IX810)Informix Dynamic Server 11 Database Administration: Managing and Optimizing Data (IX220)Informix Dynamic Server 11 Replication (IX420)IBM Informix Dynamic Server Advanced Performance Tuning (MW729)
For detailed information, visit our offer page.
PS... the book has proven to be extremely popular, so clearly there is a need for new books on IDS!
svisser1 2700018UK9 2,749 Views
The August edition of the DB2 Magazine Newsletter came out today and I learned about this challenge that IDUG is running... IBM is sponsoring:
Introducing the DB2 9 Deep Compression Challenge
Based on feedback from early users, Deep Compression is a hugely-popular feature of DB2 9 for Linux/UNIX/Windows, IBM's latest data server. To highlight this feature, the International DB2 Users Group (IDUG®) is pleased to announce the IDUG DB2 9 Deep Compression Challenge, a non-competitive industry-wide competition aimed at highlighting the storage optimization benefits - costs savings, in particular- users can achieve with the Deep Compression feature available in DB2 9 for Linux, UNIX and Windows.
For details see the August edition of the DB2 Magazine Newsletter and the description of the IDUG DB2 9 Deep Compression Challenge.
Use the new developerWorks tutorial created by Eric Johnson to learn how to debug SQL stored procedures using Visual Studio 2005.
Title: IBM Database Add-Ins for Visual Studio 2005, Part 2: Deploy, debug, and correct your SQL stored procedures
Follow steps to deploy, debug, and correct SQL stored procedures using IBM® Database Add-ins for Visual Studio 2005.
In this tutorial
* Create a stored procedure that updates the salaries in the EMPLOYEE table of the sample database.* Use the major features of the SQL stored procedure debugger.
* Use the SQL stored procedure debugging features to test SQL stored procedures, and to find and fix problems in them.* Learn about the features of debugging SQL stored procedures when run from Visual Studio 2005.
This tutorial is written for DB2® SQL PL programmers. Familiarity with DB2 SQL PL is assumed.
General familiarity with the IBM Database Add-ins for Visual Studio 2005 is also assumed. To become more familiar with the general features of the IBM Database Add-ins for Visual Studio, see Overview of IBM Database Add-ins for Visual Studio 2005 and the Develop proof-of-concepts .NET applications tutorial series.
System requirements To complete this tutorial, you need a DB2 9 database server. You also need to have the DB2 server or client installed on a workstation with Microsoft Visual Studio 2005 and Version 9 fix pack 2 (FP2) or later of the IBM Database Add-ins for Visual Studio 2005. Finally, you need the sample database that comes with the DB2 database server.