Having problems with message search?
All,
Here's my installment of DB2 Updates over the last few weeks.
-------------------------------------------------------------------------------------
DB2 Viper 2 Open Beta Program
(http://www-306.ibm.com/software/data/db2/9/openbeta.html)
Highlights of the DB2 Viper 2 Release
* Increased integration between relational and XML functionality allowing for easy development and XML publishing of relational data
* Greater knowledge and control of your systems with integrated workload management
* Hand’s off fail over with automated and easy to use high availability
* Greater flexibility and granularity in security, auditing & access control
* Simplified memory management and increased customization capabilities
-------------------------------------------------------------------------------------
Software withdrawal and support discontinuance: Selected IBM DB2 products — Some replacements available
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS907-125)
See the announcement letter for full details. Note that April 30, 2009 has been announced as the date for the withdrawal of support for a number of DB2 V8.1 and V8.2 products.
-------------------------------------------------------------------------------------
Software withdrawal and support discontinuance: Selected IBM DB2 for Multiplatforms Tools — Replacements available
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS907-126)
See the announcement letter for full details. Note that September 30, 2008 has been announced as the date for the withdrawal of support for several DB2 Multiplatform Tools.
-------------------------------------------------------------------------------------
DB2 Chat with the Lab - DB2 for LUW Security Enhancements: Making Database Security Management and Compliance Easier
Thursday, July 19th 8AM PST, 10 AM CST, 11 AM EST, 4 PM London, 5 PM Paris
(https://ww4.premconf.com/webrsvp/register?conf_id=6060504)
Securing information assets, simplifying security management and complying with government regulations are becoming a significant challenge for many organizations today. The security capabilities in DB2 for LUW have been enriched in Viper II to allow organizations to address that challenge. This presentation reviews the DB2 for LUW security model and introduces the new Viper II security features: Database Roles, Trusted Contexts, Auditing and LBAC enhancements. Our speakers for this call are Sal Vella, Vice President, DB2 Development for Linux, Unix and Windows and Business Intelligence, and Walid Rjaibi, Senior Software Engineer, DB2 Security and Privacy.
-------------------------------------------------------------------------------------
Redbook - DB2 9 for z/OS Technical Overview
(http://www.redbooks.ibm.com/abstracts/sg247330.html)
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 - DB2 for z/OS Administration Tools for Enhanced Change Management
(http://www.redbooks.ibm.com/abstracts/sg247441.html)
A database administrator (DBA) has a challenging job trying to maintain databases in today’s nonstop 24x7 environments. This challenge is compounded by the complexity of database structures and the time pressure of trying to be up again as soon as possible without making mistakes.
When business expands, several DB2 subsystems have to be maintained, such as multiple development systems, function test, acceptance test, volume test, and production systems. Often changes have to be implemented across multiple DB2 subsystems.
The two IBM DB2 for z/OS tools that help database administrators to implement database changes are the DB2 Administration Tool and the DB2 Object Comparison Tool.
In this IBM Redbooks publication we show how, with Version 7.2, the two tools offer an enhanced Change Management function to manage and track the changes of your DB2 objects. We show how the tools help you define changes, resolve conflicts, register the changes, analyze the changes to generate a work statement list that applies the changes, and then run the changes in the correct order. The Change Management functions also allow you to back out completed changes and facilitate the management of a convenient audit trail.
This book contains a major update to the Change Management functions described in DB2 for z/OS Tools for Database Administration and Change Management, SG24-6420-01.
-------------------------------------------------------------------------------------
Redbook - Database Partitioning, Table Partitioning, and MDC for DB2 9 (Draft)
(http://www.redbooks.ibm.com/redpieces/abstracts/sg247467.html)
As organizations strive to do more with less, DB2 Enterprise Server Edition V9 for Linux, Unix, and Windows contains innovative features for delivering information on demand and scaling databases to new levels. The table partitioning, newly introduced in DB2 9, and database partitioning feature provide scalability, performance, and flexibility for data store. The multi-dimension clustering table enables rows with similar values across multiple dimensions to be physically clustered together on disk. This clustering allows for efficient I/O and provides performance gain for typical analytical queries.
How are these features and functions different? How do you decide which technique is best for your database needs? Can you use more than one technique concurrently?
This IBM Redbooks publication addresses these questions and more. Learn how to set up and administer database partitioning. Explore the table partitioning function and how you can easily add and remove years of data on your warehouse. Analyze your data to discern how multi-dimensional clustering can drastically improve your query performance.
-------------------------------------------------------------------------------------
Redbook - Best Practices for SAP BI using DB2 9 for z/OS (Draft)
(http://www.redbooks.ibm.com/redpieces/abstracts/sg246489.html)
Clients will want to know how to exploit the new features of both DB2 9 for z/OS and SAP in their SAP BW environments. This IBM Redbook will describe the benefits of DB2 V9 for SAP Business Information Warehouse. It will cover best practices, and provides performance and tuning recommendations.
SAP Business Information Warehouse is the central reporting tool for almost all SAP business solutions. It is based on building blocks called InfoObjects that contain data about customers, sales, and business information. InfoObjects include InfoSources, ODS objects, and InfoCubes. The business intelligence solution from IBM and SAP can help you aggregate and leverage this information, giving you a system-wide view of your business data and delivering it across your enterprise to support sound business decisions.
However, this structure can lead to slow performance if the system is not set up and managed according to good database principles. This redbook describes best practices for this product on a zSeries platform, and provides performance and tuning recommendations for loading and querying data. It also addresses general system administration and troubleshooting.
The audience for this redbook includes SAP and DB2 administrators. Knowledge of these products and of the z/OS environment is assumed.
-------------------------------------------------------------------------------------
blog - Shrinking Automatic Storage Tablespaces
(http://blogs.ittoolbox.com/database/technology/archives/shrinking-automatic-storage-tablespaces-17232)
From Chris Eaton's blog. Something new in Viper 2!
-------------------------------------------------------------------------------------
blog - New db2diag.log formatting tool
(http://blogs.ittoolbox.com/database/technology/archives/new-db2diaglog-formatting-tool-17275)
Also from Chris's blog. Not as new as Chris initially thought (a reader correctly identified that it was introduced in DB2 8.2), but nifty, nonetheless!
-------------------------------------------------------------------------------------
Announcement - Enhanced DB2 Tools for Multiplatform Environments
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-132)
The DB2 Toolkit for Multiplatforms V2.1 adds the full functionality of DB2 Change Management Expert for Multiplatforms to the existing combination of offerings (see the following table for more information). DB2 Toolkit for Multiplatforms combines six selected DB2 tools into a single orderable offering that provides all the function at a significant cost savings.
DB2 Toolkit for Multiplatforms includes these full-function products:
* For details on DB2 Change Management Expert for Multiplatforms, refer to 206-130 , dated June 6, 2006.
* For details on DB2 Data Archive Expert for Multiplatforms, refer to 205-323 , dated December 6, 2005.
* For details on DB2 High Performance Unload for Multiplatforms, refer to 206-130 , dated June 6, 2006.
* For details on DB2 Performance Expert for Multiplatforms, refer to 205-140 , dated June 7, 2005.
* For details on DB2 Recovery Expert for Multiplatforms, refer to 205-140 , dated June 7, 2005.
* For details on DB2 Test Database Generator for Multiplatforms, refer to 205-323 , dated December 6, 2005.
-------------------------------------------------------------------------------------
Announcement - IBM Metadata Workbench V8.0 and IBM WebSphere Transformation Extender V8.1 for DataStage add value to IBM Information Server
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-133)
Metadata Workbench offers:
* Complete traceability of information across tools, allowing data elements in reports to be traced back to their sources or even back to their original data models
* Responsiveness to change by providing an understanding of the impact of any change to any piece of information across tools, showing which reports, services,
or target databases will be impacted before a source data element is changed
* A complete set of reporting, management, and administrative functions for metadata elements within IBM WebSphere Metadata Server
WebSphere Transformation Extender for DataStage offers:
* Advanced file integration functions to IBM WebSphere DataStage, enhancing its ability to parse and validate complex hierarchical file structures like XML, EDI, and SWIFT messages
* Easy handling of complex file structures for optimal processing by DataStage
* Extensibility for parsing and validation of complex industry-standard formats like EDI, SWIFT, and HIPAA
-------------------------------------------------------------------------------------
Support Flashes
- Known issues on Windows operating systems when migrating to DB2 Version 9.1 from DB2 UDB Version 8
This document describes known issues related to migration to DB2 Version 9 on Windows and their resolutions.
- Migration to DB2 Version 9 from DB2 UDB Version 8 FAQs
This document answers some of the more Frequently Asked Questions for migration to DB2 Version 9 from DB2 UDB Version 8.
The questions are grouped by:
Migration support to DB2 Version 9 from DB2 UDB Version 8
DB2 server migration
DB2 client migration
Database application and routine migration
-------------------------------------------------------------------------------------
DB2 Magazine eBook - Isolation Levels and Data Consistency
(http://news.db2mag.com/cgi-bin4/DM/y/n8vv0FhO7y0FLd0FKPQ0Ei)
Do you know what DB2 isolation level your most important, mission-critical application uses? Do you know how to use isolation levels to control the behavior and performance of applications in multiuser environments? Or do you go with the defaults and hope for the best?
In DB2 Magazine's latest e-book, columnist Roger Sanders explains how to maintain data consistency by using the right DB2 Universal Database (UDB) for Linux, Unix, and Windows isolation level for the job.
-------------------------------------------------------------------------------------
DB2 Magazine Email Newsletter - May, 2007
(http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0EJwI0EL)
IN THIS ISSUE:
1. From the Editor
* DB2 Magazine gets the community spirit
2. Poll Positions
* Rate your company's information security efforts
3. Asked and Answered
* How do you clone just a portion of a database?
4. Skills Set
* News and information about IBM education
5. Must Read
* DB2 9 Fundamentals
6. In the Zone
* The latest articles on DB2, Informix, U2, and more
****************************************
1. FROM THE EDITOR
* DB2 Magazine gets the community spirit
Some of you have noticed that the first DB2 Magazine issue of the year
is a few months later than usual. If you've visited DB2mag.com in the
past week, you've probably guessed why: We've been busily working out
the next chapter in the magazine's history. The latest issue
(available in print and online) includes great how-to articles on data
governance, DB2 security, Informix SQL scripts and performance tuning,
plus coverage of IBM's FileNet acquisition and the Informix Dynamic
Server (IDS) "Cheetah" beta program.
But we're trying something new, too: We're asking you to get involved,
share your best ideas, comment on the new blog (eventually, blogs),
give feedback, and generally share your opinions and experience. Help
make the new DB2 Magazine Community Wiki the best online technical
resource for IBM information management outside of IBM itself. Share
those ideas and tips you've been trying to get into the print magazine
for years. Contribute all that pent-up advice to the community.
You can help make this Web site the resource you want it to be. What
are you going to make of it?
--Read the security and compliance issue online.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6C0E6
--Browse and contribute to the wiki.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6D0E7
--Comment on DB2mag.com's new community spirit in the blogs.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6E0E8
****************************************
2. POLL POSITIONS
* Is information at your company kept in Fort Knox or made available
to anyone who knocks? Rate your company's information security
efforts.
--Take the poll.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FGFl0E4
--Find out what's driving security efforts at most companies.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6F0EA
****************************************
3. ASKED AND ANSWERED
* How do you clone a portion of a database?
Let's say you want 10 percent for the overall size; would you take 10
percent from a primary file and then make sure all the referential
integrity is maintained for all the other files? Some files would need
to be copied in entirety.
--Find out what DB2 guru Roger Sanders suggests.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6G0EB
****************************************
4. MUST READ
* DB2 9 Fundamentals Certification Study Guide
Roger E. Sanders, MC Press (May, 2007)
This comprehensive guide covers planning, security, database objects,
SQL, XQuery, XML, tables, views, indexes, and database concurrency.
Each chapter contains a set of practice questions and thoroughly
explained answers.
--Find out more about the book.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0Bk8y0Ea
****************************************
5. SKILLS SET
* IDUG 2007--India Forum
This three-day event (May 31 to June 2) in Bangalore, India, will
deliver lessons on a variety of subjects and DB2 releases, including
DB2 9. Designed for professional application developers and database
administrators who use DB2, the forum will be valuable to new DB2
users as well as experienced professionals.
-- Browse the conference program.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FCnp0Ej
* DB2 9 Discount Certification Voucher
For a limited time, when you purchase the new IBM DB2 9 New Features
book (ISBN: 0072264594), you can receive a Professional Certification
Voucher good for 50 percent off the list price of the IBM DB2 9
Fundamentals Exam (730) or the IBM DB2 9 DBA for Linux, Unix and
Windows Exam (731).
-- Register for the offer or find out more.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FCiL0E3
* New Enterprise Content Management - Document Manager Certification
The new role and exam (445) targets professionals who perform
high-level design and requirements gathering and install and configure
Document Manager.
-- Learn more about the new certification exam.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6H0EC
*DB2 9 Advanced Database Administration for Linux, Unix and Windows
Certification
* This new certification role and exam (734) is targeted to DBAs with
extensive DB2 9 experience. The test covers advanced topics such as
performance, high availability, security and networking.
-- Find out more or register for the exam.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6I0ED
* New DB2 9 System Administration for Linux, Unix and Windows Upgrade
Exam
This new exam can be used to upgrade DB2 UDB V8 DBA LUW or z/OS
Professional Certification to DB2 9 DBA LUW or z/OS Professional
Certification. Candidates have 60 minutes to complete the exam and
must score a minimum of 55 percent to pass.
-- Learn more or register for the exam.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6I0ED
* Spring IBM Training Catalog
The training catalog features new and updated courses and curricula,
training paths and skills offers and promotions. A simplified layout
groups all Information Management Software chapters together.
-- Download the online version.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6J0EE
* IBM Redbook: Informix Dynamic Server V10: Superior Data Replication
for Availability and Distribution
The high availability and enterprise replication features of Informix
Dynamic Server (IDS) Version 10 can simplify and automate enterprise
database deployment. Version 10 offers patent-pending technology that
virtually eliminates downtime and automates many of the tasks
associated with deploying mission-critical enterprise systems.
-- Download a PDF, view in HTML or order a hardcopy.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6K0EF
* Information Management Technical Conference - Germany
Mark your calendar for the primary technical exchange and
skill-building event in Information Management. This event for
business and IT executives, managers, professionals, DBAs and
developers offers more than 200 technical sessions across 11 tracks.
-- Get conference details.
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6L0EG
****************************************
6. IN THE ZONE
* Visualize spatial data in DB2
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6M0EH
* Configure DB2 databases for data protection with IBM Tivoli Storage
Manager for Advanced Copy Services
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6N0EI
* Database version control with DB2 Change Management Expert
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6O0EJ
* Use Business Intelligence Reporting Tool with DB2 DWE
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6P0EK
* Data archiving with Informix Dynamic Server table-level restore
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6Q0EL
* Enhance Informix Dynamic Server security with Pluggable
Authentication Module and JDBC
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6R0EM
* Use IBM OmniFind Yahoo! Edition REST APIs
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6S0EN
* Expanded capabilities for Informix .NET programming
http://news.db2mag.com/cgi-bin4/DM/y/e7fS0FhO7y0FLd0FF6T0EO
-------------------------------------------------------------------------------------
DB2 Magazine Email Newsletter - June 2007
(http://www.db2mag.com/newsletter/070613.shtml)
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
| ||||||||||||||
|
|
From
the Editor -------------------------------------------------------------------------------------
Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone
(602) 217-2937 - Fax
Offline 
Send Email