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


Computer Associates
E-News
Ingres® Newsletter
Version 05.01
March 30, 2005

In This Newsletter

Product News
> Ingres® r3 for Solaris Now Generally Available
> Advantage™ Enterprise Access r2.1 SP3 Now Generally Available
> Advantage™ OpenROAD® Development r4.1 SP3 Now Generally Available on Windows
> Soon to Be Announced - Open Beta for Ingres® r3 Cluster Solution (Ingres® Cluster) on Linux

Product Updates
> Advantage™ OpenROAD® Development r4.1 SP3 Nears General Availability on UNIX/Linux
> Coming Soon: Open Beta for Ingres® r3 on VMS
> Coming Soon: Beta for Advantage™ OpenROAD® Development r5
> Ingres®, Advantage™ OpenROAD®, and Enterprise Access Product Matrix
> Recent Service Packs and Patches

General Information
> EJB Development with Ingres®
> The Ingres® Query Optimizer
> Problems with Ingres® r3 on SuSE 9.2
> Security Auditing
> Compiling Ingres® 32-Bit Applications on AMD64 Linux
> Advantage™ Enterprise Access (Gateway) Timezone Adjustment Behavior

Special Events
> Ingres® User Group Meetings

Product News
Ingres® r3 for Solaris Now Generally Available
We are pleased to announce that Ingres r3 for Solaris is now GA and available at ca.com/opensource/ingres. The powerful new capabilities introduced in the r3 release of Ingres are now generally available to our many customers who depend on Solaris.

Top
Advantage™ Enterprise Access r2.1 SP3 Now Generally Available
We are pleased to announce that Advantage Enterprise Access r2.1 SP3 is now generally available.

When you are ready to receive Advantage Enterprise Access r2.1 SP3, you may choose one of the following methods of ordering:
  • Place your order by submitting an Advantage Enterprise Access online order form located on the Advantage Enterprise Access SupportConnectSM product home page.
  • Download this product through SupportConnect.
  • For North American orders, you may call the Computer Associates International, Inc. (CA) Orders Department at 1-800-841-8743. If you are outside of North America, please call your local account representative or the local CA office.
  • Contact your local Customer Advocate.

Top
Advantage™ OpenROAD® Development r4.1 SP3 Now Generally Available on Windows
We are pleased to announce that Advantage OpenROAD Development r4.1 SP3 for Windows is available for download on the Advantage OpenROAD Development SupportConnectSM product home page.

Top
Soon to Be Announced - Open Beta for Ingres® r3 Cluster Solution (Ingres Cluster)
on Linux
Ingres r3 running in an active-active cluster configuration under Linux is approaching beta release with an anticipated start date of mid-to-late April. This will be an open beta with source and binaries available from the Ingres open source website: ca.com/opensource/ingres.

To run Ingres r3 Cluster Solution, you need the following:
  • Two or more x86-based servers running any version of Linux that supports the Native POSIX Threading Library. This requirement generally means a 2.6 kernel, but Red Hat has also back ported NPTL support to later versions of the 2.4 kernel (RHES SP2 and above).
  • OpenDLM Distributed Lock Manager (DLM). This is an open source distributed lock manager that can be obtained from the CA open source website (preferred) or from sourceforge.net/projects/opendlm.
  • iiquorumd cluster quorum manager. This is a small daemon process that maintains cluster membership for OpenDLM. This will be available from the Ingres open source website.
  • A cluster file system (CFS). Ingres is vendor-neutral with respect to cluster file systems. We have tested with both OCFS and GFS, with much better results from GFS. At present, there are unresolved issues with OCFS in which OCFS presents an inconsistent view of the file system to different nodes to applications like Ingres, which create and destroy files and directories on the fly. In principle, any CFS that presents shared storage as a regular file system while maintaining file consistency will work. Various CFS implementations have their own kernel requirements, which may be more restrictive than those of Ingres, and GFS has very poor performance with database page sizes of 2K.
  • Any form of shared storage supported by the selected CFS.
  • A private LAN is strongly recommended for DLM traffic and CFS usage. A separate private LAN for both is preferred. The LAN can be put together with standard Ethernet cards and switches or can use specialized cluster interconnect hardware such as Topspin's InfiniBand or Myrinet.
