SupportConnect - Unicenter Database Management Solutions Newsletter, Version 05.06

NOTE: E-News technical information is dynamic and links in archived copies of these technical newsletters may eventually become invalid as the products evolve. Please check the support web page for your product to get the latest technical information.


Computer Associates
E-News
Unicenter® Database Management Solutions
Newsletter

Version 05.06
August 01, 2005

In This Newsletter

Product News
> Unicenter® Database Management r11.5 for DB2 UDB for z/OS Beta Invitation Letter
> Unicenter® Database Command Center r11.1 Beta Invitation Letter

Product Updates
> Hyper UFRE114 for Unicenter® Fast Recover® r11 for DB2 UDB for z/OS
> Hyper UDTE198 for Unicenter® Detector® r11 for DB2 UDB for z/OS
> Hyper UFLE166 for Unicenter® Fast Load™ r11 for DB2 UDB for z/OS
> Hyper UIDC296 for Unicenter® Database Organizer™ 5.1.3 for IMS
> Hyper UIDD075 for Unicenter® Database Organizer™ r11 for IMS

General Information
> Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
> Product Tips for Unicenter® Database Management Solutions for IMS
> Product Tips for Using SupportConnectSM With the Unicenter® Database Management
Solutions for DB2 UDB for z/OS and IMS Solutions
> Technical Interview: Phil Grainger, Product Manager, With Ron Colmone, VP DB2 Performance Tools

Special Events
> DB2 Information Management Technical Conference
> IDUG Technical Symposium 2005
> IDUG Europe 2005 - Berlin, Germany
> Technical Webcast for Unicenter® Database Management

Product News
Unicenter® Database Management r11.5 for DB2 UDB for z/OS Beta Invitation Letter
Dear Valued Customer,

Computer Associates International, Inc. (CA) is pleased to announce that our Unicenter Database Management Solutions for DB2 UDB for z/OS development has opened registration for the r11.5 beta program.

Unicenter Database Management Solutions r11.5 for DB2 UDB for z/OS has come out with several exciting features:
  • Additional DB2 V8 exploitative support in several tools.
  • Unicenter® RC/Migrator® includes support for long names, online schema changes, and greater than 254 partitions.
  • Unicenter® RC/Update® supports long names.
  • Unicenter® RC/Query® includes support for long names, new DB2 V8 fields on reports, DB2 V8 DDL syntax, and SEQUENCE objects.
  • Unicenter® RC/Secure® includes support for long names, MQTs, and SEQUENCE objects.
  • Unicenter® RC/Extract™ supports mixed-case object names with embedded blanks.
  • Unicenter® Database Analyzer® supports long names, version tables, 999 partitions for the DU utility code, and symbolics for LOBs.
  • Unicenter® Detector® includes full support for DB2 V8 including long names, support for collecting dynamic SQL text as standard activity, and integrated data sharing statistics.
  • Unicenter® CA-Insight™ for DB2 includes full support for DB2 V8 including long names.
  • Unicenter® Plan Analyzer® includes support for long names, new SQL syntax, and 2 MB SQL support for single statement explains through the Detector dynamic explain interface.
  • Unicenter® Subsystem Analyzer supports long name strings and integrated data sharing statistics.
  • Unicenter® SQL Ease® includes support for new SQL syntax and long names within SQL statements.
  • Unicenter® Fast Recover® supports long names, DPSIs, 2000 byte index keys, and SORTLOG for log only recoveries.
  • Unicenter® Log Analyzer® includes support for long names, DB2 V8 table version, and the generation of GRANT / REVOKE.
  • Unicenter® Quick Copy includes support for long names and the concurrent copy option.
  • Unicenter® Recovery Analyzer® includes support for System Backup / System Restore and point-in-time recovery.
  • Unicenter® Fast Check® includes support for long names, 4096 partitions, DPSIs, varying length index keys, online schema changes, and dynamic allocation of work data sets.
  • Unicenter® Fast Index® supports varying length index keys.
  • Unicenter® Fast Load™ includes support for long names and 4096 partitions.
  • Unicenter® Fast Unload® supports long names and 4096 partitions.
  • Unicenter® Rapid Reorg® supports long names, 4096 partitions, and discards for online reorg.
