main content

SupportConnect - Unicenter Database Management Solutions Newsletter, Version 07.01

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.

E-News

Unicenter® Database Management Solutions
Newsletter
Version 07.01
January 24, 2007

In This Newsletter

Product News

	>	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

General Information

	>	Product Tips for Unicenter® Database Management Solutions for DB2 UDB 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
	>	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
	>	Webcast: Extending Your Data Model Reuse With AllFusion® ERwin Data® Modeler - February 22, 2007
	>	Rocky Mountain Oracle User's Group (RMOUG) in Denver, CO - February 14-15, 2007

Product News

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 SupportConnect^SM.

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

General Information

Product Tips for Unicenter® Database Management Solutions for DB2 UDB for z/OS
Product Tip: Unicenter® Database Analyzer® for DB2 UDB for z/OS. ZLB0005E: DICTIONARY CORRUPTED BY DB2. TS IS EMPTY. DICTIONARY WILL BE DROPPED. The following error occured during extract procedure statistics collection processing. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84007

Product Tip: Unicenter Database Analyzer for DB2 UDB for z/OS. What do the settings of 'J' and 'D' for the field ACTION JCL DESTINATION do from the SUBMIT - BUILD JCL PARAMETERS screen? No matter which option is used, upon hitting ENTER the processing goes to the next screen BATCH JCL SPECIFICATION where a DESTINATION again has to be entered.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84035

Product Tip: Unicenter® Thread Terminator for DB2 UDB for z/OS. The following errors occur while attempting to expand the EDM pool size in Thread Terminator:
PTT1062E ERROR PROCESSING DB2 COMMAND CALL. DB2 RETURN CODE 00F30034
PTT1070E INTERNAL ERROR ENCOUNTERED. ERROR NUMBER=?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84036

Product Tip: Unicenter® CA-Batch Processor. An IBM load utility fails with a return code 8 and the following error: Why?
BPA0114E: RETAIN PROCESSING NOT DONE, NO DSAB FOUND MATCHING DDNAME PTILOAD.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84038

Product Tip: Unicenter® RC/Migrator® for DB2 UDB for z/OS. When creating a migration strategy an 'A' or an 'E' can be used to select the primary object on the Create Migration Strategy screen. What is the difference between the two?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84040

Product Tip: Unicenter RC/Migrator for DB2 UDB for z/OS. Dividing by 15 which was used with other utilities temporary datasets to use cylinders instead of tracks did not work for this dataset. The allocations come out way too high. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84041

Product Tip: Unicenter® RC/Query® for DB2 UDB for z/OS. The following error occurs doing a QPRINT in RC/Query: Why?
PT047E - DYNAMIC ALLOCATION ERROR, RC=0000000C;RSN=035C;INFO=0018
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84042

Product Tip: Unicenter® RC/Secure® for DB2 UDB for z/OS. On the RC/Secure Application Domain screen, the field Deletion Date => always has the date 03-23-2023. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84043

Product Tip: Unicenter® RC/Extract™ for DB2 UDB for z/OS. Does the SHRLEVEL parm on the RC/EXTRACT JCL control card get ignored for an SQL type extract?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84044

Product Tip: Unicenter® RC/Update® for DB2 UDB for z/OS. Why is the header criteria in RC/UPDATE not being saved?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84063

Product Tip: Unicenter RC/Extract for DB2 UDB for z/OS. How do I extract a referentially intact set of data from two tables which do not have DB2 RI defined between them?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84073

Product Tip: Unicenter® Fast Check® for DB2 UDB for z/OS. How do I load to and check the validity of data between two tables which do not have DB2 RI associated with them? Application maintained RI has been used. RI violations are suspected due to program errors but DB2 RI may not be created as this will disrupt the existing application.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84217

Product Tip: Unicenter RC/Secure for DB2 UDB for z/OS. In RC/Secure, when performing a recover dropped object security on a large amount of objects and then submitting on-line, the following error occurred: Why?
*** PT743E: Module is NOT an APF Authorized Library Module ***
*** A unrecoverable processing error has occurred. ***
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84390

