End of Life Announcement for CA 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 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. In order to focus our development efforts and to help our customer base achieve their strategic business initiatives, we are investing our resources in new technology and software and will be dropping support for Unicenter Data Compressor for DB2 for z/OS. This means Unicenter Data Compressor for DB2 for z/OS will no longer be enhanced and that maintenance and technical support will be discontinued within the next 12 months. However, CA will honor any contractual requirements to sustain support on defined products.

We will be contacting you with more detailed information as well as the confirmed End of Life date for Unicenter Data Compressor for DB2 for z/OS. Until then, should you have any questions or concerns, please contact your local CA Account Manager or Support Availability Manager.

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

Top

CA Insight DPM for Distributed Databases r11.2.1 Now Integrates With CA eHealth®
CA Insight DPM for Distributed Databases helps customers meet service availability goals by understanding and managing database performance. With CA Insight r11.2.1, important database performance intelligence is delivered to the CA eHealth solution. By sharing performance information across networks, systems and databases, proactive actions can be taken; problem resolution time is reduced, availability to the business is restored and service level agreements can be met.

• CA eHealth customers can prioritize and isolate trouble spots (network, systems or databases) before they impact the business. Other integration enhancements with CA Insight include:
  • Oracle and SQL Server database AIMS replaced with new support that includes Oracle 10g, SQL Server 2005 and Sybase.
  • Faster problem isolation with new metric inclusions, including the Database Quality Index.
• CA Insight customers can maintain high performing databases for overall IT performance goals and improved problem resolution. Other integration enhancements with CA eHealth include:
  • New performance reports as well as custom performance reporting capabilities

Top

CA ERwin® Modeling Suite 4.1.4 Service Pack 5
The last Service Pack for the CA ERwin® Modeling Suite 4.1.4 series was recently released. Information can be found on SupportConnect^SM. Go to the CA ERwin Modeling Suite Product Home Page, select the product you want (for instance, CA ERwin® Data Modeler) on the Technical Information section, go to the Solutions and Patches section and then click on Latest Download for ERwin Data Modeler. For CA ERwin Data Modeler 4.1.4: supportconnectw.ca.com/public/erwin/downloads/erwin-updates.asp.

Top

CA Database Management Solutions r11.6 for IMS Beta Program
CA is pleased to invite you to participate in the forthcoming CA Database Management Solutions r11.6 for IMS Beta program. Your participation offers you the ability to test CA Database Management Solutions r11.6 for IMS in your own environment, allowing you to give us feedback on product enhancement(s), quality, and the beta program process. 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 our IMS Tools development team to investigate and address any reported problems, questions, or comments.

Support for IMS v10 is the key feature of this release.

For more information and to register for this forthcoming beta, please drop a line to Mohan Kumar (mohan.kumar@ca.com).

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 CAs solutions for DB2 to manage DB2 object changes alongside Endevor changes

Top

PEA ZFRF194 for CA Fast Recover®
PEA ZFRF194 for CA Fast Recover
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZFRF194

Top

PEA ZFRF192 for CA Fast Recover®
PEA ZFRF192 for CA Fast Recover
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZFRF192

Top

PEA ZFRF186 for CA Fast Recover®
PEA ZFRF186 for CA Fast Recover
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZFRF186

Top

PEA ZFLF252 for CA Fast Load™
PEA ZFLF252 for CA Fast Load
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZFLF252

Top

PEA ZXMF036 for CA Xmanager
PEA ZXMF036 for CA Xmanager
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZXMF036

Top

PEA ZDTF361 for CA Detector®
PEA ZDTF361 for CA Detector
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZDTF361

Top

PEA ZUTE137 for CA Utilities Common
PEA ZUTE137 for CA Utilities Common
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZUTE137

Top

Hyper UGEF520 for CA General Services r11.5 for DB2 for z/OS
Hyper UGEF520 for CA General Services r11.5 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UGEF520

Top

Hyper URRE246 for CA Rapid Reorg® r11.5 for DB2 for z/OS
Hyper URRE246 for CA Rapid Reorg r11.5 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=URRE246

Top

Hyper UDTF263 for CA Detector® r11.5 for DB2 for z/OS
Hyper UDTF263 for CA Detector r11.5 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UDTF263

Top

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

Top

Hyper URRF248 for CA Rapid Reorg® r11.5 for DB2 for z/OS
Hyper URRF248 for CA Rapid Reorg r11.5 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=URRF248

Top

Hyper UBPF080 for CA Batch Processor r11.5 for DB2 for z/OS
Hyper UBPF080 for CA Batch Processor r11.5 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UBPF080

Top

PEA ZIDE147 for CA Database Organizer™ for IMS
PEA ZIDE147 for CA Database Organizer for IMS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZIDE147

Top

PEA ZIDE135 for CA Database Organizer™ for IMS
PEA ZIDE135 for CA Database Organizer for IMS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=ZIDE135

Top

Product Tips for CA Database Management Solutions for DB2 for z/OS
Product Tip: CA Detector® for DB2 for z/OS - In the Detector Program Activity Reporting screen, why are two rows displayed on the Package / DBRM Summary screen; one as a PROC type and the other as a PKGE type when Detector reports on stored procedures?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91748