As you may be aware, by joining the beta program, you get an opportunity to try out the new features and changes earlier than the rest of the customer base. Also, you get input into product direction and the ability to tell us if something really won't work or will affect you positively or negatively. We can make changes in the product during beta that might not be possible once it has gone GA. The Beta testing process is an integral part of our product development. You will be assisting us by helping to ensure the product is stable, as well as providing us any input you may have on new features or functionality you might like to see added to the product.

To learn about the systems requirements and to register to participate in this beta program, please visit: supportconnectw.ca.com/public/beta/unidbmgtdb2/unidbmgtdb2beta.asp.

Please feel free to contact me with any questions or concerns.

We look forward to hearing from you.

Very truly yours,
Mohan Kumar
Beta Program Coordinator
Tel: +1 630 505 6626
Fax: +1 630 505 6410
Mohan.kumar@ca.com

For more information about our Unicenter Database Management Solutions for DB2, please visit: ca.com/Solutions/Solution.asp?ID=2906.

For a complete overview of all CA beta programs, please visit: supportconnectw.ca.com/public/ca_common_docs/cabetas-programlist.asp.

Top

Unicenter® Database Command Center r11.1 Beta Invitation Letter
Dear Valued Customer,

Computer Associates International, Inc. (CA) is pleased to announce that our Unicenter® Database Management solution team has opened registration to enroll beta customers to test the first of our next generation of database management solutions - Unicenter Database Command Center (Unicenter DCC).

Unicenter DCC is a new web-enabled cross-platform database management portal that centralizes the management of databases spread across multiple Relational Database Management Systems (RDBMS) and platforms. This solution addresses the challenges of managing heterogeneous databases and increases DBA productivity. Unicenter DCC also provides advanced database administration features for the Ingres® r3 database.

Some of the exciting new features of this beta release are listed as follows:
  • Heterogeneous Database Support - Unicenter DCC supports databases from multiple vendors on multiple platforms through a single product, eliminating the need to install, learn, and invest in multiple tools specific to each database type. Databases supported are Oracle; DB2 UDB for Linux, UNIX, and Windows; DB2 for z/OS and Ingres r3.


  • Intuitive and Flexible Interface - Unicenter DCC is built using industry standard web technologies. This helps ensure optimum performance, consistent look-and-feel, and easy customizable workspaces. Unicenter DCC also provides a central interface for integrating other CA database management products.


  • Object Management - With the browser interface, you can quickly perform tasks like creating, altering, and renaming objects and many other tasks specific to each database type.


  • Data Unload for Ingres - Unicenter DCC provides the ability to unload data from Ingres r3 tables and offers the ability to schedule data unload jobs on any server in the enterprise. The data can be unloaded in multiple formats, such as delimited, fixed, binary, and XML data formats.


  • Reorg for Ingres - The object reorganization for Ingres r3 feature improves the efficiency of Ingres databases by restructuring objects that have become fragmented because of data inserts, updates, and deletions.


  • Integration with Other Products - Unicenter DCC provides a launch pad for other CA database management products. This offers integration with Unicenter® TSreorg™ for Oracle and Unicenter® Fast Unload® for DB2 UDB for Linux, UNIX, and Windows.


  • Customizable Interface - Unicenter DCC lets you tailor your workspace. For example, you can tailor your workspace to only view the production or test servers you manage. This feature saves time and effort when navigating to the respective domains.


  • Thin Client Technology - Unicenter DCC does not require you to install any additional components on the client. You can launch Unicenter DCC by launching a browser and securely connecting to databases across various geographical locations.
A complete listing of all the features can be found in the documentation directory on the beta distribution CD.

We would encourage you to enroll early to participate in Unicenter DCC and experience its many benefits.

