SupportConnect - Unicenter Database Management Solutions Newsletter, Version 07.02
  

NOTE: E-News technical information is dynamic and links in archived copies of these technical newsletters may eventually become invalid as the products evolve. Please check the support web page for your product to get the latest technical information.


CA
E-News
Unicenter® Database Management Solutions
Newsletter

Version 07.02
February 26, 2007

In This Newsletter

Product News
> CA Simplifies Product Names
> Unicenter® Database Management Solutions for IMS for z/OS
> IMS Tools 5.1 - Drop Support Reminder
> AllFusion® Endevor® Change Manager Option for DB2 UDB for z/OS
> Information Regarding New Release
> AllFusion® Modeling Solutions
> General Availability Announcement for AllFusion® Data Modeling Suite r7.1 Service Pack 2

Product Updates
> Unicenter® Database Management Solutions for DB2 UDB for z/OS
> Hyper UDBD067 Unicenter® CA-Insight™ Performance Monitor r11.5 for DB2 UDB for z/OS
> Hyper UCID139 Unicenter® CA-Insight™ Performance Monitor r11.5 for DB2 UDB for z/OS
> Hyper USAF085 Unicenter® Subsystem Analyzer r11.5 for DB2 UDB for z/OS
> Hyper UDBC116 Unicenter® CA-Insight™ Performance Monitor r11.0 for DB2 UDB for z/OS
> Hyper UCIC238 Unicenter® CA-Insight™ Performance Monitor r11.0 for DB2 UDB for z/OS
> Hyper USAE108 Unicenter® Subsystem Analyzer r11.0 for DB2 UDB for z/OS
  Unicenter® Database Management Solutions for IMS for z/OS
> Hyper UIDE167 Unicenter® Database Organizer™ for r11.5 for IMS for z/OS

General Information
> Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
> Product Tips for Unicenter® Database Management Solutions for IMS for z/OS
> Product Tips for AllFusion® Modeling Solutions
> FAQs for AllFusion® Modeling Solutions
> FAQs for Unicenter® Database Management Distributed Database Tools
> Unicenter® Database Management Solutions for DB2 and IMS Tools PTF Buckets
> Important Changes to the CA DB2 Display Services
> IDC Report: Achieving Business Value and Gaining ROI With CA's EITM Software
> AllFusion® ERwin® Data Modeler Certified With DB2 V9.1 for Linux, Unix, and Windows
> AllFusion® CA-File Master™ Plus for IMS Beta Announcement
> AllFusion® CA-InterTest® Batch r8 Beta Announcement: Helping You Meet the Challenges
of Debugging DB2 Stored Procedures and IMS/DC Programs
> CA Whitepaper: Robust Infrastructure Relies on a Healthy Database Foundation
> Road Maps

Special Events
> CA WORLD® 2007: Real Innovation for Real Business
> Free iPod nano When You Buy Qualifying AllFusion® ERwin® Data Modeling Solutions
> Tradeshow and Conferences: The Wilshire Meta-Data Conference & DAMA International Symposium
> Webcast: Achieve Greater Insight Into Your Multi-Database Monitoring and Performance Management: Introducing CA-Insight™ for Distributed Databases

Product News

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 for IMS for z/OS

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

Top

AllFusion® Endevor® Change Manager Option for DB2 UDB for z/OS

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

AllFusion® Modeling Solutions

General Availability Announcement for AllFusion® Data Modeling Suite r7.1
Service Pack 2

On behalf of CA, 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.

We are pleased to announce that the AllFusion Modeling Suite r7.1 SP2 is now available. This Service Pack includes all maintenance published prior to this update. By installing this Service Pack, you ensure that your systems are current on maintenance for r7.x.

We encourage you to read the full announcement at:
supportconnectw.ca.com/public/erwin/infodocs/afmodsuite71sp2_prodann.asp.

Top

Product Updates
Unicenter® Database Management Solutions for DB2 UDB for z/OS

Hyper UDBD067 for Unicenter® CA-Insight™ Performance Monitor r11.5
for DB2 UDB for z/OS

For more information about hyper UDBD067 and to download the hyper, please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UDBD067.

Top

Hyper UCID139 for Unicenter® CA-Insight™ Performance Monitor r11.5
for DB2 UDB for z/OS

For more information about hyper UCID139 and to download the hyper, please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UCID139.

Top

Hyper USAF085 for Unicenter® Subsystem Analyzer r11.5 for DB2 UDB for z/OS
For more information about hyper USAF085 and to download the hyper, please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=USAF085.

Top

Hyper UDBC116 for Unicenter® CA-Insight™ Performance Monitor r11.0 for DB2 UDB for z/OS
For more information about hyper UDBC116 and to download the hyper, please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UDBC116.

Top

Hyper UCIC238 for Unicenter® CA-Insight™ Performance Monitor r11.0 for DB2 UDB for z/OS
For more information about hyper UCIC238 and to download the hyper, please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UCIC238.

