swarug-users : Messages : 583-636 of 665

Messages: Show Message Summaries (Group by Topic) Sort by Date

#636 From: "James Hou" <james.hou@...>
Date: Fri Mar 21, 2008 11:05 pm
Subject: James Hou is out of the office james.hou@...
Send Email

I will be out of the office starting  03/10/2008 and will not return until
03/24/2008.



American Express made the following annotations on Fri Mar 21 2008 16:05:27
------------------------------------------------------------------------------
"This message and any attachments are solely for the intended recipient and may
contain confidential or privileged information. If you are not the intended
recipient, any disclosure, copying, use, or distribution of the information
included in this message and any attachments is prohibited. If you have received
this communication in error, please notify us by reply e-mail and immediately
and permanently delete this message and any attachments. Thank you."

American Express a ajout� le commentaire suivant le Fri Mar 21 2008 16:05:27

Ce courrier et toute pi�ce jointe qu'il contient sont r�serv�s au seul
destinataire indiqu� et peuvent renfermer des renseignements confidentiels et
privil�gi�s. Si vous n'�tes pas le destinataire pr�vu, toute divulgation,
duplication, utilisation ou distribution du courrier ou de toute pi�ce jointe
est interdite. Si vous avez re�u cette communication par erreur, veuillez nous
en aviser par courrier et d�truire imm�diatement le courrier et les pi�ces
jointes. Merci.
******************************************************************************
-------------------------------------------------------------------------------

Reply | Forward | Messages in this Topic (1)

#635 From: "Colleen Holland" <Colleen.Holland@...>
Date: Fri Mar 21, 2008 11:04 pm
Subject: Colleen Holland is OOO until 3/24 Colleen.Holland@...
Send Email

I will be out of the office starting  03/18/2008 and will not return until
03/22/2008.

Ian C Towner in our UK office or Charlene R Baber in our Florida office are
available to assist during my absence.   You may also send an email to IMCDMDB2
or IMCDMIMS to reach the next available person on our team.

If you have an urgent situation that needs leadership attention,  please
contact team Director, Doug Chamis in Florida  954-757-1707.  Please respect
time zone differences if this is not an urgent request.

Make your day super!
Colleen


American Express made the following annotations on Fri Mar 21 2008 16:04:44
------------------------------------------------------------------------------
"This message and any attachments are solely for the intended recipient and may
contain confidential or privileged information. If you are not the intended
recipient, any disclosure, copying, use, or distribution of the information
included in this message and any attachments is prohibited. If you have received
this communication in error, please notify us by reply e-mail and immediately
and permanently delete this message and any attachments. Thank you."

American Express a ajout� le commentaire suivant le Fri Mar 21 2008 16:04:44

Ce courrier et toute pi�ce jointe qu'il contient sont r�serv�s au seul
destinataire indiqu� et peuvent renfermer des renseignements confidentiels et
privil�gi�s. Si vous n'�tes pas le destinataire pr�vu, toute divulgation,
duplication, utilisation ou distribution du courrier ou de toute pi�ce jointe
est interdite. Si vous avez re�u cette communication par erreur, veuillez nous
en aviser par courrier et d�truire imm�diatement le courrier et les pi�ces
jointes. Merci.
******************************************************************************
-------------------------------------------------------------------------------

Reply | Forward | Messages in this Topic (1)

#634 From: Jay Allen <ja@...>
Date: Fri Mar 21, 2008 11:03 pm
Subject: Fw: RUG Discount for IDUG 2008 North American Conference ibm4swarug
Offline
Send Email

FYI ...

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

----- Forwarded by Jay Allen/Phoenix/IBM on 03/21/2008 03:54 PM -----

The IDUG 2008 North American Conference will take place May 18-22, 2008 in Dallas, Texas, and as usual, we would like to offer RUG members a discount.

RUG members will receive a $50 discount off their early bird registration rate when they reference the IDUG RUG Coupon. Please access it at http://conferences.idug.org/portals/1/2008/docs/IDUG_NA08_RUG.pdf,

Please distribute this to your members! Thank you,

Michael McBride
International DB2 Users Group
Board of Directors - Regional User Group Liaison

Reply | Forward | Messages in this Topic (1)

#633 From: "lightyr_smh" <shunn@...>
Date: Mon Feb 25, 2008 3:08 pm
Subject: Presentation from last meeting lightyr_smh
Offline
Send Email

Hi everyone,

I just added my presentation about Enterprise Security to the SWARUG
website. You may have received an automatically generated email saying
the presentation was available but for some reason the link does not
work.

If you want a copy of the presentation just go to
http://tech.groups.yahoo.com/group/swarug-users/files/

Let me know if you have any questions.

Thanks,

Steve

steve.hunn@...

Reply | Forward | Messages in this Topic (1)

#632 From: swarug-users@yahoogroups.com
Date: Mon Feb 25, 2008 3:02 pm
Subject: New file uploaded to swarug-users swarug-users@yahoogroups.com
Send Email

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the swarug-users
group.

   File        : /A Brief Look at Enterprise Security - SWARUG.ppt
   Uploaded by : lightyr_smh <shunn@...>
   Description : Enterprise Security Feb 21-08

You can access this file at the URL:
http://groups.yahoo.com/group/swarug-users/files/A%20Brief%20Look%20at%20Enterpr\
ise%20Security%20-%20SWARUG.ppt

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.htmlfiles

Regards,

lightyr_smh <shunn@...>

Reply | Forward | Messages in this Topic (19)

#631 From: "Julie Reid" <julie.reid@...>
Date: Wed Feb 20, 2008 5:03 pm
Subject: Julie Reid is out of the office. julie.reid@...
Send Email

I will be out of the office starting  02/20/2008 and will not return until
02/25/2008.

If you need to contact Common Services:
Open an Information or SQP Request via our Engagement DB
(IPCNA003/SVR/AEXP/job_proj\C_Dir\comsvc.nsf), or
Send an email to 'Common Services Team' distribution list.

For urgent assistance with TAMS or CTS, route an IMR to GLCOMSV.

If you need help with opening the request or IMR, contact the helpdesk at 602-
766-2000.

Otherwise I will respond  to your message when I return.


American Express made the following annotations on Wed Feb 20 2008 10:03:12
------------------------------------------------------------------------------
"This message and any attachments are solely for the intended recipient and may
contain confidential or privileged information. If you are not the intended
recipient, any disclosure, copying, use, or distribution of the information
included in this message and any attachments is prohibited. If you have received
this communication in error, please notify us by reply e-mail and immediately
and permanently delete this message and any attachments. Thank you."

American Express a ajout� le commentaire suivant le Wed Feb 20 2008 10:03:12

Ce courrier et toute pi�ce jointe qu'il contient sont r�serv�s au seul
destinataire indiqu� et peuvent renfermer des renseignements confidentiels et
privil�gi�s. Si vous n'�tes pas le destinataire pr�vu, toute divulgation,
duplication, utilisation ou distribution du courrier ou de toute pi�ce jointe
est interdite. Si vous avez re�u cette communication par erreur, veuillez nous
en aviser par courrier et d�truire imm�diatement le courrier et les pi�ces
jointes. Merci.
******************************************************************************
-------------------------------------------------------------------------------

Reply | Forward | Messages in this Topic (1)

#630 From: "Steve Hunn" <shunn@...>
Date: Wed Feb 20, 2008 3:54 pm
Subject: SWARUG meeting tomorrow at Wells Fargo in Chandler lightyr_smh
Offline
Send Email

Hi everyone,

I just wanted to give you a final reminder about our meeting tomorrow ... if you have not already registered please RSVP to Randy Corum, krcorum@...

There will also be a drawing for a very special prize. My company, Lumension Security is holding a user security conference in Scottsdale Mar 3 - 5. The lineup includes several recogized security experts and admission is normally $395 but I'll be giving away one complementary pass. Details about the conference are at http://360.lumension.com/home.html

Full meeting details are available at the SWARUG website.

http://www.lightyr.com/swarug/news.html

Hope to see you tomorrow ...

Steve

Reply | Forward | Messages in this Topic (1)

#629 From: "William R Marshall" <william.r.marshall@...>
Date: Tue Feb 12, 2008 5:01 pm
Subject: I will be out of the office starting 02/12/2008 and will not return until 02/13/2008. I will check my email Tuesday night but otherwise I will respond to your message when I return. If this is an emergency, please call my cell# 602.370.1030. william.r.marshall@...
Send Email

I will be out of the office starting  02/12/2008 and will not return until
02/13/2008.

I will be out of the office starting 02/12/2008 and will not return until
02/13/2008.  I will check my email Tuesday night but otherwise I will respond
to your message when I return.  If this is an emergency, please call my cell#
602.370.1030.


American Express made the following annotations on Tue Feb 12 2008 10:01:11
------------------------------------------------------------------------------
"This message and any attachments are solely for the intended recipient and may
contain confidential or privileged information. If you are not the intended
recipient, any disclosure, copying, use, or distribution of the information
included in this message and any attachments is prohibited. If you have received
this communication in error, please notify us by reply e-mail and immediately
and permanently delete this message and any attachments. Thank you."

American Express a ajout� le commentaire suivant le Tue Feb 12 2008 10:01:11

Ce courrier et toute pi�ce jointe qu'il contient sont r�serv�s au seul
destinataire indiqu� et peuvent renfermer des renseignements confidentiels et
privil�gi�s. Si vous n'�tes pas le destinataire pr�vu, toute divulgation,
duplication, utilisation ou distribution du courrier ou de toute pi�ce jointe
est interdite. Si vous avez re�u cette communication par erreur, veuillez nous
en aviser par courrier et d�truire imm�diatement le courrier et les pi�ces
jointes. Merci.
******************************************************************************
-------------------------------------------------------------------------------