To learn about the systems requirements and to register to participate in the beta program for Unicenter Database Command Center r11.1, please visit: supportconnectw.ca.com/public/beta/udbcc111/udbcc111beta.asp.

Your participation in programs like this helps CA deliver market-leading solutions of the highest quality. The Unicenter Database Management solutions team looks forward to working closely with you.

Thank you.

Sincerely,

Unicenter Database Management Solutions Team

Top

Product Updates
Hyper UFRE114 for Unicenter® Fast Recover® r11 for DB2 UDB for z/OS
For more information about hyper UFRE114 and to download the hyper,
please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UFRE114.

Top

Hyper UDTE198 for Unicenter® Detector® r11 for DB2 UDB for z/OS
For more information about hyper UDTE198 and to download the hyper,
please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UDTE198.

Top

Hyper UFLE166 for Unicenter® Fast Load™ r11 for DB2 UDB for z/OS
For more information about hyper UFLE166 and to download the hyper,
please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UFLE166.

Top

Hyper UIDC296 Unicenter® Database Organizer™ 5.1.3 for IMS
For more information about hyper UIDC296 and to download the hyper,
please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UIDC296.

Top

Hyper UIDD075 Unicenter® Database Organizer™ r11 for IMS
For more information about hyper UIDD075 and to download the hyper,
please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UIDD075.

Top

General Information
Product Tips for Unicenter® Database Management Solutions for DB2 for z/OS
Product Tip: Unicenter® Plan Analyzer® for DB2 UDB for z/OS. How can you prevent excessive PLAN_TABLE rows from accumulating over time?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI69006

Product Tip: Unicenter® CA-Insight™ Performance Monitor for DB2 UDB for z/OS. Where are the GSS IMOD datasets defined?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI68913

Product Tip: Unicenter CA-Insight Performance Monitor for DB2 UDB for z/OS. Is there a way to evaluate storage usage for each request and free the storage, if necessary?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI68910

Product Tip: The message DBG550C1W SELECTED RECORDS NOT FOUND is displayed when history records are displayed in Unicenter CA-Insight Performance Monitor for DB2 UDB for z/OS (IDB2) Thread History selection screen. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI69074

Product Tip: When the .OPTION is set to NOERRORS within Unicenter® Batch Processor for DB2 UDB for z/OS (RBP), the job continues when an IGD17101I error is encountered, even though its accompanied by a rc=8 and rsn=38. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI69880

Product Tip: What are the REGION requirements for Unicenter® Fast Load™ for DB2 UDB for z/OS (PFL) for the different OUTPUT-CONTROL options of BUILD, ALL, and REORG?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI69253

Product Tip: Unicenter Fast Load for DB2 UDB for z/OS (PFL) is being used to load an object with no explicitly defined clustering index. In such a case, the first index created is used as the clustering index even though it was not defined with the CLUSTER option.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI69911

Product Tip: Running Unicenter® Rapid Reorg® for DB2 UDB for z/OS (PRR). Execution of utility with DATA-AVAILABLE CRITICAL option for Online Reorg processing and the job is failing with the following:
POR0125E - RID SORTING SUBTASK HAS ABENDED
This error has occurred in CSECT 'RRA@OROP'.
PRR0028I - RAPID REORG Processing Ended - Return Code: 008
The process appears to be abending within sort with the sort package of DFSORT in this instance.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI69245

Product Tip: Running Unicenter® Fast Unload® for DB2 UDB for z/OS (PFU) with SHRLEVEL CHANGE processing and it is discovered that the unload file may contain extra or missing rows depending on the previous DML INSERT / UPDATE / DELETE activity. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI69340

Product Tip: Running Unicenter® Recovery Analyzer® for DB2 UDB for z/OS (PRA). Execution of ssid@CDC and receiving message RAW00017 message within step that performs checkpoint processing. This message is produced normally as Recovery Analyzer waits for the checkpoint process to complete. A value in the Recovery Analyzer PRA PARMLIB member determines how long Recovery Analyzer waits for the automatic checkpoint process to complete. What
value(s) in the PRA member control the wait for the checkpoint process to complete?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI69208