Top

Hyper USAE108 for Unicenter® Subsystem Analyzer r11.0 for DB2 UDB for z/OS
For more information about hyper USAE108 and to download the hyper, please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=USAE108.

Top

Unicenter® Database Management Solutions for IMS for z/OS

Hyper UIDE167 for Unicenter® Database Organizer r11.5 for IMS for z/OS
For more information about hyper UIDE167 and to download the hyper, please log on to SupportConnectSM at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=UIDE167.

Top

General Information

Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
Product Tip: Unicenter® CA-Batch Processor. How do you use the RESTART command?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84959

Product Tip: CA Common Services for z/OS. How to rename CCITCP and CCITCPGW procname?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413916

Product Tip: Unicenter® Database Analyzer® for DB2 UDB for z/OS. PDA Statistic Job ends with RC008.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC415983

Product Tip: Unicenter® Fast Load™ for DB2 UDB for z/OS. How do I load Data into a DB2 table after transfer from my PC after export from a spreadsheet package like Microsoft Excel?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84994

Product Tip: Unicenter® Fast Unload® for DB2 UDB for z/OS. How do I Unload Data from a DB2 table, transfer to my PC and load it into a spreadsheet package like Excel with Fast Unload for DB2 for z/OS?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84993

Product Tip: General Services. What is the necessary preparation to capture a SYSMDUMP online?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85943

Top

Product Tips for Unicenter® Database Management Solutions for IMS for z/OS
Product Tip: Unicenter® Database Analyzer® for IMS. Which steps are necessary to rebuild the Datacom-Index (low-level qualifier 'IXX615') of the IMS Information Repository (IIR)database, if this dataset has gotten lost or damaged?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85258

Product Tip: Unicenter Database Analyzer for IMS. Which steps are necessary to increase the size of the Datacom®/AD database for the IMS Information Repository (IIR), if one of the area datasets has become full?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85259

Product Tip: Unicenter Database Analyzer for IMS. Is it possible also to check the related INDEX databases if Database Analyzer (DBA) will be invoked by Database Copier™ (DBCOPY) to check the pointers of a MAIN database while image-copying it?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85260

Product Tip: Unicenter® Database Organizer™ for IMS. How does Database Organizer (DBO) allocate database DD statements from JOB CONTROL, DBRC RECON datasets, and dynamic allocation library (MDALIB)?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI85236

Top

Product Tips for AllFusion® Modeling Solutions
Product Tip: AllFusion® ERwin® Modeling Quality Assurance Team has executed certification tests of AllFusion® ERwin® Data Modeler on the supported databases listed at:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC416974.

Product Tip: User Defined Properties (UDPs) have been in AllFusion ERwin Data Modeler for a very long time but their power is not always fully utilized. You may have used UDP help document your model, but did you know that you can also use them to access an external file from within ERwin? Click below to learn more about this powerful functionality:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417761.

Top

FAQs for AllFusion® Modeling Solutions
When I Reverse Engineer a SQL Server 2000 Script file with Distinct Type that has a specified datatype and precision, how does AllFusion® ERwin® Data Modeler determine where the Distinct should be placed in the Domain Dictionary?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC415152

When importing an external file using the Metadata Integration Wizard, an error log can be generated. By default that is saved into the user's Temp directory in the system. Can I specify the directory to save that log file, and, if so, how?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC415156

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. Why do I get this error?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC415502

I am trying to create an Oracle External table, but I get a usage error when Forward Engineering to the database. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC415503

I would like to close and save my Reverse Engineered model that was created during the Complete Compare, however, I did not turn off the 'Auto Close Database/Script Models' checkbox in the Advanced Options. Do I have to Reverse Engineer my model again?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC415504

When I try to create a Primary Key for SQL Server as a target database, the phrase 'Clustered' is not generated in r7.1 whereas v. 4.1.4 did so. Why is that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC416062

What is the utility of the Table CHECK checkbox in the Forward Engineer Schema Generation window, Options/Table?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC416063

I would like to add an owner for all of the objects in my model so that all of my tables display as OWNER.Tablename. Can I do that globally instead of going to each table and manually entering an owner name in the table editor?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC416066

Opening a v. 4.1.4 model in r7 loses the super-subtype relationships.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC416627

What is the difference between an inclusive and exclusive super-subtype relationship?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC416635

How do I make AllFusion® Data Model Validator available on the Tools | Add-in Menu?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC416636

How do I prevent Owner information from appearing in AllFusion ERwin Data Modeler's Forward Engineer and Complete Compare SQL Syntax?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417358

Top

FAQs for Unicenter® Database Management Distributed Database Tools
Why does the error "Date feed cancelled (stat= -903, 0) scan is OFF" display for I/O and Memory charts? This happens when I launch the Database Performance Management web console Health View. There are no values for the I/O and Memory charts.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417687