Reply | Forward | Messages in this Topic (1)

#628 From: "Steve Hunn" <shunn@...>
Date: Tue Feb 12, 2008 5:00 pm
Subject: SWARUG meeting - Feb 21 lightyr_smh
Offline
Send Email

Hello SWARUG members,

I hope to see you at the upcoming SWARUG meeting � it will be on Thursday, Feb 21 at Wells Fargo in Chandler.

The lineup includes the following presentations;

Protecting Enterprise Data � Steve Hunn (that's me!)

Structure and Format Enhancements in DB2 9 for z/OS � Willie Favero (always entertaining and informative)

Replication, replication, replication! You can do it, EMC storage can help - Paul Pendle (experienced Systems Integration Engineer)

Full details are available on our website http://www.lightyr.com/swarug/news.html

Please RSVP to Randy Corum at krcorum@... to let him know if you will be coming.

Regards,

Steve Hunn

Reply | Forward | Messages in this Topic (1)

#627 From: "Steve Hunn" <shunn@...>
Date: Thu Jan 31, 2008 2:57 pm
Subject: SWARUG Meeting Thursday February 21 lightyr_smh
Offline
Send Email

Hello Everyone!

This is a reminder that our next meeting will be held on Thursday February 21, 2008 from 8:30 AM to 3:30 PM. The agenda and short speaker biographies are below. We look forward to seeing you at the meeting!

Please RSVP to Randy Corum, krcorum@...

Full details are available at our website: http://www.lightyr.com/swarug/news.html

The meeting will be held at

Wells Fargo � Ocotillo. 2600 South Price Road Chandler, Arizona 85286 480-724-6834

8:30 - 9:00 AM               Registration & Continental Breakfast
9:00 - 9:15 AM               SWARUG Business
9:15 - 10:15 AM             Protecting Enterprise Data
                                    Steve Hunn, Lumension Security
10:15 - 10:30 AM           Break
10:30 - 12:00 PM           Structure and Format Enhancements in DB2 9 for z/OS
                                    Willie Favero, IBM

12:00 - 1:00 PM Lunch
1:00 - 3:00 PM Replication, replication, replication! You can do it, EMC storage can help.
Paul Pendle, EMC

Speaker BIOs

Steve Hunn, Regional Manager, Lumension Security

Steve has over 20 years experience with business software. During that time he has had a range of responsibilities including development, analysis, project management and sales. In his current position with Lumension Security he helps customers ensure that their enterprise data is secure. Steve has been a SWARUG board member for 10 years and has been a regular presenter at user groups and tech conferences. He holds several IBM DB2 and WebSphere certifications.

Willie Favero, Senior Certified Consulting IT Software Specialist, IBM

Willie is currently working with the Data Warehouse for System z Swat Team at IBM's Silicon Valley Lab. He is also a member of IBM's zChampion team, a representative for System z with IBM's Academic Initiative, an IBM Certified Solutions Expert for DB2 9 for z/OS and DB2 for z/OS Version 8, DB2 UDB, and DB2 for OS/390 Version 7, and a participant in the zNextGen program at SHARE. Between IMS/VS DB/DC, Cincom's Total and Supra, IDMS, and DB2, he has over 30+ years experience working with database. However, Willie has spent his last 24 years working primarily with the DB2 family. In his spare time he blogs about DB2 for z/OS at http://blogs.ittoolbox.com/database/db2zos/

Paul Pendle, Systems Integration Engineer, EMC

Paul has over 30 years in the data processing industry focusing on Databases, Operating systems and disk storage systems. Currently a Systems Integration Engineer selling Storage Hardware and Software.

Reply | Forward | Messages in this Topic (1)

#626 From: Jay Allen <ja@...>
Date: Tue Dec 4, 2007 9:38 pm
Subject: INVITATION: DB2 Chat with the Lab ibm4swarug
Offline
Send Email

All,

DB2 Chat with the Lab - Wednesday, December 12 - DIFFERENT TIME: 9:30 AM Pacific, 11:30 AM Central, 12:30 PM Eastern, 5:30 PM London, 6:30 PM Paris
Accelerating Warehouse Delivery with the DB2 Warehouse Tooling

This chat will discuss the capabilities of the DB2 Warehouse tooling and how it can help you accelerate the development and deployment of your Data Warehouse environment up and above standard Database Capabilities. Our speakers for this session will be Sal Vella, Vice President of Development for DB2 for Linux, Unix and Windows and Business Intelligence and Phil Downey, DB2 Program Manager, who will be speaking to us from Australia. Because of the speaker's location, we are changing the start time for this session only. This talk is targeted at DB2 LUW customers and partners.

You may RSVP to this Chat at: https://ww4.premconf.com/webrsvp/register?conf_id=4362127

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

Reply | Forward | Messages in this Topic (1)

#625 From: "Steve Hunn" <shunn@...>
Date: Mon Dec 3, 2007 2:34 pm
Subject: User Group meeting with Sheryl Larsen this Thusday lightyr_smh
Offline
Send Email

Good morning everyone,

Don't forget that our user group this Thursday will be featuring Sheryl Larsen as well as presentations from Mike Sniezek and Todd Mollenhauer of BMC.

If you have not already done so please RSVP to garretth@...

Full details are available on our website http://www.lightyr.com/swarug/news.html

Hope to see you there,

Steve Hunn

480 515-1498

Reply | Forward | Messages in this Topic (1)

#619 From: Jay Allen <ja@...>
Date: Fri Nov 30, 2007 7:27 pm
Subject: Monthly DB2 Update ibm4swarug
Offline
Send Email

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

(http://www.ibm.com/support/docview.wss?uid=swg24017514)

LANfree DB2 Backup to TSM Recommendation

(http://www-1.ibm.com/support/docview.wss?uid=swg21287060)

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21284097)

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21165448)

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21271149)

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21254493)

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21200005)

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21227461)

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21271974)

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

Reply | Forward | Messages in this Topic (23)

#618 From: <garretth@...>
Date: Wed Nov 28, 2007 10:26 pm
Subject: FW: SWARUG meeting - Thursday, December 6, 2007 ladytarot2003
Offline
Send Email

Hello Everyone!

This is a reminder that our next meeting will be held on Thursday, Dec 6, 2007 from 8:30 AM to 3:30 PM.

We will be holding elections for the 2008 SWARUG board. Please consider running for one of the positions!

Our presenters will be Sheryl M. Larsen, SMLI - Todd Mollenhauer, BMC - Mike Sniezek, BMC

We look forward to seeing you at the meeting!

Please RSVP to Helena Garrett garretth@....

Full details are available at our website: http://www.lightyr.com/swarug/news.html

The meeting will be held at Wells Fargo – Ocotillo. 2600 South Price Road Chandler, Arizona 85286 480-724-6834

Agenda

8:30 - 9:00 AM Registration & Continental Breakfast9:00 - 9:15 AMSWARUG Business & Election 9:15 - 10:15 AMOnline Schema Made SimpleTodd Mollenhauer, BMC10:15 - 10:30 AMBreak10:30 - 12:00 PMDB2 in DB2 – There is nothing like an example!Mike Sniezek. BMC12:00 - 1:00 PMLunch1:00 - 3:00 PM DB2’s Top SQL Performance Enhancements Sheryl M. Larsen

Speaker BIOs

Todd Mollenhauer, Senior Software Consultant, BMC Software.

Todd worked as a DB2 DBA, and DB2 System Programmer for a major telecommunications company for 13 years. Since joining BMC in 1996, he has worked with DB2 customers in the western U.S. implementing BMC DB2 solutions.

Mike Sniezek, Brand Manager, BMC Software

Mike Sniezek’s career in Information Technology began in 1976. He joined BMC Software in 1994, where he is currently a Brand Manager for the mainframe database tools. Mike has a wide range of knowledge of mainframe, distributed technology, and process management and has lectured at various conferences. He has published several articles, primarily on database technology and the Internet.

Sheryl M. Larsen, Inc.,

SMLI, is a firm specializing in Advanced SQL Consulting and Education (www.smlsql.com). Sheryl M. Larsen is the founder/president and is an internationally recognized researcher, consultant and lecturer and is known for her extensive expertise in SQL. She has over 20 years experience in DB2, published many articles, several popular DB2 posters, and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. She is frequently asked to keynote DB2 world wide events. She is an IDUG “Hall of Fame” speaker, President of the Midwest Database Users Group (www.mwdug.org), and a member of IBM’s DB2 Gold Consultants program

Thanks!

Reply | Forward | Messages in this Topic (1)

#617 From: Jay Allen <ja@...>
Date: Wed Nov 28, 2007 6:18 pm
Subject: INVITATION: Chat with the Lab, Thursday, November 29th ibm4swarug
Offline
Send Email

All,

Sorry for the short notice, but I've been on jury duty since before Thanksgiving!

DB2 and Informix Chat with the Lab - Thursday, November 29, 2007 8 AM PST, 10 AM Central, 11 AM Eastern, 4 PM London, 5 PM Paris
IBM Data Studio and pureQuery

IBM Data Studio is a comprehensive data management solution that empowers you to effectively design, develop, deploy and manage your data, databases and database applications throughout the entire application development life cycle using a consistent and integrated user interface. pureQuery is Data Studio tooling runtime that improves application performance, manageability, and problem determination across the life cycle. Our speaker is Dr. Stephen Brodsky, Information Management Architect and Senior Technical Staff Member.

