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 URRF248 Unicenter® Rapid Reorg® r11.5 for DB2 for z/OS
Hyper URRF248 Unicenter Rapid Reorg r11.5 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=URRF248

Top

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

Top

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

Top

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

Top

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

Top

Hyper UDTE322 Unicenter® Detector r11.0 for DB2 for z/OS
Hyper UDTE322 Unicenter Detector r11.0 for DB2 for z/OS
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UDTE322

Top

Product Tips for Unicenter® Database Management Solutions for DB2 for z/OS
Product Tip: Unicenter® RC/Compare™ for DB2 for z/OS - How do I perform a compare of two table-controlled partitioning tables, which will generate an ALTER TABLE ADD PARTITION/ALTER TABLE ALTER PARTITION rather than a DROP/CREATE?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC431612

Product Tip: Unicenter® Detector® for DB2 for z/OS - How to trap Dynamic SQL
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC431769

Product Tip: Within the Detector Profile of the DETECTOR Collection Exclusion Groups Menu, is Wildcarding/Masking supported in the Plan Exclude/Include Lists? Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432210

Product Tip: How do I Unload Data from a non-current image copy? The Image Copy is stored on a GDG that is a few generations old. The Image Copy was produced on another subsystem. The Unload will be executed and loaded to a local table.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432703

Product Tip: How do I direct the output from the execution of a strategy submitted through the batch processor to a dataset?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI91205

Top

Product Tips for CA ERwin® Modeling Suite
This document discusses how Complete Compare filtering works in r7.x. It covers filtering by type and by instance, how these two kinds of filtering interact with each other, and their effects on performance and memory use. This document was written by one of the developers of Complete Compare, so be sure not to miss it.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432009

Visual Studio Team Edition for Database Professionals (VSDB) delivers a database development product designed to manage database change, improve software quality through database testing, and bring the benefits of Visual Studio Team System and life cycle development to database professionals. The integration of CA ERwin Data Modeler and Visual Studio allows you to use your existing data models and data-modeling tools to streamline the data modeling and schema generation process as follows:

1. Use your existing CA ERwin DM database designs to jump-start the creation of managed objects in Visual Studio.
2. Use the design visualization, task automation and advanced modeling features of
   CA ERwin DM to fine-tune schemas.
3. Reuse data models across the IT environment.

Top

Product Tips for Unicenter® Database Management Distributed Database Tools
CA Insight will help you manage the performance of your Microsoft SQL Server Database cluster environments by providing an enterprise view of your physical Microsoft cluster allowing you to quickly see which node is having issues and then being able to drill down into the specific performance of those nodes. Click here to read the full article:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432322.

Top

FAQs for CA ERwin® Modeling Suite
How to Upgrade your CA ERwin® Model Manager Software and/or Licenses?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC429544

We found we have duplicate users in our Orale CA ERwin Model Manager. How can we remove them?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432223

I Reverse engineered my database and CA ERwin® Data Modeler crashes or results in a specific error message. The crash or error only occurs with this particular database. How can I find which object(s) in the database are causing the crash or error?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC431528

I open a 4.x *.er1 model that was saved as 4.1.4 using 7.2. A Naming Standards file is attached but I get the error, "The attached naming standards model file can not be found. No changes to the naming standards loaded."
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC431532

Our Naming Standards (*.nsm) works differently each time we upgraded from v. 4.1.4 build 4033 to 414 build 4415 and R7. Why is that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432224

I am using the Complete Compare. How can I import a foreign key (FK) constraint name change when both sides are calculated?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432225

When using CA ERwin Data Modeler, I noticed there were datatypes missing for my database. How can I add these datatypes to ERwin?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432226

When I create a new table without any columns, by default, a XPK index is created. If I add another table and relationship line, by default a XFK index is added. I do not want these indexes to appear in my DDL script or when I generate to my database.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432227

Why doesn't CA ERwin Data Modeler Release 7.x create the objects when a "Syntax Error" occurs when I Reverse Engineer an Oracle script? In v. 4.1.4, when there were parsing errors, the objects were created.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432234

When opening a model, I get an error, "Model Processor could not be found," and the model does not open. It works fine on another PC, but not on this one. What is this error?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432236

Can the API capture the abbreviations as defined in the Naming Standards (NSM) glossary? I need to use logical and abbreviated physical names as defined in the NSM, but using the API, I only see the logical names but not the abbreviated physical names.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC432292

Top

FAQs for Unicenter® Database Management Distributed Database Tools
Why do I receive an ODBC connection failure (SQLSTATE=S1000, Native Error=12514) when trying to add a server in the CA Database Command Center portal?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC430069

Why is there a "?" (question mark) for the Status for Insight knowledge agent on the Overview page?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC429716

Why can't I see the new Insight knowledge agent I just created on the Insight Overview page?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC430057

Why don't I see the agent view when I start Unicenter® Database Performance Management?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC430070

The SQL database agent (caiSQLA2) appears as an "Unknown" severity in Worldview. When viewing the node, the watchers all appear correctly.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC433355

What are the prerequisites to ensure I install caiOraA2_81 correctly?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC430084

I upgraded from Fast Unload® 2.4.3 to 4.2.2p2. Why is the row sequence in the output file in a different order than before I upgraded?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC429718

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

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

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. Read the new co-produced White Paper, "Managed SQL Server 2005 Deployments with CA ERwin Data Modeler and Microsoft Visual Studio Team."
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.

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

Top

Top

Top