SupportConnect - Unicenter Database Management Solutions Newsletter, Version 06.10
  

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.


CA
E-News
Unicenter® Database Management Solutions
Newsletter
Version 06.10
November 27, 2006

In This Newsletter
Product News
> Unicenter® Database Management for Distributed Database Tools
> Unicenter® Database Management r11.2 Beta
> Unicenter® Database Management Solutions for DB2 UDB for z/OS
> DB2 Tools P01 - Drop Support Reminder
> Unicenter® Database Management Solutions for IMS for z/OS
> IMS Tools 5.1 - Drop Support Reminder

General Information
> Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
> Product Tips for AllFusion® Modeling Solutions
> FAQs for AllFusion® Modeling Solutions
> Announcement for AllFusion® Modeling Solutions
> FAQs for Unicenter® Database Management Distributed Database Tools
> AllFusion® CA-File Master™ Plus for IMS Beta Announcement
> AllFusion® CA-InterTest® Batch r8 Beta Announcement: Helping You Meet the Challenges
of Debugging DB2 Stored Procedures and IMS/DC Programs
> Unicenter® Database Command Center Architecture
> Road Maps

Special Events
> CA World® 2007
> Access the Latest On-Demand Technical Webcasts
> Webcast: The Data Model Scorecard
> Free iPod nano When You Buy Qualifying AllFusion® ERwin® Data Modeling

Product News
Unicenter® Database Management Distributed Database Tools

Unicenter® Database Management r11.2 Beta
Dear CA Database Management Customer,

We are pleased to announce:

Unicenter Database Management r11.2 beta software is available.

For information on how to obtain the Unicenter Database Management (UDM) r11.2 beta software, you need to first register to participate and be accepted into the BETA program. You can do so after signing into SupportConnectSM and then selecting this link to apply:
supportconnectw.ca.com/public/beta/udbm112/udbm112beta.asp.

Unicenter Database Management r11.2 is a browser-based multi-database management solution that unifies and simplifies the management of different Relational Database Management Systems (RDBMS). A consistent look and feel helps Database Administrators (DBAs) manage different databases with increased productivity, and helps reduce RDBMS complexity and management costs.

Some of the exciting new capabilities this beta release includes:

  • Microsoft SQL Server 2005 support
  • Expanded multi-database administration support
  • Expanded remote and agent-based database monitoring and performance management capabilities
  • Expanded database unloading support for export or to load to other databases
  • Expanded database online/offline restructuring and optimization
Built on the CA EITM Integration Platform, UDM r11.2 includes CA's Management Database (MDB) and supports an MDB on Ingres, Oracle, or Microsoft SQL Server database platforms. Also provided in this release is additional integration for customers with Unicenter® Network and Systems Management for comprehensive enterprise-wide infrastructure management coverage.

Your participation in programs such as this Beta enables CA to deliver market leading solutions of the highest quality based upon your requirements and direct input. The Unicenter Database Management Solutions team looks forward to your participation and input.

The Unicenter Database Management Team

Top
Unicenter® Database Management Solutions for DB2 UDB for z/OS

DB2 Tools P01 - Drop Support Reminder
The termination of support for the individual product releases that comprise the Unicenter® Database Management Solutions P01 for DB2 UDB for z/OS release happened as of October 1, 2006. Click here to read the full drop support letter information. Upgrade options include r11 SP3 and the r11.5 release which contains the most recent DB2 V8 exploitation. You can also find the latest support release schedule for all DB2 Tools by visiting SupportConnectSM.

Top
Unicenter® Database Management Solutions for IMS for z/OS

IMS Tools 5.1 - Drop Support Reminder
The termination of support for the individual product releases that comprise the Unicenter Database Management Solutions 5.1 for IMS for z/OS is effective May 31, 2007. Click here to read the full drop support letter information. Upgrade options include r11 SP2 and the r11.5 release which contains the most recent IMS V9 exploitation. You can also find the latest support release schedule for all IMS Tools by visiting SupportConnectSM.

Top
General Information
Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
Product Tip: Unicenter® Software Delivery Manager-SDMMV 11.0. How do you prevent DB2 Object Comparison I/O errors during the SDM installation process?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI82580

Product Tip: Unicenter® Post Install for DB2. What tape volsers correlate to the available r11 SP and r11.5 SP versions of the CA-DB2 for z/OS tools?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC407121

Product Tip: Unicenter® RC/Update® for DB2 UDB for z/OS. How can I easily backup DDL?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83328

Product Tip: Unicenter Software Delivery Manager-SDMMV 11.0. A SMP/E GIM38201E error message may occur for one or more of the following MOD ENTRIES listed below when running the APPLY or APPLY CHECK process installing r11.0 SP3 maintenance on top of r11.0 SP1. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83393