You may RSVP for this call at: https://ww4.premconf.com/webrsvp/register?conf_id=7342813

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

Reply | Forward | Messages in this Topic (1)

#614 From: Jay Allen <ja@...>
Date: Tue Oct 30, 2007 5:27 pm
Subject: INVITATION: DB2 Chat with the Lab, Wednesday, November 7th ibm4swarug
Offline
Send Email

All,

DB2 Chat with the Lab - Wednesday, November 7th - 8 AM PST, 10 AM CST, 11 AM EST, 4 PM London, 5 PM Paris
DB2 Warehouse 9.5 - What's New in the Platform for High Performance DB2 Analytics

This Chat will cover the architecture and new capabilities of DWE 9.5. Many of the new features improve the overall usability and performance of the product and its analytical capabilities including: Design tooling for effective Workload Management deployment and monitoring, OLAP cube definition and administration, Alphablox interfaces, enhancements to the data mining process and web deployment. Our speakers will be Sal Vella, Vice President of DB2 Development for Linux, Unix and Windows and Business Intelligence and Pat Bates, Product Manager, DB2 Warehouse Analytics.

You may RSVP to this Chat at: https://ww4.premconf.com/webrsvp/register?conf_id=3940586

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

Reply | Forward | Messages in this Topic (1)

#612 From: Jay Allen <ja@...>
Date: Thu Oct 25, 2007 7:06 pm
Subject: Monthly DB2 Update ibm4swarug
Offline
Send Email

All,

Here's my installment of DB2 Updates over the last month.

Jay Allen

-------------------------------------------------------------------------------------

Announcement - IBM DB2 V9.5 for Linux, UNIX, and Windows provides agility to align IT with business
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-261)

IBM DB2 Linux, UNIX, and Windows V9.5 delivers:

* Improved performance for high priority workloads
* Shortened developer timelines with enhanced XML features
* Shortened time to recover
* Enhancements to server and compliance to safeguard your data server
* Reduced administration with advances in performance, manageability, and installation

-------------------------------------------------------------------------------------

Announcement - Eliminating the barriers with IBM DB2 Warehouse V9.5
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-257)

IBM DB2 Warehouse V9.5 is an integrated package of components and capabilities that provides a data repository and the tools needed to help create a data warehouse.

V9.5 includes three key new data warehouse capabilities; Cubing Services, Workload Management, and Unstructured Text Analysis. In addition, several products have been extensively enhanced including DB2, Alphablox, and SQL Warehouse Tool. The focus of this release is to:

* Add a DB2 based multidimensional, data analysis capability with a wide assortment of tools and applications
* Provide robust workload management enabling better control over an operational data warehouse
* Give the IT staff the ability to manage workload based on service levels
* Provide analysis capability for unstructured text data
* Improve data load and execution with parallel control flow capability
* Simplify warehouse management through the integration of its tooling framework
* Expand the usage and desirability of Alphablox by making it easier to build applications
* Extend the ability to easily capture data from remote sources

-------------------------------------------------------------------------------------

Announcement - IBM DB2 Connect V9.5 for Linux, UNIX, and Windows shortens development time and reduces cost
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-256)

DB2 Connect V9.5 is the next generation hybrid data server with optimized management of both XML and relational data.

Shortens development time lines

* Eclipse-based IBM Data Studio solution
* Tight integration with leading application infrastructures like Hypertext Preprocessor (PHP), Perl, Ruby on Rails, Java, and .NET, including .NET Framework 2.0
* Enhanced support for federated data solutions

Reduces cost

* Adaptive, self-tuning memory allocation
* Object Maintenance Policy wizards for DB2 for z/OS

-------------------------------------------------------------------------------------

Announcement - Building analytic applications faster and easier with IBM Alphablox V9.5 for Linux, UNIX, and Windows
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-255)

IBM Alphablox V9.5 for Linux, UNIX, and Windows now enables both Java and non-Java developers to build analytic, browser-based applications with a new, easy-to-use, point-and-click user interface. It also provides functionality to make it easier to design, develop, and test analytic applications and new features to help users interact with data and perform calculations.

Linux on System z is now available for Alphablox V9.5.

-------------------------------------------------------------------------------------

Announcement - IBM adds new and enhanced information management tools for distributed environments
(http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS207-260)

IBM offers new and advanced information management tools for distributed operating environments in the following categories.

* Utilities Management
o IBM DB2 High Performance Unload for Multiplatforms V3.2.0
o IBM DB2 High Performance Unload for Workgroups V3.2.0
o IBM DB2 Change Management Expert for Multiplatforms V1.1.0 (new pricing options)

* Performance Management
o IBM DB2 Performance Expert for Multiplatforms V3.1.0
o IBM DB2 Performance Expert for Workgroups V3.1.0

* Business Analysis
o IBM DataQuant for Multiplatforms V1.2.0

* Data Governance
o IBM Database Encryption Expert for Linux, UNIX, and Windows, V1.1.0
o IBM DB2 Audit Management Expert for Multiplatforms V1.1.0

* Information Integration
o IBM WebSphere Replication Server V9.5.0
o IBM WebSphere Data Event Publisher V9.5.0

-------------------------------------------------------------------------------------