Top

Product Tips for Unicenter® Database Management Solutions for IMS
Product Tip: Running Unicenter® Database Organizer™ for IMS (DBO) with BUF4RANDSEQ=1500 specified receiving messages:
IDI0900E UNABLE TO ACQUIRE STORAGE FOR WORK AREA RPL.
IDI7601I FUNCTION RETURN CODE = 0012 (MODULE DBOGBHB, SUFFIX (0), OFFSET 04C2)
IDI7602I CUMULATIVE RETURN CODE = 0012
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI70267

Top

Product Tips for Using SupportConnectSM With the Unicenter® Database Management Solutions for DB2 UDB for z/OS and IMS Solutions
Product Tip: How to Download and Install Unicenter Database Management Solutions for DB2 UDB for z/OS or IMS from SupportConnect?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC366495

Top

Technical Interview: Phil Grainger, Product Manager, With Ron Colmone,
VP DB2 Performance Tools

This month will start a series of interviews between Phil Grainger, the Product Manager for our DB2 tools, and key members of the development teams.

This month, Phil is with Ron Colmone. Ron is a VP in our DB2 tools development group, with specific responsibilities for the CA DB2 Performance tools, Install, and Common Services used by all of the DB2 products.

Ron - release 11.5 of the DB2 tools is right around the corner; what types of changes will we expect to see in the products and general services?

Most of the major enhancements made to the products are to support DB2 V8 features. There have been significant changes made to the ISPF display service in order to handle long object names and enable column / field level scrolling. Additionally, there have been significant changes made to the product driver, the program that manages the main menu and calls the batch utilities.

You mentioned significant changes were made to our Driver program. Could you just spend a few moments explaining what type of changes we have made in this area?

Sure, Phil. First of all, we have now integrated into the Driver program the use of the PTXMAN (XManager) started task. Many of our customers that are familiar with Detector and Subsystem Analyzer are already accustomed to configuring and running PTXMAN. PTXMAN has always been a generalized server task. We've just expanded its usage to provide us with a means to perform secured authorized functions in an on-line TSO environment. A new global parameter has been introduced in the SETUP PARMLIB member to identify the XManager to connect to when the driver program starts. Other products that previously utilized XManager for services, now utilize the common parameter.

So, customers will ALWAYS need to run the PTXMAN started task to use ANY of our products (not just Detector or Subsystem Analyzer) - right?

That's correct. Both batch and on-line users of our products will require an active XManager address space to be available. Users can optionally configure an XManager Started Task for use by all of the products, shared with the products such as Detector and Subsystem Analyzer that have historically used XManager for the performance collections, or they can elect to configure a separate XManager Started Task for their collections. We do discuss these various configuration methods in our General Facilities Reference Guide.

If the PTXMAN configuration is not carried out correctly, will people still be able to use our products?

Since PTXMAN is required by the Driver program, improper configuration could result in the products not being available. If the PTXMAN Started Task is not active, or the Driver program is unable to connect to XManager, for whatever reason, an error message will be issued indicating that an attempt to connect to XManager failed. If XManager is active and you are still unable to connect, please review your SETUP PARMLIB member to ensure that the appropriate XMANID is specified.

OK, so then if XManager is required by all of the products, including batch, does that have any impact on the installation of our products?

Good question. As you know, during our install process we invoke our products to run various tasks such as, object compares, alters, binds, etc. These tasks generally run as a Batch Processor scripts and execute under the Driver program. Therefore, since the Driver program is being executed, the PTXMAN started task will need to be running before the installation process can proceed. In some environments, it might not yet be feasible to implement PTXMAN as a started task. For this reason, it is possible for XManager to be submitted as a long running Batch JOB. Please reference the appendix in the General Facilities Reference Guide describing how to configure PTXMAN as a Batch JOB.

