Hi guys,

I'm now wondering if there is any way that could tell whether ingres
database is installed or not?

Many thanks,

Guoqiang Yang

Assuming Unix/Linux or Windows:
Is the environment variable II_SYSTEM defined for any user on the
system?
If not defined, then Ingres is not installed.
If it is defined, then check the location(s) defined and inspect to see
whether there is the file set for an Ingres installation.

Cheers,
Michael

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
IngresBeginner
Sent: 12 June 2009 10:02
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] checking whether ingres is installed

Hi guys,

I'm now wondering if there is any way that could tell whether ingres
database is installed or not?

Many thanks,

Guoqiang Yang
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres

On Jun 12, 2009, at 4:01 AM, IngresBeginner wrote:

Guoquiang,

What kind of platform are you on? Regardless, if you have a way
to search every directory on every drive, look for a file called

version.rel

I've never run into that filename in other software, but it should
be present in any Ingres installation installed since 1990.

UNIX (as user root):

find / -name version.rel

VMS: (as a user with READALL privilege, and for each disk device):

dir DEVICE1:[000000...]version.rel

Windows (as an Administrator):

In Windows Explorer, right-click on each device and select
"Search" operation and look for the file called version.rel

Hope this helps,

Michael Leo
Director of Managed Services
Kettle River Consulting

MLeo (AT) KettleRiverConsulting (DOT) com
+1 612-859-2108 (cell)
+1 612-605-1978 (fax)

If you mention:
- Has Ingres been installed successfully?
Check in Ingres ingres/files/install.log file if there is any error
like ' E_' ....

- Is there any Ingres installation on your machine?
Check if there is the process 'iigcn'

- If you want to try if you can perform a test sql statement via:
echo "SELECT DBMSINFO('_version') as version\\g" | sql -s iidbdb
Result:
INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation
┌───────────────┠€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â ”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€ ───────────────â”�
│version │
├───────────────┠€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â ”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€ ───────────────┤
│II 9.2.0 (su9.us5/143) │
└───────────────┠€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â ”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€ ───────────────┘
(1 row)

Bilgilhan


--
bilgihan