CA Simplifies Product Names
Beginning January 30, 2007, CA is simplifying its product names. Our intention is to describe our products by what they enable you and your business to accomplish. Some names have already changed; others will change over the next 12-18 months as part of the planned development cycle. There is nothing you need to do. We have established a dedicated site at ca.com/productnames as a resource center where you'll find additional information such as frequently asked questions, customer service numbers, and a list of current product names and former names.

Top

Unicenter® Database Management Solutions r11.5 SP1 for DB2 for z/OS Service Pack Announcement
To: Unicenter Database Management Solutions for DB2 for z/OS Customers
From: The CA DB2 Product Team
Subject: Service Pack Announcement

On behalf of the CA team, we appreciate your business and the opportunity to provide high-quality, innovative software and services. As part of our ongoing commitment to customer success, we regularly announce updated releases and maintenance for our products.

Today, we are pleased to announce the availability of Unicenter Database Management Solutions r11.5 service pack 1 (SP1) for DB2 for z/OS. With this new service pack, we are pleased to continue to offer an alternative to physical distribution. You can download this service pack, the Product Documentation, and the Product Information Packet from SupportConnect^SM. Logon to supportconnect.ca.com and access the Products Link under the Downloads heading on the left side of the page to get started. Please note that if you have multiple DB2 products licensed, you only need to select and download one product as the package is the same for each product.

In addition to cumulative maintenance this service pack includes new capabilities such as:

Support for DB2 V8 long names within CA RC/Extract™ for DB2 for z/OS and the edit and browse functions of CA RC/Update® for DB2 for z/OS. Support for DB2 V8 Table Controlled Partitioning within CA RC/Update for DB2 for z/OS, CA RC/Migrator® for DB2 for z/OS and CA RC/Compare™ for DB2 for z/OS.

DB2 9 toleration within these products:
CA Insight™ Database Performance Monitor for DB2 for z/OS, CA Detector® for DB2 for z/OS, CA Subsystem Analyzer for DB2 for z/OS, CA Plan Analyzer® for DB2 for z/OS, CA SQL Ease® for DB2 for z/OS, CA Database Analyzer® for DB2 for z/OS, CA Index Expert™ for DB2 for z/OS, CA RC/Migrator for DB2 for z/OS (except for the RC/Merger® functionality), CA RC/Compare for DB2 for z/OS, CA RC/Query® for DB2 for z/OS, CA RC/Update for DB2 for z/OS, CA RC/Secure® for DB2 for z/OS, CA RC/Extract for DB2 for z/OS, CA Quick Copy for DB2 for z/OS, CA Recovery Analyzer® for DB2 for z/OS, CA Fast Recover® for DB2 for z/OS, CA Log Analyzer® for DB2 for z/OS, CA Merge/Modify™ for DB2 for z/OS.

Selected user enhancements including:
SHRLEVEL CHANGE snapshot copies in CA Quick Copy for DB2 for z/OS, Change Data Capture analysis report in CA Log Analyzer for DB2 for z/OS, display of host variables on active threads in the Thread Termination capability in the CA Value Pack, plan include/exclude with wildcard support in CA Detector for DB2 for z/OS, support for zIIP processor statistics within CA Insight DPM for DB2 for z/OS, support for comparison of cost values within CA Plan Analyzer for DB2 for z/OS, support for DEADLINE, LONGLOG, TERM and DELAY within the online reorg functionality of CA Rapid Reorg® for DB2 for z/OS, support for 8K/16K bufferpools with BP-LOOKUP for data-sharing in CA Fast Unload® for DB2 for z/OS.

For additional details see the Summary of Changes document at: supportconnect.ca.com/cadocs/k0/k003533e.pdf.

If you prefer to receive a physical copy of this new service pack and collateral, please call 1-800-637-5858, option 2 or for customers outside North America, please contact your local CA Support Center. Be sure to request Unicenter Database Management Solutions r11.5 SP1 for DB2 for z/OS.

If you have any questions regarding this notice, please contact your local Support Availability Manager. For technical assistance, please contact Technical Support at 1-800-859-3289 (U.S. and Canada) or your local CA support number.