You mentioned changes to the ISPF display interface for supporting Long Name Objects, can you explain these changes?

Certainly. IBM has provided a relatively new feature to ISPF to enable the end user to use their LEFT and RIGHT scroll commands to scroll within a field on the panel when the variable is longer than the field on the panel. The feature works by placing the cursor in a field that supports this type of scrolling and use the LEFT (PF10) and RIGHT (PF11) commands. Since many of the Object Names in DB2 V8 can now be up to 128 bytes long (Column names 30 bytes long), it would be almost impossible to accommodate entering and displaying these names on a 3270 screen. Therefore, making use of this new feature in ISPF is essential to working with Long Names. Additionally, our ISPF display general service manages an ISPF dynamic area on many of our product's panels. The ISPF feature for field level scrolling is not available in the dynamic area of the panel, so we've implemented a similar field and column level scrolling in our general service.

That sounds pretty innovative. Is there anyway to view or enter the entire contents of the field without using the scroll commands?

Yes. By placing the cursor on the field and entering the EXPAND command (perhaps associated with a PFKEY) you can get a POPUP that expands the entire contents of the field for VIEW/EDIT purposes. Similarly, the EXPAND command is also available in the dynamic area.

What about objects that have been redefined by IBM to have longer lengths, but are being used by our customers with the existing (version 7) lengths - e.g. tables with no more than 18 character names - will they see any changes?

For the most part, the panels have been visually unchanged. By default they will still accommodate the Version 7 object name lengths, without needing to scroll or expand the fields/columns. So customers that are not planning to take advantage of long object names will not see a major difference in the user interface.

I'm sure that support for Long Name objects has impacted many areas of the products. How did this affect the PTDB database tables?

Many of the tables in the PTDB database have had to change in order to accommodate Long Name objects or expanded statistics columns. In some cases, we need to wait until DB2 has been converted to DB2 V8 running in NFM before we can alter our tables, due to increased lengths of KEY columns that would cause Index Keys to expand beyond the previous 254 byte limit. Therefore, when upgrading to DB2 V8 or moving the subsystem from Compatibility Mode, Enabling New Function Mode, or to New Function Mode, there may be a need to re-execute the DB2 tasks though the Post Install process. This information is documented in the Post Install Reference Guide.

Are there any consequences if the DB2 Post Install Tasks are preformed after an upgrade or a change to New Function Mode?

It would depend on the product if there were required changes to its tables or packages. However, to help ensure that installation tasks were performed, the Driver program will validate the SSIDVER and SSIDMODE keyword parameters that were specified in the SETUP PARMLIB member with the version and mode of the DB2 subsystem when a connect request occurs to the subsystem. If they don't match, the connection is denied and a message is issued warning the user that the Post Install process may not have been executed, since the Install process customizes the DDL and Bind Control cards based on the these values in PARMLIB.

Thank you, Ron, for the time you've taken today. Perhaps next time we can start to look further at specific product features coming in release 11.5.

Top

Special Events
DB2 Information Management Technical Conference
September 11-16, 2005
Walt Disney Dolphin Hotel
Lake Buena Vista, Florida

CA's Unicenter® Database Management solutions for DB2 UDB for z/OS provide DBAs the advanced functionality critical to maintaining today's 24X7 environments, while affording organizations exceptional value for their investment. These solutions are designed as complete, integrated solutions that address today's most pressing performance, administration, and backup and recovery challenges.

Visit the DB2 Information Management Technical Conference product EXPO to explore CA's complete portfolio of solutions for DB2 UDB for z/OS and Linux, UNIX, Windows. Featured solutions include:
  • Unicenter® Database Performance Management for DB2 UDB for z/OS
  • Unicenter® Database Administration for DB2 UDB for z/OS
  • Unicenter® Database Backup and Recovery for DB2 UDB for z/OS
  • Unicenter® Database Management for DB2 UDB for LUW
  • eTrust™ Identity and Access Management
  • AllFusion® Data Modeling Suite