Product Tip: CA Detector for DB2 for z/OS - When attempting to view SQL Text related to a table by using the 'Q' option on the Detector Table SQL Activity Display panel, the Detector Exception SQL User summary screen sometimes displays instead of the SQL itself. Drilling down from the Detector Exception SQL User Summary panel results in viewing SQL that may or may not be related to the selected table. Would expect to only see the SQL text related to the table from the Detector Exception SQL User Summary panel. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91749

Product Tip: CA Detector for DB2 for z/OS - Detector does not acknowledge that the interval time of an existing datastore has been changed. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91750

Product Tip: CA Detector for DB2 for z/OS - Can the maximum intervals defined to an existing Detector datastore be updated?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91751

Product Tip: CA Detector for DB2 for z/OS - Is there a batch procedure to create a new Detector collection datastore?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91753

Product Tip: CA Detector for DB2 for z/OS - Will distributed SQL be captured when the collection threshold is set to zero?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91754

Product Tip: CA Detector for DB2 for z/OS - What contributes to the amount of data being collected in a Detector datastore for Activity collection?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91756

Product Tip: CA Detector for DB2 for z/OS - Would changing the Detector collection interval time length reduce the demand for external datastore space or increase the allocation requirements?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91757

Product Tip: CA Detector for DB2 for z/OS - Does Detector support VSAM Extended Addressability for the collection datastore VSAM datasets?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91758

Product Tip: CA-Insight Performance Monitor for DB2 for z/OS - Does Insight (IDB2) Data collector need to stay up just like DB2 during The Daylight-Saving Time (DST) switch or does it need to be stopped?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91857

Product Tip: CA RC/Migrator® for DB2 for z/OS - How can the table SYSINDEXPART be added into an EQF?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC435446

Product Tip: CA RC/Migrator for DB2 for z/OS - Using an Alteration strategy, how can you change a primary key constraint?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC435741

Top

Product Tips for CA ERwin® Modeling Suite
A common request made by CA ERwin® Data Modeler users is for a way to easily synchronize their foreign key indexes with their constraints. The purpose of this document is to explain how to use the CA ERwin Data Modeler API to do that as well as to serve as an introduction to using the API. This document will use a sample that can also be used to sync Foreign Key (FK) indexes and constraint names.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC436179

The SQL and View Trace utilities in CA ERwin® Data Modeler r7 are helpful in troubleshooting permissions and privilege errors, and in improving the performance of CA Reverse Engineer or Complete Compare operations. This document uses Microsoft SQL Server 2000 as an example but the principles are the same for all supported databases.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC436178

Top

FAQs for CA ERwin® Modeling Suite
When trying to logon to CA ERwin® Model Manager running on SQL Server 2000, I am getting the error, "SQL Server 2000 (using db-lib) error 515, severity 16 Cannot insert the value NULL into column ", table", column does not allow nulls. INSERT fails."?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432982

I am creating a column constraint for SQL Server. For the Validation Rule in the Validation Rules editor, I would like to see %AttFieldNameIN() but I am instead getting @ColIN(), after typing Valid Values. How can I get %AttFieldNameIN()?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC433242

I cannot select the foreign key (FK) color palette; it is grayed out.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC433244

Transform UI Changes in CA ERwin® Data Modeler r7?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC433678

When trying to connect to SQL Server 2005 you may get the error message: 'unable to locate client connectivity software'. The solution is to install the SQL Server 2000 client software. Where can I get that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC433695

When I generate the schema for all of the indexes associated with one table, the DDL script does not show the create index statements for my foreign keys (FK)?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC433802

My HELP | About AllFusion® ERwin® Data Modeler screen shows UNKNOWN as an Organization name and 0000000 for the Company ID. How can I correct that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC433806

While trying to Reverse Engineer from SQL Server 2005 database I get the error, "There is no Text for object DF_xxxx?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC433905

I have a v. 4.1.4 *.xml file. Can that file be opened using r7 CA ERwin Data Modeler?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC434204

Using the Complete Compare, I am exporting a change, dropping a column in a table in the database which already has many rows (actual data). What will happen to the data?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC434205

I have assigned user defined domains to the columns in my physical model. If I delete the domain that is assigned to a column, what will happen to the data types of those columns?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC434206

How can we get the Pre and Post scripts to generate in the same order in which they appear in the Pre and Post script window? CA ERwin Data Modeler seems to ignore the order in which the scripts appear and instead uses their order of creation.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC435352

Top

FAQs for CA Database Management Distributed Database Tools
Why is there a message that shows "-29: scan data: The scan is currently off", however I see data on other scans under the CPU and Processes tab?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC436173

Does CA Fast Unload® for Distributed Databases support the new feature for Oracle 10.2 called Transparent Data Encryption (TDE)?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC436175

Can multiple Unicenter® SQL Station application instances be opened at the same time?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC436174

Can I use Unicenter® Network and Systems Manager as the Event Manager for Insight 11.2 (on a different machine)?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC436168

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 Database Management Solutions for DB2 and IMS Tools Service Pack Buckets
CA 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 supportconnectw.ca.com/public/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

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

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

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

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

CA ERwin® Modeling Product Roadmap at:
supportconnectw.ca.com/premium/erwin/infodocs/erwin_roadmap.pdf.

Top

Top

Top

Top

Top