I set up security via the Unicenter® Database Performance Management Windows Console, however when I use the web server to access the application, the security settings I have set are not working.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417659

What causes the bgprocdown event to trigger?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417660

Why can't I edit my agents on the Unicenter Database Performance Management Web Console?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417664

Why do I get the message, "You cannot copy or move a table with partitions" when I attempt to perform a table copy and paste?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417661

How can I use the Unicenter® Fast Unload® MaxOutFileSize parameter with TSReorg™?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417663

How can I limit the maximum size of an output file?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417662

Unicenter® NSM Database Performance Monitor Option
Is Unicenter® Network and Systems Management Database Performance Monitor Option 3.1 version compatible with Oracle 9i? I am installing Oracle 9i, I see an option to install only Oracle 8i (caiOraA2_81).
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC417665

Top

Unicenter® Database Management Solutions for DB2 and IMS Tools PTF Buckets
Would you like an easy way to keep your DB2 and IMS Tools current on maintenance? If so, check out the new PTF buckets that are available!

Preventive maintenance buckets are now available for the DB2 and IMS tools. The new buckets provide enhanced product stability and facilitate ease of maintenance tracking. The preventive maintenance bucket contains all PTFs that have been generated since the last service pack was released and is refreshed weekly. Source IDs have been assigned to the PTFs to help you manage your PTF installation. In addition, Preventive Service Planning (PSP) buckets containing hiper PTF and PTFs resolving PE PTFs are still available.

The DB2 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 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 click on the link under the "PTFs Since Last Service Pack" heading.

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

IDC Report: Achieving Business Value and Gaining ROI With CA's EITM Software
Quantified benefit, ROI, and payback period for EITM solutions from actual CA customers.

This paper documents the benefit, ROI, and payback period achieved by 12 worldwide customers using CA EITM software. On average, customers achieved a 3 year benefit of $85,333 per 100 users, ROI of 398%, and an 8.6 month payback period. Customers using multiple solutions raised their results to an ROI of 398% and 7.7 month payback period. Data is provided for CA's network management, system management, database management, workload automation, and application management solutions.

Top

AllFusion® ERwin® Data Modeler Certified With DB2 V9.1 for Linux, Unix, and Windows
With the release of 7.1 Service Pack 2, ERwin has been certified with DB2 V9.1 for LUW. To see a list of all the databases that are certified and supported with ERwin, click here.

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
If you want to learn how AllFusion CA-InterTest Batch r8 equips you with powerful and easy to use debugging capabilities and how you can partner with CA for a first-hand look at all the new features, click here.

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

Road Maps
UPDATED 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

Special Events

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 EDB01SN: The State of Unicenter® Database Management
Speaker: Scott Jessee, CA
Date/Time: Monday, April 23, 2007 - 11:00 a.m.

Session EDB14SN: End-to-End Performance Management for the DBA
Speaker: Richard Bolesta, CA
Date/Time: Wednesday, April 25, 2007 - 8:30 a.m.

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

Session EDM20SN: AllFusion® Modeling Suite User Group Exchange at Goodyear Tire & Rubber
Speaker: Tom Bilcze
Date/Time: Monday, April 23, 2007 - 4:00 p.m.

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

Top

Free iPod nano When You Buy Qualifying AllFusion® ERwin® Data Modeling Solutions
There are two eligible purchases to qualify. Simply make an eligible AllFusion® Modeling Suite r7.1 product purchase and you can get a free 1GB iPod nano. For more information, please review the promotion today!

Top

Tradeshow and Conferences: The Wilshire Meta-Data Conference & DAMA International Symposium
Visit CA at booth 201 during this year's Meta-Data DAMA conference and learn how our powerful data modeling and metadata management tools can help you identify, understand, manage, and leverage enterprise-wide information assets. Located at the Sheraton Boston Hotel, Boston, Massachusetts, March 4 - 8, 2007.

Top

Webcast: Achieve Greater Insight Into Your Multi-Database Monitoring and Performance Management: Introducing CA-Insight™ for Distributed Databases
Optimal database performance is vital to the overall service availability of your enterprise. Join CA for a technical update on the new CA-Insight for Distributed Databases r11.2, proactive database monitoring and diagnosis for multiple database platforms.
March 6, 2007 - 1:00 p.m. ET

Top


You are subscribed as &*TO;.

To subscribe, unsubscribe, or change the format for this or other newsletters, please go to our E-News subscription page. You can also unsubscribe by sending an email to: editor_man-auto@ca.com with "Unsubscribe enews_man-auto" (without the quotes) in the message body. You must include the exact email address that you wish to unsubscribe.
Feedback? Comments? Suggestions?
Send an email to: editor_man-auto@ca.com. All submissions become the property of the publisher and may or may not be reprinted.
NOTE: This address should be used only for feedback on this newsletter. Requests for technical support should be submitted through normal channels.

CA
 
 
 
Page Tools