We designed our ongoing product development, customer support and maintenance programs to help customers succeed, and believe our latest service pack is a good example of our efforts.

Thank you for your continued support of CA.

Top

CA Software Change Manager Interface r11.5 for DB2 for z/OS Beta Program
CA is pleased to invite you to participate in the CA Software Change Manager Interface r11.5 for DB2 for z/OS (formerly Endevor® for DB2) Beta program. Your participation offers you the ability to validate SCM for DB2 in your own environment, allowing you to give us feedback on product enhancements, quality, and the beta program.

Your contribution to this critical product test cycle is directly related to the success of the generally available (GA) release of CA products and ensures we deliver solutions that are ready to meet your real-world requirements.

As a participant in the beta program, you will communicate directly with the Beta Research and Development team to investigate and address any reported problems, questions, or comments.

Key Features:

• Support for DB2 versions 7 and 8
• Conversion utility from earlier versions of Endevor for DB2
• Utilizes the power of CA solutions for DB2 to manage DB2 object changes alongside Endevor changes

Top

Hyper UFLF204 Unicenter® Fast Load™ for r11.5 for DB2 for z/OS
Hyper UFLF204 - Unicenter® Fast Load™ for r11.5 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UFLF204

Top

Hyper UFLE247 Unicenter® Fast Load™ for r11.0 for DB2 for z/OS
Hyper UFLE247 - Unicenter® Fast Load™ for r11.0 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UFLE247

Top

Product Tips for Unicenter® Database Management Solutions for DB2 for z/OS
Product Tip: The following message appears on the Operator Consoles with a message number when a PDA extract and statistics update job is run. Why does it appear and what can be done to get rid of it?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI89223

Product Tip: What happens to the extract procedure processing action procedures with user defined conditions if a user defined condition SQL statement encounters a non-zero sqlcode?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI89222

Product Tip: When executing Unicenter® Fast Load™ for DB2 UDB for z/OS (PFL), what control cards are needed to allow the loading of multiple PARTs of a partitioned table at the same time. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI89556

Product Tip: When RC/Migrator® performs an analysis the RCMTOLR DD is produced by R11.5 release. It is dynamically allocated with this format: USERID.RCM56XW.Dnnnnnnn.JOBNAME.JOBnnnnn. I want to avoid the creation of this dataset using a userid as a hlq. Security violations often happen when the user doing the analysis does not have authority to create such a dataset. How can this be avoided?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI89630

Product Tip: How do I use the IBM LISTDEF and TEMPLATE functions in an RC/Migrator Utility Model Services COPY model?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI89620

Product Tip: While in RC/Migrator, ACM failed during the load step. The job ended with DPA0046W. The additional error message displayed: DSNU353I #DG1C DSNURWBF - RECORD (32327) WILL BE DISCARDED DUE TO CHECK CONSTRAINT DSNCOL_COLCARDF VIOLATION ON TABLE xxx.SYSCOLUMNS. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI89618

Product Tip: Using Batch Processor, is there a way to Unload data from one ssid and load it on another ssid that exists on another LPAR?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI89619

Top

FAQs for AllFusion® Modeling Solutions
I am trying to generate a Primary Key (PK) index for Oracle database but there is no tablespace clause in the Create Index statement. How can I include those in the syntax?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC425257

I Complete Compare with my database to generate an Alter Table script. My model has a Foreign Key (FK) and Relationship but the database side does not. When I try to export the FK and relationship by clicking the right arrow, nothing happens.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC425258

The %ForEachAtt macro returns all of the columns and the correct Physical column order. However, unified columns are returned multiple times. Each unified column appears as a duplicate in the expansion. Is there any way to avoid this?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC425259

My composite Primary Key in a parent table consists of Primary Keys (PK) and Alternate Keys (AK), and I would like only the AKs to be migrated to the child tables. How can I accomplish that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC425261

I am trying to move my columns using the drag and drop, but AllFusion® ERwin® Data Modeler does not allow me to do so.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC425791

I am trying to Reverse Engineer from Oracle 10g database, but Packages are not coming in. Why is that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC425792