Product Tip: Unicenter® Plan Analyzer® for DB2 UDB for z/OS. Why do I get 'PP028E: No data was found matching selection criteria' with any dialog using Hversion in Unicenter Plan Analyzer for DB2 for z/OS?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84545

Product Tip: Unicenter® Rapid Reorg® for DB2 UDB for z/OS. How should table data rows be loaded back to DB2 after they have been removed by a Reorg utility as discards?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84665

Product Tip: Unicenter® Fast Unload® for DB2 UDB for z/OS. How do I unload table data from an image copy dataset where the table in question no longer exists on any current subsystem using Fast Unload for DB2 for z/OS?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=QI84672

Product Tips for AllFusion® Modeling Solutions
Product Tip: Complete Compare is one of the most widely used features in AllFusion® ERwin® Data Modeler and it has a brand new look and functionality in r7. This document walks you through the various menus and screens and explains the options that are used to apply the desired filters for comparison. You can now save and share these options for consistency and ease. To know more about the Complete Compare in r7 and some of its more advanced features:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC415062.

Product Tip: With AllFusion ERwin Data Modeler r7, the support for Oracle 10g database has been expanded to include all relational constructs. From tablespaces, partitioning, functions to DiskGroups, AllFusion ERwin Data Modeler now supports it all. If your database is Oracle, this document will help in understanding the various new editors as well as some guidelines for their usage. Go to ERwin's support of Oracle 10g:
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC415068.

FAQs for AllFusion® Modeling Solutions
Where is the Physical Name selection for Table and Column in the Reverse Engineer Option Set using r7?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC412971

When importing all of the differences between models using the new software, tables that do not exist in both models are lost.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC412972

Why am I getting the error "Failed to instantiate COM component" when trying to run the ERwin Spy as an add-in?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC412975

I would like to Complete Compare my model against the database, however, AllFusion® ERwin® Data Modeler is asking me, "Do you really want to compare the selected model to itself?" Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413452

The r7 AllFusion ERwin Data Modeler Complete Compare Resolve Differences screen is showing duplicate Foreign Key columns for both the left and right models. Why is that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413965

I am Complete Comparing my model against Oracle 9i and I see 'Distinct' for some of the views in the Resolve Differences screen. What does that mean?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413973

When I run the MIMB and export a file as XML Schema XSD file, the related tables appear as nested tables. How can I avoid that?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC413978

My Reverse Engineered model has the 'Generate' button unchecked for some of the Foreign Key (FK) indexes in the Index editor. Why?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414585

Why can't I export a Foreign Key (FK) column in the Resolve Differences screen?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414586

How can I reset the column order in my table to be same as my attribute order for that one table only?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414587

I Reverse Engineered my SQL Server database in order to Complete Compare it against my model. The Resolve Differences screen shows Foreign Key (FK) indexes to be missing on the database side even though my Reverse Engineered model has the FK index.
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414588

FAQs for Unicenter® Database Management Distributed Database Tools
What are the minimum rights I need to have in order for Unicenter® DBA to work correctly?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414614

Can the Management Database (MDB) repository be installed into my existing Ingres database running on my UNIX machine?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414615

When accessing a database, I get a message "older version server side objects detected, do you want to upgrade now?"
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414632

What does a "Loss Action" status mean on File System Database Watcher for the SQL Server agent?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414637

Can the Management Database (MDB) repository be installed into my existing Ingres database running on my UNIX machine?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414615

When accessing a database, I get a message "older version server side objects detected, do you want to upgrade now?"
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414632

What does a "Loss Action" status mean on File System Database Watcher for the SQL Server agent?
supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC414637

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.

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.

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

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.

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.

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.

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.

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!

Webcast: Extending Your Data Model Reuse With AllFusion® ERwin® Data Modeler
February 22, 2007
Mark your calendar and join Danny Sandwell of AllFusion® Modeling Product Management for this technical update on AllFusion ERwin Data Modeler r7.1. Register here.

Rocky Mountain Oracle User's Group (RMOUG) in Denver, CO - February 14-15, 2007
CA Database Management solutions will be showcased and CA experts will be presenting at the Rocky Mountain Oracle User's Group (RMOUG) in Denver, CO, on February 14-15. For more information, visit the RMOUG website: www.RMOUG.org.

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.

main content

Page Tools

print