Keep on Learning
Were you one of the very happy readers of the first edition of this book? If you check this book out on amazon.com... you'll see that the first edition of the book had 17 extremely positive reviews of the book. People liked the way the material was presented in a graphical, visual way... the case studies.... and the review questions. On top of that, the authors know there stuff and spend much of their working life talking to customers and helping them understand how to use the product and the benefits each feature is likely to bring.
From the publisher:
Understanding DB2, Second EditionBy Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
IBM DB2 9 and DB2 9.5 provide breakthrough capabilities forproviding Information on Demand, implementing Web servicesand Service Oriented Architecture, and streamlininginformation management. Understanding DB2: Learning Visuallywith Examples, Second Edition, is the easiest way to masterthe latest versions of DB2 and apply their full power toyour business challenges.
Written by four IBM DB2 experts, this book introduces keyconcepts with dozens of examples drawn from the authors'experience working with DB2 in enterprise environments.Thoroughly updated for DB2 9.5, it covers new innovationsranging from manageability to performance and XML support toAPI integration. Each concept is presented witheasy-to-understand screenshots, diagrams, charts, andtables. This book is for everyone who works with DB2:database administrators, system administrators, developers,and consultants. With hundreds of well-designed reviewquestions and answers, it will also help professionalsprepare for the IBM DB2 Certification Exams 730, 731, or736.
Special Offer: Use the Coupon Code for this bookdescription to receive a 35% discount (coupon codes are casesensitive). Plus, FREE shipping in the US for every order.Coupon Code: CHONG0183
THANKS and CONGRATULATIONS to the author team! Another fantastic job![Read More]
Have you tried taking an ILO (instructor-led online) training class yet? With travel budgets disappearing, but the need for training never ending, learning from your home or office makes perfect sense.
What do you get with ILO?
You'll get the high-quality content and personal interaction that you expect from a classroom course with the convenience and cost-savings of online training with instructor-led online training (ILO). With speakers, microphone or headset, you join a virtual classroom where you interact with the instructor and fellow students as if you're in a traditional class setting.
Now is the best time to experience the live instruction, hands-on labs and exciting group dynamics when you enroll in an ILO class. If you want to see how this works, view a demo and enroll today.
Keep on learning!
One thing that I've noticed about myself given the fact that my career is in the database area... is that I have very little tolerance for bad data. I would take a stab and guess that most of you have a story that you could share about how frustrating it is to work with some companies in respect to the data that they have on YOU!
My story involved trying to change the name on my utility bills.... I've been told that I must pay first $60, have the original account closed, a new one opened with the name changed, and then the eventual fall out of owing even more money as other people were dependent on the original account number. After several encounters I found myself screaming that they should pay ME for helping clean their data!
Anyway, this is a long way to encourage you to read the new blog by the authors of the book: Enterprise Master Data Management: An SOA Approach to Managing Core Information.
If you read the first blog entry, you'll see many examples similar to mine of the difficulties to correct bad data. Add your own story! If you read the book, you'll see examples, big and small of this kind of problem, but better yet, you'll get real advice as to how data and systems should be organized so your customers aren't blogging about how difficult it is to work with you!
Once again, the new blog is: www.ibm.com/developerworks/blogs/page/mdmbook and it will have entries from all 6 authors: Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul van Run, and Dan Wolfson.
One of the publishers that I work with quite often is MC Press. You may know of MC Press through the large number of books that they have published on IBM products and technologies. For instance, you'll find books within the following categories:
I've blogged many times about the amazing series of certification guides that have been published by MC Press, including:
We're working on two more certification guides that will be part of this series.... so stay tuned to find out more details.
When you go to the book links above... you'll notice that there is a banner on the site reminding you of our Assess & Save Promotion. Remember that this promotion is only active till the end of the month, so don't miss out.
Two more things you should know.... One... you can save 20% on all books that you purchase before April 19, 2009 through the MC Press Online bookstore.
Two... if you are a registered member of MC Press Online, you'll have access to a rich collection of resources such as white papers, articles, and podcasts. MC Press Online likes to reward its members with cool prizes. Currently you have a chance to win a pair of Zetronix 80” Video Glasses. Interested? Check out the free resources and enter for your chance to win!
Earlier I mentioned how proud I was of this book. One of the authors has just sent me a blog review of this book from James Koopmann(http://blogs.ittoolbox.com/database/solutions/archives/005241.asp).
Clearly James is also very impressed with the book for many reasons. If you haven't checked this book out yet, I encorage you to do so.
I have made this the August book of the month and coincidentally, Amazon decided to put it on special. You can get the book at a 37% discount right now! Go for it.
Also, the book has made it into Amazon's top 100 ranking and all 9 of the reader comments is positive.
Read it and let me know what you think! I'm looking at this book as a model for other future IBM Press books. What do you think?
svisser1 2700018UK9 4,576 Views
DB2 9.7 is now available, and you should consider giving it a try. Why?
1) You can download DB2 Express-C for free to see how the latest features work.
2) I've had the pleasure of reviewing the latest edition of the "Getting Started with DB2 Express-C" free book. Raul and his team did an amazing job writing a short book that covers just about everything that you need to know to get started using DB2. The latest edition isn't posted yet, but should be really soon.
3) Compression, WLM, and SQL/PL are the big stories. Did you see the cool video that explains how great these feature is? The video is actually the Technology Update Chat with the Lab.... watch it :)
4) 35% Improvement in DBA Efficiency
5) Lower Server and License Costs
6) Lower Storage Costs
7) Easier XML projects
8) Peace of Mind
9) Free update for customers with DB2 support!
For these and all reasons, check out the IBM Upgrade to DB2 9.7 website.
(Practice) test yourself : Online Information Management pre-exams
Come prepared for complimentary exams offered at the IBM Information On Demand 2008 conference, coming to Las Vegas Oct. 26 - 31, with free Information Management certification practice tests. Usually offered through Prometric for a fee, take these tests online for at no charge for two weeks leading up to the conference.
How? If you are registered for the conference, you will receive an email containing your promocode allowing you to take the practice test for FREE.
If the results of the practice test indicate that you need to improve your skills... here are a few suggestions:
Exam Preparation Documents
For exam objectives and cutscores for each exam, see the exam preparation documents.
We now have an extensive collection of Certification Prep Guides, including
DB2 9 Fundamentals Certification Study Guide for Exam 730 by Roger Sanders
DB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders
DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Dan Luksetich
DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide for Exam 734 by Roger Sanders and Dwaine Snow
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger Sanders
See also the DB2inBooks group on channeldb2.com.
Pre-Conference Crammer Courses
DB2 for z/OS DBA Certification Crammer (Exam 732)
Speaker: Susan Lawson
This high level certification preparation review is intended to help you take IBM Certification Test 732, DB2 9 DBA for z/OS. Gain an intense overall review of those areas that are on the certification exam.
DB2 9 for Linux & Windows DBA Certification Crammer (Exam 731)
Speaker: Roger Sanders
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9 DBA for Linux, UNIX, and Window certification exam (Exam 731). The material for this course is aligned with the 731 exam objectives.
Remember: Those who are certified are eligible to attend the certification lounge at the IOD conferences... for FREE MASSAGES!
For additional conference information, see also the IOD Conference group on channeldb2.com.
Now available for pre-orders: Expert Preparation for Exam 732: DB2 9 for z/OS Database Administration Certification Study Guide by Susan Lawson and Daniel Luksetich.
The book is expected to publish BEFORE the IOD conference in October despite the website saying the book publishes in November.
Book Description:DB2 9 for z/OS Database Administration Certification Study Guide is the definitive guide to preparing for the IBM Certification 732 Version 9 DBA Certification Exam. The book covers all topics on the exam and also provides a wealth of information about DB2 z/OS Version 9. It also includes a lot of practical information and tips for best performance and usage of DB2. The book is written by two industry experts who were both members of the team that created the 732 exam.
This book covers all of the topics that are on the exam: Database design and implementation, operation and recovery, security and auditing, performance, and installation and migration. There are practice questions with detailed answers at the end of each chapter as well as an 80+ question practice exam. But beyond certification prep, it also covers the new features of version 9 for both database and application development. It will serve as an essential tool for studying for exam 732 as well as a reference that all DB2 DBAs will want on their desktops.
732 Exam Objectives Covered in the Book: * Section 1 - Database Design and Implementation* Section 2 - Operation and Recovery* Section 3 - Security and Auditing* Section 4 – Performance* Section 5 - Installation and Migration/Upgrade
Table of Contents: Preface 1. DB2 Product Fundamentals 2. Environment 3. Access and Security 4. Database Objects 5. Retrieving & Manipulating Objects 6. Advanced SQL Coding 7. Maintaining Data 8. Recovery and Restart 9. Data Sharing 10. Using SQL in an Application Program 11. Binding an Application 12. Application Program Features 13. Stored Procedures 14. Accessing Distributed Data 15. Advanced Functionality 16. Locking and Concurrency 17. Performance, Monitoring, and Tuning Appendix A: DB2 Sample Database Appendix B: Practice Exam Questions Appendix C: Practice Exam Answers
svisser1 2700018UK9 4,557 Views
This book published last year, but is deserving of much more attention!
Use Best Practice Patterns to Understand and Architect Manageable, Efficient Information Supply Chains That Help You Leverage All Your Data and Knowledge
In the era of “Big Data,” information pervades every aspect of the organization. Therefore, architecting and managing it is a multi-disciplinary task. Now, two pioneering IBM architects present proven architecture patterns that fully reflect this reality. Using their pattern language, you can accurately characterize the information issues associated with your own systems, and design solutions that succeed over both the short- and long-term.
Building on the analogy of a supply chain, Mandy Chessell and Harald C. Smith explain how information can be transformed, enriched, reconciled, redistributed, and utilized in even the most complex environments. Through a realistic, end-to-end case study, they help you blend overlapping information management, SOA, and BPM technologies that are often viewed as competitive.
Using this book’s patterns, you can integrate all levels of your architecture–from holistic, enterprise, system-level views down to low-level design elements. You can fully address key non-functional requirements such as the amount, quality, and pace of incoming data. Above all, you can create an IT landscape that is coherent, interconnected, efficient, effective, and manageable.
At IBM Insights:
If you are attending the IBM Insights conference, you can meet Mandy and Harald and have them sign your book for you. They will be available on Tuesday October 28 from 2:45 to 3:45 pm at the conference bookstore.
About the authors:
FREng CEng FBCS
Mandy has worked for IBM since 1987. She is an IBM Distinguished Engineer, IBM Master Inventor, and member of the IBM Academy of Technology Leadership Team. As the chief architect for InfoSphere® Solutions in IBM’s Software Group, Mandy designs common information integration patterns for different industries and solutions.
In earlier roles, Mandy’s work has focused on transaction processing, event management, business process management, information management, and model-driven development. This breadth is reflected in her invention portfolio, which to date stands at over 50 issued patents worldwide.
Outside of IBM, Mandy is a fellow of the Royal Academy of Engineering and a visiting professor at the University of Sheffield, UK. In 2001, she was the first woman to be awarded a Silver Medal by the Royal Academy of Engineering, and in 2000, she was one of the “TR100” young innovators identified by MIT’s Technology Review magazine. In 2006, she won a British Female Innovators and Inventors Network (BFIIN) “Building Capability” award for her work developing innovative people and the BlackBerry “2006 Best Woman in Technology - Corporate Sector” award. More recently, she was granted an honorary fellowship of the Institution for Engineering Designers (IED) and she won the “2012 everywoman Innovator of the Year.” For more information on Mandy’s publications, see http://en.wikipedia.org/wiki/Amanda_Chessell.
Harald has worked for IBM since 2005. Harald is a software architect in IBM’s Software Group specializing in information quality, integration, and governance products, and is IBM certified in delivering IBM Information Management solutions. In this role, he develops best practices, methodology, and accelerators for common information integration use cases.
Harald has 30 years of experience working with data quality products and solutions; product and project management; application development and delivery; system auditing; technical services; and business processes across the software, financial services, healthcare, and education sectors. Harald was the product manager at Ascential® Software and IBM responsible for designing and bringing the IBM InfoSphere Information Analyzer product to market as a key component in IBM’s information quality portfolio. He has been issued three patents in the field of information quality and rule discovery and was recently recognized as an IBM developer- Works Contributing Author.
His publications include the IBM developerWorks articles “The information perspective of SOA design” [parts 6, 7, and 8], “Use IBM WebSphere® AuditStage in a federated database environment,” “Using pre-built rule definitions with IBM InfoSphere Information Analyzer,” “Designing an integration landscape with IBM InfoSphere Foundation Tools and Information Server” [part 1], and “Best practices for IBM InfoSphere Blueprint Director” [parts 1 and 2]. For the IBM InfoSphere Information Server documentation, Harald contributed to the “IBM InfoSphere Information Analyzer Methodology and Best Practices Guide” and “IBM InfoSphere Information Server Integration Scenario Guide”; he has also contributed to three IBM Redbooks®.
I posted last week about the vast number of retail books that are available in India at local prices. Did you know that Shroff Publishers also reprint IBM Redbooks?
The following IBM Redbooks books are available for purchase, in printed format, through Shroff Publishing in India: AIX V6 Advanced Security Features Introduction and Configuration for Rs. 450AIX Version 6.1 provides many significant new security technologies and security enhancements. The purpose of this IBM Redbooks publication is to highlight and explain the security features at the conceptual level, as well as provide practical examples of how they may be implemented. Some features are extensions of features made available in prior AIX releases, and some are new features introduced with AIX V6.
Major new security enhancements introduced with AIX V6 in 2007:
- Trusted AIX (Multilevel Security)- Role Based Access Control (RBAC)- Encrypted File System- Trusted Execution- AIX Security Expert Enhancements
This IBM Redbooks publication will provide a technical introduction to these new enhancements. The topics are both broad and very complex. This book will serve as an initial effort in describing all of the enhancements together in a single volume to the security/system hardening oriented audience.
Connecting Enterprise Applications to WebSphere Enterprise Service Bus for Rs. 600Service Oriented Architecture (SOA) promises a great leap forward in the re-use of applications by simplifying application composition. The technology that simplifies application composition is Service Component Architecture (SCA). SCA is an open component architecture for wiring services together to build composite applications.
WebSphere Enterprise Service Bus provides the on-ramp and off-ramp to incorporate many different applications and services into an SOA solution.
In this IBM Redbooks publication we introduce SCA and how it has evolved from earlier application integration architectures. We explain how WebSphere ESB connects applications and components to the service bus by using adapters and other types of SCA imports and exports.
Our main focus is helping you sort through the many choices that need to be made when deciding how to connect applications together to meet the requirements of a business scenario. We propose six different solution patterns, each with alternative implementations to choose from, to take on most integration scenarios. We also provide seven worked examples of some of the alternatives, which are fully described in the text, and are also available as working samples from the ITSO Redbooks Web site.
Developing SIP and IP Multimedia Subsystem (IMS) Applications for Rs. 650The convergence of Internet Protocol (IP) networks is enabling seamless communications that combine data, voice, video and other information streams. The true value of converged IP network however is realized through the converged applications that leverage the network. The key enabler to developing converged applications is the platform for designing, developing, testing, and deploying applications that integrate and compose services.
This IBM Redbook introduces IBM tools for creating converged Session Initiation Protocol (SIP) and IP Multimedia Subsystem (IMS) applications. It provides programming guidelines and working examples that demonstrate how to use the different development tools. It also provides hints and tips that enable you to quickly get up to speed developing converged applications.
The portfolio of products include the IBM WebSphere Application Server Network Deployment, IBM WebSphere IP Multimedia Subsystem Connector, IBM WebSphere Presence Server, IBM WebSphere Telecom Web Services Server, and IBM WebSphere Integration Developer.
This IBM Redbooks publication is aimed at the diverse set of professionals that design and develop SIP and IMS applications.
Dynamic Warehousing: Data Mining Made Easy for Rs. 525Data mining has evolved from the ethereal domain of the highly-skilled mathematician to the expert data miner's workbench tool and ultimately to widely accessible business applications. For decades, industry and academia have been engaged in far-reaching research and development of data mining. At the same time, businesses have been leveraging this research, exploiting a handful of algorithms most useful in finding information to help resolve business problems.
Recent trends have made these algorithms and systems, which are rooted in solid research, available to a wide range of business users in easy-to-use forms. Large numbers of business analysts, who may not be data mining experts, can now solve high-value business problems using data mining technology embedded in database-resident business applications.
In this IBM Redbooks publication, we discuss the methodology and selected techniques of embedded data mining and show how sophisticated technologies can be used in today's business environment to create significant business value. All this is enabled by the IBM DB2 Warehouse (DB2W) data mining capabilities. Using DB2W, we show examples of using data mining capabilities for such analytic functions as data modeling, scoring, and visualization. In addition, there are scenarios and examples that help in understanding where, when, and how to use data mining. For techniques, technical details, and practical examples, this is the book you need.
Experience J2EE! Using WebSphere Application Server V6.1 - Update for Rs. 500This IBM Redbooks publication is a hands-on guide to developing a comprehensive J2EE application, including core functions, security, Web services, and messaging. In the context of J2EE, messaging is also known as Java Message Service (JMS).
Novice users are thus able to experience J2EE, and advance from theoretical knowledge gained by reading introductory material to practical knowledge gained by implementing a real-life application.
Experience is one stage in gaining and applying knowledge, but there are additional stages needed to complete the knowledge acquisition cycle. This IBM Redbook also helps in those stages:
Before experiencing J2EE, you learn about the base specifications and intellectual knowledge of J2EE through brief descriptions of the theory and through links to other information sources.
After experiencing J2EE you will explore advanced J2EE through previews of advanced topics and links to other information sources.
IBM DB2 9 for z/OS: New Tools for Query Optimization for Rs. 600The cost-based optimizer of IBM DB2 for z/OS has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures, such as star schemas. DB2 for z/OS V8 has provided access path visualization and a Statistics Advisor function through a new Visual Explain.
DB2 9 for z/OS starts addressing the challenge of reducing cost of ownership by extending query optimization through expert-based query and workload analysis, server enhancements, and an Index Advisory function. These functions are delivered with two tools: DB2 Optimization Service Center and DB2 Optimization Expert.
This book helps you understand the installation, customization, and usage aspects of the tools. You are guided through scenarios of gradually increasing complexity where the functions of the tools are exploited for query optimization.
IBM Lotus Notes and Domino 8 Deployment Guide for Rs. 550In today's competitive and diverse marketplace, effective collaboration is a critical component of organizational success. Lotus® Notes® and Domino®, the premier IBM® collaboration platform, helps organizations improve collaboration, increase productivity, and streamline business processes. The Lotus Notes 8 interface is intuitive and easy to use, and the Lotus Domino 8 server is secure, flexible, and reliable. Together, Lotus Notes and Domino 8 can help your organization to:
- Increase employee effectiveness and creativity through integrated messaging, collaboration, and office productivity applications.- Reduce overall cost of ownership by deploying integrated offering with office productivity suite included at no additional charge.- Protect IT infrastructure with a layered security model that reaches from server to individual field in a document.- Increase mobile and offline productivity from secure, reliable replication.- Increase individual responsiveness through customizable interface.- Reduce application development and deployment costs through quick creation application component mash ups.- Minimize downtime with high availability and simplified administration tools.
This IBM Redbooks® publication provides you with information about the new enhancements and features of Lotus Notes and Domino 8 and provides guidelines or directions on how to implement or utilize these. It also provides you with an approach to planning and deploying Lotus Notes and Domino 8 in new and existing environments.
Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows for Rs. 700IBM 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.
Patterns: SOA Design Using WebSphere Message Broker and WebSphere ESB for Rs. 450The Patterns for e-business are a group of proven, reusable assets that can be used to increase the speed of developing and deploying e-business applications. This IBM Redbooks publication focuses on the use of the WebSphere Enterprise Service Bus and WebSphere Message Broker together to form an enterprise service bus (ESB) implemented in a service-oriented architecture (SOA).
This book discusses patterns for integrating WebSphere Enterprise Service Bus and WebSphere Message Broker and includes a scenario to help you design, develop, and deploy these products.
This book is designed to assist customers that are approaching the use of both advanced and basic ESB products from typically messaging and J2EE worlds, but are not quite sure when each is appropriate.
Understanding SOA Security Design and Implementation for Rs. 550Securing access to information is important to any business. Security becomes even more critical for implementations structured according to Service-Oriented Architecture (SOA) principles, due to loose coupling of services and applications, and their possible operations across trust boundaries. To enable a business so that its processes and applications are flexible, you must start by expecting changes – both to process and application logic, as well as to the policies associated with them. Merely securing the perimeter is not sufficient for a flexible on demand business.
In this IBM Redbooks publication, security is factored into the SOA life cycle reflecting the fact that security is a business requirement, and not just a technology attribute. We discuss an SOA security model that captures the essence of security services and securing services. These approaches to SOA security are discussed in the context of some scenarios, and observed patterns. We also discuss a reference model to address the requirements, patterns of deployment, and usage, and an approach to an integrated security management for SOA.
This book is a valuable resource to senior security officers, architects, and security administrators.
*****************************I'll attempt to post on a weekly basis as to what DB2 training resources are available in India.