When using AllFusion ERwin Data Modeler Release 7, from the Model Explorer, if I right click on "Transform", "New" is grayed out. Why can't I create a transform from the Model Explorer?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC425793

Why does the r7 Oracle 9i Complete Compare show a Primary Key (PK) constraint name difference when no difference appears in the v. 414 compare?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC425794

Why doesn't View Columns appear when Reverse Engineering from a DB2/390 Version 8 Database?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC426557

In v. 4.1.4, AllFusion ERwin Data Modeler generated one statement for a Primary Key (PK) index with its tablespace. However, in r7, it generates two statements, a CREATE UNIQUE INDEX statement and an ALTER TABLE ADD CONSTRAINT statement. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC426559

I am creating a table and a view. I add the view relationship line, however, no columns are displayed in the view table. Is there a change in the r7 version?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC426560

Top

FAQs for Unicenter® Database Management Distributed Database Tools
Can I use Oracle for my Management Database (MDB) with my Unicenter® Data Command Center?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC427948

Can I upgrade CA Fast Unload® from a previous version to 11.2 or do I have to uninstall the previous version first?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC427949

Can I upgrade to CA TSreorg™ from a previous version to 11.2 or do I have to uninstall the previous version first?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC427950

Top

Help Improve the Documentation for the AllFusion® ERwin® Data Modeling Suite
Thank you for your responses to our Modeling Suite documentation survey. We appreciate your comments and want you to know ... We Hear You. We want you to know that we take your comments seriously and appreciate your time and effort.

Your responses have indicated some common areas of concern, and we will implement as many of your suggestions for improvement as possible. As a result of your feedback, we are confident that as we move forward, the Modeling Suite documentation will be updated and improved to serve you better. Once again, thank you.

If you have not had an opportunity to take this survey, please click the following link: casurveys.com/wsb.dll/135/modeling_suite.htm.

Top

Product Line Community - Modeling
The Product Line Community (PLC) is a global virtual CA customer community that is focused on our Modeling solutions. The PLC provides a forum for bilateral communication between CA and users of CA solutions - enhancing the users' experience while leveraging CA Technology. The PLC model is to act as an umbrella community, over the local user groups, to ensure all CA Modeling users have equal access to all organizations within CA (including Development, Product Management, etc.). Along with quarterly webcasts with CA and a Listserv available, we will be establishing a forum for PLC members as well as other activities exclusive to the PLC - Modeling community.

Not a PLC member yet? Please use the registration instructions below:

• Go to the causergroups.ca.com.
• Click on "Join Today" located in the lower right corner.
• At the drop down menu, select "PLC - Modeling".
• Enter your information.
• Submit registration.

Top

Unicenter® Database Management Solutions for DB2 and IMS Tools
Service Pack Buckets
Unicenter Database Management Solutions for DB2 and IMS Tools Service Pack Buckets Service Pack, Preventive Maintenance, and Preventive Service Planning buckets are now available for the DB2 and IMS tools!

The Service Pack Bucket contains all PTFs that have been released as part of a Service Pack. It provides a quick and easy way to download full Service Packs from our support website, eliminating the need to order physical tapes as new maintenance releases are made available. The Preventive Maintenance Bucket contains all PTFs that have been generated since the last Service Pack was released. The Preventive Service Planning (PSP) bucket containing hiper PTFs, and PTFs resolving PE PTFs, is also still available.

The DB2 Service Pack, Preventive Maintenance, and PSP buckets are located on the Unicenter® DB2 Products for DB2 for z/OS support page at supportconnectw.ca.com/public/db2/db2_supp.asp.
The IMS Service Pack, Preventive Maintenance, and PSP buckets are located on the Unicenter® IMS Utilities Solutions Pack support page at supportblic/ims/ims_supp.asp.
On each support page, choose the "Detailed Service Pack Information" link under the "Solutions & Patches" heading, then choose from the links under the "PTFs Since Last Service Pack" or "Service Pack Download" headings.

Top