For more information, visit: ca.com/events/eventdetail.aspx?CID=16309&CevID=72260.

Top

IDUG Technical Symposium 2005
IDUG 2005 - Technical Symposium
conferences.idug.org/techsymposium/2005/index.cfm
September 26-27, 2005
Radisson Admiral - Toronto Harbourfront
Toronto, Canada

As a data management professional, you are being asked to do more than ever before. Flexibility, adaptability and speed - along with tools that allow you to perform at the highest level - are your greatest assets. The IDUG 2005 - Technical Symposium can provide attendees with information on how to achieve an on demand DB2 world through high-profile DB2 education presented by world-renowned DB2 authorities, a DB2 Products & Services Exhibition showcasing the latest in products and services including Unicenter® Database Management solutions for DB2, the opportunity to ask the experts your tough DB2-related questions at the IBM Panel Discussion, and invaluable peer networking opportunities.

Don't miss the opportunity to see CA's own DB2 expert, Phil Grainger, present "Version 8 for z/OS Partitioning - Warts and All." This session, scheduled for a half day on Tuesday, September 27, 2005, will look in detail at the differences between table based and index based partitioning and will consider some real world examples. The session will then critically examine various aspects of partitioning that still don't work "as expected" and some things that cause confusion.

For more information, visit: ca.com/events/eventdetail.aspx?CID=16320&CevID=72133.

Top

IDUG Europe 2005 - Berlin, Germany
IDUG 2005 - Europe is the premiere European DB2 education event. Whether you are new to DB2 or have used it for some time, IDUG is the place to be next October in Europe to gain valuable information and proven user experiences on how to get the most out of this powerful database engine.

IDUG 2005 - Europe offers:
  • More than 100 educational sessions presented by users, consultants, developers, and industry experts.
  • Face-to-face interaction with industry leading vendors during the DB2 Solution Center.
  • FREE DB2 Certification Exams for DB2 UDB for z/OS, and DB2 UDB for Linux, UNIX, and Windows.
  • Invaluable networking opportunities to enhance your professional peer network.
IDUG 2005 - Europe
conferences.idug.org/europe/2005/index.cfm
October 24-28, 2005
Estrel Hotel and Convention Centre
Berlin, Germany

Top

Technical Webcast for Unicenter® Database Management
The Technical Update Webcast for Customers for the latest product announcements:
Unicenter® Database Management for DB2 for Linux, UNIX, Windows Tech Update Webcast -
CA's Unicenter Database Management for Distributed RDBMS provides comprehensive performance management and administration for DB2 UDB for LUW databases in addition to other database types.

Significant functionality and benefits:
  • New fast unloading technology for DB2 UDB for LUW reduces database unloading time.
  • Graphical Windows and browser-based consoles enables faster response and resolution.
  • Advanced capabilities without reliance on specific database type or versions eliminates premature and costly database upgrades.
  • Single solution for Database Management from one vendor with superior worldwide service and support.
  • Built-in CA Common Services integration enables greater functionality and capabilities as product technologies are added together.
Unicenter Database Management for DB2 for Linux, UNIX, Windows Data Sheet:
ca.com/Solutions/Collateral.asp?CID=69654&ID=335

Unicenter® Fast Unload® for DB2 UDB for Linux, UNIX, Windows Data Sheet:
ca.com/Solutions/Collateral.asp?CID=68535&ID=1355

Top


You are subscribed as &*TO;.

To subscribe, unsubscribe, or change the format for this or other newsletters, please go to our E-News subscription page. You can also unsubscribe by sending an email to: editor_man-auto@ca.com with "Unsubscribe enews_man-auto" (without the quotes) in the message body. You must include the exact email address that you wish to unsubscribe.
Feedback? Comments? Suggestions?
Send an email to: editor_man-auto@ca.com. All submissions become the property of the publisher and may or may not be reprinted.
NOTE: This address should be used only for feedback on this newsletter. Requests for technical support should be submitted through normal channels.

Computer Associates