If you are interested in participating in this beta, please contact Patricia.Austin@ca.com.

Top
Product Updates
Advantage™ OpenROAD® Development r4.1 SP3 Nears General Availablity on UNIX/Linux
Advantage OpenROAD Development r4.1 SP3 for UNIX/Linux is approaching final certification with an anticipated GA date of early April. Look for it to be available on SupportConnectSM in April 2005.

Top
Coming Soon: Open Beta for Ingres® r3 on VMS
Ingres r3 running on VMS over Alpha servers is approaching beta release. This will be an open beta with source and binaries available from the Ingres open source website (opensource.ca.com/projects/ingres). All those interested in participating in this beta are encouraged to contact Patricia.Austin@ca.com.

Top
Coming Soon: Beta for Advantage™ OpenROAD® Development r5
Advantage OpenROAD Development r5 is approaching beta release with an anticipated start date of mid-to-late May 2005. All those interested in participating in this beta are encouraged to contact Patricia.Austin@ca.com.

Top
Ingres®, Advantage™ OpenROAD®, and Enterprise Access Product Matrix
An updated product matrix is available for Ingres, Advantage OpenROAD, and 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 Ingres product home page at supportconnectw.ca.com/public/ingres/infodocs/ingres-openroad-matrix.asp.

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

The following patches are currently available for Ingres r2.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) 9482 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 r2.0:

Current Installed Release Identifier Applied
Patch
Number		 New Release Identifier
II 2.0/0001 (int.w32/00) 9601 II 2.0/0308 (int.w32/00)
II 2.0/0011 (axm.vms/00) 9605 II 2.0/0308 (axm.vms/00)
II 2.0/0001 (dgi.us5/00) 9884 II 2.0/0308 (dgi.us5/00)

The following patches are currently available for Advantage OpenROAD 4.1:

Current Installed Release Identifier Applied
Patch
Number		 New Release Identifier
OR 4.1/0302 (int.w32/00) 10464 OR 4.1/0403 (int.w32/00)
OR 4.1/0302 (su4.us5/00) 9178 OR 4.1/0302 (su4.us5/00)
OR 4.1/0302 (int.lnx/00) 9208 OR 4.1/0302 (int.lnx/00)
OR 4.1/0302 (hpb.us5/00) 9210 OR 4.1/0302 (hpb.us5/00)
OR 4.1/0302 (axp.osf/00) 9223 OR 4.1/0302 (axp.osf/00)

The following patches are currently available for Advantage Enterprise Access 2.1:

Current Installed Release Identifier Applied
Patch
Number		 New Release Identifier
EA 2.1/0106 (int.wnt/00) 10437 EA 2.1/0403 (int.w32/00)
EA 2.1/0106 (hpb.us5/00) 10347 EA 2.1/0403 (hpb.us5/00)
EA 2.1/0106 (rs4.us5/00) 10346 EA 2.1/0403 (rs4.us5/00)
EA 2.1/0106 (su4.us5/00) 10345 EA 2.1/0403 (su4.us5/00)

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

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

Top
General Information
EJB Development with Ingres®
Enterprise JavaBeans (EJB) development with Ingres enables rapid application development in today's multiplatform environments. Click here to find out how to configure and use Ingres with a J2EE compliant application server.

Top
The Ingres® Query Optimizer
The Optimizer Facility (OPF) is one of the major components of the Ingres database server. It is responsible for transforming a parsed query into an executable query plan. This transformation includes the phases one would expect from a state-of-the-art commercial query optimizer including query rewrite and cost-based plan generation. This document discusses the architecture of OPF in sufficient detail to enable a DBMS practitioner to understand its major control structures and flow of control.
opensource.ca.com/projects/ingres/documents/technical/optimizer