Redbook - High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windows
(http://www.redbooks.ibm.com/abstracts/sg247363.html?Open)

As organizations strive to do more with less, IBM DB2 for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions by leveraging enterprise system resources with broad support for clustering software such as HACMP, TSA, and Microsoft Windows Cluster Server.

This IBM Redbooks publication describes DB2’s high availability functions and features, focusing on High Availability Disaster Recovery (HADR) in the OLTP environment. The book provides a detailed discussion of HADR, including setup, configuration. administration, monitoring, and best practices.

We explain how to configure cluster software HACMP, TSA, and MSCS with DB2 and show how to use these products to automate HADR takeover.

DB2 also provides unprecedented enterprise-class scalability to 32-bit and 64-bit Linux, UNIX, and Windows platforms. We introduce the DB2 Database Partitioning Feature, covering the installation, configuration, and scaling of a database partition.

-------------------------------------------------------------------------------------

Redbook - Best Practices for SAP BI using DB2 9 for z/OS
(http://www.redbooks.ibm.com/abstracts/sg246489.html?Open)

Clients want to know how to exploit the new features of both DB2 V9 and SAP in their SAP BI environments. This IBM Redbooks publication describes the benefits of DB2 V9 for SAP Business Information Warehouse. It covers 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, DataSore 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.

This book 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.

-------------------------------------------------------------------------------------

Redbook - Leveraging DB2 Data Warehouse Edition for Business Intelligence
(http://www.redbooks.ibm.com/abstracts/sg247274.html?Open)

In this IBM Redbook we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business intelligence infrastructure for analytics and Web-based applications, and best practices for deployment. DB2 DWE integrates core components for data warehouse construction and administration, data mining, OLAP, and InLine Analytics and reporting. It extends the DB2 data warehouse with design-side tooling and runtime infrastructure for OLAP, data mining, InLine Analytics, and intra-warehouse data movement and transformation, on a common platform based on DB2 and WebSphere. The platform pillars are based on the technology of DB2, Rational Data Architect (for physical data modeling only), the SQL Warehousing Tool, Intelligent Miner, DB2 Cube Views, and Alphablox. DWE includes an Eclipse-based design environment, DWE Design Studio, that integrates the DWE products (with the exception of Alphablox and Query Patroller) with a common framework and user interface. The new SQL Warehousing Tool enables visual design of intra-warehouse, table-to-table data flows and control flows using generated SQL. DB2 Alphablox is the tool for developing custom applications with embedded analytics-based visual components. DWE enables faster time-to-value for enterprise analytics, while limiting the number of vendors, tools, skill sets and licenses required.

-------------------------------------------------------------------------------------

Redbook - DB2 9 for z/OS Performance Topics
(http://www.redbooks.ibm.com/abstracts/sg247473.html?Open)

DB2 9 for z/OS is an exciting new version, with many improvements in performance and little regression. DB2 V9 improves availability and security, as well as adds greatly to SQL and XML functions. Optimization improvements include more SQL functions to optimize, improved statistics for the optimizer, better optimization techniques, and a new approach to providing information for tuning. V8 SQL procedures were not eligible to run on the IBM System z9 Integrated Information Processor (zIIP), but changing to use the native SQL procedures on DB2 V9 makes the work eligible for zIIP processing. The performance of varying length data can improve substantially if there are large numbers of varying length columns. Several improvements in disk access can reduce the time for sequential disk access and improve data rates.

The key DB2 9 for z/OS performance improvements include reduced CPU time in many utilities, deep synergy with IBM System z hardware and z/OS software, improved performance and scalability for inserts and LOBs, improved SQL optimization, zIIP processing for remote native SQL procedures, index compression, reduced CPU time for data with varying lengths, and better sequential access. Virtual storage use below the 2 GB bar is also improved.

This IBM Redbooks publication provides an overview of the performance impact of DB2 9 for z/OS, especially performance scalability for transactions, CPU, and elapsed time for queries and utilities. We discuss the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates.

Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are familiar with DB2 V9. See DB2 9 for z/OS Technical Overview, SG24-7330, for an introduction to the new functions.

-------------------------------------------------------------------------------------

Redbook - Dynamic Warehousing: Data Mining Made Easy
(http://www.redbooks.ibm.com/abstracts/sg247418.html?Open)

Data mining has evolved from the ethereal domain of the highly-skilled mathematician to the expert data miner's workbench tool and ultimately to widely accessible business applications. For decades, industry and academia have been engaged in far-reaching research and development of data mining. At the same time, businesses have been leveraging this research, exploiting a handful of algorithms most useful in finding information to help resolve business problems.

Recent trends have made these algorithms and systems, which are rooted in solid research, available to a wide range of business users in easy-to-use forms. Large numbers of business analysts, who may not be data mining experts, can now solve high-value business problems using data mining technology embedded in database-resident business applications.

In this IBM Redbooks publication, we discuss the methodology and selected techniques of embedded data mining and show how sophisticated technologies can be used in today's business environment to create significant business value. All this is enabled by the IBM DB2 Warehouse (DB2W) data mining capabilities. Using DB2W, we show examples of using data mining capabilities for such analytic functions as data modeling, scoring, and visualization. In addition, there are scenarios and examples that help in understanding where, when, and how to use data mining. For techniques, technical details, and practical examples, this is the book you need.

-------------------------------------------------------------------------------------

Redbook - Database Partitioning, Table Partitioning, and MDC for DB2 9
(http://www.redbooks.ibm.com/abstracts/sg247467.html?Open)

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 the 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.

-------------------------------------------------------------------------------------

Redpaper - Index Compression with DB2 9 for z/OS
(http://www.redbooks.ibm.com/redpapers/abstracts/redp4345.html?Open)

In data warehouse applications, it is common to have many very large indexes defined on large tables. It is also possible that the index spaces exceed the size of the tables upon which the indexes are based. As one way of helping you to manage the cost of ownership, in
DB2 9 for z/OS (New Function Mode) you can choose to compress your indexes and you can define indexes with a page size larger than
4 KB. All references to the DB2 product refer specifically to DB2 9, except where the release level is explicitly mentioned.

Compression has been available for table spaces on z/OS since DB2 Version 3. This IBM Redpaper explains some of the significant differences between data and indexes in the way that compression is managed, as well as a comparison of the performance characteristics.

A limited set of performance measurements obtained in a laboratory setting are described in this paper, but the main spirit of this paper is not about specific performance numbers. In other words, the paper describes how the implementation methodology affects the performance of both data and index compression, and the authors hope that the reader does not get too focused on the path lengths of the implementation or the performance of any specific hardware. User experiences will vary. It is difficult to predict the impact of index compression on performance, but in this paper we attempt to provide a methodology that will give some insight about how to predict the effect of index compression on the CPU utilization.

-------------------------------------------------------------------------------------

blog - Simplified Restore and Rollforward Command
(http://blogs.ittoolbox.com/database/technology/archives/simplified-restore-and-rollforward-command-19608)

For those that have been using DB2 for some time or those coming from other data servers, you are likely familiar with the RESTORE command. With RESTORE, you specify the backup image you want to restore (indicated by the timestamp the backup was TAKEN AT) the media you are restoring from and the database name you are restoring to. Then if you want to roll the database forward to end of logs or a point in time you follow the restore with a ROLLFORWARD command.

What many may not be aware of is that in V8 there was a simplification of this process. The RECOVER command not only combines the above two steps into a single step but it also focuses on what you want to accomplish rather than how to accomplish that task. What I mean by this is you simply specify at what point in time you want the database to be at after the recovery and DB2 figures out the best way to get you there.

-------------------------------------------------------------------------------------

alphaWorks - Web 2.0 Starter Toolkit for IBM DB2
(http://www.alphaworks.ibm.com/tech/web2db2?open&S_TACT=106AH21W&S_CMP=AWLP)

Users starting with PHP are faced with the task of downloading a Web server and PHP modules and finding a relational database. The next struggle is to get code enabled for mash-ups, Ajax applications, and Web feeds. Web 2.0 Starter Toolkit for IBM� DB2� is a conveniently packaged set of products and technologies. The kit enables the quick creation of DB2 Web services and feeds using PHP technology.

All items are in one convenient place; these include downloads for PHP extension, an optional PHP IDE (integrated development environment), sample code, flash demonstrations, and DB2 Express – C: a "free to build, deploy, distribute" data server. Also included are tutorials, examples, and other learning materials.

-------------------------------------------------------------------------------------

Support Flashes

DB2 UDB Version 8.1 FixPak 15 (also known as Version 8.2 FixPak 8)

(http://www-1.ibm.com/support/docview.wss?uid=swg24016650)

DB2 Version 9.1 Fix Pack 3 for Linux, UNIX and Windows

(http://www-1.ibm.com/support/docview.wss?uid=swg24016651)

Recommended maintenance for WebSphere Classic Data Event Publisher for z/OS, WebSphere Classic Replication Server for z/OS, WebSphere Classic Federation Server for z/OS, and WebSphere Data Integration Classic Connector for z/OS Version 9.1 PTF rollup 2

(http://www-1.ibm.com/support/docview.wss?uid=swg21270940)

IMS log reader service and IBM WebSphere DataStage integration enhancement now available in Classic V9.1 Rollup 2

(http://www-1.ibm.com/support/docview.wss?uid=swg21270463)

Capture changes to IMS databases by running a service in a data server address space that reads IMS logs directly. Reduce mainframe CPU processing by pushing non-relational to relational data transformations to the WebSphere DataStage platform.

Recommended Base Software Stack for Balanced Configuration Unit (BCU) on AIX

(http://www-1.ibm.com/support/docview.wss?uid=swg21179515)

This document describes the recommended base software stack for Balanced Configuration Unit (BCU) on AIX�.

The recommendations are based on a philosophy that stability is the ultimate factor in BCU, and takes precedence over functionality and performance. The following recommendations are reviewed often and are intended to be a guiding roadmap of current recommendations for BCU, but also to answer forward looking questions of BCU maintenance strategy. The general guidelines provide supplemental information, corrections, and clarifications to BCU documentation at https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=idwbcu-requestt

DB2 UDB Version 8.2 upgrade considerations

(http://www-1.ibm.com/support/docview.wss?uid=swg21223978)

This document covers the changes and conversions that happen when you install DB2 UDB Version 8.2 (DB2 UDB Version 8.1 FixPak 7) or a higher level on a server that already has DB2 UDB Version 8.1 (up to FixPak 6 level) installed.

Migration to DB2 Version 9 from DB2 UDB Version 8 FAQs

(http://www-1.ibm.com/support/docview.wss?uid=swg21239997)

This document answers some of the more Frequently Asked Questions for migration to DB2� Version 9 from DB2 Universal Database™ (DB2 UDB) Version 8.

DB2 Version 9 migration roadmap

(http://www-1.ibm.com/support/docview.wss?uid=swg21227461)

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 Universal Database™ (UDB) Version 8.

DB2 Viper 2 Open Beta migration roadmap

(http://www-1.ibm.com/support/docview.wss?uid=swg21254493)

This migration roadmap will help you navigate through the available information and resources related to migration to DB2� Viper 2 Open Beta from DB2 Universal Database™ (DB2 UDB) Version 8 or DB2 Version 9.1

SQL0818N - "A timestamp conflict occurred." when executing a 32-bit application on DB2 Version 9.1 Fix Pack 3 for the Solaris SPARC platform or HP Integrity platform.

(http://www-1.ibm.com/support/docview.wss?uid=swg21270919)

After upgrading to DB2� Version 9.1 Fix Pack 3, a 32-bit application may receive an SQL0818N error if running a Call Level Interface (CLI) based application on either the Solaris SPARC platform or the HP Integrity platform. It is possible that 32-bit DB2 internal tools like the Command Line Processor (CLP), or db2look may experience similar problems.

APAR# IZ05048 has been opened to address the problem. DB2 special builds have been created and can be downloaded from the following locations:

Sun (SPARC): ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/special_builds/v9/fp3/sun64/special_17960_sunos_universal.tar.gz
HP-UX (IA64, HP Integrity servers): ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/special_builds/v9/fp3/hpipf64/special_17960_hpipf_universal.tar.gz

The special builds can be installed on top of DB2 Version 9.1 Fix Pack 3 to correct the problem. These special builds are to be installed just like a regular DB2 fix pack.

Restrictions on the use of group privileges when executing DDL statements or binding packages

(http://www-1.ibm.com/support/docview.wss?uid=swg21224422)

Users attempting to:

- Execute certain DDL statements that include references to other database objects
- Bind packages containing static SQL statements that reference other database objects

are unable to do so, because they appear to be missing privileges on the other database objects despite having the required privileges granted to them through group memberships.

-------------------------------------------------------------------------------------

DB2 Magazine eBook - Table Spaces and Locking Levels
(http://cmp.ebookhost.net/db2/quest/6/)

Whether they realize it or not, every programmer who works with DB2 for z/OS needs to know about table-space and table locks. In this new e-book from DB2 Magazine, Bonnie Baker cracks open the mysteries surrounding the different locking levels. This printable, downloadable e-book explains the ins and outs of the DSNZPARMs that control locking and covers timeouts, lock escalation, lock upgrades, deadlocks, index-only locking contention, and more.

-------------------------------------------------------------------------------------

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone
(602) 217-2937 - Fax

Reply | Forward | Messages in this Topic (23)

#608 From: "Steve Hunn" <shunn@...>
Date: Tue Oct 9, 2007 10:36 pm
Subject: SWARUG meeting Dec 6 with Sheryl Larsen and BMC Software lightyr_smh
Offline
Send Email

Hello everyone,

We have a very special SWARUG meeting scheduled for Thursday, Dec 6, 2007.

Sheryl Larsen will be presenting DB2's Top SQL Performance Enhancements

Mike Sniezek of BMC Software will talk about DB2 in DB2 � There is nothing like an example!

Todd Mollenhauer of BMC Software will present Online Schema Made Simple

I know it is nearly 2 months away but this is such a great lineup of speakers and topics that I wanted to give you plenty of notice to fit it into your schedules. The meeting will be at Wells Fargo in Chandler - it is an excellent facility but they do have limited seating so make sure that you reserve your spot. Please RSVP to Helena Garrett garretth@...

Full details are on our website at http://www.lightyr.com/swarug/news.html

Regards,
Steve Hunn
Lightyear Consulting
480 515-1498

Reply | Forward | Messages in this Topic (1)

#607 From: Jay Allen <ja@...>
Date: Tue Sep 18, 2007 9:07 pm
Subject: DB2 Chat with the Lab - September 24th and September 27th ibm4swarug
Offline
Send Email

All,

This month we will be hosting 2 DB2 Chat with the Labs. You may RSVP beginning tomorrow.

DB2 Chat with the Lab - Monday, September 24, 2007 - 8 AM PST, 10 AM Central, 11 AM Eastern, 4 PM London, 5 PM Paris
Workload Management in Viper 2

Our first Chat will provide an overview of the new workload management capabilities being introduced in the next major release of DB2 LUW codenamed Viper 2. The motivation and objectives behind this work will be described along with an overview of the new functions being introduced. Our speakers will be Sal Vella, Vice President of DB2 Development for Linux, Unix and Windows and Business Intelligence and Paul Bird, Senior Technical Staff Member, DB2 LUW Development.

Please RSVP at: https://ww4.premconf.com/webrsvp/register?conf_id=4240079

DB2 Chat with the Lab - Thursday, September 27, 2007 - 8 AM PST, 10 AM Central, 11 AM Eastern, 4 PM London, 5 PM Paris
Deep Dive into Deep Compression - a look into Compression in Viper and Viper 2

DB2 9 (code named Viper) brought the initial functionality and capability of Deep Compression. Significant storage savings and in many cases, performance benefit, is possible. Viper 2 will bring additional enhancements to the compression story in DB2, including automation. This session will provide an overview and roadmap of Deep Compression in DB2 as well as share best practices and insights into successfully deploying this functionality. Our speakers will be Sal Vella, Vice President of DB2 Development for Linux, Unix and Windows and Business Intelligence, Bill Minor, DB2 Development Manager, and Chris Eaton, DB2 Product Manager.

Please RSVP at: https://ww4.premconf.com/webrsvp/register?conf_id=4998975

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

Reply | Forward | Messages in this Topic (1)

#605 From: <garretth@...>
Date: Tue Sep 18, 2007 4:39 pm
Subject: SWARUG meeting - Thursday, Sept 20 ladytarot2003
Offline
Send Email

Hello Everyone!

This is a reminder that our next SWARUG meeting will be on Thursday, Sept 20 at Wells Fargo in Chandler.

Reply | Forward | Messages in this Topic (2)

#600 From: "Steve Hunn" <shunn@...>
Date: Fri Sep 7, 2007 4:09 pm
Subject: SWARUG meeting - Thursday, Sept 20 lightyr_smh
Offline
Send Email

Hello everyone,

Our next SWARUG meeting will be on Thursday, Sept 20 at Wells Fargo in Chandler. Please RSVP to Helena Garrett
garretth@...

Full details are available at our website;
http://www.lightyr.com/swarug/news.html

Regards,
Steve Hunn
Lightyear Consulting

Reply | Forward | Messages in this Topic (2)

#597 From: Jay Allen <ja@...>
Date: Fri Aug 31, 2007 6:57 pm
Subject: Monthly DB2 Update ibm4swarug
Offline
Send Email

All,

Here's my installment of DB2 Updates over the last month or so. Please take note of the FixPaks available for DB2 UDB V8 and DB2 9 HIPER APARs.

Jay Allen

-------------------------------------------------------------------------------------

High Impact Pervasive (HIPER) APARs

DB2 for Linux, UNIX, and Windows Versions 8 and 9 Security Vulnerabilities and HIPER APARs

(http://www-1.ibm.com/support/docview.wss?uid=swg21268189)

Some DB2 for Linux�, UNIX�, and Windows� Version 8 and Version 9.1 products contain serious security vulnerabilities.

The DB2 Technical Support organization is releasing a set of new fix packs for the affected DB2 products that close the vulnerabilities. The following fix packs are being made available on the DB2 Service and Support web site (http://www.ibm.com/software/data/db2/support/db2_9/):

FixPak 15 for DB2 Universal Database™ (DB2 UDB) Version 8.1 (also known as FixPak 8 for DB2 UDB Version 8.2)
(http://www.ibm.com/support/docview.wss?uid=swg24016650)
Fix Pack 3 for DB2 Version 9.1
(http://www.ibm.com/support/docview.wss?uid=swg24016651)

IBM� recommends that you review the vulnerability descriptions and deploy one of the above fix packs to remove the vulnerabilities on your affected DB2 installations.

-------------------------------------------------------------------------------------

DB2 Viper 2 - Open Beta
(http://www-306.ibm.com/software/data/db2/9/openbeta.html)

The DB2 Beta team is looking for DB2 customers, partners or consultants who are interested in new technology and who can help us perfect the upcoming DB2 release. By downloading the DB2 Viper 2 Open Beta code and giving us your feedback you'll be helping to shape the future of DB2. Learn more about the DB2 Viper 2 Open Beta Program if you're interested in working with us.

Benefits of the Beta Program

* Early access to key new DB2 functionality
* Interactive chalk talks and discussion with the DB2 developers
* Jump start on skills development with Viper 2 education and best practices materials
* Development managed forum for all your Viper 2 questions and suggestions

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

-------------------------------------------------------------------------------------

Flash - DB2 Distributed Data Severs to Implement New Lifecycle Policy
(http://www-1.ibm.com/support/docview.wss?uid=swg21268275)

Beginning with IBM� DB2� Universal Database Version 8, and applying to later versions, IBM will now provide standard support for 5 years with an optional purchasable extension of service for 3 additional years, "5 plus 3".

-------------------------------------------------------------------------------------

Redbook - Using the IBM System Storage N Series with Databases
(http://www.redbooks.ibm.com/abstracts/sg247292.html?Open)

This IBM� Redbooks� publication discusses how to optimize the IBM System Storage™ N series products with some of the major commercially available databases available to customers today. Topics include installation, performance, monitoring, and management when using the IBM System Storage N series with IBM DB2� , Microsoft� SQL, and Oracle� . We also cover best practices and tips for using the IBM System Storage N series with these major database applications.

-------------------------------------------------------------------------------------

Redbook - Database Partitioning, Table Partitioning, and MDC for DB2 9
(http://www.redbooks.ibm.com/abstracts/sg247467.html?Open)

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 the 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 - DB2 9 pureXML Guide
(http://www.redbooks.ibm.com/abstracts/sg247315.html?Open)

IBM DB2 9 for Linux, UNIX, and Windows marks a new stage in the evolution of data servers. IBM has continually led the data management industry with the release of innovative technology. DB2 9 is a new generation data server with revolutionary pureXML technology. This technology in DB2 9 fundamentally transforms the way XML information is managed for maximum return while seamlessly integrating XML with relational data.

In this IBM Redbook we discuss the pureXML data store, hybrid database design, and administration. We describe XML schemas, industry standards, and how to manage schemas. We also cover SQL/XML, XQuery, and XPath using easy-to-understand examples. Lastly, we show how to use XML technology efficiently in business applications.

-------------------------------------------------------------------------------------

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 - Best Practices for SAP BI using DB2 9 for z/OS
(http://www.redbooks.ibm.com/abstracts/sg246489.html?Open)

Clients want to know how to exploit the new features of both DB2 V9 and SAP in their SAP BI environments. This IBM Redbooks publication describes the benefits of DB2 V9 for SAP Business Information Warehouse. It covers 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, DataSore 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.

This book 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.

-------------------------------------------------------------------------------------

Redbook - Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows
(http://www.redbooks.ibm.com/abstracts/sg247048.html?Open)

IBM DB2 has long been known for its technology leadership. This IBM Redbooks publication, intended for technical staff who are involved in an Oracle to DB2 conversion project, is an informative guide that describes how to migrate the database system from Oracle to DB2 Version 9 on Linux, UNIX, and Microsoft Windows platforms.

This book provides conversion methodology and step-by-step instructions for installing and using IBM Migration Toolkit (MTK) to port the database objects and data from Oracle to DB2. It illustrates, with examples, how to convert the stored procedures, functions, and triggers. Application programming and conversion considerations are discussed, along with the differences in features and functionality of the two products.

In addition, you can find script conversion samples for data loading, database administration, and reports that are useful for DBAs. The testing section provides procedures and tips for conversion testing and database tuning. The laboratory examples are performed under Oracle 10g and DB2 Version 9. However, the migration process and examples can be applied to Oracle 7, 8, and 9i.

-------------------------------------------------------------------------------------

Redbook - Developing PHP Applications for IBM Data Servers
(http://www.redbooks.ibm.com/abstracts/sg247218.html?Open)

PHP is one of the world's most popular programming languages for building dynamic data-driven Web applications, and IBM data serv�ers store a majority of the world's data -- combining these two technologies is a natural step for any Web developer.

This IBM Redbook provides lots of information for developers, including code samples for creating PHP applications with DB2, Informix Dynamic Server (IDS), and Cloudscape. We use the latest PHP data access extensions including: PHP Data Objects (PDO) and the native ibm_db2 extension for PHP.

We describe the installation and configuration details for setting up the IBM data servers and Apache Web application server for PHP applications. We include Zend Core for IBM, Zend Studio installation, and configuration.
In addition, we discuss the process of porting PHP applications from MySQL 5 to DB2 UDB V8.2.

-------------------------------------------------------------------------------------

Redbook (DRAFT) - High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windows
(http://www.redbooks.ibm.com/redpieces/abstracts/sg247363.html?Open)

As organizations strive to do more with less, IBM DB2 for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions by leveraging enterprise system resources with broad support for clustering software such as HACMP, TSA, and Microsoft Windows Cluster Server.

This IBM Redbook describes DB2’s high availability functions and features focus on High Availability Disaster Recovery (HADR) in OLTP environment. This book provides detailed discussion on HADR including setup, configuration. administration, monitoring, and best practices.

We discuss how to configure cluster software HACMP, TSA, and MSCS with DB2 and how to use these products to automate HADR takeover.

DB2 also provides unprecedented enterprise-class scalability to 32-bit and 64-bit Linux, UNIX, and Windows platforms. We introduce DB2 Database Partitioning Feature covering installation, configuration, and scaling a database partition.

-------------------------------------------------------------------------------------

Redbook (DRAFT) - Index Compression with DB2 9 for z/OS
(http://www.redbooks.ibm.com/redpieces/abstracts/redp4345.html?Open)

In data warehouse applications, it is common to have many very large indexes defined on large tables. It is also possible that the index spaces exceed the size of the tables upon which the indexes are based. As one way of helping you to manage the cost of ownership, in DB2� 9 for z/OS� (New Function Mode) you can choose to compress your indexes and you can define indexes with a page size larger than 4 KB. All references to the DB2 product refer specifically to DB2 9, except where the release level is explicitly mentioned.

Compression has been available for table spaces on z/OS since DB2 Version 3. This IBM� Redpaper explains some of the significant differences between data and indexes in the way that compression is managed, as well as a comparison of the performance characteristics.

A limited set of performance measurements obtained in a laboratory setting are described in this paper, but the main spirit of this paper is not about specific performance numbers. In other words, the paper describes how the implementation methodology affects the performance of both data and index compression, and the authors hope that the reader does not get too focused on the path lengths of the implementation or the performance of any specific hardware. User experiences will vary. It is difficult to predict the impact of index compression on performance, but in this paper we attempt to provide a methodology that will give some insight about how to predict the effect of index compression on the CPU utilization.

-------------------------------------------------------------------------------------

BLOG Entry - Chris Eaton - New ROLLFORWARD option in Viper 2
(http://blogs.ittoolbox.com/database/technology/archives/new-rollforward-option-18171)

Some of the new features in DB2 Viper 2 will probably never get much press attention or even be in a presentation at a conference because they are pretty small. But they can sure help make your life easier. This is one example of such a feature.

DB2 has supported online backups for many years. To restore those backup images you must roll forward to at least the end of the backup time to ensure the database is consistent. In a DPF environment if you want to recreate the entire database you have to roll forward all partitions at least to the end of the most recent backup. Finding that time and putting it into the rollforward command can be a pain. Now there is a new option on rollforward to take you up to the minimum recovery time for the database. Simply use

DB2 ROLLFORWARD DATABASE dbname TO END OF BACKUP

Optionally if you are using DPF you can add

ON ALL DBPARTITINNUMS

to the end of the command and it will roll forward on all partitions to a consistent point in time (the minimum recovery time).

It's a small addition but sometimes it's the little things that go unnoticed but that make life just a bit easier.

-------------------------------------------------------------------------------------

BLOG Entry - Chris Eaton - Viewing HADR status through SQL
(http://blogs.ittoolbox.com/database/technology/archives/viewing-hadr-status-through-sql-17733)

Based on the number of questions and comments in my initial HADR posting I know that many of you are using HADR for high availability or disaster recovery. If you are using HADR, here is an administrative views that you can use to monitor your cluster via SQL.

The view is called SYSIBMADM.SNAPHADR and gives you a SQL interface to monitor your HADR cluster. In this view you can see the primary and standby configuration information like the hostname, port numbers, role, syncmode, etc. As well you can see the monitor information like which log file and log page each server is currently working on, what state the pair are in (i.e. PEER, REMOTE CATCH UP, etc) as well as the current log gap (if any) between the two servers.

As an example, you can monitor the connection state and the log gap with
SELECT HADR_STATE, HADR_LOG_GAP FROM SYSIBMADM.SNAPHADR

One thing you may want to do is run the following query every 5 minutes over the course of a single day. This will give you a profile of you cluster on a typical day showing you the number of concurrent connections and the HADR log gap between the two systems. The log gap should be close to zero if the standby is able to keep up. Don't worry if it's not exactly zero even if you are using sync mode because the reports of where each database is in the log file are not taken simultaneously so when compared there may be a small gap. If you find a log gap appearing, you can add a lot of detailed information from the SNAPDB view to isolate any issues (note you need to first create the table that will store the snapshot info which I call MYHADRMONITOR)

INSERT INTO MYHADRMONITOR
SELECT D.SNAPSHOT_TIMESTAMP, HADR_STATE, HADR_CONNECT_STATUS,
HADR_PRIMARY_LOG_PAGE, HADR_PRIMARY_LOG_LSN,
HADR_STANDBY_LOG_PAGE, HADR_STANDBY_LOG_LSN,
HADR_LOG_GAP,
APPLS_CUR_CONS
FROM SYSIBMADM.SNAPDB D, SYSIBMADM.SNAPHADR H

-------------------------------------------------------------------------------------

alphaWorks - IBM Single System View Monitor for DB2
(http://www.alphaworks.ibm.com/tech/db2top?open&S_TACT=106AH62W&S_CMP=NEWS)

What is IBM Single System View Monitor for DB2?

This tool was developed by IBM technical field specialists and development labs for the purpose of quickly and efficiently monitoring a complex DB2� Database Partitioning Feature (DPF) environment. It uses simple and familiar monitoring user interfaces and combines DB2 snapshot information from all partitions in a DB2 DPF system in order to provide a unified view of the database.

How does it work?
This monitor for DB2 UDB is specifically designed for DPF environments. It provides a unified, "single-system view" of a multi-partition DB2 database that can be used to quickly identify either partition-specific or global problems in the system.

The user interface is character-based and is similar in nature to many UNIX� monitoring utilities.

IBM Single System View Monitor for DB2 uses the DB2 snapshot monitoring APIs to retrieve data. It uses both global as well as partition-specific monitoring information to provide aggregation as well as quick drill-down capabilities.

-------------------------------------------------------------------------------------

alphaWorks - Web 2.0 Starter Toolkit for IBM DB2
(http://www.alphaworks.ibm.com/tech/web2db2/?open&ca=daw-flht-08232007&S_TACT=106AH62W&S_CMP=NEWS)

What is Web 2.0 Starter Toolkit for IBM DB2?

Users starting with PHP are faced with the task of downloading a Web server and PHP modules and finding a relational database. The next struggle is to get code enabled for mash-ups, Ajax applications, and Web feeds. Web 2.0 Starter Toolkit for IBM� DB2� is a conveniently packaged set of products and technologies. The kit enables the quick creation of DB2 Web services and feeds using PHP technology.

All items are in one convenient place; these include downloads for PHP extension, an optional PHP IDE (integrated development environment), sample code, flash demonstrations, and DB2 Express – C: a "free to build, deploy, distribute" data server. Also included are tutorials, examples, and other learning materials.

This technology runs on Windows�.

How does it work?
The Web 2.0 Starter Toolkit for IBM DB2 helps you pull together all the necessary downloads for a complete PHP stack. The toolkit then installs helpful demonstrations and sample code. You can also install the Starter Toolkit demonstrations on top of Zend Core for IBM, a production-ready PHP stack.

Please also see this related alphaWorks technology: Industry Formats and Services with pureXML.

-------------------------------------------------------------------------------------

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone
(602) 217-2937 - Fax

Reply | Forward | Messages in this Topic (23)

#596 From: <topins@...>
Date: Tue Aug 28, 2007 12:50 am
Subject: FW: SWARUG Sept 20, 2007 swarug-users@... sherrytopin
Offline
Send Email

Please RSVP garretth@... if you can attend.

Thanks

SWARUG - September 20, 2007

Location:
Wells Fargo - Ocotillo
2600 South Price Road
Chandler, Arizona 85248
480-724-6834

AGENDA:
08:30 - 9:00 Breakfast
09:00 - 9:15 SWARUG Business
09:15 - 10:10 Presentation #1
10:15 - 10:30 Break
10:30 - 11:25 Presentation #2
11:30 - 12:30 PM Lunch
12:30 PM - DB2 SIG:

Speaker: John Buselli – Regional Vice President, Western Region Softech

John leads Princeton Softech's Western Sales Region with the mission to meet the rapidly growing demand for Princeton Softech's enterprise data management solutions and to ensure client success.

Prior to joining the Princeton Softech team, John was Director of Western Sales for KVS Incorporated, a leading information archiving and compliance software solution provider. While at KVS, John was part of a team that grew revenue over 100% annually that led to the acquisition of the company by Veritas Software. Before KVS, John was Vice President, Western Sales, for Verity Corporation, a leading provider of Information Management and Retrieval solutions. John has also held sales management positions with leading technology firms such as Texas Instruments, Seer Technologies and CrossCommerce.

John is a graduate of the Pennsylvania State University.

Presentation #1
Controlling Data Growth Through Database Archiving in a DB2 Environment
Information is the most valuable asset in business today. Information is required for all revenue generating transactions. As businesses expand, the number of data transactions subsequently grows as well. In this session we will examine best practices for controlling data growth through database archiving, a key component of enterprise data management.

Presentation 2
Managing Test Data Effectively in a DB2 Environment and Data Privacy in the DB2 Testing Environment
Gartner suggests that 70 percent of data breaches are internal to corporations. Many organizations today focus only on implementing strategies to protect data in the production environment, while leaving the testing environment vulnerable.   In this session, you will learn about appropriate strategies for removing, masking and transforming data that can be used to identify individuals in your testing environment. In addition, you will get a better understanding of how you can create contextually accurate but fictionalized data to produce accurate test results and support compliance with local, state, national, international and industry-based privacy regulations.

Reply | Forward | Messages in this Topic (1)

#595 From: "Steve Hunn" <shunn@...>
Date: Tue Aug 28, 2007 12:25 am
Subject: Re: SWARUG Sept 20, 2007 swarug-users@... lightyr_smh
Offline
Send Email

Dilip,

Thanks, this looks good. Before you send it out to the group you will need to add the RSVP information. I know that WF is very particular about security and everyone should pre-register.

Steve

On 8/27/07, Dilip.K.Chakrabarty@... <Dilip.K.Chakrabarty@... > wrote:

SWARUG - September 20, 2007

Location:
Wells Fargo - Ocotillo
2600 South Price Road
Chandler, Arizona 85248
480-724-6834

AGENDA:
08:30 - 9:00 Breakfast
09:00 - 9:15 SWARUG Business
09:15 - 10:10 Presentation #1
10:15 - 10:30 Break
10:30 - 11:25 Presentation #2
11:30 - 12:30 PM Lunch
12:30 PM - DB2 SIG:

Speaker: John Buselli � Regional Vice President, Western Region Softech

John leads Princeton Softech's Western Sales Region with the mission to meet the rapidly growing demand for Princeton Softech's enterprise data management solutions and to ensure client success.

Prior to joining the Princeton Softech team, John was Director of Western Sales for KVS Incorporated, a leading information archiving and compliance software solution provider. While at KVS, John was part of a team that grew revenue over 100% annually that led to the acquisition of the company by Veritas Software. Before KVS, John was Vice President, Western Sales, for Verity Corporation, a leading provider of Information Management and Retrieval solutions. John has also held sales management positions with leading technology firms such as Texas Instruments, Seer Technologies and CrossCommerce.

John is a graduate of the Pennsylvania State University.

Presentation #1
Controlling Data Growth Through Database Archiving in a DB2 Environment
Information is the most valuable asset in business today. Information is required for all revenue generating transactions. As businesses expand, the number of data transactions subsequently grows as well. In this session we will examine best practices for controlling data growth through database archiving, a key component of enterprise data management.

Presentation 2
Managing Test Data Effectively in a DB2 Environment and Data Privacy in the DB2 Testing Environment
Gartner suggests that 70 percent of data breaches are internal to corporations. Many organizations today focus only on implementing strategies to protect data in the production environment, while leaving the testing environment vulnerable.   In this session, you will learn about appropriate strategies for removing, masking and transforming data that can be used to identify individuals in your testing environment. In addition, you will get a better understanding of how you can create contextually accurate but fictionalized data to produce accurate test results and support compliance with local, state, national, international and industry-based privacy regulations.

Reply | Forward | Messages in this Topic (1)

#593 From: Jay Allen <ja@...>
Date: Mon Aug 20, 2007 7:09 pm
Subject: "Web Application Development 101" Webinar ibm4swarug
Offline
Send Email

All,

This is the 5th in our 2007 series of DB2 customer webinars targeted at the application development community. It will take place this Wednesday, August 23rd and is entitled "Web Application Development 101". It will cover the basics about web application development, including terminology, web history and a deeper dive into specific languages. The speakers will be David Majcher and Ty Weis, both members of our TechWorks (formerly Advanced Technical Support) group.

Here are the details:

Title:	Web Application Development 101 Workshop
Date:	08/23/2007
Start Time:	02:00 PM US/Eastern
Duration:	90 minutes
Presenter:	Ty Weis & David Majcher

CONFERENCE DESCRIPTION

This workshop will cover the basics about web application development including terminology, web history and a deeper dive into specific languages like XSLT, PhP, Java, Ajax, and Ruby on Rails to provide a better understanding of the application development environment.

INSTRUCTIONS TO JOIN

1. Join the Online Conference

Click here to join the conference at its scheduled start time or paste this link into your browser: https://whiteglove.on.raindance.com/confmgr/join_as_tempuser.jsp?eventId=46448&invitationId=889379
Click join
Choose the “Light Version” when prompted

* Please note: You will not be able to join the conference until the moderator has started it.

2. Listen to the Audio Conference
Once you have joined the online conference, use the information below to join the audio portion of the conference:

Dial-in Number: 800-896-8445
International Dial-in Number: 785-830-1916
Audio Conference ID: WAD101

Regards,

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

Reply | Forward | Messages in this Topic (1)

#591 From: "Andy K Chang" <andy.k.chang@...>
Date: Mon Aug 20, 2007 11:27 pm
Subject: Invitation: DB2 9 PureXML Webinar - August 28, 2007 11 am PST (Aug 28 11:00 AM MST) andykchang
Offline
Send Email

Description

__________________

All,

Join us for a DB2 9 PureXML webinar on August 28, 2007. In this two-hour session you'll learn why DB2 9 pureXML is a radical departure from what other databases have done to claim support for XML - the difference between XML-enabled databases and a true XML repository. Attendees will learn how to leverage the power and flexibility of XML while leveraging the consistency, familiarity, speed, and reliability of DB2. Learn how to use DB2 9 pureXML to:

• Store XML in a native hierarchical format
• Query XML using SQL
• Query XML with XQuery
• Manage XML schemas and perform XML validation
• Apply existing investments in the following areas to XML data:
o Data maintenance procedures
o SQL development skills
o Performance tuning skills
• Build XML centric applications
• Learn how to have DB2 parse XML documents faster than your application ever could!

This Web seminar will demonstrate the capabilities of DB2 9 pureXML and how DB2 9 pureXML can be used to build a powerful data repository as well as provide a feature rich environment for the developer wanting to utilize XML data.

Title: DB2 PureXML Proof of Technology
Date: Tuesday, August 28, 2007
Time: 11:00 AM - 1:00 PM Pacific Standard Time

System Requirements
PC-based attendees
Required: Windows® 2000, XP Home, XP Pro, 2003 Server
Macintosh®-based attendees
Required: Mac OS® X 10.3.9 (Panther®) or newer

Space is limited.
Please go to https://www.gotomeeting.com/register/391888125 and register today.
For Additional Details Contact: Louis Lo, IBM Information Management Specialist (louislo@...)
Toll Free: 1-888-771-7705, Option 1, ext: 333461

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

American Express made the following annotations on Mon Aug 20 2007 16:24:53 ------------------------------------------------------------------------------ ****************************************************************************** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." American Express a ajouté le commentaire suivant le Mon Aug 20 2007 16:24:53 Ce courrier et toute pièce jointe qu'il contient sont réservés au seul destinataire indiqué et peuvent renfermer des renseignements confidentiels et privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pièce jointe est interdite. Si vous avez reçu cette communication par erreur, veuillez nous en aviser par courrier et détruire immédiatement le courrier et les pièces jointes. Merci. ****************************************************************************** ---------------------------------------------------------------------

Reply | Forward | Messages in this Topic (1)

#590 From: Jay Allen <ja@...>
Date: Mon Aug 20, 2007 11:13 pm
Subject: DB2 9 PureXML Webinar - August 28, 2007 11 am PST ibm4swarug
Offline
Send Email

All,

Join us for a DB2 9 PureXML webinar on August 28, 2007. In this two-hour session you'll learn why DB2 9 pureXML is a radical departure from what other databases have done to claim support for XML - the difference between XML-enabled databases and a true XML repository. Attendees will learn how to leverage the power and flexibility of XML while leveraging the consistency, familiarity, speed, and reliability of DB2. Learn how to use DB2 9 pureXML to:

• Store XML in a native hierarchical format
• Query XML using SQL
• Query XML with XQuery
• Manage XML schemas and perform XML validation
• Apply existing investments in the following areas to XML data:
o Data maintenance procedures
o SQL development skills
o Performance tuning skills
• Build XML centric applications
• Learn how to have DB2 parse XML documents faster than your application ever could!

This Web seminar will demonstrate the capabilities of DB2 9 pureXML and how DB2 9 pureXML can be used to build a powerful data repository as well as provide a feature rich environment for the developer wanting to utilize XML data.

Title: DB2 PureXML Proof of Technology
Date: Tuesday, August 28, 2007
Time: 11:00 AM - 1:00 PM Pacific Standard Time

System Requirements
PC-based attendees
Required: Windows� 2000, XP Home, XP Pro, 2003 Server
Macintosh�-based attendees
Required: Mac OS� X 10.3.9 (Panther�) or newer

Space is limited.
Please go to https://www.gotomeeting.com/register/391888125 and register today.
For Additional Details Contact: Louis Lo, IBM Information Management Specialist (louislo@...)
Toll Free: 1-888-771-7705, Option 1, ext: 333461

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

Reply | Forward | Messages in this Topic (1)

#588 From: Jay Allen <ja@...>
Date: Thu Jul 26, 2007 5:58 pm
Subject: Rational Data Architect Webinar - Wednesday, August 1, 2007 10 am PST ibm4swarug
Offline
Send Email

All,

If you were unable to attend yesterday's Rational Data Architect Proof-of-Technology, here's another chance to get a look at how this Data Modeling tool an help your organization!

Regards,

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

Unlock the mystery of your existing data sources with Rational Data Architect!

Join us for a Webinar on August 1

Join us for a Rational Data Architect (RDA) FREE Proof OF Technology webinar on August 1st!

This 2 hour Webinar on Rational Data Architect (RDA) consists of an online demo focusing on how resolve your problems associated with enterprise data modeling and information integration because of the ever-growing complexity of our enterprise databases and environments.

Rational Data Architect enables you to:
• Create logical and physical data models
• Discover data sources
• Explore and visualize the structure of data sources
• Relate disparate data sources
• Compare the structure of two data sources/targets
• Discover similarities between data sources
• Analyze models and data sources for conformance to enterprise standards
• Design and deploy federated databases

The Webinar will include a demonstration of the basic features of RDA, reverse engineering, transformation and mapping.We will go cover an overview of RDA as well as discuss:
• Navigating the Gui
• Importing; from DDL, from databases, from Erwin
• Implementing naming standards
• Publishing
• LDM to PDM transformation
• Mapping & Compare

Title:		Unlock the mystery of your existing data sources with Rational Data Architect!

Date:		Wednesday, August 1, 2007

Time:		1:00 PM - 3:30 PM EDT

System Requirements
PC-based attendees
Required: Windows� 2000, XP Home, XP Pro, 2003 Server, Vista

Macintosh�-based attendees
Required: Mac OS� X 10.3.9 (Panther�) or newer

Space is limited.
Reserve your Webinar seat now at:
https://www.gotomeeting.com/register/923551785

Reply | Forward | Messages in this Topic (1)

#586 From: Jay Allen <ja@...>
Date: Fri Jul 6, 2007 8:23 pm
Subject: Monthly DB2 Update ibm4swarug
Offline
Send Email

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21240661)

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

(http://www-1.ibm.com/support/docview.wss?uid=swg21239997)

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)

FEATURED STORIES

From the Editor
Several guests (old friends and new) dropped in to DB2mag.com this month, bringing housewarming gifts for the new site. Highlights include:

* Extreme SQL Performance: Performance guru Sheryl Larsen explains how to optimize SQL, schema designs, performance structures, bufferpools, and storage to match your DB2 workload.
* DB2 for LUW performance tips: DB2 performance and security guru Scott Hayes brings advice from his popular DB2 LUW Performance Diagnosis Lab series to the DB2 Magazine blogs.
* Wiki Wisdom: Readers share their best tips on DB2 for z/OS encryption, DB2 data movement tools, DB2 and .Net, plus thoughts on the Informix community, cultural paradigms, and life with DB2.

Also new on the site this month: The DB2 Magazine career center, featuring job listings and advice for tech professionals.

IBM NEWS

Cheetah is Ready to Pounce
IBM celebrated the release of Informix Dynamic Server 11 (codenamed "Cheetah") at the Informix development lab in Lenexa, Kansas, yesterday. Learn about the new features at the IBM Informix site or in "Run, Cheetah, Run," by Stuart Litel. The new Multinode Active Cluster for High Availability feature (known as MACH 11), gets a thorough write-up in Eric Herber's Informix Zone blog. Coming June 21: A webcast on the architect's view of new Informix Dynamic Server features.

DB2 Customer Ingenix Wins at TDWI
Healthcare information and research company Ingenix won The Data Warehouse Institute's 2007 Best Practices Award in the enterprise data warehouse category. TDWI's Best Practices Awards program identifies and honors companies that have demonstrated excellence in developing, deploying, and maintaining BI and DW applications. Winners are chosen by a panel of independent judges.

POLL POSITIONS

In his recent column, Howard Fosdick suggests the no-cost DB2 Express-C as a way for certification candidates to get some hands-on DB2 experience while preparing for certification. Tell us what uses you've found for the free version of IBM's hybrid XML-relational data server.

MUST READ

DB2 9 for Developers
By Philip K. Gunning (MC Press, 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.

SKILLS SET

	DB2 9 Book Discounts Phil Gunning's book is just the latest volume on DB2 9. These two books are currently available at a discounted price through the IBM Information Management Bookstore: DB2 9 Fundamentals Certification Study Guide, by DB2 Magazine columnist Roger E. Sanders IBM DB2 9 New Features, by key members of the DB2 9 development team.
	Information Management Certification Offers Certification candidates can take up to three certification exams at no charge at the upcoming IBM Information On Demand 2007 conference, Oct. 14-19 in Las Vegas. Additional exams are available for $75 each. Get details about the available certification exams, discount vouchers, and pre-conference technical education on DB2mag.com's skills and education page.
	New Certification Exam and Tutorial Series: IBM Informix Dynamic Server V11 System Administration To achieve this IDS certification credential, candidates must take and pass exam 918. This new exam includes seven sections containing a total of 71 multiple choice questions. Candidates have 120 minutes to complete the exam and must score 70 percent correct or greater to pass. A new series of eight tutorials helps candidates prepare. A quick registration is required, and each tutorial should take less than two hours to complete.
	International DB2 User Group (IDUG) Updates: IDUG recently posted the Spring 2007 issue of IDUG Solutions Journal to its Web site. The issue features user- and industry expert-authored articles on DB2 locking, reorg and automation, deep compression in DB2 9, and more. The conference schedule is now available for IDUG 2007 - Europe, 5-9 November 2007 in Athens, Greece. Completing an online registration survey brings a chance to win a complimentary registration. The IDUG 2007 - North America wrap-up article is now available, and the 2008 North America Call for Presentations and Call for Volunteers are open at idug.org.

IN THE ZONE

	Get started with IBM DB2 Test Database Generator
	DB2 and Ruby on Rails, Part 2: One powerful combo!
	System Administration Certification exam 918 for IDS 11 prep, Part 3
	Add advanced search to your WebSphere Commerce store with OmniFind Discovery Edition
	Applying category-based item security in WebSphere Product Center
	Get started with Industry Formats and Services with pureXML
	Character-based string functions in DB2 9

-------------------------------------------------------------------------------------

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone
(602) 217-2937 - Fax

Reply | Forward | Messages in this Topic (23)

#583 From: Jay Allen <ja@...>
Date: Fri Jul 6, 2007 5:59 pm
Subject: Rational Data Architect Proof of Technology, July 25 ibm4swarug
Offline
Send Email

All,

I'm pleased to announce that IBM will be conducting a Proof of Technology - "Discovering the Value of IBM DB2 Rational Data Architect" at the IBM Phoenix office on July 25. A PoT is a combination of lecture, demonstration and hands-on labs intended to give attendees a "deep dive" of the technology in a controlled environment.

To register, simply RSVP to neil.williams@....

Rational Data Architect is an enterprise data modeling and integration design tool which works with all the major databases, including Informix, DB2, Oracle, SQL Server, MySQL, Sybase, and many others.

Some examples of its capabilities include:

Create logical and physical data models.
Discover, explore and visualize the structure of data sources.
Discover potential relationships and identify relationships (through mapping) between disparate data sources.
Compare and synchronize the structure of two data sources/targets.
Analyze models and data sources for conformance to enterprise standards.
New release features integrations with IBM Rational Software Architect, Eclipse 3.2 and IBM Information Server; additional mappings and expanded support for XML, DB2 V9, Sybase, Informix and MySQL.

Additional information about Rational Data Architect is available here:
http://www-306.ibm.com/software/data/integration/rda/

Discovering The Value of IBM DB2 - Rational Data Architect
Proof of Technology

The Rational Data Architect (RDA) Proof-of-Technology (PoT) consists of a one day event combining demonstrations, presentations and lab exercises focusing on logical and physical data modeling with RDA. This Proof-of-Technology starts with a demonstration of the basic features of RDA, and then includes presentations and hands on labs. During the PoT, attendees will be guided through a demo to acclimate the attendee with the RDA graphical user interface.

Objective: The objectives of this session is to ensure a common understanding of the high level challenges of managing data and how RDA provides significant assistance in meeting these challenges. How RDA provides this assistance will be reinforced via demonstrations and hands on labs.
Audience: This session is specifically designed for DBAs, Information Architects and Data Modelers. No prerequisite knowledge is required; however, general familiarity with data modeling is helpful.

Date: July 25

Where: IBM Offices at 2929 N Central Ave, 7th floor, Room 701, Phoenix, AZ

Cost: This session is offered free of charge. However, participants are responsible for their own business travel expenses.

Time: This session is scheduled for one day beginning at 9:00 AM and ending at 5:00 PM.

Duration: 1 Full Day

Agenda:
MORNING
WHY RATIONAL DATA ARCHITECT (RDA)
OVERVIEW OF RDA
DEMO OF SOME THINGS WITH HANDS ON
NAVIGATING THE GUI
IMPORTING (GETTING STARTED)
FROM DDL
FROM DATABASE
FROM ErWin
IMPLEMENTING NAMING STANDARD
PUBLISHING
SUMMARY

AFTERNOON – DEMO/LABS
MODELING
LOGICAL MODELING
DOMAIN MODELS
PHYSICAL MODELS
TEAMING
MAPPING
WRAP UP

Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone & Fax

Reply | Forward | Messages in this Topic (1)

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages