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.
Keep on Learning
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,340 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,333 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,173 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]