Product Tip: Unicenter® Quick Copy for DB2 UDB for z/OS. How can I customize Imagecopy Dataset Names with Quick Copy?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83522

Product Tip: Unicenter® Fast Unload for DB2 UDB for z/OS. When executing Fast Unload for DB2 utility (PFU) on DB2 v8 NFM, an SQL-156 can occur on views that were created prior to DB2 v7. Read further to avoid this.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83531

Product Tip: Unicenter Fast Unload for DB2 UDB for z/OS. An unload of a view that was created PRIOR to version 7 of DB2 is receiving the following error when unloaded by Fast Unload. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC409753

Product Tip: Unicenter RC/Update for DB2 UDB for z/OS. How do I display more table data on screen when browsing or editing?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83733

Product Tip: Unicenter RC/Update for DB2 UDB for z/OS. How do you make a one step migration (in batch)?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83735

Product Tip: Unicenter® RC/Migrator® for DB2 UDB for z/OS. How do I get rid of old RCM Strategies?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83737

Product Tip: Unicenter RC/Migrator for DB2 UDB for z/OS. How do I configure RCM Models so that the utility datasets generated at analysis time use a high level qualifier other than the userid?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83802

Product Tip: Unicenter® Log Analyzer® for DB2 UDB for z/OS. If a DB2 subsystem becomes part of a Datasharing group, will my existing PLA strategies continue to work against that DB2?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC410456

Top
Product Tips for AllFusion® Modeling Solutions
Product Tip: The AllFusion® ERwin® Data Modeler R7 Options Dialog – Reset Messages, XML, and SQL Trace Functionality
Did you know you can use the Options dialog to set global defaults on where AllFusion ERwin Data Modeler saves your Transaction Logs and Activity Summary? You can specify the path and folder where you want the output saved from this and other functionalities, such as XML and Diagnostics. Click here to explore and understand these options:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC411111.

Product Tip: AllFusion ERwin Data Modeler r7 Subject Area Export
Subject Areas are instrumental in helping you manage your models. In r7, this long standing functionality has been enhanced. You can now export Subject Areas from one model to another instead of recreating them. Click here to see how Complete Compare can import whole Subject Areas as well as Subject Area objects:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC411039.

Product Tip: New DB Certification Doc
CA is continually working to improve our software and services to best meet the needs of our customers. The following database support policy is effective immediately, and is designed to maximize responsiveness to our customers and to help focus our support and R&D efforts on those databases most relevant to our customer base. AllFusion ERwin Data Modeler will only provide ongoing support for the following databases:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC342484.

Top
FAQs for AllFusion® Modeling Solutions
I added some columns to my model. In v. 4.1.4, there was a check box "Generate ALTER script" in the Complete Compare Resolve Differences dialog. How may I generate ALTER TABLE syntax using the Complete Compare in version 7.1?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408733

I cannot specify an ampersand ("&") in my Oracle tablespace name and AllFusion® ERwin® Data Modeler converts that to an underscore ("_").
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408737

In AllFusion ERwin Data Modeler v. 4.1.4, I was able to Complete Compare a model against a script that has only index create statements. How can I do this in 7.x?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408738

How can I delete foreign keys (FK) which are not in database, but are in the model?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408739

I need to use ALTER instead of a DROP for a minor change to an existing table in a model. I just want to change one table in a large model and the complete compare takes a long time. Is there an easier and quicker way to do that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408740

I created a relationship from a parent entity to a child entity and I expected to see the parent entity's primary key (PK) migrate to the child entity as a Primary Foreign Key (PFK). But I don't see any PFKs in the child entity. Why is that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408743

Why are option set changes not saved after I create a new Forward Engineer Option Set and choose to Save As in the Selected model?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408744

Why, when using %Verbphrase in my script, I find inconsistent and unidentifiable results in my large logical-physical model?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408745

Top
Announcement for AllFusion® Modeling Solutions
CA Certifies ObjectRiver as ca smart™ for AllFusion® ERwin® Data Modeler Integration
November 3, 2006 - ObjectRiver, a provider of Master Data Management solutions to
Web-enable enterprise data, announced that the latest release of its Master Data Management solution has been ca smart certified as interoperable with CA's AllFusion ERwin Data Modeler r7. Read the full press release.

Top
FAQs for Unicenter® Database Management Distributed Database Tools
How do I add an agent on a machine that has an agent or Unicenter® Database Performance Management GUI already installed on it?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC411090

What are the default ports for the product Unicenter® Database Command Center?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC411091

Does the Unicenter® TSReorg™ agent use ODBC (Open Database Connectivity) to connect to the Oracle instance?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC411092

Why do I get the error "Unable to add HCFG page" when I try to configure an agent using HCE (Hierarchical Configuration Editor)?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC411093

I am installing UDPM for Oracle 4.5.2 on AIX 5.3 machine. Why do I get the error message: "Cannot load package PMORA:Can't locate PMORA.pm in @INC at (eval 1) line"?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC411154

