SupportConnect - Advantage Ingres Newsletter Version 03.03
  

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 03.03
June 25, 2003

In This Newsletter
Product News
> Participate in the Beta Program for Advantage™ Ingres® 2.6 for OpenVMS

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

General Information
> What you should know before calling Technical Support
> Advantage™ OpenROAD® Application Startup Performance Considerations
> ODBC Invalid Descriptor Index Error in Advantage™ Enterprise Access for MS SQL Server (Gateway)
> Default Locking with Advantage™ Enterprise Access
> Advantage™ Enterprise Access (Gateway) pst_max and sqlda_size Configuration Variables

Special Events
> CA WorldSM 2003

Product News
Participate in the Beta Program for Advantage™ Ingres® 2.6 for OpenVMS
Beta testing for Advantage Ingres 2.6 for OpenVMS is underway. Further information about this program can be found at:
supportconnectw.ca.com/public/ca_common_docs/ingres-erdalpha26-beta.asp.

Top
Product Updates
Advantage™ Ingres® Enterprise Relational Database, 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 Advantage Ingres, Advantage OpenROAD Development, and Advantage Enterprise Access have been certified. To view the product matrix, visit the Advantage Ingres information 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 SupportConnect Advantage Ingres information page at:
supportconnectw.ca.com/premium/ingres/downloads/patch_by_platform.asp.

Top
General Information
What you should know before calling Technical Support
This document covers sources of information where you might research a problem, general information that needs to be supplied when raising an issue, and product specific information.

Further information about this can be found at: supportconnectw.ca.com/premium/ingres/infodocs/4347.asp.

Top
Advantage™ OpenROAD® Application Startup Performance Considerations
Advantage OpenROAD applications can be complex and frequently require other included applications to run. As applications and their included applications become larger and more complex, it may take longer and longer for the initial frame to be retrieved from the applications' image files and displayed. Eventually, this time lag between starting the application and viewing its initial frame may be considered a performance problem.

This document describes the runtime system processes that occur when an Advantage OpenROAD image file is run. Understanding these processes may provide insight into performance-related problems associated with starting Advantage OpenROAD applications and how to solve them.

Further information can be found at: supportconnectw.ca.com/premium/ingres/infodocs/4346.asp.

Top
ODBC Invalid Descriptor Index Error in Advantage™ Enterprise Access
for MS SQL Server (Gateway)
You may receive the ODBC INVALID DESCRIPTOR INDEX error when selecting TEXT data type columns in a non-recommended way through the Advantage Enterprise Access for MS SQL Server gateway. This article explains the reason behind the error and how you can avoid the error without sacrificing performance.

Further information about this can be found at: supportconnectw.ca.com/premium/ingres/infodocs/4348.asp.

Top
Default Locking with Advantage™ Enterprise Access
The default locking strategy varies across DBMS's and should be considered when accessing other DBMS's with Advantage Enterprise Access.

Further information about this can be found at: supportconnectw.ca.com/premium/ingres/infodocs/4350.asp.

Top
Advantage™ Enterprise Access (Gateway) pst_max and sqlda_size
Configuration Variables
Both sqlda_size and pst_max are gateway configuration variables used to provide initial values for the Advantage Enterprise Access (Gateway) to allocate memory for query processing. This article answers most commonly asked questions and clears up some confusion about these two parameters.

Further information about this can be found at: supportconnectw.ca.com/premium/ingres/infodocs/4349.asp.

Top
Special Events
CA WorldSM 2003
Check out the latest conference and session information for CA World 2003 at the Mandalay Bay Convention Center in Las Vegas, NV, July 13-17. We welcome your involvement with more than 75 informative sessions planned. Registration is open now. Best yet? CA Education is FREE again this year for conference attendees. Don't miss out on this terrific opportunity to take advantage of training on both CA products and industry-related topics, including Performance Tuning for Large-Scale Advantage™ Ingres® Servers or Web Services and Wireless-Enabling Advantage™ OpenROAD®.

Top


You are subscribed as &*TO;.

To subscribe, unsubscribe, or change the format for this or other newsletters, please go to our eNews subscribtion 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