Keep on Learning
Not only is tomorrow the first online community day, but it is also the launch of the "Search for the XML Superstar" contest. Show the world how great your XML skills are!
There are five categories in the contest: 1) XML application programming2) ported applications3) database gadgets4) videos5) query challenge
Contestants will participate in a combination of education, exposure to practical applications and “tests” that will validate understanding and ability to program IBM database technologies. Entries will be judged by an independent panel of DB2 professionals.
Participants in the contest will be eligible to win one of a series of great prizes, including:
* an all-expense paid trip to an IDUG conference* a Segway i2 personal transport system* a new laptop* an iPod* a Sony PlayStation 3 * a Nintendo Wii system
Don't miss this amazing opportunity to build your resume, to gain recognition from world-class consultants and be celebrated for standing out among your peers.
Thanks to Bob Bernard for providing this comprehensive list of Data Studio websites that I can pass on to you.
First of all, what is Data Studio?
Data Studio provides a comprehensive suite of integrated tools for development database administrators and application developers. The tooling for each of these roles is essentially divided between two main views in the Data Perspective: the Data Project Explorer, and the Database Explorer. There are also features to help team members share resources.
The IBM Data Studio Information Center introduces IBM Data Studio and the underlying workbench technology, and explains how to use its integrated development environment to achieve your database development goals. For information about related products, visit the related product information links within the Information Center.
The Data Studio forum is ideal to engage in discussions related to the use of IBM Data Studio. The latest release is V1.1.2. This forum also contain discussions on previous releases, V1.1.1 and V1.1(also known as DB2 Developer Workbench 9.5 during its open beta), and DB2 Developer Workbench 9.1.
Articles and Papers
* DB2 Viper II and the IBM Data Studio Developer Workbench by Paul Zikopoulos, October 19, 2007
* IBM Beefs Up Data Studio by P. J. Connolly, January 15, 2008
* Data Web Services: Build Web services the new way to access IBM database servers by Vijay Bommireddipalli, December 6, 2007
* The Easy Way to Quick Data Access by Rafael A. Coss, Stephen A. Brodsky, and Vijay BommireddipalliIBM takes the drudgery out of JDBC programming with pureQuery, an integrated language that queries relational databases as well as Java collections and database caches. pureQuery and Data Web Services are components of the new IBM Data Studio, a new common database application development and administration platform.
* Web service development and deployment with Informix Dynamic Server and IBM Data Studio by Shweta Sinha, Prasanna Alur Mathada, and Amitava ChakrabortyIBM Data Studio brings Informix Dynamic Server (IDS) developers the latest in Web services technology. Learn how this new set of tools makes it easy to design, develop, deploy, and manage your IDS applications. Get started with Web services development using the latest methodology, and also learn how you can simulate a Web service response by converting it to presentable HTML format.
* Introduction to IBM Data Studio, Part 1: Get started with IBM Data Studio, Version 1.1.0 and Eclipse by Debra R. Eaton
* Understanding pureQuery, Part 2: Assist class modelers with data modeling by Azadeh AhadianLearn how the features of pureQuery can assist you as an object-oriented developer to define a set of database relational artifacts using traditional class modeling.
You can download the warranted or unwarranted version of IBM Data Studio and take part in the Data Studio Community on developerWorks.
Join Hans Miseur and others on the LinkedIn group IDUG Europe 2009 to discuss plans for next year's IDUG conference in Rome.
The current question is regarding whether people are interested in attending a crammer course for Exam 737: DB2 9 System Administration for z/OS. The exam is really new... here are the objectives of the exam:
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, and tune secure DB2 for z/OS environments.
Section 1 - Installation and Migration (15%)
1. Given a scenario, demonstrate knowledge of the installation/migration plan process2. Given a scenario, describe how to execute the installation/migration plan3. Evaluate appropriate DSNZPARM settings
Section 2 - Security and Auditing (7%)
1. Given a scenario, demonstrate knowledge of how to protect DB2 subsystem and resources2. Describe auditing techniques3. Describe role-based security and the advantage of deploying it
Section 3 - System Operation and Maintenance (21.5%)
1. Describe how to use and manage DB2 components and processes2. Demonstrate knowledge of DB2 commands3. Given a scenario, describe how to monitor an dcontrol DB2 threads4. Demonstrate knowledge of DB2 commands
Section 4 - Backup and Recovery (20%)
1. Demonstrate knowledge of system level backup and recovery procedures2. Given a scenario, describe how to recover from system failures3. Describe the process for disaster recovery
Section 5 - Performance and Tuning (21.5%)
1. Given a scenario, analyze performance2. Demonstrate knowledge of how buffer pools and ZPARMs can affect performance3. Demonstrate knowledge of statistics, tools, and traces used for monitoring4. Given a scenario, describe techniques to achieve efficient use of memory5. Demonstrate knowledge of workload manager settings for DB2
Section 6 - Troubleshooting (15%)
1. Given a scenario, describe which documentation can be used to solve a problem2. Demonstrate knowledge of operator commands and traces fro troubleshooting3. Describe how to identify contention problems4. Demonstrate knowledge of diagnostic utilities5. Given a scenario, identify and resolve data sharing problems
How can you study for the exam? Currently there are two courses listed on the Exam Preparation page: DB2 9 for z/OS System Administration, Course number: CV85, and DB2 9 for z/OS Implementation Workshop, Course number: CV86.
I personally would like to see a book published in the MC Press certification study series. What do you think? Are you interested in taking this exam? Would you also want a related book? I have an author and an outline, I just need to be sure that there are interested people once the books is available.
Let me know either in a comment to this blog entry, or by sending me an email directly.... or via the linkedIN entry that Hans started. Looking forward to hearing from you.
svisser1 2700018UK9 3,987 Views
I’m a big fan of the DB2Night Show and attend as many shows as I can. Friday June 20th Leon Katsnelson was the guest on Scott Hayes’ award winning webinar series.
Leon is a great speaker and is passionate about many things including building databases in the cloud. Leon is managing the team of people who have brought us IBM BLU Accelearation for Cloud ( BLU for Cloud).
BLU Acceleration for Cloud is a data warehousing and analytics solution available in the Cloud. It is powered by the next generation in-memory technology DB2 with BLU Acceleration and is combined with Cognos BI. With BLU for Cloud, you’ll experience a powerful, simple, agile Cloud solution.
Try the Beta in your browser or use it through a Cloud provider such as Softlayer or AWS, or let IBM handle it for you through managed services.
During the webinar, Leon explains why IBM is so passionate about Cloud technology and why you should care (your career may depend on it). The way companies approve IT budgets is changing. Be sure you are part of the change.
During the polling questions it came out that many people are afraid of the cloud due to security issues. This isn’t a new requirement. IBM has built its reputation on keeping data safe and secure, and if we suggest you put your data in the cloud, you can be sure that we have technology built into the solution to keep your data safe. Leon gets into details about the security technology including encryption that is built in.
The best thing about this solution is that it is easy! Really easy! Someone else looks after the hardware and the underlying software, leaving you with quality time to explore your data. Data isn’t very valuable on its own. The value is in analyzing it to get the answers to move your business to the next level.
The other thing that is great bout this solution is that it’s fast. Really fast! The buzz word for the past several years has been “big data”. Most of our customers have been managing big data for years. What we need is fast data. BLU for Cloud makes your big data fast data.
Watch the replay: http://www.dbisoftware.com/blog/db2nightshow.php?id=515
Read the storify: https://storify.com/IBMDB2/why-database-in-the-cloud
Try BLU in the Cloud: http://bluforcloud.com/
svisser1 2700018UK9 3,986 Views
Will published: July 20, 2009
About the Author
Neal Fishman, leader of IBM Software Group's integration forensics program, has spoken at conferences around the world, and is a Practicing Member of the World Wide Institute of Software Architects. He holds IBM certifications in DB2, DataStage, QualityStage, and Information Analyzer. Fishman co-authored Enterprise Architecture Using the Zachman Framework.
· Why poor-quality data has become even more dangerous
· Practical solutions for assessing, improving, and sustaining data quality
· Why data governance is so critical-and realistic models for implementing it
· How to instill proactive accountability throughout your data processes
· Proven techniques for evaluating data before, during, and after its use
· Handling persistence and memory-resident databases in SOA environments
· Improving business, system, reference, and “meta” data
· Creating data models that support today’s broader spectrum of applications
· Sustaining data quality through conditioning
· Using systems thinking to limit future data problems and understand the potential ripple effects of data sharing
What is a Rough Cut?
The Rough Cuts service from Safari Books Online gives you exclusive access to an evolving manuscript that you can read online or download as a PDF and print. A Rough Cuts book is not fully edited or completely formatted, but you'll get access to new versions as they are created.
If you prefer to pre-order a copy, amazon currently has the pre-order price set at $26.39... which is a 34% discount.
Either way, I'm sure you'll love the book as much as I do!
Green MDM can be a win-win initiative, good for both the environment as well as the bottom line. Green MDM can go beyond the traditional Green computing area of saving IT resources and related energy consumption.
Find out how... read the latest entry on the MDM blog... this one written by Paul van Run.
Also, buy the Enterprise Master Data Management: A SOA Approach to Managing Core Information book direct from the publisher for the best price!
Anyone who has been to a very large conference will understand the critical need to have a pair of very comfortable shoes to wear at the conference. Last year, one of the attendees of the IOD 2007 conference wore a pedometer and says that she racked up 93 km of walking through the week at the Mandalay Bay! That's a LOT of walking in a single week... on floors that are perhaps not the best to walk on.
This past weekend I invested in a pair of super comfortable shoes and am currently wearing them in so that I am prepared for the IOD NA Conference at the Mandalay Bay in Las Vegas. There are now 7 weeks before the conference begins, so that should give me plenty of time to break in this new pair!
Also, if you get certified at the conference or were previously certified, you are welcome to join the Certification Lounge. The Lounge will once again be featuring tables, chairs, food, beverages, and best of all.... free massages! We want to ensure that you are specially rewarded for earning your certification.
The certification exams offered at the conference are also free to attendees.... so arrive prepared so you can be qualified to take advantage of the free massages from day 1.
Come prepared to maximize your comfort!
See you at the conference, I hope!
Last year, David Pittman and Crysta Anderson interviewed many of our IBM Champions and created a series of blog entries and podcasts on “MasteringDataManagement". This site is going away, but I thought the content was still very valuable.
As a result, I have permission to republish these articles on my blog. I plan to do one every day or so until I’ve finished. Here are the entries I plan to publish:
I’ll update the entries if necessary and will add links to this page so you can easily find out about our awesome IBM Champions!
Thanks to Crysta and David for all their hard work. I hope you find this series as valuable as I do.
I'm interested in what your answer is....
What new skills will you pursue in 2009?
1. XML2. SOA-related skills3. Database modeling and design4. Information systems design5. New programming languages and techniques6. Catching up with new features in DB2 and Informix7. Certification8. All of the above9. None of the above
From:IBM Database MagazineDecember 16, 2008Volume 9, Issue 26
svisser1 2700018UK9 3,966 Views
One of the planned IDUG conferences took place last week in Orlando and is now over. Two more large conferences are planned for this year:
For those of you who attended IDUG, I have a special request for you. Can you write about what you learned? Especially about the upcoming product releases.
Did you attend a session by Bob Picciano, Paul Zikopoulos, Leon Katsnelson, Matthias Nicola, Aamer Sachedina, Chris Eaton, Matt Huras, George Baklarz, Kent Collins, Eric Alton, or Michael Kwok? If you did, how about writing about it to share with those who weren’t able to attend? My blog entry about the sessions at IDUG that were about DB2 10.5: DB2 10.5 with BLU Acceleration at IDUG Orlando
We’d like to hear your impressions of the features that are coming up.
Write a blog or article, take part in a podcast or video, show your slides on slideshare, create a prezi.... we really want to hear from you! You can email me, send me a note on Linked IN, comment on my blog.
Have you tried the Tech Previews?
Introducing the IBM Big SQL Technology Preview
Have you downloaded the new Flashbook?
Have you watched the new videos?
Books at a Discount
Remember to take advantage of the great discounts you can get on retail books when you purchase online direct from the publisher. For details see my blog post: Published books featured at IDUG 2013
Learn more about BLU
Blog entry: Do you know BLU?
May 8 Tech Talk: Introduction and Technical Tour: DB2 10.5 with BLU Acceleration with Berni Schiefer
IDUG NA 2014 is May 12-16 at Sheraton Phoenix
I’m already looking forward to seeing my friends again... and making new friends!
At IBM... keeping our skills current is one of the most important goals we set for ourselves each year. But the typical human trait of procrastinating quite often sets in, leaving December the time when people scramble to take courses and exams! If you are like this... I have good news for you.... there are lots of options available for you. Here are five options:
1) Take a free ILO course. See this blog entry by Kate.
2) Take a certification exam. You can take exams at Prometric Testing Centers, so book your time now.
3) Which exam should you take? For exam objectives and cutscores for each exam, see the exam preparation documents.
4) Read a book. See my blog entry for a list of my suggestions.
5) Enter a contest. See my blog entry for some choices.
We are off to a great start in 2008 with an incredible 29% increase over December 2007. Information Management software published six IBM Redbooks publications in January: five books and one paper. The most active book in the month of January was "DB2 for z/OS Stored Procedures: Through the CALL and Beyond" followed by "Content Manager OnDemand Guide".
DB2 for z/OS Stored Procedures: Through the CALL and BeyondThis IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2 has offered an ever improving support for developing and operating stored procedures. DB2’s enhancements are related to tooling, language support, system environment, and have opened new possibilities for secure, highly portable applications in line with the e-business strategy of today's organizations.
Content Manager OnDemand GuideThis IBM Redbooks publication covers a variety of topics relating to the practical application of Content Manager OnDemand (simply referred to as "OnDemand") for Multiplatforms Version 8.3 (also known as Version 188.8.131.52), z/OS Version 7.1, and IBM eServer iSeries Common Server Version 5.3 of the OnDemand product. Where necessary, separate sections are included to cover variations between the different platforms.
DB2 Security and Compliance Solutions for Linux, UNIX, and WindowsIn this book, we discuss the existing and new DB2® security features introduced in DB2 9.5 for Linux , UNIX, and Windows. These enriched DB2 security features provide you the capability to protect your data and comply with regulatory requirements.
More Popular Downloads for Information Management Software This Month
High Availability and Scalability Guide for DB2 on Linux, UNIX, and WindowsAs organizations strive to do more with less, IBM DB2 for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions by leveraging enterprise system resources with broad support for clustering software such as HACMP, TSA, and Microsoft Windows Cluster Server. This IBM Redbooks publication describes DB2’s high availability functions and features, focusing on High Availability Disaster Recovery (HADR) in the OLTP environment. The book provides a detailed discussion of HADR, including setup, configuration. administration, monitoring, and best practices.
Dimensional Modeling: In a Business Intelligence EnvironmentIn this IBM Redbook we describe and demonstrate dimensional data modeling techniques and technology, specifically focused on business intelligence and data warehousing. It is to help the reader understand how to design, maintain, and use a dimensional model for data warehousing that can provide the data access and performance required for business intelligence.
Oracle to DB2 Conversion Guide for Linux, UNIX,and WindowsIBM DB2 has long been known for its technology leadership. This IBM Redbooks publication, intended for technical staff who are involved in an Oracle to DB2 conversion project, is an informative guide that describes how to migrate the database system from Oracle to DB2 Version 9 on Linux, UNIX, and Microsoft Windows platforms.This book provides conversion methodology and step-by-step instructions for installing and using IBM Migration Toolkit (MTK) to port the database objects and data from Oracle to DB2. It illustrates, with examples, how to convert the stored procedures, functions, and triggers. Application programming and conversion considerations are discussed, along with the differences in features and functionality of the two products.In addition, you can find script conversion samples for data loading, database administration, and reports that are useful for DBAs. The testing section provides procedures and tips for conversion testing and database tuning. The laboratory examples are performed under Oracle 10g and DB2 Version 9. However, the migration process and examples can be applied to Oracle 7, 8, and 9i.
IBM WebSphere Information Analyzer and Data Quality AssessmentIBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information that is spread across their systems. It enables organizations to integrate disparate data and deliver trusted information wherever and whenever needed, in line and in context, to specific people, applications, and processes.
IBM WebSphere Information Analyzer is a data profiling and analysis tool that is a critical component of IBM Information Server. It is designed to help business and data analysts understand the content, quality, and structure of their data sources by automating the data discovery process. Bundled with IBM WebSphere Information Analyzer is AuditStage, a data rule monitoring tool that is designed to help business and data analysts validate data and assess ongoing data quality trends.
Data Modeling Techniques for Data WarehousingThis redbook gives detail coverage to the topic of data modeling techniques for data warehousing, within the context of the overall data warehouse development process. The process of data warehouse modeling, including the steps required before and after the actual modeling step, is discussed. Detailed coverage of modeling techniques is presented in anevolutionary way through a gradual, but well-managed, expansion of the content of the actual data model.Coverage is also given to other important aspects of data warehousing that affect, or are affected by, the modeling process. These include architecting the warehouse and populating the data warehouse.
DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and MoreIBM DATABASE 2 Universal Database Server for z/OS Version 8 is the twelfth and largest release of DB2 for MVS. It brings new synergy with the zSeries hardware and is the first major subsystem to exploit the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, application development, and query functionality enhancements for e-business, while building upon the traditional characteristics of availability, exceptional scalability, and performance for the enterprise of choice.
Sam Poon and Fraser MacArthur recently updated their popular list of recommended articles for those specializing in DB2 for Linux, UNIX, and Windows database administration. Sam and Fraser have filtered through the many articles posted on dWorks and sorted them into the following categories to make it easier for you to find the article that you need:
* Native XML support * Installation and migration * Administration * Monitoring and tuning * High availability * Linux platform * Windows platform * Porting * Problem determination * Certifications
They focus on the content for the DB9, for example, in the Certification category, you'll find links to the tutorial series that were created for Exams 730, 731, and 733.
DB2 9 Fundamentals certification 730 prep series
* Type: Tutorial * Date: 2006 * The Fundamentals tutorial series provides an introduction to SQL (Structured Query Language) and covers how DB2® 9 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation. 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.
DB2 9 Database administration 731 certification prep series
* Type: Tutorial * Date: 2006 * If you know DB2 9 and can perform intermediate to advanced level administrative tasks, you may benefit from becoming an IBM Certified Database Administrator. This series of seven tutorials is designed to help you prepare for the DB2® 9 for Linux®, UNIX® and Windows? Database Administration (Exam 731) certification exam to attain the certification "IBM Certified Database Administrator - DB2 9 for Linux, UNIX and Windows." 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.
DB2 9 Application Development 733 certification prep series
* Type: Tutorial * Date: 2007 * The IBM Certified Application Developer certification confirms to others that you are an intermediate or advanced level DB2 for Linux, UNIX, and Windows application developer and shows that you have strong skills in all common programming tasks as well as embedded SQL programming, ODBC/CLI programming, or Java programming. This series of nine free tutorials is designed to help you prepare for the DB2 for Linux, UNIX, and Windows Application Development certification exam (Exam 733). Each tutorial includes a link to a free DB2 for Linux, UNIX, and Windows trial download. 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. You can take the tutorials online, or download a PDF.
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]
An Introduction to IMS: Your Complete Guide to IBM's Information Management System
This book is considered the only up-to-the-minute guide to IMS Version 9--straight from IBM IMS experts. It introduces IMS, one of the world's premiere software products, it thoroughly covers key IMS functions, from security to Java support for both new and experienced IMS administrators, programmers, architects, and managers and it is prerequisite reading for IBM IMS Mastery Certification Program. To order this book, please visit:
For information on the IMS Mastery Certification Program, see http://www.ibm.com/software/data/ims/education/masterypgm.html