Ingres NT Patch Level

On 06/23/99 02:52:15 PM Roy Hann  wrote:

>I need to determine the patch level of an OI 1.2 installation on NT. I told
>someone I couldn't think of any way to do it.  Please show me I am wrong.

Roy,

Here is the answer I received from CA Tech. Support when I asked
this question:

   There are two ways of determining what patches have been
   installed on NT. The first is to simply check the files in the
   ingres directories. Any files replaced by a patch will have
   the original file backed up with a .pxxxx extension, where
   xxxx is the patch number. For instance, if patch 5307 replaces
   iiabf.exe with a newer version (which it does), the original
   executable will be copied to a file called iiabf.exe.p5307,
   and the new iiabf.exe will take it's place. Just check for a
   bunch of files in the %II_SYSTEM%\ingres\bin directory with a
   .pxxxx extension. The other way is to check the registry.
   Whenever a patch is installed, a notation is made in
   HKEY_LOCAL_MACHINE\SOFTWARE\Computer Associates International
   Inc.\OpenIngres

When connecting to the server via SQL, and issuing the select
_version()
command the following is displayed:

   OI 2.0/9712 (int.wnt/00)

   However, when accessing the registry on the server, the
   following is found:

   [HKEY_LOCAL_MACHINE\SOFTWARE\Computer Associates International
    Inc.\OpenIngres]
   "RegisteredOwner"="MDS"
   "RegisteredOrganization"="SCT"
   "OIVersion"="OI 1.2/01 (int.wnt/02)"

The upgrade from OpenIngres 1.2 to OpenIngres 2.0 did not update
the registry correctly.  The version of OpenIngres 2.0 running on
the server did not have any patches applied.

It looks like the most reliable way to check for patches is to
check the ..\bin directory for files with a .pxxxx extension.
__________
Bill Hoelzer
SCT Manufacturing & Distribution Systems
Ingres Q & A
Back to William's Home Page
Email William