Have you signed up for the IBM Press newsletter? The copy that came out today has part of the interview with Rebecca Bond, lead author of the soon to be published book... the FIRST retail book to cover VIPER / DB2 9 content:
Understanding DB2 9 Securityby Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong,and Yuk-Kuen Henry Chan
Understanding DB2 9 Security is the only comprehensive guideto securing DB2 and leveraging the powerful new securityfeatures of DB2 9. Direct from a DB2 Security deploymentexpert and the IBM DB2 development team, this book givesDBAs and their managers a wealth of security informationthat is available nowhere else. It presents real-worldimplementation scenarios, step-by-step examples, and expertguidance on both the technical and human sides of DB2security.
To read the interview, visit: http://www.ibmpressbooks.com/promotion/3977
To subscribe to the IBM Press newsletter, visit: http://www.ibmpressbooks.com/newsletters
Keep on Learning
svisser1 2700018UK9 2,777 Views
svisser1 2700018UK9 2,528 Views
Download the latest DB2 9 Express-C software for free.... this new version of DB2 is tailored for the new Windows Vista operating system and openly available for download, at no cost, to customers, developers and partners. Current editions of DB2 Express-C supports the Windows and Linux operating systems on various 32-bit and 64-bit processor architectures.
DB2 Express-C enables and supports the growing community of DB2 developers and customers, making it easier for them to create and deploy applications and solutions that meet their changing information management requirements regardless of platform or OS changes.
DB2 9 Express-C offers the same core DB2 9 data server found in other editions, in a smaller package specifically designed for use in software development, deployment, redistribution and embedding within applications. No charge community support for DB2 Express-C is available via www.ibm.com/db2/express. For-fee IBM support is available with the purchase of DB2 Express Edition.
DB2 Express-C for Vista provides developers with the industry's first no-cost, fully functional relational and pureXML data server to use for developing and deploying applications on the new Windows platform.
See http://www.ibm.com/press/us/en/pressrelease/20735.wss for the official announcement.
svisser1 2700018UK9 2,556 Views
Are you trying to prepare to pass certification exam 443 (http://www.ibm.com/certify/tests/obj443.shtml)? You'll be happy to know that a series of articles are now available to prepare you to pass the IBM® DB2® Content Manager V8.3 certification exam 443.
These articles provide a strong foundation for educating yourself on DB2 Content Manager, from understanding how to gather requirements for your content management system, to learning about the core products, to tuning and administering, to troubleshooting.
To get to the articles, go to this url: http://www.ibm.com/developerworks/db2/library/long/cmcertification/The articles were written by Karensa Jablonka, Mary Desisto, and Michael Lowe.... all long term content manager experts.
Good luck on the test!
svisser1 2700018UK9 2,641 Views
Although we haven't had a tremendous number of retail books published this year, there are several key ones that I'd like to tell you about. The titles are not listed in any particular order:
Information on Demand Introduction to DB2 9 New Featuresby Paul Zikopoulos, Chris Eaton, George Baklarz, Leon Katsnelson (flashbook)
This one was a custom book that we did for the IOD conference. You cannot buy individual copies like most books, but if you want a stack of the books, that can be accomodated... send me a note if you do want to pursue a bulk order.
DB2 9:pureXML Overview and Fast Startby Cynthia Saracco, Don Chamberlin, Rav Ahuja
This was also a custom book, where hardcopies were handed out at the IOD conference. We're out of hardcopies, but can print more if we had the demand. We also have the content loaded on the redbook site for all to read electronically.
Introduction to SQL: Mastering the Relational Database Language (4th Edition)by Rick Vanderlans
This is the 4th edition of a popular university text book that was written by an IBM Gold Consultant. The book doesn't cover XML, but is an excellent book to help new comers learn SQL.
Refactoring Databases: Evolutionary Database Design (The Addison-Wesley Signature Series)by Scott Amber and Pramod J. Sadalage
This book is written from a design perspective. It's not specifically about DB2, but will help you design your databases for improved performance.
SQL Pocket Guideby Jonathan Gennick
This is an excellent small reference book that covers SQL across all relational database products.
Understanding DB2 9 Securityby Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
This is our first official published book on DB2 9! Everything that you should know about the security features in DB2 9, plus much more. This book will help you consider all of the actions that must be taken to ensure that your data is well protected from various threats.
IBM DB2 9 New Featuresby Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton
Coming in January... not only a listing of the latest DB2 features but a good way for you to learn how to use the new features so that you can begin realizing significant business benefits.
svisser1 2700018UK9 2,721 Views
With the end of the year come lists… lists of all the accomplishments made throughout the year. A few posts ago I listed all of the retail books that were published in 2006. This post lists the redbooks that published this year… and what a list! Thirty books that span the wide range of topics in the Information Management area. I’m sure there is a book that would be valuable to you and others you know.
Congratulations to everyone who was involved in producing these 30 books. No small feat!
DB2 9: pureXML Overview and Fast Start
DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET
Developing PHP Applications for IBM Data Servers
DB2 Performance Expert for Multiplatforms V2.2
Coupling Facility Performance: A Real World Perspective
IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide
Powering SOA with IBM Data Servers
LOBs with DB2 for z/OS: Stronger and Faster
DB2 Recovery Expert for z/OS User Scenarios
Data Integrity with DB2 for z/OS
WebSphere Replication Server for z/OS Using Q Replication: High Availability Scenarios for the z/OS Platform
Disk storage access with DB2 for z/OS
DB2 UDB for z/OS: Design Guidelines for High Performance and Availability
A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
Leveraging DB2 Data Warehouse Edition for Business Intelligence
Improving Business Performance Insight . . . with Business Intelligence and Business Process Management
Dimensional Modeling: In a Business Intelligence Environment
Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries
The Ins and Outs of XML and DB2 for i5/OS
Preparing for and Tuning the SQL Query Engine on DB2 for i5/OS
SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries
Moving Forward with the On Demand Real-time Enterprise
How does the MIDAW facility improve the performance of FICON channels using DB2 and other workloads?
Performance Tuning for Content Manager
Content Manager OnDemand Guide
Content Manager Implementation and Migration Cookbook
WebSphere Replication Server Using Q Replication High Availability Scenarios for the AIX Platform
IBM DB2 Document Manager with IBM Records Manager Solution Guide
E-mail Archiving and Records Management Integrated Solution Guide Using IBM DB2 CommonStore and DB2 Records Manager
IMS Connectivity in an On Demand Environment: A Practical Guide to IMS Connectivity
Publishing IMS and DB2 Data using WebSphere Information Integrator: Configuration and Monitoring Guide[Read More]
Now this list was a difficult one to put together. In fact, I went to Louise McNicoll from the Toronto Lab for this list... and you may discover that it isn't all inclusive. You may notice that the authors are all employees of the Toronto Lab. Yes, the employees from the US and India have published articles as well, but I have not yet been able to pull together a complete list. One of my goals for the New Year!
Nevertheless, you'll notice that this is a very lengthy list, so clearly the list will be much longer when I get all the details.
I hope you find this list useful. Happy Reading :)
Comparing real time cardinality to the optimizer cardinality estimatesby Samir Kapoor, Sid Selvarajah, Kaarel Truuvert
A quick start: Developing and testing SQLJ programs using Rational Application Developerby Yongli An, Joyce Coleman
Set up a Multi-tier SPECjAppServer2004 cluster with DB2by Tony Lau, Meng Fu
Set up a WebSphere v6 SPECjAppServer2004 cluster with DB2 for Linux, UNIX, and Windowsby Tony Lau
Backup/Restore Schemas for DB2 Universal Databaseby Serge Rielau
Configure DB2 UDB ESE V8.2 with the Database Partitioning Feature on SUSE Linux Enterprise Serverby Sam Poon, Fraser McArthur
DB2 9 XML Performance Characteristicsby Irina Kogan, Matthias Nicola, Berni Schiefer
DB2 Partitioning Features: an overview for data warehousesby Paul McInerney
DB2 Developer's releaseby Paul Zikopoulos
DB2 Universal Database: The Database Explorer, Part 1by Paul Zikopoulos
DB2 Universal Database: The Database Definition Windows, Part 2by Paul Zikopoulos DB2 Universal Database: Building Stored Procedures using the Database Expolorer View, Part 3by Paul Zikopoulos DB2 Universal Database: Building User Defined Functions using the Data Definition View, Part 4by Paul Zikopoulos DB2 Universal Database: Generating SQL Statements Using the SQL Editor, part 5by Paul Zikopoulos DB2 Universal Database: Productivity Features of the SQL Builder, Part 6 by Paul Zikopoulos Building Tables with the DB2 Designer and Visual Studio 2005 by Paul Zikopoulos Build a DB2 Bound Data Application using Visual Studio 2005by Paul Zikopoulos How to Build an ASP.NET Web Site Using DB2 Data with Visual Studio 2005by Paul Zikopoulos Binding DB2 Data to Visual Studio 2005 Windows Applicationsby Paul Zikopoulos Creating an XML Schema Document (XSD) with the DB2 Tools for Visual Studio 2005 Database Journal (www.databasejournal.com)by Paul Zikopoulos
DB2 9 Fundamentals exam 730 prep, Part 1: DB2 planningby Paul Zikopoulos DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data by George Baklarz
Information on Demand Global Conference Web 2.0 Personal Plannerby Leons Petrazickis, Grant Hutchison
DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 databy Roman Melnyk
Introducing DB2 9: DB2 9 unveiledby Rav Ahuja
Introducing DB2 9: Application development enhancements by Rav Ahuja
Introducing DB2 9, Part 1: Data compression in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 2: Table partitioning in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 3: Self-tuning memory in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 4: Autonomic and other enhancements in DB2 9by Rav Ahuja
Setting up DB2 for UNIX and Linux on NFS mounted file systemsby Felix Lee
DB2 Developer Workbench, Part 1: Developer Workbench concepts and basic tasksby Chris Eaton
DB2 Developer Workbench, Part 2: Developer Workbench and stored proceduresby Debra Eaton
DB2 XML evaluation guideby Gerald Leung, Grant Hutchison
Kick-start your J2EE applications using DB2 9 with pureXML and WebSphere Community Editionby Gerald Leung, Lin Sun
DB2 Express-C, the developer-friendly alternative by Grant Hutchison
Work with XML Data in the Zend Framework: Getting started with the Zend_Db_Xml Incubator Project by Salvador Ledezma
Take the Fast Trainby Rahul Kitchlu, Boris Bialek
Cost-based Optimization in DB2/XMLby John Hornibrook, Andrey Balmin, Tom Eliaz, Lipyeow Lim, David Simmen, Guy Lohman, Min Wang, Chun Zhang
Automating DB2 HADR Failover using IBM Tivoli System Automation for Linuxby Melody Ng, Steve Raspudic, Chris Felix
Installing the DB2 Plug-in for Nagios System Monitor (PDF download)by Chris Thomason
What's Hot for Javaby Christine Law
HASE: A Hybrid Approach to Selectivity Estimation for Conjunctive Predicatesby Calisto Zuzarte, Xiaohui Yu, Nick Koudas High Availability with IBM® DB2® 9 and xkoto GRIDSCALE (PDF download)by David Tam, Belal Tassi Workload Adaptation in Autonomic DBMSsby Randy Horman, Baoning Niu, Patrick Martin, Wendy Powley, Paul Bird CASCON 2006
Using Zend Core for IBM and IBM® DB2 Technologies to Implement an OLTP System Supporting Tens of Thousands of Simultaneous Database Connectionsby Nailah Bissoon, John Tran, Sunil Kamath Zend Developer Zone
A Recipe for Services Oriented Architectureby Paul Zikopoulos
Taking Control: DB2 Query Patrollerby Paul Zikopoulos, Dwaine Snow
Introducing the db2pd Tool – A Not-So-Well Known Friend for a DBAA Simple Fix to a DB2 Query Patroller Locking Problemby Paul Zikopoulos
Accessible Standy Database in IBM DB2 UDB HADR Environement Using VERITAS Volume Instant Snapshots (PDF download)by Nuzio Ruffolo www.ibm.com[Read More]
svisser1 2700018UK9 2,874 Views
Happy New Year to Everyone!
A series of new certification roadmaps have been created to help you find your way around the latest exams that are available to support the newest product releases for Information Management Software.
This series of certification roadmaps will help you define and map out your certification path for a variety of job-related certifications for our Information Management software products.
These roadmaps are designed to provide a comprehensive, concise view of all the exams and roles available as well as provide you with the most efficient path to achieve the various levels of certification. Once you earn one or more of these certifications, you earn the right to display the Information Management professional certification mark.
The roadmaps fall into the following categories:
Content Management and Discovery Content Manager V8.3 => Exam 443 Content Management On Demand => Exam 444 Content Management Document Manager => Exam 445 (currently under development) DB2 9 Family Fundamentals => Exam 730 Database Administration for DB2 on Linux, Windows and UNIX => Exam 731 Database Administration for DB2 on z/OS => Exam 732 (currently under development) Application Development => Exam 733 (currently under development) Advanced Database Administration => Exam 734 (currently under development)
Dynamic Data Warehousing and Business Intelligence IBM Alphablox => Exam 715 Business Intelligence Solutions => Exam 705 DB2 Data Warehouse Edition => Exam 716 Information Integration Websphere IIS QualityStage V7.5 => Exam 416 WebSphere IIS DataStage Enterprise Edition V7.5 => Exam 415 Informix Informix Dynamic Server V9 => Exam 915 Informix 4GL V10 => Exam 917 Red Brick™ Warehouse => Exam 914 U2 U2 Family => Exam 713 UniVerse V10 => Exam 714 UniData V6.1 => Exam 711 To access the roadmaps, click Certification Roadmaps
I hope that the new year brings you and your family much joy, laughter and love.
svisser1 2700018UK9 2,720 Views
I started my career in database as a technical writer working on the Toronto Information Development team. This is the team of people who create the documentation that is available to support the product in manuals and online help. The team of people has changed much since I left 9 years ago... and the sheer volume of information that the team creates is incredible! I hope the job is as much fun now as it was during my 6 years.
(Interesting side note: One of the technical writers who is back on the team on an assignment is sci-fi author Karl Schroeder. Welcome back Karl!)
To see of list of the manuals that are available to support DB2 9, click List of DB2 Manuals. Here is the large number you can select from :
Release Notes * Release Notes for Fix Pack 1 * Net Search Extender Release Notes
Getting started * What's New * Quick Beginnings for DB2 Clients * Quick Beginnings for DB2 Servers * Getting started with DB2 installation and administration on Linux and Windows * Migration Guide
Administration * Administration Guide: Planning * Administration Guide: Implementation * Data Movement Utilities Guide and Reference * Data Recovery and High Availability Guide and Reference * National Language Support Guide and Reference * Performance Guide * Query Patroller Administration and User's Guide * Spatial Extender and Geodetic Data Management Feature User's Guide and Reference * System Monitor Guide and Reference * Troubleshooting Guide * XML Guide
Application development * Getting Started with Database Application Development * Developing ADO.NET and OLE DB Applications * Developing Embedded SQL Applications * Developing Java Applications * Developing Perl and PHP Applications * Developing SQL and External Routines * XML Extender Administration and Programming
Reference * Administrative API Reference * Administrative SQL Routines and Views * Call Level Interface Guide and Reference Vol.1 * Call Level Interface Guide and Reference Vol.2 * Command Reference * Precompiler Services APIs * Message Reference Vol.1 * Message Reference Vol.2 * SQL Reference Vol.1 * SQL Reference Vol.2 * XQuery Reference
Tutorial * DB2 Visual Explain Tutorial
Additional component information * DB2 Connect * Quick Beginnings for DB2 Connect Servers * Quick Beginnings for DB2 Connect Personal Edition * DB2 Connect User's Guide * IBM WebSphere Information Integration * Administration Guide for Federated Systems * ASNCLP Program Reference for Replication and Event Publishing * Configuration Guide for Federated Data Sources * SQL Replication Guide and Reference
Of course the standard these days is to deliver PDF versions of the manuals, but for those of you who like to have a printed copy sitting on your desk for easy access, you can buy printed / bound copies (in many but not all countries or regions) from the IBM Publications Center.
To order printed DB2 manuals: Order Printed DB2 Manuals.[Read More]
svisser1 2700018UK9 2,667 Views
I was just reminded yesterday about a blog entry that I read early last year about the book Understanding DB2(R): Learning Visually with Examples. The entry was from James F. Koopmann. The statement that I found most interesting was this:
Now it has been close to 15 years since I worked with DB2 on MVS and have over the years wanted to pick up DB2 again. But having enough time to pull away from Oracle and all the projects I seem to be doing never really gave me the opportunity. Honestly I can say that I am glad I waited. If I would have started with any other book instead of Understanding DB2 I may have gotten discouraged.
One of the best parts of reading this book was that it went into just enough detail for experienced database practitioners to obtain a clear understanding of the components of DB2. Often I was able to easily relate my Oracle, and old DB2 experience, to the concepts in this book. This made learning even easier. This is no easy. I am not even sure that the authors of this book sought out to do. But I can tell you from experience that I have in the past tried to relate database systems, such as Oracle, DB2, SQL Server, and Sybase, together and it is not an easy task to find the information needed. This book cuts through the chase and quickly and easily points out the physical and logical components of DB2 that now allows me to do this.
One of our training courses that was created specifically for those trained on other relational databases has been recently update and is another good way to expand existing skills to include DB2: CF282 Fast Path to DB2 9 for Experienced Relational DBA * Classroom * 3 Days *
svisser1 2700018UK9 3,524 Views
Here's another very long list for you.... this one lists all of the tutorials that were created on dWorks in the past year. Tutorials are very popular learning resources and they now cover most of our product areas. Check them out, or pass this information onto someone who you think would benefit from finding these learning materials.
Data Servers Cross Product The ultimate mashup, Part 6: Give the user control DB2 9 Fundamentals exam 730 prep, Part 1 DB2 9 Fundamentals exam 730 prep, Part 2 DB2 9 Fundamentals exam 730 prep, Part 3 DB2 9 Fundamentals exam 730 prep, Part 4 DB2 9 Fundamentals exam 730 prep, Part 5 DB2 9 Fundamentals exam 730 prep, Part 6 DB2 9 Fundamentals exam 730 prep, Part 7DB2 XML evaluation guide DB2 EveryplaceBuild end-to-end DB2 Everyplace mobile applications
DB2 for LUWDB2 9 table partitioningHello World, Part 7: DB2 for Linux, UNIX, and WindowsDevelop proof-of-concept .NET applications, Part 5: Create and consume Web services Kick-start takes you to the movies, Part 2 DB2 9 self-tuning memory management Shrink your database using DB2 9 row compressionDB2 Developer Workbench, Part 3: Developer Workbench and XMLThe ultimate mashup, Part 5: Change out Web servicesInformation on Demand Global Conference Web 2.0 Personal PlannerKick-start your J2EE apps using DB2 9 with pureXML and WebSphereSet up an SQL realm with DB2 Express-C, and WebSphere DB2 Developer Workbench and stored proceduresCreate XML-based stored procedures using the DB2 Developer WorkbenchSQL and XQuery tutorial for IBM DB2, Part 7: XML and XQuerySQL and XQuery tutorial for IBM DB2, Part 5: Data comparison SQL and XQuery tutorial for IBM DB2, Part 6: Data definition language and data control language The ultimate mashup, Part 1: Use and combine Web servicesDevelop a personal movie database app based on PHP and DB2 Create an XML-based Java application using DB2 9SQL & XQuery tutorial for IBM DB2, Part 4: Data analysisDB2 Developer Workbench concepts and basic tasksSQL & XQuery tutorial for IBM DB2, Part 3: Joins and unionsWire your application to DB2 pureXML data (Part 4)SQL & XQuery tutorial for IBM DB2, Part 1: Introduction to Aroma and SQLSQL & XQuery tutorial for IBM DB2, Part 2: Basic queriesDocument-level security using DB2 9 pureXML and LBAC DB2 9 DBA certification exam 731 prep, Part 1 DB2 9 DBA certification exam 731 prep, Part 2 DB2 9 DBA exam 731 prep, Part 3 DB2 9 DBA exam 731 prep, Part 4 DB2 9 DBA exam 731 prep, Part 5 DB2 9 DBA exam 731 prep, Part 6 DB2 9 DBA exam 731 prep, Part 7 Develop proof-of-concept .NET applications, Part 2 Develop proof-of-concept .NET applications, Part 3 Tutorial: DB2 label-based access control, a practical guide, Part 2: A step-by-step guide to protect sensitive data using LBAC Create database objects in DB2 Viper using .NET Integrate DB2 Express-C in apps with ActiveGrid LAMP StudioTutorial: Build Web services using IBM Database Add-ins for Visual Studio 2005: Highlights of the refreshDevelop DB2 applications using persistence-based frameworksDB2 and Rational: Working together, Part 2 Tutorial: Develop and test SQLJ programs for DB2 using Rational Application Developer Developing DB2 UDB User Defined Functions with .NET
DB2 for z/OSCreate z/OS procedures with Database Add-Ins for Visual Studio 2005
IMSIntegrate an IMS transaction into a Business Process Execution Language process
Classics/4GL/EGLCut out the Middle-Man: Use Informix Dynamic Server with J/Foundation to host a Java application service
CloudscapeApache Derby resources from the Web services perspective, Part 2: Producing and consuming WS-Notifications with DerbyApache Derby resources from the Web services perspectiveGet a head start with JDBC 4.0 using Apache Derby
U2A Hitchhiker's Guide to the UniVerse, Part 4: File and performance implicationsA Hitchhiker's guide to the UniVerse, Part 3Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 2: Sizing hashed files in UniVerse
Content ManagerContent Manager V8.3 Certification Exam TutorialsSearch legacy data sources
Document ManagerGet started with DB2 Document Manager, Part 2DB2 Document Manager: Build a simple client application (Tutorial)
OmniFind Discovery ServerStore selected OmniFind analysis results to a relational database
OmniFind Enterprise EditionSemantic search in IBM OmniFind Enterprise Edition, Part 2
DataStageIntegrated access to application data
Information IntegratorFederation Configuration Wizard
MDM-WebSphere Product CenterWebSphere Product Center - First steps
svisser1 2700018UK9 2,475 Views
Pearson Education, the publisher for the latest IBM Press book, Understanding DB2 9 Security has just issued an online coupon for this book, and I wanted to let you know first:
Coupon Expires: June 30, 2007Use code BOND5907 during the checkout step.Discount: 35% offISBNs: 0131345907 Understanding DB2 9 Security
If you've read the book and liked it, post here or in amazon to let others know!
svisser1 2700018UK9 2,722 Views
A friend / co-worker of mine has just self-published a book about her dog, Dylan. The book is filled with humourous stories about Dylan when he was a puppy. Lots of photos too! I haven't received my copy yet, but I'm quite impressed with the comments posted on amazon:
Dylanisms - Short Stories About a Dog by Ellice D. Uffer[Read More]
svisser1 2700018UK9 2,652 Views
Rav Ahuja put together the Voice of the DB2 Community - Podcast series that I wanted to tell you about. It includes interviews and discussions on topics vital to DB2 for Linux, UNIX, and Windows. The interviews are with technical leaders, users, and business partners, who offer their expert insights and discuss technology innovation and evolution.
Here are the topics that you will find on the site at this time:
DB2 9 Strategy and Overview [9 Nov 2006, 15 min, 5.2MB] Chief DB2 Architect, Tim Vincent, discusses DB2 9 strategic priorities and introduces the key features in this most significant version of DB2 for Linux, UNIX, and Windows. Tim also gives a sneak preview into the future of DB2.
Related resources: Webcast: DB2 9 Overview White paper: Introducing DB2 9 DB2 9 Certification [16 Nov 2006, 5 min, 1.8MB] Heather Ramsey, Training and Certification Program Manager, talks about the roadmap and the resources available for getting DB2 9 certified.
Related resources: Website: Prep for DB2 9 administration certification Quest Toad for DB2 [23 Nov 2006, 5 min, 1.7MB] Jim Wankowski and Amit Agarwal, technology specialists at Quest Software, discuss Toad for DB2, a database development and administration tool.
Related resource: Website: Toad for DB2 DB2 9 pureXML usage scenarios [27 Nov 2006, 6min, 2MB] Matthias Nicola from the DB2 team in IBM Silicon Valley Lab talks to the common use cases for DB2 9 pureXML technology, including a couple of industry specific scenarios.
Related resources: Webcast: DB2 9: Unlock your XML PotentialRedbook: DB2 9 pureXML Guide DB2 9 Table Partitioning overview [28 Nov 2006, 5min, 1.8MB] Kevin Beck from the DB2 development team explains how this new DB2 9 feature can be used for partitioning data using range values and simplify roll-in and roll-out.
Related resources: Webinar: DB2 9 Range Partitioning and Large RID Support Article: Introducing Table Partitioning in DB2 9
Enjoy listening... instead of reading, for a change!Susan[Read More]
svisser1 2700018UK9 2,954 Views
Today I'd like to tell you about the DB2 Chat with the Lab series of webcasts that feature Lab experts who have developed breakthrough technology. All of the sessions listed here are replays, but a new one is coming in February about Performance Tuning. Listen live so you can get YOUR questions answered.
Here is a list of the chats that were recorded earlier: * SAP on DB2 LUW: An Inside Look at TechnologyReplay of this Chat held on December 12, 2006 is now available.Learn how DB2 is optimized for SAP applications, focusing on features such as multi-dimensional clustering, automatic storage management, self tuning memory management, automated table maintenance, deep compression, online inplace reorganization, High Availability Disaster Recovery, and the "Optimized for SAP" switch. Our speakers, Matt Huras, IBM Distinguished Engineer, and Torsten Ziegler, Development Manager with SAP, cover how the key capabilities of DB2 9 are exploited through SAP applications and how they provide unique value to DB2 and SAP customers.
* DB2 9: Simplify database management with Automatic StorageReplay of this Chat held on November 14, 2006 is now available.Managing database storage can be a resource intensive and a time consuming task. The recently introduced Automatic Storage in DB2 9 represents a major leap forward. This feature can associate a set of storage paths with a database, create table spaces on these storage paths without explicitly specifying storage or containers, and let DB2 automatically extend and add containers on the fly. All these capabilities contribute to lowering the Total Cost of Ownership (TCO) of your database environment by substantially reducing the amount of storage administration that database administrators have to perform. This Chat with the Lab will dive into the details on Automatic Storage and the role it plays in DB2 for LUW's storage strategy.
Join Sal Vella, VP of DB2 development, Aamer Sachedina, Senior Software Engineer in DB2 Development, to learn about Automatic Storage in DB2 9, and understand how you can make your job as a DBA much easier. * DB2 9: Securing your data with Label-Based Access ControlReplay of this Chat held on October 12, 2006 is now available.Securing information assets and restricting data access to only those with the need to know is becoming a significant challenge for many organizations, especially in highly classified environments such as government agencies, armed forces, healthcare institutions, etc. Label-Based Access Control (LBAC) is a new security capability in DB2 9 that allows you to control access to your data at a very granular level. With LBAC you can limit data access at the row and/or column level based on security labels. Unlike traditional implementations of mandatory access control (e.g., Multilevel Security), the DB2 LBAC capability allows you to tailor the security label definition to best suit your application specific needs. DB2 LBAC integrates well with other DB2 capabilities (like data partitioning) and can be combined with such capabilities to offer an even stronger security.
Join Sal Vella, VP of DB2 Development, and Walid Rjaibi, Senior DB2 Software Engineer - Security and Privacy, for a deep dive into the LBAC capability in DB2 9 on Linux, UNIX, and Windows. * DB2 9 pureXML: Unlock Your XML PotentialReplay of this Chat held on September 20, 2006 is now available.If you are an IT manager, database administrator, solutions architect or application developer, you are already aware that working with XML data has become increasingly important in your job. XML is a backbone for service-oriented architectures — and XML-based data standards are fueling information exchange and integration in virtually every industry.
Join Sal Vella, vice president of DB2 development, Matthias Nicola, DB2 XML performance expert, and Rav Ahuja, DB2 program manager, for an in depth look at the innovative pureXML technology in DB2 9, and understand how you can unlock the latent potential of your XML data. * Turbo Charge Your Data Server with DB2 9 Query and System Optimization ToolsReplay of this Chat held on August 29, 2006 is now available.Everyday database administrators (DBAs) are under pressure to take an organization's data assets to the next level by optimizing data server throughput and query activities. This webcast is about easy-to-implement tools and strategies that can simplify your DBAs work life and boost the value of your data server. You will learn about DB2 Performance Expert and DB2 Query Patroller tools and how to:* Gain control of and optimize DB2 on Linux, UNIX, and Windows * Improve throughput response time and consistency * Automatically prioritize, coordinate and control multiple queries * Generate valuable reports about current and long-term database behavior
Join Sal Vella Vice President, DB2 for Linux, Unix and Windows; Dwaine Snow, IBM senior product manager; and Alice Ma, IBM Information Management DB2 Tools Specialist for this one-hour complimentary Webcast and find out how you can take back control of your database environment. * DB2 9: Automatic Database Configuration and Memory TuningReplay of this Chat held on July 20, 2006 is now available.IBM has been a pioneer in autonomic computing. A number of self-configuring, self-optimizing, and self-healing capabilities were introduced in the earlier DB2 releases. DB2 9 continues along this strategy of helping you derive more value from your data, while spending less time managing it. This new version contains revolutionary features like self-tuning memory and automatic configuration of newly created databases. These autonomic features are designed to make database administration effortless, improve administrator productivity, and lower ownership costs.
Join Sal Vella, VP of DB2 development, and Adam Storm, DB2 autonomic computing developer, for an in-depth look at some of the new autonomic capabilities in DB2 9. * DB2 9: Using Data Compression to Cut CostsReplay of this Chat held on June 15, 2006 is now available.Disk storage systems can often be the most expensive components of a database solution. For large warehouses or databases with huge volumes of data, the cost of the storage subsystem can easily exceed the combined cost of the hardware server and the data server software. Therefore even a small reduction in the storage subsystem can result in substantial cost savings for the entire database solution. Data row compression in DB2 9 is a remarkable new feature that can reduce storage requirements, improve I/O efficiency, and result in savings of up to 80%.
Join Sal Vella, VP of DB2 Development, Bill Minor, DB2 Development Manager, and Chris Eaton, DB2 Product Manager, to take you through a deep dive into DB2 9's compression technology and its impact for your business. * DB2 9: Range Partitioning and Large RID supportReplay of this Chat held on May 24, 2006 is now available.DB2 9 contains innovative features for delivering information on demand and scaling databases to new levels. The Table (Range) Partitioning capabilities in DB2 9 provide a number of advantages including better query performance, improved large table manageability, and dynamic data roll-in/roll-out. The Large Row Identifier (RID) allows for creation of tables and indexes that are terabytes in size. Together these features enable the ability to create and easily manage databases with virtually unlimited capacity, and are especially beneficial in large data-warehousing environments. Join Sal Vella, VP of DB2 Development, and Matt Huras, IBM Distinguished Engineer and lead DB2 Architect, for an in-depth look at the new Table Partitioning and Large RID support in DB2 9 on Linux, UNIX, and Windows. * DB2 9 OverviewReplay of this Chat held on April 6, 2006 is now available.DB2 9 is the code-name for a new version of DB2 due out in summer 2006 that introduces numerous innovations to help organizations realize the business value of information. These innovations include the industry’s first hybrid data server - serving data from both pure relational and pure XML structures. DB2 9 also includes other compelling enhancements such as additional optimizations for powering SAP faster with lower cost than alternatives, new storage optimization advances that will dramatically reduce storage costs, and advanced security capabilities to control access and meet compliance requirements.
Join Sal Vella, VP of DB2 Development, and Peter Kohlmann, Senior DB2 Product Manager, from the IBM Toronto Lab to learn about the exciting new capabilities available in DB2 9 on Linux, UNIX, and Windows platforms and understand:* How DB2 9 leads the way in providing Information as a Service* How DB2 9 helps you manage your business, not your database* How DB2 9 is part of an agile development environment, and* How DB2 9 is even more secure and resilient
svisser1 2700018UK9 14,782 Views
Have you ever used an online book engine such as Safari or Books 24x7? Both Safari and Books 24x7 are online book engines that give you access to thousands of retail books. These engines are quite powerful and very suitable in today’s electronic world. IBM Press books are available in both engines.
Safari is an online book engine that is jointly owned by Pearson and O’Reilly. All books that are published by these publishers are automatically formatted for Safari and made available to anyone who has a subscription to Safari. If you have a subscription, you can read the entire book electronically, search for a keyword across the entire library or a subset of the library, bookmark well-used pages in the books you’ve read, make notes for your co-workers who also have subscriptions, download chapters to print or read offline, or copy code directly from the book into your programs. You can sign up for a 2-week trial from Safari Online. Monthly subscription rates can be as low as $19.99 depending on the number of books you choose for your bookshelf.
Books 24x7 has all the same features as Safari, but a slightly different set of books. Books 24x7 is a direct competitor to Safari and as such, typically carry only the books published outside of Pearson or O’Reilly. Exceptions are made when Books 24x7 buys the electronic rights to use a Pearson or O’Reilly book. This was an arrangement that was made for the IBM Press books that are published through Pearson. You can get further information about the subscription details and prices from Books 24x7.
IBM employees have a paid subscription to Books 24x7 and you can sign up to use it through this internal site: Internal IBM Site for Books 24x7.
I’ve used Books 24x7 to review books and table of contents, searched for specific topics in a set of books, but one of the key benefits is their newsletter. At least every week I’m sent a note telling me about the new books that are available on the engine. I end up seeing titles that are very interesting and useful that I wouldn’t have known about without this newsletter! Another thing that I’ve recently discovered is that some of the books have a mp3 teaser available that allows you to listen to someone reading part of the book to you. This is great for commuters or for anyone who wants a break from reading!
Let me know if you’ve tried these engines and if you see benefits to using them.
Many of us are unable to take the time to go to a conference for a week to build our skills. If you would like to go to a face-to-face event to learn about a new product or technology with taking the time or expense of a full conference, see if there is a technical briefing planned for your city.
As an example, you may wish to consider attending the following technical briefing: Experience the power of Information Management solutions
This is a half-day briefing that covers the following:
* Learn how DB2 9 can help you reduce costs and improve service levels.
* Learn about DB2 9 enhancements for working with SAP.
* See how Information Management software integrates data better than other vendors.
* Gain an understanding of how the new IBM data server can unlock the latent potential of XML with performance and development savings.
* See how "Information as a Service" delivers business information accurately, consistently, timely, and coherently across disparate operating systems, applications and legacy systems.
* Learn how IBM solutions can break down information silos by connecting product, location, trading partner, organization, and terms of trade seamlessly across the Web, intranets, collaboration workspaces, file shares, and content management systems.
* Minimize the total cost of ownership by implementing a solution that provides pre-built, secure integrations to Lotus Domino, WebSphere Portal, FileNet, Documentum, and Open text. Mitigate the risk of exposing content by delivering a highly secure search experience. During this briefing, you'll see demos for:
* DB2® 9 * DB2 9 Development Center and pureXML™ * IBM Information Server (including WebSphere QualityStage, WebSphere DataStage, and WebSphere Federation Server) * Dynamic Warehousing Solutions -- DB2 Data Warehouse Edition & Alphablox * IBM OmniFind
Note: Click on Select location and register to find where and when this technical briefing is taking place.
svisser1 2700018UK9 2,753 Views
There were plenty of notes about the DB2 wiki when it first launched, but have you had a chance to benefit from it yet?
The purpose of this wiki is to provide technical information about using DB2 on Windows/Unix/Linux platforms in a slightly less formal manner than the product documentation. The wiki was started to support DB2 Express C users who have downloaded DB2 for free, but since DB2 Express C is largely the same as other editions of DB2, all can benefit from this information.
If you would like to ask questions about the product, try the Discussion/ Help forums. You'll see a lot of ongoing activity on these forums, so join in if you can.
svisser1 2700018UK9 2,148 Views
In the December Edition of DB2 Magazine, the feature article is
Tracking The TruthBy Cynthia Harvey
The article is a follow up to the joint research project from IBM and the National Geographic Society, called the The Genographic Project. The project asked for volunteers to send a sample of their DNA to project so it could be analyzed and tracked to help determine the origins of people. Apparently there are unique DNA markers that are passed from parent to child that rarely mutate, allowing the scientists to trace the migration paths of the earliest humans.
I was interested in this story for two reasons. First of all, I've always been interested in family history, so I was one of the volunteers who sent DNA in. I received my report a couple of years ago and found it very interesting. The second reason is that the technology used to store the DNA and to analyze the very large amount of collected data is IBM technology, specifically DB2 and WebSphere.
Read about the technical challenges that the team was faced with and how they overcame those challenges with the help of IBM as their technology partner.
DB2 Magazine: http://www.db2mag.com/
svisser1 2700018UK9 2,501 Views
Thanks to Melissa, Kate, and Heather from my team for putting this much-needed DVD together!
This interactive self-study DVD helps you to get started on IBM Content Manager Enterprise Edition Version 8.3 to take control of your information.
IBM Content Management software captures, stores, manages, integrates and delivers all forms of digital content across a company’s entire value chain from employees to customers to suppliers and partners - to create real business value.
This DVD provides you with a set of learning resources to help you discover ways to increase productivity and turn business information into business value, including:
* Learn about the latest tutorials, Redbooks, and articles about Content Manager * Discover how Content Manager can help you leverage business information * Prepare to become an IBM Certified Solution Designer - DB2 Content Manager V8.3 with our series of nine Content Manager Tutorials * Listen to IBM and industry experts discuss the key benefits Content Manager * Check out our latest case studies and read though our informative whitepapers
To order your complimentary copy, you must complete a brief online order form.
Side note: I proctored Exam 443 for someone this afternoon who was taking the exam for a second time. The first time he took the exam, he was unable to pass it. This time he was able to pass the exam with a near perfect score! How did he do it? He told me that since his first attempt, he has been using CM V8.3 extensively as part of his job. Experience using the product, along with reading the available training resources is an excellent strategy for passing a certification exam.
svisser1 2700018UK9 3,065 Views
The good news is that Roger Sanders has just completed the manuscript for the Exam 730 Study Guide. The bad news is that it won't be published until May, just in time for the IDUG NA Conference in San Jose. By the way, Roger will also be running his extremely popular and well-received crammer course at the IDUG NA conference as well. See the conference agenda for information.
I've known Roger since 1997 when he first began writing retail books for DB2. In the past 10 years, Roger has been successful at writing numerous books, redbooks, articles, tutorials and ebooks. By far, the most prolific author I know... although Paul Zikopoulos is a close rival :)
I recommend Roger's publications for a number of reasons. First of all, he is an excellent writer! He makes complicated topics easy to understand and is successful at writing material that is NOT BORING. Secondly, when it comes to study guides, Roger makes sure that he creates many extra questions for readers to try to answer and then learn from the answer. His up coming book has 150 study questions! And some of the explanations take over a page to explain why the correct answer is correct.
Not including the study guide mentioned above, here is a list of the publications that Roger has published. I've added links to the current content.
Using the IBM System Storage N Series with Databases (co-author)IBM Redbooks, 2007 (To be published early 2007)
Integrating IBM DB2 with the IBM System Storage N Series (co-author)IBM Redbooks, 2006 (ISBN 0738496855, 102 pages)
Using IBM DB2 UDB with IBM System Storage N Series (co-author)IBM Redbooks, 2006 (ISBN 0738496820, 130 pages)
DB2 Universal Database V8.1 Certification Exam 703 Study GuideIBM Press/Prentice Hall, 2004 (ISBN 0131840495, 499 pages)Also available in Books 24x7 and Safari.
DB2 Universal Database V8.1 Certification Exam 701/706 Study GuideIBM Press/Prentice Hall, 2004 (ISBN 0131840487, 486 pages)Also available in Books 24x7 and Safari.
DB2 Universal Database V8.1 Certification Exam 700 Study GuideIBM Press/Prentice Hall, 2003 (ISBN 0131424653, 416 pages)Also available in Books 24x7 and Safari.Translated and printed in Russian
DB2 UDB Exploitation of NAS Technologies (co-author)IBM Redbooks, 2002 (ISBN 0738425222, 288 pages)
All-in-One DB2 Administration Exam GuideMcGraw-Hill, 2002 (ISBN 0072133759, 840 pages)Translated and printed in Chinese
DB2 Universal Database SQL Developer’s GuideMcGraw-Hill, 2000 (ISBN 0071353895, 834 pages)Translated and printed in Chinese
DB2 Universal Database API Developer’s GuideMcGraw-Hill, 2000 (ISBN 0071353925, 640 pages)Translated and printed in Chinese
DB2 Universal Database Call Level Interface (CLI) Developer’s GuideMcGraw-Hill, 1999 (ISBN 0071345728, 740 pages)
ODBC 3.5 Developer’s GuideMcGraw-Hill, 1999 (ISBN 0070580871, 975 pages)
The Developer’s Handbook to DB2 for Common ServersMcGraw-Hill, 1997 (ISBN 007057725, 1146 pages)
Database Cloning (Distributed DBA Column)DB2 Magazine, Quarter 4, 2006 – Volume 11 Number 4
What’s it to you? DB2’s XML support is here. Are you ready to handle it? (Distributed DBA Column)DB2 Magazine, Quarter 3, 2006 – Volume 11 Number 3
Beyond the Default (Part 2) (Distributed DBA Column)DB2 Magazine, Quarter 2, 2006 – Volume 11 Number 2 Beyond the Default (Distributed DBA Column)DB2 Magazine, Quarter 1, 2006 – Volume 11 Number 1
Split Mirroring (Distributed DBA Column)DB2 Magazine, Quarter 4, 2005 – Volume 10 Number 4
Rollforward Recovery (Distributed DBA Column)DB2 Magazine, Quarter 3, 2005 – Volume 10 Number 3
Protecting DB2’s Image (Distributed DBA Column)DB2 Magazine, Quarter 2, 2005 – Volume 10 Number 2
The Cornerstone of Crash Recovery (Distributed DBA Column)DB2 Magazine, Quarter 1, 2005 – Volume 10 Number 1
Performance Monitoring, Part 3 (Distributed DBA Column)DB2 Magazine, Quarter 4, 2004 – Volume 9 Number 4
Improving DB2 Universal Database PerformanceCertification Magazine, October, 2004
Performance Monitoring, Part 2 (Distributed DBA Column)DB2 Magazine, Quarter 3, 2004 – Volume 9 Number 3
Performance Monitoring, Part 1: It’s a Snap(shot)(Distributed DBA Column)DB2 Magazine, Quarter 2, 2004 – Volume 9 Number 2
Basic Performance Tuning, Part 3 (Distributed DBA Column)DB2 Magazine, Quarter 1, 2004 – Volume 9 Number 1
Basic Performance Tuning, Part 2 (Distributed DBA Column)DB2 Magazine, Quarter 4, 2003 – Volume 8 Number 4
Basic Performance Tuning, Part 1 (Distributed DBA Column)DB2 Magazine, Quarter 3, 2003 – Volume 8 Number 3
Demystifying FFDC DataDB2 Magazine, Quarter 1, 2003 – Volume 8 Number 1
Understanding DB2 for Common Server’s Two-Phase Commit Process,DB2 Magazine, Spring 1998, Volume 3 Number 1,
Developing Database Applications with Call Level Interface in DB2 for Common Servers,IDUG Solutions Journal, Volume 4 Number 2, May 1997
Database Recovery Mechanisms for DB2 for Common Servers,Platinum Edge, Volume 3 Number 4, December 1996
TECHNICAL WHITE PAPERS:
Integrating PeopleSoft 8.4 GL Batch with IBM DB2 UDB ESE V8.1 (64 Bit) for AIX on IBM eServer pSeries p630 and Network Appliance FAS960 Enterprise ServerNetwork Appliance, Inc. (Technical Report 3279)http://www.netapp.com/tech_library
DB2 Universal Database Enterprise Server Edition V8.1 - Basic Performance Tuning GuidelinesNetwork Appliance, Inc. (Technical Report 3290)http://www.netapp.com/tech_library
IBM DB2 UDB Enterprise Server Edition V8.1 for UNIX: Integrating with a NetApp FilerNetwork Appliance, Inc. (Technical Report 3272)http://www.netapp.com/tech_library
DB2 Universal Database Enterprise Edition V7.2 - Basic Performance Tuning GuidelinesNetwork Appliance, Inc. (Technical Report 3222)http://www.netapp.com/tech_library
DB2 Universal Database Enterprise Edition V7 for Solaris: Integrating with DAFS Database Accelerator (DDA) and a Network Appliance FilerNetwork Appliance, Inc. (Technical Report 3185)http://www.netapp.com/tech_library
DB2 UDB Enterprise Edition V7 for Windows NT, Backup and Recovery Using a NetApp FilerNetwork Appliance, Inc. (Technical Report 3126)http://www.netapp.com/tech_library
Accessing Data from Your PC Using Version 7 of the SAS System,Proceedings of the 23rd Annual SAS Users Group International Conference, March 1998
OTHER: Tutorials: DB2 V9.1 Database Administration for Linux, UNIX, and Windows Certification Preparation - Part 4: Database Monitoring, 2006
Tutorials: DB2 V9.1 User Certification Preparation - Part 6: Database Concurrency, 2006
DB2 UDB Triggers,Knowledge Xpert for DB2, Quest Software, 2005
DB2 UDB Error Handling,Knowledge Xpert for DB2, Quest Software, 2005
DB2 UDB SQL Overview,Knowledge Xpert for DB2, Quest Software, 2004
Demystifying First Failure Data Capture (FFDC) Data,Knowledge Xpert for DB2, Quest Software, 2004
Understanding DB2 UDB’s Two-Phase Commit Process,Knowledge Xpert for DB2, Quest Software, 2004
Basic DB2 UDB Performance Tuning Guidelines,Knowledge Xpert for DB2, Quest Software, 2004
DB2 UDB’s Snapshot Monitor,Knowledge Xpert for DB2, Quest Software, 2004
Managing Log Files with a User Exit Program,Knowledge Xpert for DB2, Quest Software, 2004
Tutorials: DB2 V8 Application Development Certification Preparation - Part 3 of 7: Embedded SQL Programming,http://www.ibm.com/developerWorks, 2004
Tutorials: DB2 V8 Application Development Certification Preparation - Part 4 of 7: CLI/ODBC Programming,http://www.ibm.com/developerWorks, 2004
Tutorials: DB2 V8.1 Family Fundamentals Certification Preparation - Part 6: Database Concurrency,http://www.ibm.com/developerWorks, 2003
Tutorials: DB2 V7.1 User Certification Preparation - Part 6: Database Concurrency,http://www.ibm.com/developerWorks, 2002