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

Improving Your On-line Support Experience: CA's New Technical Support Initiatives
You talked. We listened. We hope you've noticed some of the changes. In response to your feedback, we've been upgrading the CA support site. We're implementing a series of initiatives, with the aim of providing you, our valued customer, with world-class information and support.
Read the full story.

Top

Unicenter® Database Management Solutions r11 SP3 for IMS for z/OS
Service Pack Announcement
To: Unicenter Database Management Solutions for IMS for z/OS Customers
From: The CA IMS 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 SP3 for IMS 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 IMS products licensed, you only need to select and download one product as the package is the same for each product.

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

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-201-7536 (U.S. and Canada) or 1-631-342-4683 (International).

We designed our ongoing product development, technical 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

IMS Tools 5.1 - Drop Support Reminder
The termination of support for the individual product releases that comprise the Unicenter Database Management Solutions 5.1 for IMS for z/OS is effective May 31, 2007. Click here to read the full drop support letter information. Upgrade options include r11 SP2 and the r11.5 release which contains the most recent IMS V9 exploitation. You can also find the latest support release schedule for all IMS Tools by visiting SupportConnect^SM.

Top

Unicenter® Database Management Solutions r11 SP4 for DB2 UDB for z/OS
Service Pack Announcement
To: Unicenter Database Management Solutions for DB2 UDB 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 SP4 for DB2 UDB 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.

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

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 1-631-342-4683 (International).

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

Information Regarding New Release
If you are a customer of the Endevor® option for DB2, then this is the news you have been waiting for. A new release of this option is currently undergoing the final stages of development and will be entering beta testing soon.

This new release marks a significant change from earlier releases - by using the DB2 object management engine of CA's RC/Migrator® and RC/Compare™ products. This will mean that future development efforts in support of new versions of DB2 can be concentrated in one area.

The most important change for you, the customer, is that the latest Endevor option for DB2 will support ALL IBM supported versions of DB2 for z/OS as of December 2006.

If you are interested in knowing more about this exciting new development, please contact me directly (phil.grainger@ca.com) or, if you have an interest in possibly joining the beta program, then please drop a line to Mohan Kumar (mohan.kumar@ca.com).

Top

Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
Product Tip: Unicenter® Plan Analyzer® for DB2 UDB for z/OS. What does the message "No Plan Table Rows Found" mean when doing a current explain?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85079

Product Tip: PPA is using a different Plan_Table than the one associated with the user logon id and is causing the following error message: -206 ERROR: ACCESS_DEGREE IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE, OR IS NOT A COLUMN OF THE TRIGGERING TABLE OF A TRIGGER during an explain in Unicenter Plan Analyzer for DB2 UDB for z/OS (PPADB2)?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85081

Product Tip: Where does Plan Analyzer for DB2 UDB for Z/OS get the list of user ids that are displayed when you select to create the Plan_Table using option 14 off the main menu?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85080

Product Tip: Can Plan Analyzer for DB2 UDB for z/OS Explain utility write the output of an Explain to a plan table called something other than Plan_Table? For example, can the Explain output be written to Plan_Table_2?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85444

Product Tip: How do you reset the threshold values for a particular ruleset in Plan Analyzer for DB2 UDB for z/OS?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85445

Product Tip: Unicenter® Rapid Reorg® for DB2 UDB for z/OS. What are the meanings of the different counts within the POR0345I message?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413372

Product Tip: Unicenter Rapid Reorg for DB2 UDB for z/OS. I have an object with multi-versioned rows and get PRR8013E when I attempt to reorg it. How do I resolve this? supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414446

Product Tip: Unicenter® RC/Migrator™ for DB2 UDB for z/OS. Why is RCM ALTER OUTPUT SCREEN different between r11 and r11.5?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413985

Product Tip: How does Unicenter RC/Migrator for DB2 UDB for z/OS avoid overwriting analysis DDL that is still being executed but may not have been completed yet?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85844

Product Tip: Unicenter RC/Migrator for DB2 UDB for z/OS. How can I apply arithmetic equations to numeric values like Primary and Secondary quantities on Tablespaces and Indexes during analysis to make changes which would cater to normal increases and decreases in size?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85316

Top

Product Tips for Unicenter® Database Management Solutions for IMS for z/OS
Product Tip: Unicenter® Secondary Index Builder for IMS for z/OS. How can sort options to optimize performance be passed to an external sort utility (e.g. CA-SORT, DFSORT, SYNCSORT) which will be invoked during SIB (Secondary Index Builder) execution.
Answer: DD statements SORTCNTL (for CA-SORT) or DFSPARM (for DFSORT and SYNCSORT) can be used in the SIB job control to pass information.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85261

Top

Product Tips for AllFusion® Modeling Solutions
Product Tip: Traditionally, AllFusion® ERwin® Data Modeler created a Foreign Key index when a database, that had a Foreign Key constraint but not a Foreign Key (FK) index, was Reverse Engineered. Although in the Index editor for the Reverse Engineered model AllFusion ERwin Data Modeler marked the Foreign Key constraint as 'not generated', that can cause some confusion when a Complete Compare (CC) is performed in r7. This document explains and clarifies why the r7 CC Resolve Differences screen may seem to show you what at first appears to be unexpected results with regards to missing FK indexes on the database side of the comparison, but what is in fact actually quite normal, and how that may be handled.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC419837