Important Changes to the CA DB2 Display Services
The initial feedback from the r11.5 user community has been favorable with regard to our strategy for supporting long object names. As a result of broad, world-wide adoption of the r11.5 release, we have received a great deal of feedback regarding our display services and have received some suggestions for improvement of these services. We are currently working on implementing some of these improvements and plan on having these available as a PTF after our next service pack. For the full article, please visit:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413684.

Top

CA ERwin® Data Modeling Suite r7.2 Patch Release 1
On behalf of CA, we appreciate your business and the opportunity to provide you with high-quality, innovative software and services. As part of our ongoing commitment to customer success, we regularly announce and deliver updated releases and maintenance for our products and we are implementing a "Patch Release" mechanism for customers on the r7 series.

Patch Releases will be cumulative maintenance and made available every 6-8 weeks and will be subject to a subset of the full QA regression test case suite. This subset will exercise all major areas of product functionality and additional tests will be selected based on the specific issues being resolved for the Patch Release. This approach optimizes the joint goals of providing timely support and a high quality product. All maintenance delivered in patches will be brought forward to the subsequent GA Release.

Be sure to check the Solutions and Patches section or Announcements link on the Product Home Page on SupportConnect^SM at supportconnect.ca.com or our new online support system, CA Support Online, at support.ca.com for news of new releases. This month, CA ERwin Data Modeling Suite Patch Release 1 was released. If you have any questions on the new Patch Release, please be sure to Contact Us at CA Technical Support.

Top

Help Improve the Documentation for the Distributed Database Management Products
In our continuing effort to improve products, we are asking Distributed CA Database Management customers to provide feedback on the documentation. The documentation survey provides a valuable opportunity to provide direct input and for you to help us create documentation that better satisfies your needs.

The results of this survey will be carefully reviewed and analyzed by the CA Database Management documentation team. We will try to incorporate as many comments and suggestions as possible. Your participation is very important to us.

Please click on the following link to begin this brief survey. casurveys.com/wsb.dll/135/dcc_doc_survey.htm

Thank you for your time and assistance and please forward this email to any other Distributed CA Database Management users in your organization.

Top

CA File Master™ Plus for IMS
Do you have IMS in your shop?

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

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. 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 CA File Master Plus for IMS is not yet in General Availability status, contact CA's beta team to learn more (corpbeta@ca.com).

Top

DB2 9 Features Survey
CA is committed to providing the highest level of quality in our products and services. Since soliciting customers' opinions is key to satisfying their real needs, we are currently conducting a survey to help us plan how our products will continue to leverage IBM's DB2 9 for z/OS.

This latest version offers considerable changes and many new features - but which are most important to you? In other words, which features or improvements provide the added value that will cause you to move to DB2 9?

Please take the online survey regarding selected DB2 9 features at www.casurveys.com/wsb.dll/56/db2_9.htm. Note that this survey does not comprise a definitive list of new features, but rather concentrates on those items new to DB2 9 that may have an impact on tools development. Your feedback is most appreciated and will be used as direct input into our development process.

Top

AllFusion® ERwin® Data Modeler Documentation Survey
Help Improve the Documentation for the AllFusion® ERwin® Data Modeling Suite.

Thank you for your responses to our Modeling Suite documentation survey. We appreciate your comments and want you to know ... We Hear You. We want you to know that we take your comments seriously and appreciate your time and effort.

Your responses have indicated some common areas of concern, and we will implement as many of your suggestions for improvement as possible. As a result of your feedback, we are confident that as we move forward, the Modeling Suite documentation will be updated and improved to serve you better. Once again, thank you.

If you have not had an opportunity to take this survey, please click the following link: www.casurveys.com/wsb.dll/135/modeling_suite.htm.

Top

Help Ensure the Success of Your MS SQL Server Deployments
The integration of CA's ERwin® Data Modeler with Microsoft's Visual Studio Team Edition for Database Professionals brings together an industry-leading heterogeneous database design product with a focused MS SQL Server development and life cycle management environment to provide a rigorous platform from which you can manage the development and deployment of MS SQL Server applications. To learn more, visit ca.com/erwin/msdn.

Top

Road Maps
Unicenter® Database Management Solutions for DB2 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

Top

Top