Having problems with message search?
All,
Here's my installment of DB2 Updates over the last month.
Jay Allen
-------------------------------------------------------------------------------------
Announcement - IBM to acquire Cognos
(http://www-306.ibm.com/software/data/info/cognos/)
On November 12, 2007 IBM announced that it has signed an agreement to acquire Cognos. Cognos is a recognized industry leader and one of the largest providers of business intelligence and performance management solutions, with more than 25,000 customers and over 3,000 partners. Together, IBM and Cognos will become the industry's leading provider of technology and services for Business Intelligence and Performance Management.
-------------------------------------------------------------------------------------
Redbook - LOBs with DB2 for z/OS: Stronger and Faster
(http://www.redbooks.ibm.com/abstracts/sg247270.html?Open)
The requirements for a database management system (DBMS) have included support for very large and complex data objects.
DB2 UDB for OS/390 Version 6 introduced the support for large objects (LOBs): they can contain text documents, images, or movies, and can be stored directly in the DBMS with sizes up to 2 gigabytes per object and 65,536 TB for a single LOB column in a 4,096 partition table. The introduction of these new data types has implied some changes in the administration processes and programming techniques. The book Large Objects with DB2 for z/OS and OS/390, SG24-6571, introduced and described the usage of LOBs with DB2 for z/OS at Version 7 level.
Major enhancements for LOB manipulation have been introduced with DB2 UDB for z/OS Version 8 and DB2 Version 9.1 for z/OS (DB2 9 in this book). These enhancements include performance functions such as the avoidance of LOB locks and DRDA LOB flow optimization, usability functions such as file reference variables, FETCH CONTINUE, and the automatic creation of objects. DB2 utilities provide integrated support with LOAD and UNLOAD, Cross Loader, REORG, CHECK DATA, and CHECK LOB.
In this IBM Redbooks publication, we provide a totally revised description of the DB2 functions for LOB support as well as useful information about how to design and implement LOBs. We also offer examples of their use, programming considerations, and the enhanced processes used for their administration and maintenance. We also detail how SAP solutions use LOBs.
This book replaces the previous book, Large Objects with DB2 for z/OS and OS/390, SG24-6571, for DB2 Version 8 and Version 9.1.
-------------------------------------------------------------------------------------
Redbook - DB2 9 for z/OS Technical Overview
(http://www.redbooks.ibm.com/abstracts/sg247330.html?Open)
IBM DATABASE 2 Version 9.1 for z/OS (DB2 9 for z/OS throughout this publication) is the thirteenth release of DB2 for MVS.
It brings improved synergy with the zSeries hardware and more opportunities to drive business value in the following areas:
-- Business insight innovations
- Rich hybrid support for relational and pure XML data.
- Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP.
- A brand new user interface for the Query Management Facility to view and analyze data from either a workstation client or an ordinary Web browser.
-- Cost savings through optimized innovations
- Streamlined security and regulatory compliance through the implementation of roles, network-trusted contexts, and enhanced auditing.
- Performance-boosting innovations such as load and reorg CPU reductions, improved varying length data, logging, and insert performance.
- Query management enhancements to make accessing data even faster and more accurate with indexing improvements.
-- Business resiliency innovations
- Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages.
- DB2 restart improvements enhancing performance usability and availability in data sharing environment.
This book introduces the enhancements made available with DB2 9 for z/OS. Its helps you understand the new functions, justify investment in migrating, and plan for exploiting the key new capabilities.
-------------------------------------------------------------------------------------
Redbook Draft - DB2 9 for z/OS: New Tools for Query Optimization
(http://www.redbooks.ibm.com/redpieces/abstracts/sg247421.html?Open)
he cost-based optimizer of 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 brand 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 new functions in DB2 9 for z/OS and two tools: IBM DB2 Optimization Expert for z/OS and IBM Optimization Service Center for DB2 for z/OS.
This paper 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.
-------------------------------------------------------------------------------------
An Expert's Guide to DB2 Technology (by Chris Eaton) - Threaded Engine in DB2 9.5
(http://blogs.ittoolbox.com/database/technology/archives/threaded-engine-in-db2-95-20638)
One of the biggest new features in DB2 9.5 (and one of my personal favorites) is the new threaded engine. In DB2 9.1 and all prior releases on AIX, HP-UX, Solaris and Linux, the DB2 engine was process based. That means that all functions run in operating system processes. For example each db2agent is an individual process; all page cleaners and prefetchers were operating system processes; the log writers, readers and archivers were all processes.
Now in DB2 9.5 all of these (and more) are all threads within a single DB2 process. So what's the big deal? Well having a threaded engine gives every a number of benefits:
* The first being performance gains since the overhead and context switching is reduced significantly
* Memory savings since all threads share the same address space and now DB2 has a lower per agent footprint (around 1MB per DB2 agent savings)
* But the most important reason in my mind is that it dramatically improves usability in several key areas
-------------------------------------------------------------------------------------
An Expert's Guide to DB2 Technology (by Chris Eaton) - Automatic Compression in DB2 9.5
(http://blogs.ittoolbox.com/database/technology/archives/automatic-compression-in-db2-95-20027)
I have written a number of blog postings on Compression in DB2 9.1 (just search my blog by putting the word Compression in the search box on the top right corner of this page to find them).
Now there are some nice new enhancements to compression in DB2 9.5.
-------------------------------------------------------------------------------------
An Expert's Guide to DB2 Technology (by Chris Eaton) - Compression of XML in DB2 9.5
(http://blogs.ittoolbox.com/database/technology/archives/compression-of-xml-in-db2-95-20079)
In my last entry I posted about the new Automatic Compression capability in DB2 9.5. In this posting I wanted to talk about inline XML as well as compression for XML.
-------------------------------------------------------------------------------------
An Expert's Guide to DB2 Technology (by Chris Eaton) - More Compression Enhancements
(http://blogs.ittoolbox.com/database/technology/archives/more-compression-enhancements-20727)
In a previous posting from late last month I talked about the new automatic compression capabilities in DB2 9.5 as well as the compression for in-lined XML. There are two other compression enhancements that you should be aware of in DB2 9.5.
-------------------------------------------------------------------------------------
An Expert's Guide to DB2 Technology (by Chris Eaton) - New Administrative Views in DB2 9.5
(http://blogs.ittoolbox.com/database/technology/archives/new-administrative-views-in-db2-95-20528)
I'm just back from IDUG in Athens where I attended many great sessions and found lots of new material for my blog. I have already written many blog postings on the new administrative views in DB2 9 (search my blog for SYSIBMADM). So let's start off with some new administrative views that I learned about from Jessica Escott's session on monitoring your database through SQL.
-------------------------------------------------------------------------------------
An Expert's Guide to DB2 Technology (by Chris Eaton) - Simplified DPF backup
(http://blogs.ittoolbox.com/database/technology/archives/simplified-dpf-backup-20823)
In previous postings I mentioned that there were simplifications to the restore and rollforward commands (including the RECOVER command) that helped to make recovery simpler in DPF. Now in DB2 9.5, IBM has added simplification to the BACKUP process for DPF customers.
-------------------------------------------------------------------------------------
Announcement - IBM Information Server for System z: Leverage your mainframe as an information integration platform
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-316)
IBM Information Server for System z achieves new levels of information integration speed and flexibility on the mainframe:
* Comprehensive, unified foundation for enterprise information architectures, native on the mainframe and scalable to any volume and processing requirement
* Auditable data quality as a foundation for trusted information across the enterprise
* Metadata-driven integration, delivering breakthrough productivity and flexibility for integrating and enriching information
* Consistent, reusable information services that enable trusted mainframe data to be easily published and accessed by people, processes, and applications
* Accelerated time-to-value with proven, industry-aligned solutions and expertise
* Broadest and deepest connectivity to common mainframe data sources, along with sources residing off of the mainframe, for a complete view of information
* Ability to leverage:
o Existing mainframe resources to perform new categories of high-impact projects
o Scalability, security, manageability, and reliability of the mainframe
* Ability to add mainframe information integration work load with no impact to your z/OS operational costs
* Flexibility to perform information integration directly on the mainframe using the same skills and logic designed for other platforms
-------------------------------------------------------------------------------------
Announcement - IBM WebSphere Federation Server V9.5 delivers information clients can trust
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-301)
WebSphere Federation Server enables you to address a broader range of data integration problems. It provides new features and improvements in the following areas:
* Application development enhancements enable you to integrate XML data and Web services into a single virtual view of your enterprise information.
* Security enhancements deliver powerful new strategies for implementing security policies throughout the unified view of the enterprise.
* Configuration is enhanced with autonomic features that deliver simplified and more foolproof administration.
* Additional support for remote stored procedures enables users of DB2 family databases and Microsoft SQL Server to leverage their stored procedures throughout the unified view of the enterprise.
-------------------------------------------------------------------------------------
Announcement - IBM Entity Analytic Solutions V4.2 helps global organizations proactively respond to growing threat and fraud pressures
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-311)
IBM Entity Analytic Solutions, the world's leading solution for Entity Resolution and Analysis, delivers the following capabilities:
* Identity Resolution answers the question "Who is who," allowing you to identify people, organizations, or things.
* Relationship Resolution answers the question "Who knows who," allowing you to determine what relationships exist between people, organizations, or things.
* Anonymous Resolution allows you to share this information with third parties without disclosing the identity of the person or organization to whom the information relates, thereby avoiding contravention of data protection and similar laws.
-------------------------------------------------------------------------------------
Announcement - IBM Homogeneous Replication Feature for DB2 Enterprise Server Edition V9.5
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-291)
IBM Homogeneous Replication Feature for DB2 Enterprise Server Edition V9.5.0 provides high speed queue-based replication services to distribute, consolidate, and synchronize data in support of live reporting, high availability, and query offload applications.
As an option for all editions of DB2 Enterprise Server Edition V9.5 and DB2 Warehouse Edition V9.5, the homogeneous replication feature allows you to copy data on a regular basis to multiple DB2 or IDS remote databases. The homogeneous replication feature is part of a larger IBM solution for replicating data in small and large enterprises.
New features:
* Lock contention reduced for z/OS® batch jobs
* XML columns replication
* New option for maintaining target tables
* Promote Q replication to another system
* DECFLOAT data type supported for Q replication
* Replication dashboard
-------------------------------------------------------------------------------------
Announcement - IBM Global Name Recognition V3.1 delivers enhanced performance and faster time to value
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-295)
IBM Global Name Recognition (GNR) technology can be used to develop applications that spot fraud and other threats. It:
* Increases precision for name processing by delivering cultural classification as a range of scores for automated processing
* Adds intelligence to automated name processing by applying business rules specific to the name's culture
* Increases accuracy and selectivity by examining each possible name, rather than using a key-based approach
* Increases usefulness of search results by delivering matched names in ranked order with a confidence score for automated processing
* Reduces false positives by intelligently processing the cultural variations found in names
-------------------------------------------------------------------------------------
Announcement - IBM Base Warehouse Feature for DB2 V9.5 and IBM Enterprise Warehouse Feature for DB2 V9.5
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-297)
There are now two new ways to add data warehousing to your DB2® environment. These offerings, Base Warehouse Feature for DB2 and Enterprise Warehouse Feature for DB2, enable customers who have purchased long term maintenance agreements for the DB2 Enterprise Server Edition (ESE) instances and do not want to trade them in to migrate to DB2 Warehouse.
In addition, the Database Partitioning Feature (DPF) is being replaced by the Base Warehouse Feature for DB2. Base Warehouse Feature contains not only DPF but a number of key tools to make building a data warehouse much easier.
-------------------------------------------------------------------------------------
Announcement - IBM delivers IBM Data Studio Developer V1.1 and IBM Data Studio pureQuery Runtime V1.1
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-302)
IBM Data Studio pureQuery Runtime V1.1:
* Bridges the gap between data and Java technology by harnessing the power of SQL within an easy-to-use Java data access platform
* Improves the security and performance of characteristics of your Java applications
* Deploys applications to query in-memory collections and databases using one single API
* Deploys advanced pureQuery applications using static SQL to improve application performance and management to deliver predictable response
IBM Data Studio Developer V1.1:
* Develops database applications faster with integrated query editor for SQL and XQuery
* Optimizes your applications and queries with ease
* Builds and tests your stored procedures (Java and SQL) with the interactive routine debugger
* Accelerates Java developer productivity with pureQuery
* Rapidly develops or customizes the SQL inside Java applications
* Auto-generates test applications for your pureQuery applications
-------------------------------------------------------------------------------------
Support Flashes
- DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
- LANfree DB2 Backup to TSM Recommendation
Tivoli® Storage Manager (TSM) supports LAN-free data movement. However, it is recommended that when backing up DB2®, archive logs should be backed up over the LAN. This solution is for DB2 running on AIX®, HP-UX®, Linux®, and Solaris®.
- Installing IBM JDK on Linux platforms
This technote clarifies how to properly configure the IBM® Java™ Developer's Kit on Linux® platforms. Incorrect configuration usually results in SQL4301 returned when calling SQLJ.INSTALL_JAR() or Java stored procedures and UDFs.
- Known issues for DB2 on AIX 4.3.3, 5.1, 5.2, and 5.3
This document describes known AIX® issues and APARs related to DB2®. Fixes for the AIX APARs described below can be obtained from Fix Central at http://www.ibm.com/servers/eserver/support/unixservers/aixfixes.html
- Redistribution enhancements announced in Viper 2 Open Beta deferred to DB2 Version 9.5 Fix Pack 1
The data redistribution enhancements announced in the DB2® Viper II Open Beta will now be available in DB2 Version 9.5 Fix Pack 1. This technote summarizes the documentation changes made in support of this change in availability.
- DB2 Version 9.5 migration roadmap
Upgrading to DB2® Version 9.5 might require migration of your environment components. These components are DB2 servers, DB2 clients, database applications, and routines. Migrating these components requires an understanding of the DB2 database product migration concepts and the DB2 database products.
This migration roadmap will help you navigate through the available information and resources related to migrating DB2 Version 9.5 from DB2 Universal Database (DB2 UDB®) Version 8 or DB2 LUW Version 9.1
- DB2 migration portal
Upgrading DB2® database products to a new release might require migrating your DB2 environment components such as DB2 servers, clients, and database applications.
This migration portal contains a list of all the available migration roadmaps, migration guides, and information and resources related to migration to a new release of DB2 products and migration of software that uses DB2 database products such as DB2 Data Warehouse, DB2 Content Manager, and SAP systems.
- DB2 Version 9 migration roadmap
Upgrading to DB2 Version 9 might require migration of your environment components. These components are DB2 servers, DB2 clients, database applications, and routines. Migrating these components requires an understanding of the DB2 database product migration concepts and the DB2 database products.
This migration roadmap will help you navigate through the available information and resources related to migration to DB2 Version 9 from DB2 UDB Version 8.
- DB2 Version 9.1 APARs related to database migration from DB2 UDB Version 8
This document lists the APARs that could affect database migration from DB2® Universal Database™ (DB2 UDB) Version 8 to DB2 LUW Version 9.1.
-------------------------------------------------------------------------------------
Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone
(602) 217-2937 - Fax
Offline 
Send Email