Top
Problems with Ingres® r3 on SuSE 9.2
Attempting to install the current GA release of Ingres r3 for x86 Linux - that is, Ingres r3 3.0.1 (int.lnx/109) - on SuSE Linux 9.2 Pro results in many errors and probably complete failure.

SuSE 9.2 is the first major distribution to ship with Bash v3.0 and changes in v3.0 adversely affect some of the shell scripts used during installation and operation of Ingres on Linux. With the new version, if bin/bash is invoked as /bin/sh (which is usually a link to /bin/bash on Linux), it enforces POSIX compliance much more strictly than in previous releases. All the Ingres shell scripts are run under /bin/sh, and Bash does not like some of the "trap" syntax Ingres uses in many of its scripts, which results in the following error:

trap: usage: trap [-lp] [[arg] signal_spec ...]

RedHat Enterprise Linux 4.0 also ships with Bash v3.0 but does NOT have the same problem. This may be because it is using a slightly old version of Bash (3.0.0 instead of 3.0.15 on SuSE 9.2 Pro), or it may be that RedHat has modified its version of Bash v3.0 not to exhibit this behavior.

Either way, the problematic syntax has been corrected and the problem does not exist in the forthcoming Ingres r3 3.0.2 release.

Top
Security Auditing
This article is an overview of security auditing in Ingres®. It covers how to set up and configure security auditing, examine the audit logs, and troubleshoot common errors. Learn more about Security Auditing.

Top
Compiling Ingres® 32-Bit Applications on AMD64 Linux
Ingres r3 for Intel Linux is supported on AMD64 Linux, but to compile and link 32-bit binaries, you must tell the compiler you want this by using the -m32 switch. Failure to do so may result in errors relating to the chip architecture. The following is an example of what the compilation command should look like:

cc -m32 -w -o /db/ingres/example/test test.c -
lc/i3/ingres/lib/dates_lib.a /i3/ingres/lib/libingres.a -lm -ldl -lpthread -lcrypt -lgcc_s

Top
Advantage™ Enterprise Access (Gateway) Timezone Adjustment Behavior
The Enterprise Access gateway handles timezone adjustment differently than Ingres®. That is, the DATE fields do not undergo the same timezone adjustment process as Ingres. When dealing with DATE fields in the gateway, it is important to understand how date values are stored and retrieved across different timezones so that proper measures can be taken to ensure date value consistency. This article describes this important timezone adjustment behavior.

Top
Special Events
Ingres® User Group Meetings
If you are new to Ingres, you may not know about the large number of Ingres user groups around the world. These groups are run by users for the benefit of users and provide the ideal venue for Ingres DBAs, developers, and other interested parties to meet and exchange ideas on how to get the best from Ingres. Most groups hold regular meetings that include incisive presentations by users and CA technical staff. Some meetings scheduled in the coming months include:

Sweden
24 May, Stockholm
www.ca.com/se/foreningar/swing/

Finland
25 - 26 May, Tallinn, Estonia
www.ca.com/offices/finland/events/usergroupdays/index.htm

Germany
31 May - 2 June, Lahnstein
www.ca.com/de/event/gerug_ug.htm

UK
6 June, Ditton Manor, Datchet
www.iua.org.uk

Western Australia
16 April, Perth
members.ozemail.com.au/~ingresug/wa/index.html

South Australia
April, Venue & Date TBC
members.ozemail.com.au/~ingresug/sa/index.html

If you would like the opportunity to meet with like-minded professionals and to exchange views and ideas, why not attend the next meeting of your local user group? You will be welcomed. If you would like to become a member of a user group, register on the CA User Group web page and do the following:
  1. Log on to www.causergroups.com.
  2. Click the Join a User Group link.
  3. Fill out the New Member form.
  4. Enter your password.
  5. Click the Join Group button.
If you are a user group president and would like the details of your next meeting published, please contact Patricia.Austin@ca.com, and we will include it in the next edition of E-News.

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