SupportConnect - Advantage Ingres Newsletter, Version 04.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.


Computer Associates
E-News
Advantage™ Ingres® Newsletter
Version 04.02
May 25, 2004

In This Newsletter
Product News
> New Beta Program for Advantage™ Ingres® r3 for Linux, Windows, Sun Solaris, IBM AIX, and HP-UX
> OpenLink Software

Product Updates
> Advantage™ Ingres®, Advantage™ OpenROAD® Development, and Advantage™ Enterprise Access Product Matrix
> Recent Service Packs and Patches

General Information
> Advantage™ Ingres® r3 OPF Enumeration Enhancement

Product News
New Beta Program for Advantage™ Ingres® r3 for Linux, Windows, Sun Solaris,
IBM AIX, and HP-UX
Beta testing for Advantage Ingres r3 for Linux (32-bit), Windows, Sun Solaris, IBM AIX, and HP-UX has now begun. Experience the latest technology for yourself by participating in the beta program. By participating in this very important program, you will have early access to the new features as well as direct interaction with CA's Development team.

Top
OpenLink Software
OpenLink Software is pleased to announce the immediate availability of Release 5.1 of its high-performance ODBC 3.5, JDBC 3.0, and ADO.NET data access drivers for all commercial releases of Advantage™ Ingres®, including many older releases of this product (Ingres, OpenIngres, and Ingres II since Release 6.4). All driver releases are available for Microsoft Windows, Linux, Mac OS X (multi-tier format only), and all major UNIX variants, and can be downloaded for a free 30-day evaluation from www.openlinksw.com

Top
Product Updates
Advantage™ Ingres®, Advantage™ OpenROAD® Development, and Advantage™ Enterprise Access Product Matrix
An updated product matrix is available for Advantage Ingres, Advantage OpenROAD Development, and Advantage Enterprise Access. This matrix details the platforms and operating system releases against which each product has been certified. To view the product matrix, visit the Advantage Ingres product news page at: supportconnectw.ca.com/public/ingres/infodocs/ingres-openroad-matrix.asp.

Top
Recent Service Packs and Patches
For the latest information on Advantage Ingres, Advantage OpenROAD Development, and Advantage Enterprise Access patches and Service Packs, visit the Advantage Ingres product news page at: supportconnectw.ca.com/premium/ingres/downloads/ingres_updates.asp.

The following patches are currently available for Advantage™ Ingres® Enterprise Relational Database Release 2.6:

Current Installed Release Identifier Applied
Patch
Number		 New Release Identifier
II 2.6/0201 (axp.osf/00) 9481 II 2.6/0305 (axp.osf/00)
II 2.6/0201 (hpb.us5/00) 9395 II 2.6/0305 (hpb.us5/00)
II 2.6/0207 (hp2.us5/02) 9480 II 2.6/0305 (hp2.us5/00)
II 2.6/0201 (int.lnx/00) 9478 II 2.6/0305 (int.lnx/00)
II 2.6/0201 (int.w32/00) 9394 II 2.6/0305 (int.w32/00)
II 2.6/0201 (rs4.us5/00) 9396 II 2.6/0305 (rs4.us5/00)
II 2.6/0207 (r64.us5/02) 9477 II 2.6/0305 (r64.us5/00)
II 2.6/0201 (su4.us5/00) 9397 II 2.6/0305 (su4.us5/00)
II 2.6/0207 (su9.us5/02) 9479 II 2.6/0305 (su9.us5/00)
II 2.6/0201 (usl.us5/00) p9482 II 2.6/0305 (us1.us5/00)
II 2.6/0201 (a64.lnx/00) 9680 II 2.6/0305 (a64.lnx/00)

The following "new" patches are currently available for Ingres II Releases 2.0 and 2.5:

Current Installed Release Identifier Applied
Patch
Number		 New Release Identifier
6.4/06 (vas.vms/00) 5422 6.4/06 (vax.vms/00)
II 2.0/0001 (axp.osf/00) 9602 II 2.0/0308 (axp.osf/00)
II 2.0/0001 (rs4.us5/00) 9599 II 2.0/0308 (rs4.us5/00)
II 2.5/0006 (int.w32/00) 9053 II 2.5/0011 (int.w32/00)
II 2.5/0006 (rs4.us5/00) 8513 II 2.5/0011 (rs4.us5/00)

The characters in parentheses are the configuration strings. If you're not sure whether a service pack applies to your installation, run "sql iidbdb" and you will see the configuration string.

A list of current service packs is always available at: supportconnectw.ca.com/premium/ingres/downloads/patch_by_platform.asp.

Top
General Information
Advantage™ Ingres® r3 OPF Enumeration Enhancement
The optimization of queries whose "from" clauses contain large numbers of tables can cause high CPU usage and, hence, have associated performance implications. Queries referencing 10, 15, or more base tables, typically accompanied by any number of possibly useful secondary indexes, have the potential to take a significant amount of CPU time to compile.

The primary reason for this phenomenon is the attempt by Advantage Ingres to consider all possible alternatives in order to guarantee the best plan for executing the query. Advantage Ingres incorporates numerous heuristic techniques to reduce the size of the query plan search space, but the size of this space can still result in queries that consume excessive CPU time without returning a valid plan.

This technical document details a discussion of the reasons for this consumption of CPU time and describes a new feature in Advantage Ingres r3 that improves the performance of such queries enormously.

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_ingres@ca.com with "Unsubscribe enews_ingres" (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_ingres@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.

Computer Associates

 
 
 
Page Tools
printPrint