Why do I get the error "ORA-00904:invalid column name" when I choose Constraints from a tablespace name?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC411135

Top
AllFusion® CA-File Master™ Plus for IMS Beta Announcement
Do you have IMS in your shop?

If so, are you aware that CA has developed a new IMS product that complements AllFusion CA-File Master Plus?

AllFusion CA-File Master Plus for IMS is a robust z/OS data management product that provides enhanced capabilities for IBM's IMS Database Management System in both an online ISPF interface and through batch commands. AllFusion CA-File Master Plus for IMS provides a set of powerful and easy-to-use tools for manipulating IMS databases, including segment selection filtering as well as data display and modification using COBOL or PL/I layouts.

Since AllFusion CA-File Master Plus for IMS is not yet in General Availability status, you may register for this beta by visiting
supportconnectw.ca.com/public/ca_common_docs/cabetas-programlist.asp
or contact the CA beta team to learn more (corpbeta@ca.com).

Top
AllFusion® CA-InterTest® Batch r8 Beta Announcement: Helping You Meet the Challenges of Debugging DB2 Stored Procedures and IMS/DC Programs
Debugging DB2 stored procedures and IMS/DC programs can be a challenge, which is why you need automated tools like AllFusion CA-InterTest Batch, part of the AllFusion® Mainframe Testing and Fault Management Tools product line.

We are pleased to announce that AllFusion CA-InterTest Batch r8 is now in Beta and available for testing. While previous versions of AllFusion CA-InterTest Batch already support the debugging of DB2 stored procedures and IMS/DC programs, the r8 release adds more sophisticated capabilities including:
  • debugging nested DB2 stored procedures
  • scheduling for IMS/DC programs and DB2 stored procedures
If you want to learn how AllFusion CA-InterTest Batch r8 equips you with powerful and easy to use debugging capabilities and how you can partner with CA for a first-hand look at all the new features, click here.

Top
Unicenter® Database Command Center Architecture
To better understand the power, flexibility, and scalability behind the new Unicenter Database Command Center and the integrated advanced products, a new white paper has been posted at: ca.com/Files/WhitePapers/uni_dm_com_cent_arch_wp_en_us.pdf.

This document is intended to familiarize you with Unicenter Database Command Center, its architecture, and components.

Top
Road Maps
Unicenter® Database Management Solutions for DB2 UDB for z/OS at:
supportconnectw.ca.com/premium/db2/common/infodocs/db2_roadmap.pdf.

Unicenter® Database Management Solutions for IMS at:
supportconnectw.ca.com/premium/ims/common/infodocs/ims_roadmap.pdf.

AllFusion® Modeling Solutions at:
supportconnectw.ca.com/premium/erwin/infodocs/erwin_roadmap.pdf.

Unicenter® Database Management Distributed Database Tools at:
supportconnectw.ca.com/premium/manageit/infodocs/manageit-roadmap.pdf.

Top
Special Events
CA World® 2007
Save the dates... April 22 - 26, 2007

CA World is quickly approaching! We are returning to the Venetian Las Vegas and Sands Expo and Convention Center in Las Vegas, Nevada, and registration is officially open! Be sure to take advantage of the Early Bird Registration before it expires on February 14, 2007.

For more information regarding discounts and special programs, be sure to visit the CA World 2007 site.

Session, pre-conference education classes, and key note speakers will be posted shortly so be sure to save this site among your favorites or register for the CA World Today Newsletter for up-to-date information.

Do you have a story or topic you want to share? Be sure to complete our "Call for Speakers" - we want to hear from you!

Top
Access the Latest On-Demand Technical Webcasts
Choose from a comprehensive series of on-demand webcasts designed to get you up-to-speed on release 11.5, as well as product specific information that will allow you to get the most from your performance data, harness the power of your database logs, and optimize migrations, and schema management.
livemeeting.viewcentral.com/reg/ca/DB2Replays

Top
Webcast: The Data Model Scorecard
December 12, 2006 - 12:00 Noon EST

Steve Hoberman, author of The Data Modeler's Workbench, has formalized a set of data model quality criteria into his Data Model Scorecard while offering techniques and tips for improving data models and designs with AllFusion® ERwin® Data Modeler and AllFusion® Data Model Validator. Register for what promises to be a very entertaining and informative webcast today.
ca.com/events/EventDetail.aspx?CID=21416&CevID=94549

Top
Free iPod nano When You Buy Qualifying AllFusion® ERwin® Data Modeling Solutions
There are two eligible purchases to qualify. Simply make an eligible AllFusion® Modeling Suite r7.1 product purchase and you can get a free 1GB iPod nano. For more information, please review the promotion today!

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.

CA
 
 
 
Page Tools
printPrint