main content

SupportConnect - Unicenter Database Management Solutions Newsletter, Version 06.09

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.

E-News

Unicenter® Database Management Solutions
Newsletter
Version 06.09
October 25, 2006

In This Newsletter

Product News

	>	Special E-News Survey
	>	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
	>	AllFusion® Modeling Solutions > AllFusion® Modeling Suite Information

Product Updates

>

Unicenter® Database Management Solutions for DB2 UDB for z/OS
> Hyper ZMMC071 Unicenter® Merge/Modify™ r11 for DB2 UDB for z/OS
> Hyper ULAF201 Unicenter® Log Analyzer® r11.5 for DB2 UDB for z/OS
> Hyper ULAE239 Unicenter® Log Analyzer® r11.0 for DB2 UDB for z/OS
> Hyper UMMC098 Unicenter® Merge/Modify™ r11 for DB2 UDB for z/OS

General Information

	>	Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
	>	Product Tips for Unicenter® Database Management Solutions for IMS for z/OS
	>	Product Tips for AllFusion® Modeling Solutions
	>	FAQs 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
	>	The Philadelphia Area Enterprise Modeling (PEMUG) User Group
	>	The Calendar May Say Summer Has Ended, But Not When We Recorded the AllFusion® Modeling Suite Summer Webcast Series
	>	CA Database Development Packs Bundled Together for Comprehensive Database Design Through Deployment
	>	10th Anniversary User Group Event
	>	Access the Latest On-Demand Technical Webcasts

Product News

Special E-News Survey
Dear CA Customer,

Please participate in a special survey to formally collect your feedback on what you like about the current CA E-News newsletters and, more importantly, what you would like to see included. Please complete the survey by October 31, 2006.

Below is the URL for the survey: casurveys.com/wsb.dll/169/eNews_1.htm.

When you click on the above link, you will then need to click "Resume" to begin the survey.

A newsletter continues to be valuable only if you get what you need from it. With the information you provide, we can bring more success to you and make them truly valuable tools for everyone. Your opinion and ideas are extremely important to the future success of these publications.

Thank you for your time and feedback.

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 SupportConnect^SM 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

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 SupportConnect^SM.

AllFusion® Modeling Solutions

AllFusion® Modeling Suite Information
AllFusion Modeling Suite 4.1 (not 4.1.4) Support Expiration Scheduled:
supportconnectw.ca.com/public/erwin/infodocs/afmodsuite71sp4_prodann.asp.

AllFusion Modeling Suite r7.1 sp1 is now GA. For product download/delivery options, select your product(s).
AllFusion® ERwin® Data Modeler
supportconnectw.ca.com/public/erwin/erwin_supp.asp
AllFusion® Process Modeler
supportconnectw.ca.com/public/bpwin/bpw_supp.asp
AllFusion® Model Manager
supportconnectw.ca.com/public/modelmart/mdlmrt_supp.asp
AllFusion® Model Navigator
supportconnectw.ca.com/public/modelnav/mdlnav_supp.asp

Product Updates

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

Hyper ZMMC071 for Unicenter® Merge/Modify™ r11 for DB2 UDB for z/OS
For more information about hyper ZMMC071 and to download the hyper,
please log on to SupportConnect^SM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZMMC071.

Hyper ULAF201 for Unicenter® Log Analyzer® r11.5 for DB2 UDB for z/OS
For more information about hyper ULAF201 and to download the hyper,
please log on to SupportConnect^SM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ULAF201.

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

Hyper UMMC098 for Unicenter® Merge/Modify™ r11 for DB2 UDB for z/OS
For more information about hyper UMMC098 and to download the hyper,
please log on to SupportConnect^SM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UMMC098.

General Information

Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
Product Tip: For Unicenter® RC/Migrator® for DB2 UDB for z/OS: Have you ever upgraded to a new release and after creating a new RC/Migrator @DEFAULT model had to manually compare every utility in that model to a heavily customized model you've been using to add any changes?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83166.

Product Tip: For General Services-GEN r11.5: How can one change the column width of a longname character field on the display?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI83201

Product Tips for Unicenter® Database Management Solutions for IMS for z/OS
Product Tip: For Unicenter® Database Copier™ for IMS: When using COMPRESSOUTPUT=YES, which kind of compression will be invoked DBCOPY? Is it a DBCOPY owned software?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI82943

Product Tips for AllFusion® Modeling Solutions
Product Tip: How to Generate the AllFusion® ERwin® Data Modeler r7 Metamodel Documentation: Do you use ERwin APIs or would like to know about the metamodel to understand the properties? Now, with AllFusion ERwin Data Modeler r7.x, you can now create a graphical html report containing all of the definitions in the metamodel. This document provides you with the details on what it is and how to create it:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408514.

Product Tip: Action Log and Advisory Panes in AllFusion ERwin Data Modeler R7: You may know that, with AllFusion ERwin Data Modeler r7.x, the changes made during a session are now documented in a dynamic Action Log. But did you know that this Action Log is also used for some other powerful features as well? Click here to learn more about this as well as the Advisory panes:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408442.

FAQs for AllFusion® Modeling Solutions
Using the 'Alter Script/Schema Generation', if a column is added, it creates the DDL. However, if the same column is then deleted in the same session, the Alter Script/Schema Generation does not generate the ALTER TABLE DROP COLUMN statement. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ403403

In v 4.1.4, AllFusion® ERwin® Data Modeler allows you to do either a logical or physical transform and keep the other side intact. In R7, when I perform a physical transform, my logical side transforms as well. How do I know which transform occurred?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ405744