Product Tip: AllFusion ERwin Data Modeler 7.x ships with improved documentation on how to use the 7.x APIs. The ERwin_API_Ref.pdf in your product's C:\Program Files\CA\AllFusion ERwin Data Modeler r7\Doc folder provides a wealth of information. Still, many customers find it useful to see actual examples. AllFusion ERwin Data Modeler / Model Manager r7.x API examples are now available in the Data Exchange Information Center on SupportConnect^SM at supportconnectw.ca.com/premium/erwin/infodocs/af-deic.asp. Click the link "SAMPLES - API - R7" to download a WinZip file containing these samples and a Microsoft Word document that describes their usage.

Top

FAQs for AllFusion® Modeling Solutions
Why are some of my Column Names the same as the Domain Names they are attached to?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417359

When I open up an xml formatted file, I get an error 155 and the model won't open. What is wrong?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417360

In the AllFusion® ERwin® Data Modeler Validation Rules editor, for Valid Value list, there is a 'Display Value'. What is 'Display Value'?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417361

Are there any possible negative results when using copy and paste?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417862

I changed my model from a target server of Oracle to ODBC. I brought up the new derived physical model using my customized DSM file with DATE converted to TIMESTAMP datatype. After I saved it, the TIMESTAMP fields went back to DATE.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417864

Using AllFusion ERwin Data Modeler, how do I create a single HTML Picture Report File which can be sent to another user?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC418231

How can I get the current subject area for an AllFusion ERwin Data Modeler r7 model, using the API?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC418233

My SQL Server database has a space between all of my column names. When I Reverse Engineer the database into AllFusion ERwin Data Modeler, my column names all contain underscores "_". How can I remove the "_" and replace them with a space " " ?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC418234

I have Complete Compared my model against the database and I am looking at the Resolve Differences screen. I see all of my columns but I don't see the datatypes for some of the columns when I highlight them.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC419603

Top

FAQs for Unicenter® Database Management Distributed Database Tools
How do I turn off the upgrade message I receive when using Unicenter® SQL-Station™ Plan Analyzer™? "The Unicenter SQL-Station Plan Analyzer repository is currently installed for version 3.3. Do you want to upgrade now?"
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC418957

Error message: "An error at this point may be caused by using an older version of the server-side components with the latest version of the client-side installation. We recommend that you update your server side installation as soon as possible."
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC418956

Why do I get the error "TSR-1321-Error opening/creating file? System error is - Too many open files (errno=24)" when running a reorg?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC418955

Why do I get the error "cannot map the library liboracore.so" when trying to configure the Oracle Knowledge Agent? This is on a 64 bit operating system with a 64 bit Oracle database.
supportconnect.ca.com/sc/redir.jsp?=reqPage=search&searchID=TEC418951

Where are the database agents located for Unicenter® Network and Systems Management 11.1?
supportconnect.ca.com/sc/redir.jsp?=reqPage=search&searchID=TEC419846

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 on our next service pack. For the full article, please visit:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413684.

Top

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

Top

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

Top

CA Whitepaper: Robust Infrastructure Relies on a Healthy Database Foundation
SQL Server is fast becoming the dominant database; understand how this may impact your enterprise. ca.com/Solutions/Collateral.aspx?CID=95479&ID=5714

Top

Programmer's Paradise Announces "Riding the Crest" Top Selling Product Awards; Partner of the Year
Programmer's Paradise(R), a subsidiary of Wayside Technology Group, announced the winners of its prestigious Riding the Crest Awards for 2006 at the company's annual awards ceremony. CA was named Partner of the Year and our own AllFusion® ERwin® Data Modeler was named the most popular, best-selling, Enterprise DBMS Tool for the 7th consecutive year. Read the full release here.

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

Top

CA WORLD® 2007: Real Innovation for Real Business
Don't miss out on CA WORLD, this April, at the Venetian Hotel in Las Vegas. Simply put, it is the most valuable and enjoyable technology event for IT and business professionals. Four days of exciting speeches and informative exhibitions from CA and CA partners will give you real technological solutions to the challenges you and your business face. All the right Database Management and Modeling experts will be there with the session topics and technology demonstrations critical to your business, including:

Session EDB03SN: Surviving the Lean Times by Saving DB2 CPU Dollars
Speaker: Dean Capps, Verizon Business
Date/Time: Tuesday, April 24, 11:00 a.m.

Session EDB06SN: IMS Database Recovery Made Simple
Speaker: Don Metzner, CA
Date/Time: Tuesday, April 24, 1:15 p.m.

Session EDM02SN: Taming and Managing Database Change With Visual Studio for DB Professionals and ERwin® Data Modeler
Speaker: Gert Drapers, Microsoft
Date/Time: Wednesday, April 25, 1:15 p.m.

Session EDB15SN: Platform Diversity and the DB2 DBA
Speaker: Benjamin Scheerer, CA
Date/Time: Wednesday, April 25, 9:45 a.m.

For more information, visit caworld.com, where you can build a customized agenda online.

Top

An Exclusive Opportunity To Meet With CA Database Management Development and Product Management
Annually, CA holds CA WORLD® so that customers are able to see and touch the latest technology as well as hear about the strategy and road maps. Additionally, customers can attend sessions specific to their needs, attend hands on labs to learn new product releases, visit development campgrounds, and meet with CA senior management on business needs. If you are considering attendance at CA WORLD 2007 (ca.com/caworld) and would like to specifically request a meeting with Senior Database Management Development and/or Database Management Product Management, please contact your local CA Sales Representative or send email to kelle.veverka@ca.com.

Top

SQL Server Webcasts
You are invited to join PASS (Professional Association for SQL Server) and CA in a series of Webcasts brought to you by PASS and hosted by CA. The Webcast series will be held once a month for the next 12 months, beginning in March, and will be divided into different topic areas: performance tuning, development, BI, and DBA. Registration for these webcasts can be found at: ca.com/Events/EventList.aspx?CID=98934.

Top

Top

Top

Top