A new ILO course has just been added. This one is an SQL workshop that is spread over 4 half-days in two weeks. ILO courses are the IBM courses that you take without traveling by joining a remote instructor via your computer.
Here are some details:
SQL Workshop - Multi Week Instructor Led Online
On completion of this course, you should be able to:
* Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses* Code inner joins and non-correlated subqueries* Use SQL arithmetic operations* Use scalar and column functions* Use UNION and UNION ALL* INSERT, UPDATE and DELETE rows* Code simple CREATE TABLE and CREATE VIEW statements
The DB2 books that you may wish to have to complement this course are:
* Understanding DB2(R): Learning Visually with Examples (2nd Edition)* DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
If you are interested in passing the DB2 9 Family Fundamentals certification exam (Test 730), you should notice that about 23% of the exam covers SQL knowledge. The book DB2 9 Fundamentals Certification Study Guide by Roger Sanders corresponds to the exam objectives and therefore covers the SQL that you need to pass the exam.
An interesting way to get a start on learning SQL is through the DB2 Games. Here are some details that I found on Kate Dawson's blog:
If you are a beginner, choose the IBM DB2 Detective GameIf you like watching crime investigation shows, this might just be the perfect game for you. Using a crime investigation theme, you will enforce your DB2 9 and SQL skills while learning relational database concepts and how they can be applied to real-life problems. I’ve played this game and highly recommend it.
If you have some existing DB2 skills, choose the IBM DB2 Business GameTry a “run your own business” scenario and put your DB2 and SQL skills to the test with the Business Game. Your company’s future depends on a key report needed to secure funds for a critical upgrade… can you put your DB2 skills into action and beat the game? Play now and find out.
Whenever I ask people who are SQL experts, they tell me that they rely heavily on these books:
* Graeme Birchall's DB2 SQL Cookbook* The SQL Reference for Cross-Platform Development* Product Docs for DB2 LUW* Product Docs for DB2 z/OS
When at conferences, I've noticed that the following books are popular:* Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition* SQL Demystified* SQL: The Complete Reference, Second Edition* SQL In A Nutshell, 2nd Edition* SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition)* SQL Pocket Guide
In writing this blog I realize how many resources are available for SQL. Clearly that means that it is a very important topic.... and one that you can continue to improve in.
Keep on Learning
The ITSO constantly produces IBM Redbooks to help you use the many IBM products and technology. Make sure you check often to keep up to date on all their releases: IBM Redbooks for Information Management Software. If you are a technical expert, consider becoming an author of an IBM Redbook signing up to be a Resident
Here are a few of the latest releases:
Security and Compliance Solutions for IBM Informix Dynamic Server
In this IBM Redbooks publication, we discuss, in detail, the security features available in IBM Informix Database Server (IDS). These enriched IDS security features provide you with the capability to protect your data and comply with regulatory requirements.
We discuss how IDS integrates with operating system security functions for user authentication and user permissions. The role separation divides the security duty among administrators. Auditing enables the database server to log sensitive operations performed by users and administrators for analysis and identifying system misuses.
Discretionary access control (DAC) is the primary access control mechanism that enables access to SQL objects using privileges and roles. Using label-based access control (LBAC), you can control read and write access of users to individual rows and columns at the table level. We then discuss how to secure server-server and server-client communication in an IDS environment, as well as address the security issues for backup and restore.
IBM InfoSphere DataStage Data Flow and Job Design
IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information 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 InfoSphere™ DataStage® is a critical component of the IBM Information Server, and the parallel framework of IBM InfoSphere DataStage is also the foundation for IBM InfoSphere QualityStage and IBM InfoSphere Information Analyzer components.
This IBM® Redbooks® publication develops usage scenarios that describe the implementation of IBM InfoSphere DataStage flow and job design with special emphasis on the new features such as the distributed transaction stage (DTS) in Version 8.0.1, slowly changing dimensions stage ( Version 8.0.1), complex flat file stage (Version 8.0.1), and access to mainframe data.
Up and Running with DB2 on Linux
Linux® is one of the fastest growing server operating platforms within the past few years. DB2® has long been known for its technology leadership. This IBM® Redbooks® publication is an informative guide that describes how to effectively integrate DB2 for Linux, UNIX®, and Windows® (LUW) with SUSE and Red Hat Linux operating systems. This book provides both introductory and detailed information about installing, configuring, managing, and monitoring DB2 in a Linux environment.
We describe the DB2 product family and features for Linux, and we provide step-by-step instructions for a single as well as for a multiple partition DB2 system installation and configuration. We discuss how to migrate single and multiple partition DB2 to DB2 Version 9.5, and discuss, in detail, DB2 database administration in a Linux environment, procedures and tools for database backup and recovery, online maintenance, and system monitoring. We cover DB2 integrated tools and their features and use.
We discuss aspects of DB2 application development in the Linux environment and provide general tips about building and running DB2 applications on Linux and the use of DB2 application development tools.
Introducing OmniFind Analytics Edition: Customizing Text Analytics
IBM® OmniFind™ Analytics Edition uses information in unstructured and structured content to improve decision making. It provides unstructured information analysis, which can improve customer service levels, create cross-sell capabilities and provide early problem detection.
IBM® OmniFind™ Analytics gives business users the tools to gain valuable insights, facilitating better business decisions, by exploring and using key information assets in the enterprise. It also provides multiple ways to explore and analyze information; delivers sophisticated entity extraction capabilities when working with unstructured content. It is based on the open Unstructured Information Management Architecture (UIMA) standard.
This IBM Redbooks publication will help you understand the power and capability of IBM OmniFind Analytics Edition Version 8.4. The book provides instructions on installing and configuring IBM OmniFind Analytics Edition. It explains how to use it for text mining, and how to work with Dictionary Editor and Rule Editor to customize the application for better analysis and discovery. The book also discusses how to setup the Alerting System for automatically watch for increased unusual activities. The integration with IBM OmniFind Enterprise Edition (OEE) is also covered.
One of the things I'm doing this summer is planning for the IOD conference... specifically arranging for books to be at the bookstore and authors to be available for book signings. I have a lot of work left to do, but here are some of the people I know who are ready to sign your books:
Carlton Doe for his soon to be published book: Administering Informix Dynamic Server: Building the Foundation
Roger Sanders for his entire cert prep series, but especially DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide.
Martin Oberhofer and possibly his co-authors of Enterprise Master Data Management: An SOA Approach to Managing Core Information.
Martin Short... just kidding! It would be great if we could arrange for him to sign something that he's produced, but don't count on it.
Stewart Friedman will be a speaker at the conference. Read this article that appeared in the NY times: Hot Ticket in B-School: Bringing Life Values to Corporate Ethics. The book that he wrote and will sign is Total Leadership: Be a Better Leader, Have a Richer Life.
I'll be at the conference and hope you will be too!
I'll post more secrets about the conference when I find them!
I use google to find links to just about anything I'm interested in. I'm not always successful in finding what I am looking for, but I'm sure it is just because of my bad search arguments.
Mark Wilding, a member of the Toronto Lab Development team, was looking for DB2 sites and was frustrated at not being able to find what he wanted to. So, always a problem solver... Mark created the following site:
Forever growing, this site should be one of the first places to go if you are looking for specific DB2 information.
Just a quick comment about Mark. Mark is one of the many prolific authors that we seem to attract in the Toronto Lab. He's been involved with a few books with many ideas still unpublished. He was the driving force behind the latest DB2 Best Practices initiative. If you don't know about this yet, check out the bookmark list to find it.
Also, Mark, along with Dan Behman, wrote a book about Linux that should be popular with many people: Self-Service Linux(R): Mastering the Art of Problem Determination .
Thanks Mark for the bookmark list as well as your passion for writing!
You may have taken part in this survey of IDUG members on the topic of evolving roles and eduction / training needs. I can't say that the results are unexpected, but I can say that it is very helpful to see the analysis and results as they are discussed in the final survey report, "Data Professionals Broaden Their Skills,". The document is currently posted on IDUG's Web site and can be downloaded free-of-charge.
IDUG partnered with Unisphere Media to conduct the survey of IDUG members on this important topic. Sponsored by CA, the survey gathered input from more than 850 data professionals, with some enlightening results that will help IDUG further serve your needs.
From a publishing perspective, I was encouraged to see that many of the books that are currently available, along with those that are in the works, meet the needs of most of the respondents.
For example, it was mentioned several times in the document that DBAs need the following types of information: database performance and tuning, SQL performance, backup and recovery, and data availability. The recently published book by George Baklarz and Paul Zikopolous, DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) covers all of the topics and confirms to me that this book is the must have book for all DBAs! The upcoming book by Roger Sanders and Dwaine Snow, DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide will make an excellent companion book for this audience as it may go into more depth on some of the topics mentioned.
The document also mentioned that more DBAs are finding the need to perform application development tasks such as SQL statement development, data modeling and design, and data access methods. In addition to the Baklarz/Zikopolous book already mentioned, you should consider the book by Philip Gunning: DB2 9 for Developers . As the title implies, the book covers the application development tasks that a DBA is required to perform.
Always an important topic is database security: "Forty-one percent reported their time engaged in data security activities has grown over the past year. Most activity in this area has been focused on access control and user authentication, and managing users, roles and permissions." I would recommend the following book: Understanding DB2 9 Security by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, and Yuk-Kuen Henry Chan
Certification was also mentioned in the survey results, but the message was: "Certification, while valuable, is only prevalent at a minority of sites, the survey found. About 47 percent of respondents - the largest segment - said a quarter or fewer of staff members are certified or working toward certification. Another 21 percent have no certified staff at all." I found this to be surprising as certification exams are extremely popular with the IDUG conference attendees. The books that support our certification program are: DB2 Certification Study Guides.
Lastly I found the difference between database consultants and database administrators interesting: "The priorities of respondents who spend most of their time in business consulting-related activities differ sharply from those mainly engaged in traditional database administration. While both types of data professionals are likely to be focused on managing explosive data growth, data managers engaged in business consulting are far more likely than traditional database administrators to be focusing on developing service-oriented architectures (34 percent versus 18 percent). Likewise, respondents engaged in business consulting roles are more likely to be moving forward business intelligence initiatives (33 percent versus 18 percent). Enterprise information integration is also more of a top concern among professionals engaged with the business (31 percent versus 21 percent)."
For this audience, I'd highly recommend the growing list of SOA titles from IBM Press, especially Enterprise Master Data Management: An SOA Approach to Managing Core Information which I was closely involved with.
I encourage everyone to read and interpret the results from this survey for themselves. The document is 23 pages in length and worth the time to read.
svisser1 2700018UK9 3,428 Views
From the July IBM Press Books Newsletter
*****************************************************************FREE eBOOK + "BUY 2 GET 1 FREE" OFFER ON SOA AND WEBSPHERE BOOKS*****************************************************************We have several special offers to celebrate the publication of anumber of important new SOA and WebSphere IBM Press books:
* Download a FREE eBook, the Summer SOA and WebSphere Sampler.Check out important content from six new and classic SOA andWebSphere titles. Topics covered include: SOA project planning, amethodology for service modeling and design, MDM as an SOA enabler,business integration architecture and patterns, and more. Downloadthis FREE eBook to read about these important topics.
* Place an order on ibmpressbooks.com for two (2) IBM Pressbooks –- one of the six featured SOA and WebSphere books plus anyother IBM Press book –- and you'll receive a FREE copy of "The NewLanguage of Business: SOA and Web 2.0" by Sandy Carter. Don't wait;this offer is only available while supplies last.
* Get a 35% discount on six new and best-selling SOA and WebSpherebooks, plus free ground shipping in the US.
* Listen to two audio podcast series from expert SOA authors whoexplain concepts from their books: Robert Laird, co-author of thejust-published "Executing SOA: A Practical Guide for the Service-Oriented Architect" has a 3-part podcast series, as does SandyCarter, author of "The New Language of Business: SOA and Web 2.0."
Visit ibmpressbooks.com/SOAspecial to learn details aboutthe special offer, and listen to the audio podcasts.
Here are the other IBM Press titles that you may wish to consider as part of this offer:
Enterprise Master Data Management: An SOA Approach to Managing Core Information By Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul Van Run, Dan Wolfson.Take your career to the next level by understanding how and why master data management can improve your business.
Understanding DB2(R): Learning Visually with Examples (2nd Edition) By Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow.With 20 5-star reviews, how can you go wrong with this book? Whether you've never used DB2 before or whether you're just trying to get up to speed with the latest features, this book is the one for you.
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) By George Baklarz, Paul C. Zikopoulos.This is the essential book that should be on everyone's bookshelf!
Understanding DB2 9 Security By Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan.Improving the security of your environment is definitely something you should consider.
PS. Happy Independence Day to all my American friends!![Read More]
svisser1 2700018UK9 3,411 Views
pureXML™ – “The two most beautiful words in the English language" when it comes to storing and handling XML data.
The pureXML capabilities unique to IBM DB2 software allow you to store your XML data natively in a database table, providing seamless integration of XML and relational data and allowing you to use both SQL and XQuery to query your XML data. What does this mean? Performance improvements, productivity improvements, and cost savings, just like those being realized by other businesses like yours.
OK... sure, this is product information. But check out these videos:
The Pitch Part 1The Pitch Part 2The Pitch Part 3
Do you like watching videos for this kind of thing? Take a look at the large number of videos that are now available on ChannelDB2.com and YouTube.com.
See also Kate's Blog and PlanetDB2.
PS... I need to remember to bring my headphones into work so I don't disturb all those around me by watching / listening to these videos![Read More]
One of the things that I'm trying to find out this year is where do people normally buy their books... and why. It seems that most people go to amazon.com. I go to amazon.com, but only to see the prices, selection, and reader comments. I typically buy at one of the local online bookstores such as amazon.ca or chapters.indigo.ca.
During my travels in the past month, I've found out that many people in Europe choose to buy directly from amazon.com rather than their local sites. Why? I think primarily because of the very favourable currency exchange... and also the price, selection and reader comments!
If you look at the bookstore site that my team maintains, we also point to amazon for the books that we mention. Not really to say that you should buy it there, but for you to see the price and the reader comments.
Since I work directly with several publishers, I also work directly with them on various book promotions. If there is a special discount promotion available for a book... I make sure that the details are mentioned on our bookstore site. For instance, next week you'll see the following information posted:
Enterprise Master Data Management: An SOA Approach to Managing Core Information
Save 35% on the new MDM book published in June that is sure to be the only complete technical primer for every MDM planner and implementer! Written by a team of 6 authors, this book systematically introduces MDM’s key concepts and technical themes, explains its business case, and illuminates how it interrelates with and enables SOA.
Save 35% with the following code at checkout:Coupon Code: IBM6250Active until 12/31/08
We've also arranged for people to buy IBM Press books direct from the publisher in Europe and Canada as well. Here are the sites:Pearson Canada - for a 35% discount on all featured books.Pearson EMEA - provides free shipping and duty for EMEA residents.Employees in Canada - contact me directly :)
For all other places in the world, international information is placed on this page: International sites
We now have many books available through MC Press as well. In the US, the recommended site is: MC Press Online. MC Press has published all of the DB2 V9 Certification Study Guides and have the long awaited Advanced DBA Study Guide coming in September. When MC Press has preorder information, it will be posted on our bookstore site.
In India, Shroff Publishers & Distributors Pvt. Ltd or Computer Bookshop. I see some IBM Press books on the Computer Bookshop site as well. Check it out and let me know if the prices are good!
I've mentioned Kindle before... If you have amazon's electronic reader, then you will be happy to note that all IBM books are kindle-ready! What a better way to have all the reference materials in a single place?
IBMers are encouraged to use Books 24x7 for electronic access to most retail books. All IBMers, worldwide, have access to Books 24x7. If you need info, let me know. If you don't work for IBM, you can pay for a subscription to either Books 24x7 or Safari for electronic books. You can read entire books electronically... or search a library of books for just the right topic.
I know I wasn't able to cover all the countries in the world. I'm still doing research! If you can help me by enlightening me on how you buy your books, please send me a comment! I'd love to hear from you!
As always, check out other bloggers via Planet DB2
svisser1 2700018UK9 3,254 Views
You have until Monday, June 30th to register for a certification voucher that entitles you to a 50% off the price of an exam fee... if you've purchased one of the cert guides. For details see: http://www.ibm.com/developerworks/blogs/page/SusanVisser?entry=follow_the_pig
Follow the pig!
The promotion has been hugely successful! If you were one of the many people who has already received a voucher, good luck on your exam! You'll be happy to know that the book you bought is proven to help people prepare for the exams... not only because of the content, but because of the sample questions and answers that are in the books.
I'm packed and ready for the IOD EMEA conference that is taking place next week in my homeland: Holland! After the conference I will stay a couple of extra weeks to explore the places where my parents grew up... before moving to Canada.
At the conference I'll be working at the bookstore, recommending books to the attendees. If you are planning to be there... come and say hi to me! I've worked closely with many of the authors who have published DB2 and related titles over the past 10 years.... so I may be able to help you choose the best book for your needs.
The bookstore is located at the main entrance of the World Forum Convention Center during the following hours:
Monday, 2 June 3 pm - 8 pmTuesday, 3 June 10 am – 6 pmWednesday, 4 June 8 am – 6 pmThursday, 5 June 8 am – 6 pm
I mentioned in a previous entry that we will be launching the new Enterprise Master Data Management: An SOA Approach to Managing Core Information book by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul Van Run, and Dan Wolfson. We've arranged to have a special author signing session that will be held outside the World Forum Theater immediately following the Information Platform & Solutions featured keynote on Wednesday, 4 June at 12.20
Another newly published book that will be available for purchase at the bookstore is Executing SOA: A Practical Guide for the Service-Oriented Architect by Norbert Bieberstein, Robert G. Laird, Keith Jones, and Tilak Mitra.
Pick up your free copy of Carlton Doe's IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology outside World Forum Theater immediately following the Data Management featured keynote on Tuesday, 3 June at 12.20.
Pick up your free copy of DB2 VIPER Strikes Again, New Features in DB2 9.5 outside World Forum Theater immediately following the Data Management featured keynote on Tuesday 3 June at 12.20.
The booksellers I’ll be working with have the following website where books may be purchased following the conference: www.vanstockum.nl
I’m not sure how connected I’ll be at the conference, so I am not sure how many posts I’ll be able to make, but I’ll try.
While I’m away, make sure that you keep an eye on Kate’s blog!
Do you ever wish that you could get practical guidance regarding the BEST way to use DB2 9 to improve the value of your DB2 data servers? For the past 6 months, the development teams have been creating Best Practice papers to help you discover the best practices for the most common DB2 9 product configurations with IBM® DB2® for Linux®, UNIX®, and Windows®.
These Best Practice papers present advice on the most optimal ways you can use DB2 to satisfy key business data processing needs. These papers are authored by leading experts in IBM's development and consulting teams, and have been extensively tested.
Each Best Practice paper is designed to provide practical guidance for the most common DB2 9 product configurations. By applying these recommendations, you may improve the value of your DB2 data servers and align yourself with IBM's technical direction for DB2.
Currently available are:
Database storage, (May 2008)Discover best practices for database storage including guidelines and recommendations for spindles and logical unit numbers (LUNs), stripe and striping, transaction logs and data, file systems versus raw devices, Redundant Array of Independent Disks (RAID) devices, registry variable and configuration parameter settings, and automatic storage.
Physical database design, (May 2008)Learn about all of the design features that relate to the physical structure of the database such as datatype selection, table normalization and denormalization, indexes, materialized views, data clustering, multidimensional data clustering, table (range) partitioning, and database (hash) partitioning.
Data life cycle management, (May 2008)See the best practices to design and implement scalable solutions that facilitate the continuous feed or roll-in and roll-out of data, with minimal interruption of data access.
Minimizing planned outages, (May 2008)View the best practices for minimizing, or even potentially eliminating, planned database outages. Planned outages can include activities such as routine database maintenance activities or upgrades to your database environment.
IBM data server security, (May 2008)This Best Practices roadmap details how to protect data servers against the common data security threats, some uncommon threats, and useful countermeasures for these threats.
Deploying IBM DB2 products, (May 2008)Discover best practices for deploying the DB2 9.5 family of products on Linux, UNIX, and Windows platforms across multiple computers quickly, easily, and consistently.
Writing and tuning queries for optimal performance, (May 2008)Learn best practices for minimizing the impact of SQL statements on DB2 database performance. This paper focuses on good fundamental writing and tuning practices that can be widely applied to help improve DB2 database performance.
Tuning and monitoring database system performance, (May 2008)See best practices for the performance evolution of a Data Server. From important principles of initial hardware and software configuration to monitoring techniques that help you understand system performance under both operational and troubleshooting conditions. For troubleshooting performance problems, this paper provide a step-wise, methodical method for determining the problem.
Managing XML data, (May 2008)Get principles and guidelines for using DB2 pureXML™ to solve business problems effectively and to achieve high performance when managing XML data in enterprise applications - illustrated with a real-world example easily adapted to other types of XML applications. See Downloads for the files associated with this paper.
Improving data server utilization and management through virtualization, (May 2008)Discover best practices for deploying DB2 9 with the IBM System p™ virtualization technology. Select the right blend of virtualization features and their configurations to achieve desired business goals, while improving the utilization of IT resources.
Frequently asked questions from problem management reports, (May 2008)Get answers to the most common questions that DB2 customers have about the DB2 data server.
Additional Best Practice papers are in development, and will be published on developerWorks as they become available.
Congratulations and THANKS to all the authors for their very valuable contribution to these papers!
PS... see also Kate's blog...[Read More]
In the past month I've been to two conferences and am about to go to one next week. Coincidentally, I was having system problems and was unable to make blog entries! Many times over the past month I've encountered items that I wanted to share with you, but since I didn't write them down, I need to rely on my taxed memory!
The first conference was actually a symposium for the IM Education and Consulting team. This is the team that I belong to and we are widely spread out in terms of location and mandate. The symposium was a chance for us to meet many of our teammates and of course to further our education. I attended sessions led by Belal Tassi (Data Governance), Chris Gruber (Info 2.0 Mashups), Melanie Stopfer (Pass it Forward), Matthias Nicola (XML), Mark Meredith (Are you Listening), and Kevin McNulty (Basics of Project Management). I enjoyed each of the sessions and intend to blog about some of what I learned in future entries.
The next conference was last week in Dallas: IDUG NA. My role at the conference was to lead the Publications and Certification sessions in the Skills Hub. The Skills Hub was our way of showing attendees that there are a variety of resources available to keep skills current. Angela Moore and Nancy Miller were my most constant team mates in this venture, but we also had help from Melanie Stopfer, Dave Romack, and Fred Whitlark. We collected 110 surveys during the time the Skills Hub was open and each person was required to listen to us briefly describe the resources that are available. To our complete shock... we discovered that nearly 90% of the people who we spoke to were unaware of developerWorks! I gave away all of my business cards in a hope that many of the people who didn't know about dworks would at least check out my blog and then wander off and explore the amazing and current content that is available in dworks... all the time! Welcome to those who are new! I hope you enjoy what you find on this site.
We were pleased to learn that most people are aware of the retail books and the growing supply of them, our certification program, our certify and save promotion (follow the pig), and of course... IBM Redbooks. We appreciate your support of these resources and hope that you find a few new ones via my blog or elsewhere. Stay tuned for future blog entries that will go into detail for each of the skills resources that we have available.
The highlight of my week was meeting Merrikay Lee, publisher of MC Press books, in person. We've been working together for several years now and have never had the opportunity to meet in person. I was able to introduce Merrikay to many of the authors she has worked with over the years, as well as reviewers and future authors.
Congratulations to Julian Stuhler, the new president of IDUG. The Skills Hub was located right next to the IDUG Information Booth, so I was lucky to spend time with many of these dedicated people!
Next week I'm at the IOD EMEA conference in Holland. I'll be working at the bookstore for the week, so if you are there, please say hi to me! We're launching the new Enterprise Master Data Management: An SOA Approach to Managing Core Information book which I'm quite proud of, but will have many valuable books for sale that will please the attendees. My parents were raised in Holland and Belgium, so I'm looking forward to finally visiting my countries of origin!
All the best!
PS... to catch up on some of the items that my team wants you to know about.... see Kate's blog... thanks Kate!
I recently invested in good headphones... and I'm glad I did. I've already used them for an ILO course, listened to the many podcasts, watched the new IBM commercials on YouTube, watched the videos on ChannelDB2, and will likely find many more purposes.
IBM's list of ILO courses is growing steadily. My recommendation... Make sure that you fully test your headphones and mic BEFORE the session. You'll have a much more productive ILO session if you do.
Kate blogged about the many podcasts that are available right now, and today the IBM Press newsletter featured many more. Podcasts are available from the following people: Danny Arnold, Dwaine Snow, Sandy Carter, Larry Klosterboer, Sara J. Moulton Reger, Raul F. Chong, Paul Zikopoulos, John Arthur Ricketts, Mike Moran, Tara Woodman, Ellice Uffer, and Scott Spangler.
I've been trying to mention as many of the IBM commercials as I can... here is the latest... . this one is called "When it Rains".
IDUG also has a growing list of courses and podcasts that you may find helpful.
ChannelDB2 contains a broad spectrum of resources including videocasts, podcasts, and more. If you would like to contribute your unique view on the DB2 products, film or record yourself and add the result to ChannelDB2.
Here is another IBM commercial. This one is called "The Grail" and is about security. Have you seen this IBM Press book that published earlier this year? It's about security as well....
Mainframe Basics for Security Professionals: Getting Started with RACF
Leverage Your Security Expertise in IBM® System z™ Mainframe Environments
For over 40 years, the IBM mainframe has been the backbone of the world’s largest enterprises. If you’re coming to the IBM System z mainframe platform from UNIX®, Linux®, or Windows®, you need practical guidance on leveraging its unique security capabilities. Now, IBM experts have written the first authoritative book on mainframe security specifically designed to build on your experience in other environments.
Even if you’ve never logged onto a mainframe before, this book will teach you how to run today’s z/OS® operating system command line and ISPF toolset and use them to efficiently perform every significant security administration task. Don’t have a mainframe available for practice? The book contains step-by-step videos walking you through dozens of key techniques. Simply log in and register your book at www.ibmpressbooks.com/register to gain access to these videos.
The authors illuminate the mainframe’s security model and call special attention to z/OS security techniques that differ from UNIX, Linux, and Windows. They thoroughly introduce IBM’s powerful Resource Access Control Facility (RACF) security subsystem and demonstrate how mainframe security integrates into your enterprise-wide IT security infrastructure. If you’re an experienced system administrator or security professional, there’s no faster way to extend your expertise into “big iron” environments.
* Mainframe basics: logging on, allocating and editing data sets, running JCL jobs, using UNIX System Services, and accessing documentation* Creating, modifying, and deleting users and groups* Protecting data sets, UNIX file system files, databases, transactions, and other resources* Manipulating profiles and managing permissions* Configuring the mainframe to log security events, filter them appropriately, and create usable reports* Using auditing tools to capture static configuration data and dynamic events, identify weaknesses, and remedy them* Creating limited-authority administrators: how, when, and why
About the Authors:
Ori Pomerantz has been securing computer networks--and teaching other people to do so--since 1995. Since joining IBM in 2003, he has written classes on several Tivoli® security products, including IBM Tivoli zSecure.
Barbara Vander Weele, a software engineer at IBM, has developed and presented education material on provisioning, security, storage, and business technologies for IBM Worldwide Education.
Mark Nelson, Senior Software Engineer at IBM, is a twenty-year veteran of the RACF design team and a frequent speaker on RACF and z/OS security-related topics.
Tim Hahn, IBM Distinguished Engineer, has been with IBM for seventeen years. He is Chief Architect for Secure Systems and Networks within the IBM Software Group Tivoli organization.
Security doesn't exist in a vacuum; it’s a part of the business process and it permeates all aspects of information technology. The bad news is that as applications run on a combination of multiple platforms, each of the platforms needs to be examined, understood, and protected. The good news is that good security techniques transcend platforms; the key is understanding how to take the knowledge that you already know and apply it across these platforms.
That's the reason for this book. Experienced UNIX or Windows security professionals can extend their existing security knowledge to the world of z/OS![Read More]
Another commercial for you to view: Killer App. This one was from last year.... and the closing remark: "I don't know how to do that." I think MDM is "how you can do that" and is the answer to connecting everything to everything... the power is amazing.
Learn how: preorder Enterprise MDM - An SOA Approach to Managing Core Information.
This is valuable reading for everyone who wants to understand MDM.
- - -
Product Description: The Only Complete Technical Primer for Every MDM Planner and Implementer
Companies moving toward flexible SOA architectures often face difficult information management and integration challenges. The “lifeblood” master data they rely on is often stored and managed in ways that are redundant, inconsistent, inaccessible, non-standardized, and poorly governed. Using Master Data Management (MDM), organizations can regain control of their master data and maximize its value in SOA environments.
Now, for the first time, there’s an authoritative, vendor-independent MDM technical reference for every practitioner: architects, technical analysts, consultants, solution designers, and senior IT decision-makers. Authored by the IBM data management innovators who are pioneering MDM, this book systematically introduces MDM’s key concepts and technical themes, explains its business case, and illuminates how it interrelates with and enables SOA.
Drawing on their experience with cutting-edge projects, the authors introduce MDM patterns, blueprints, solutions, and best practices published nowhere else--everything you need to establish a consistent, manageable set of master data, and use it for competitive advantage.
• How MDM and SOA complement each other• Using the MDM Reference Architecture to position and design MDM solutions within an enterprise• Assessing the value and risks to master data, and applying the right security controls• Utilizing PIM-MDM and CDI-MDM Solution Blueprints to address industry-specific information management challenges• Incorporating MDM solutions into existing IT landscapes via MDM Integration Blueprints• Leveraging master data as an enterprise asset—bringing people, process, and technology together with MDM and data governance• Identifying user roles, responsibilities. and skill descriptions for MDM project participants• Case studies in MDM deployment, including data warehouse and SAP integration
About the Authors: * Allen Dreibelbis, Executive Architect in the IBM Software Group Worldwide Information Platform and Solutions Architecture Team, led the development of the MDM Reference Architecture.
* Eberhard Hechler, Technical Enablement Architect for IBM Information Platform & Solutions, works with system integrators throughout Europe.
* Ivan Milman, Senior Technical Staff Member at the IBM Software Group and IBM Master Inventor, focuses on security and governance in information management.
* Martin Oberhofer, Technical Consultant at the IBM Böblingen Lab, is a member of the Worldwide IBM Software Group Master Data Management Center of Excellence.
* Paul van Run, IBM Senior Technical Staff Member, is responsible for architecting the MDM Server and WebSphere Product Center.
* Dan Wolfson is an IBM Distinguished Engineer and Chief Architect/CTO for the Information Platform and Solutions segment of the IBM Information Management Division of the IBM Software Group.
If you are attending the IBM Information On Demand EMEA Conference 2008 meet all six authors in person and have a copy of your book signed.