I derived a Logical/Physical Model from a Logical only model and I found my physical column orders are not the same as my logical attribute's order displayed on the logical side.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ405745

In Release 7, do both AllFusion ERwin Data Modeler and AllFusion Model Manager need to be at the same build number as is required in v 4.1.4?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ405746

Is it possible in AllFusion ERwin Data Modeler to use the .nsm file to generate a single word from a combination of words? e.g.: PURCHASE ORDER to PO?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ405756

How can I globally change the fill color for all of the entities in subject area?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ405757

I do not have Adobe Writer. Is there a way to generate a .pdf file using AllFusion ERwin Data Modeler?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ406987

How can I find all of the subject areas a specific Entity belongs to?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ406990

After assigning the Validation or Default constraints to some columns, how can I de-assign them?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=FAQ406992

FAQs for Unicenter® Database Management Distributed Database Tools
How do events generated from the Unicenter® Database Performance Management knowledge agents get sent to the Unicenter® Network and Systems Management console?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408724

Is it possible to monitor the output of a specified SQL query run under Unicenter Database Performance Management?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408723

All of my agents are configured to keep 90 day archive; why are my retention logs only showing current data?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408545

Why do I get invalid username/password errors when I am installing a remote Oracle agent even though I can successfully connect to the Oracle database with my Oracle username and password?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408544

Why is it when I attempt to debug a Package/Procedure, the debugger only displays NULL values?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408540

Why do I receive the error, "ORA-01031: insufficient privileges" when I install the Unicenter Network and Systems Oracle Agent even though I am providing the SYS user and password?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC408547

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

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.

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.

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.

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!

The Philadelphia Area Enterprise Modeling (PEMUG) User Group
The Philadelphia Area Enterprise Modeling (PEMUG) User Group is hosting their fall meeting on Thursday, October 26, 2006.

They extend an invitation to join their first webcast meeting, featuring Bill Inmon, "The Father of Data Warehousing." Bill is presenting DW 2.0 - The Data Architecture for the Next Generation of Data Warehouse. The focal point of the presentation is integrating unstructured data into the data. Additionally, there will be an overview of r7.1, which focuses on embedded Meta Integration functionality. Sean Graham, VP Development, will also discuss the AllFusion® Road Map outlining the future direction of the AllFusion® Modeling Suite. If you would like to dial into this webcast event, details are as follows:

Attendee link for Bill Inmon:
When: Thursday, October 26, 2006
Time: 10:15 - 11:45 a.m. (ET)

Webcast Administrator has invited you to attend a Live Meeting.
www.livemeeting.com/cc/cai/join?id=marje11-10%2F26%2F06&role=attend&pw=
Kd9.%7D% 5E8%2Bm

Subject: Philadelphia Enterprise Modeling User Group Meeting - 10-26-06
Meeting URL: www.livemeeting.com/cc/cai/join
Meeting ID: marje11-10/26/06
Meeting Key: Kd9.}^8+m
Role: Attendee
Audio Conferencing (Toll-free): (866) 900-9594
Participant Code: 9287817

FIRST TIME USERS: To save time before the meeting, check your system to make sure it is compatible with Microsoft Office Live Meeting: go.microsoft.com/fwlink/?linkid=52354.

Sean Graham - What's New in r7.1 and Road Map
Attendee link
When: Thursday, October 26, 2006
Time: 01:00 - 02:30 p.m. (ET)

Webcast Administrator has invited you to attend a Live Meeting.
www.livemeeting.com/cc/cai/join?id=marje11-10%2F26%2F06&role=attend&pw=
Kd9.%7D%5E8%2Bm

Subject: Philadelphia Enterprise Modeling User Group Meeting - 10-26-06
Meeting URL: www.livemeeting.com/cc/cai/join
Meeting ID: marje11-10/26/06
Meeting Key: Kd9.}^8+m
Role: Attendee
Audio Conferencing (Toll-free): (888) 257-4220
Participant Code: 9288279

FIRST TIME USERS: To save time before the meeting, check your system to make sure it is compatible with Microsoft Office Live Meeting: go.microsoft.com/fwlink/?linkid=52354.

The Calendar May Say Summer Has Ended, But Not When We Recorded the AllFusion® Modeling Suite Summer Webcast Series
Learn about CA's hottest new technology right from the comfort of your own desk. The AllFusion Modeling Suite r7 Webcast series was designed to provide technical content and new features of the r7 Suite, as well as industry trends and best practices. So do not worry if you missed the original webcast. Replays are available for this informative series. Simply go to ca.com/events/esm/modeling_webcasts for the AllFusion Modeling Suite replay selections.

CA Database Development Packs Bundled Together for Comprehensive Database Design Through Deployment
Together, AllFusion® ERwin® Data Modeler and Unicenter® SQL-Station® offer a "Dynamic Duo" of technology for developing, editing, testing, debugging, tuning, and managing SQL before and after it is deployed that no competitor can match. These two solutions, now bundled together for a complete offering at a value price. To learn more, click here.

10th Anniversary User Group Event
Congratulations to Ben Ettlinger and to the NYEMUG (NY Enterprise Modeling User Group) Community on an outstanding 10 years. This group has been hosting information-rich meetings 4 times each year for 10 years now. With approximately 40 people in attendance and 23 dialed in via webcast, we expect this group to continue its success for many years to come.

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

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.

main content

Page Tools

print