RE: Version IDS 7.xx for AIX 4.2.1
Posted in 1998
Topics: SQL Development & Query Writing, Data Types & Schema Design, Platform-Specific Issues, Versions, Editions & End-of-Life
Doris,
We are running IDS 7.30.UC3X3 on AIX 4.2.1. This version works great for us.
We have set the following environment variables in /etc/environment
to circumvent known problems.
1. NO_SUBQF=1
2. LIGHT_SCANS=off
The NO_SUBQF variable is a workaround for defect 95376 which is fixed in IDS
7.30.UC5
(Subquery flattening produces wrong results with EXISTS clause).
The LIGHT_SCANS variable is a workaround for defect 92062.
(Calculation of fullness of pages in light append allows too many slots on
4K pages
when partition includes VARCHARS).
IDS 7.30.UC3X3 is a patched version of IDS 7.30.UC3 which addressed bugs
97883 and 96482. Without the patches "oncheck -CI" commands were running
unacceptably long.
I hope that you find this information helpful.
Rick Bernstein
Principal Database Administrator
Alaris Medical Systems
rbernste@alarismed.com
-----Original Message-----
From: Willaert Doris [mailto:sdwilla@suzuki.be]
Sent: Tuesday, December 29, 1998 07:00
To: informix-list
Subject: Version IDS 7.xx for AIX 4.2.1
We recently ordered IDS version 7.xx for AIX version 4.2.1 and we received
IDS 7.24.UD6-1. Is this the best latest version for our platform ? What
about version 7.3 ?
Could you give me your opinion ?
TIA
Doris Willaert
Suzuki Belgium
sdwilla@suzuki.be