End of Service Announcement for CA Database Management Solutions r11.0 for IMS for z/OS
To: CA Database Management for IMS Customers
From: The CA Database Management for IMS Product Team
Subject: End of Service Announcement for CA Database Management r11.0 for IMS and Stabilization of Unicenter DC Monitor Extensions

CA is continually working to improve our software and services to best meet the needs of our customers. As part of this ongoing effort support for older releases is discontinued. This will allow our Development organization to effectively focus its resources on and add value to the newer and upcoming releases of the CA Database Solutions for IMS. End of Service means that support for CA Database Management r11.0 for IMS products will be discontinued beginning on April 30, 2009. The CA Database Management for IMS solution is comprised of the following r11.0 products:

We have also discovered that while the Unicenter DC Monitor Extensions product still provides useful functions to some customers, its value to most customers and prospective customers in the market has declined significantly over the past few years. Therefore, we are announcing that all supported releases of Unicenter DC Monitor Extensions will be functionally stabilized on April 30, 2008. Functionally stabilizing a product means that there will be no new releases or further enhancements to this product. However, maintenance and support for release r11.6 of this product will continue in accordance with your active maintenance contract.

At this time, we encourage you to plan for the migration to CA Database Management for IMS r11.6 as soon as possible so you can take full advantage of the latest new features and enhancements this release has to offer. CA Database Management r11.6 for IMS is Generally Available and contains all the enhancements in the r11.5 release with the addition of support for IMS v10. For additional information on CA Database Management for IMS, please visit the CA Database Management for IMS product pages at CA Support Online (https://support.ca.com/).

As CA would like to help make your upgrade to CA Database Management for IMS r11.6 as straightforward and successful as possible, we are offering the following:

If you have any questions regarding the support schedule, please contact CA Database Management for IMS Technical Support at CA Support Online (https://support.ca.com/). Our Technical Support Lifecycle Policy is also available at this site.

Your success is very important to us, and we look forward to continuing our successful partnership with you.

Top

End of Life Second Notification for Unicenter® Data Compressor for DB2 for z/OS
To: Unicenter Data Compressor for DB2 for z/OS Customers
From: The CA Database Management Product Team
Subject: End of Life Follow-up Announcement for Unicenter Data Compressor for DB2 for z/OS

CA is continually working to improve our software and services to best meet the needs of our customers. As a follow-up to our first letter regarding End of Life of Unicenter Data Compressor for DB2 for z/OS, we would like to confirm that support for this product will be discontinued beginning on October 1, 2008, though CA will honor any contractual requirements to sustain support on defined products.

Your success is very important to us, and we look forward to continuing our successful partnership with you.

Top

End of Service Announcement for CA Modeling Suite 7.1
CA is continually working to improve our software and services to best meet the needs of our customers. In an ongoing effort to ensure that our Development organization provides optimal support for non-legacy product releases and in conjunction with the currently planned future general availability of CA ERwin® Modeling Release 7.3 (includes: CA ERwin® Data Modeler, CA ERwin® Model Manager, CA ERwin® Process Modeler, CA ERwin® Model Navigator, and CA ERwin® Data Model Validator), we have scheduled support for Release 7.1 to be discontinued within the next 12 months. Doing so will allow our Development organization to effectively focus its resources on and increase value to that future product release.
https://support.ca.com/irj/portal/prddtlshome?productID=260

Top

Hyper URRF286 for Unicenter® Rapid Reorg® r11.5 for DB2 for z/OS
Hyper URRF286 for Unicenter Rapid Reorg® r11.5 for DB2 for z/OS
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=URRF286

Top

Hyper QO96540 for CAIRIM-MVS r1.0
Hyper QO96540 for CAIRIM-MVS r1.0
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=QO96540

Top

FAQs for CA Database Management Distributed Database Tools
If I am only installing CA Database Command Center agents (Fast Unload® or TSReorg™ for Distributed Databases), can I just copy over the components from the original image or do I have to copy the entire image?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC451852

What do we need to update or modify when the rtserver is moved or renamed? What files need to be modified?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC451720

Why do I receive the error "Failed to retrieve the back-end search results" when trying to display any objects (Tablespaces, tables) in the DCC Databases Console Tree?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC451719

I am upgrading from Unicenter® Database Command Center 11.2.1 to 11.2.2, Can I switch the Management Database (MDB) from Oracle to Microsoft SQL Server? support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC451457

Can CA Database Command Center use an existing Microsoft SQL Server Management Database (MDB)?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC450149

Can Unicenter Database Command Center be installed with an existing installation of Unicenter Management Portal r11 SP2?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC450147

What are the affects of changing the CA Insight Oracle Knowledge Agent user password in Oracle?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC450145

Why am I receiving the error: "ErrorMsg = [Microsoft][ODBC SQL Server Driver [SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" when trying to install a SQL Server 2000 Database Agent?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC452288

Top

FAQs for CA ERwin® Modeling Suite
I am updating my foreign key constraint names in the physical model. But the corresponding relationship names are not being updated. Why?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC448237

When a user attempts to Forward engineer a new login defined in the ERwin® SQL Server 2005 Login Principal editor, they receive an error "Incorrect syntax near '='" on the Login definition. How can we Forward Engineer the logins we created?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC448238

How to remove\delete Model History information from a Model, as this is now having a detrimental effect on the performance of the Model.
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC448247

I see unaligned objects in the Complete Compare Resolve Differences screen. When I tried to import at the model level, objects of the left side are replaced with those of the right side.
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449345

While Reverse Engineering SQL Server 2005 Database, I get the Error: "SQL REDB-1022, Invalid object name sys.types; REDB-1099 invalid object name sys.tables."
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449346

My migrating attributes/columns are missing from my model display. If I navigate to the Model Explorer, I see them.
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449349

What Technical Documents (TechDocs) are available for CA ERwin Data Modeler r7.2 Complete Compare functionality on CA Support Online?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449669

How can I de-link the Primary Key (PK) columns on the logical and physical sides of a model? In other words, I want 'test1' attribute to be a primary key in a logical entity but I want 'test2' to be the primary key column in the physical model.
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449748

On attempting to open an ERwin 4.x '*.er1' file in ERwin r7.x we receive the message: Input file is not readable by AllFusion® ERwin® Data Modeler. Please upgrade file by opening and saving in any version of AllFusion ERwin Data Modeler 4.1.4.
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449912

When resolving a Generalization Hierarchy via a Supertype/Subtype transformation, ERwin transforms that into a Hierarchy of Dependent Relationships. How do I keep the Generalization Hierarchy in the Logical model after the transformation?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449973

I can't Reverse Engineer from my database. I get the messages, "Invalid object name 'master..m7License' and 'No mart exists in this Database'.
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449976

On saving a model from ERwin 7.2.x to ERwin 4.1.4 format, on opening the model you receive the error: 'GlobalAlloc returned 0; size requested'. What can I do to correct that?
support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC449991

Top

Programmer's Paradise Annual Riding the Crest Awards
CA ERwin® Data Modeler received accolades from a key partner, Programmer's Paradise, when they announced winners of their annual "Riding the Crest" awards. CA ERwin Data Modeler and CA ERwin® Modeling suite were picked as top Design and Modeling & Deployment and Migration products.

Top

Are you Running z/OS 1.6 or Oolder and Using Insight™ for DB2, r11.5 SP1, or Newer?
If so, then you must apply PTF UDBD102 to avoid an S0C4 ABEND that may occur in the exception processor. This ABEND will bring down the Data Collector, and the only way to restart it is to restart it without the Exception Processor (SYSPARM EXCEPTION-PROCESSOR=NO). This ABEND occurs because SP1 contained support for DB2 Version 9, and this support contains instructions to process fields in the MVS ASSB control block associated with ZIIP engines. At z/OS 1.6 and earlier, these fields do not exist.

Top

New CA ERwin® Data Modeler Forums on Support Online
One of the exciting new features of CA's new online support system is the revamped CA Online Forums. The CA ERwin Data Modeler forum is already one of the most active boards.

To go to this forum, simply login to support.ca.com. On the left side of the page select User Communities, then select CA User Community Forums, then under Browse Boards select Databases, DB Design & Modeling, and you will see the CA ERwin General Discussion Board. Click on this link, and you are there. Check it out today!

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 web casts 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

CA Green Books and Green Papers
The CA Green Books and Green Papers page is on CA Support Online.

Top

Road Maps
CA Database Management Solutions for DB2 for z/OS at:
support.ca.com/phpdocs/7/common/db2_roadmap.pdf.

CA Database Management Solutions for IMS at:
support.ca.com/phpdocs/7/2854/2854_ims_roadmap.pdf.

CA Database Management Distributed Database Tools at:
support.ca.com/phpdocs/7/2855/2855_roadmap.pdf.

CA ERwin® Modeling Product Roadmap at:
support.ca.com/phpdocs/7/260/260_roadmap.pdf.

Top

WEBCAST REPLAY: Part 3 of CA's Three-Part Series: Beyond the Data Model: Designing the Data Warehouse
This informative webcast is the last in a 3-part series focused on Database Modeling and Design in Information Systems. Data modeling goes beyond on-line transaction processing (OLTP) models for traditional relational databases and extends in the world of data warehousing by bringing together multiple databases for analysis and decision-making. Join CA's ERwin® Product Manager Danny Sandwell along with Josh Jones and Eric Johnson of Consortio Services. This webcast was pre-recorded and available until May 14, 2008, for replay.

Top

IDUG North America - May 18-22, 2008 Hyatt Regency Dallas
CA is proud to be a charter member of IDUG, and a gold-level sponsor at the IDUG North America Conference 2008. As always, the IDUG North America conference brings together users, leading industry vendors, consultants, a strong partner community and IBM developers to discuss industry trends, explore new product and service offerings, and share best practices on how to leverage current systems. It also provides an important educational opportunity for DB2 and IMS users with nearly 80 hours of user-led technical sessions designed to help improve the effectiveness of data management systems. User experiences provide a view from the trenches to help users understand how the technology actually works in real-life situations. Developed by users, for users with substantial support from the vendor community, the conference program provides an independent and balanced perspective.

Visit CA at booth 400 where you can browse the CA Database Management for DB2 for z/OS and IMS for z/OS, CA Distributed Database Management, CA ERwin® Modeling Suite, and CA Mainframe Security solutions. Don't miss the featured CA speakers on the IDUG grid. For more information on CA's participation at IDUG visit:
ca.com/us/events/item.aspx?e=102172&eis=1.

Top