HP 3000 Manuals HP 3000 Manuals
Verification Testing
The installation verification test checks to make sure that all the
components of Access SQL/iX have been installed correctly.
To run the verification test, type:
RUN IASQLDAD.PPC.SYS
The test checks the version numbers of the following files that comprise
Access SQL/iX:
IACAT000.PPC.SYS - message catalog
IASQLSVR.PPC.SYS - MPE/iX server
IASQLDAD.PPC.SYS - process spawned by IASQLSVR
IASQLSN1.PPC.SYS - ALLBASE/SQL process
IASQLSN2.PPC.SYS - ORACLE process
IASOLID.PPC.SYS - listener process for INGRES
IASOLIDV.PPC.SYS - INGRES server process
SQLFILE.NET.SYS - NS data file
SQLMAST.NET.SYS - NS data file
SQLSERV.NET.SYS - NS data file
The message catalog and the three NS data files are all marked with the
version in their user label. The verification test opens these files and
reads the last user label in the form V.UU.FF.III, where:
V = Version code, identifying a major software revision
U = Update level, identifying a major product revision
F = Fix level, identifying a new supported revision of the
software
I = Internal fix level, identifying a special software release
that does not correspond to a normal release cycle.
The program files (IASQLSVR, IASQLDAD, IASQLSN1, and so on) are all
marked with a $VERSION statement from which the MPE/iX program
VERSION.PUB.SYS retrieves the version information. The verification test
expects the version label to be in the form:
V.UU.FF.III Information Access
A compatibility check is performed on these files. All VUFs must be the
same or an error is reported.
Access SQL/iX is dependent on either ALLBASE/SQL, ORACLE, or INGRES being
installed. For ALLBASE/SQL and ORACLE only, their existence is
determined by the presence of a certain file and its version is retrieved
by running the version program against the file. No compatibility check
is performed.
For ALLBASE/SQL, the presence of ISQL.PUB.SYS is used to indicate if the
product is installed. The verification test requires the version
information to follow the product number in the form:
HP355216-02V.UU.FF
For ORACLE, the presence of ORACLEXL.PUB.account is used to indicate if
the product is installed (where account is the location of the ORACLE
software and is defined in IASQL.PPC.SYS). ORACLE's version format is not
in the same V.UU.FF.III format as Access SQL/iX or ALLBASE/SQL. The
verification test requires the version information to follow "oraclexl."
For example,
oraclexl 6.0
is a valid ORACLE version number.
When the verification test is complete, a list of the installed files and
their version numbers is displayed.
The screen example on the next page shows what your screen displays after
running the verification test on Access SQL/iX with both ALLBASE/SQL and
ORACLE installed.
HP Information Access Services
A.07.20 Information Access SQL Server Process (Father)
COPYRIGHT (c) Hewlett-Packard Co. 1990, 1992
ALLBASE/iX Version = A.21.16
ORACLE Version = 6.0
Catalog file : IACAT000.PPC.SYS Version = A.07.20.000
Program file : IASQLSVR.PPC.SYS Version = A.07.20.000
Program file : IASQLDAD.PPC.SYS Version = A.07.20.000
Program file : IASQLSN1.PPC.SYS Version = A.07.20.000
Program file : IASQLSN2.PPC.SYS Version = A.07.20.000
Program file : IASOLID.PPC.SYS Version = A.07.20.000
Program file : IASOLIDV.PPC.SYS Version = A.07.20.000
Data file : SQLFILE.NET.SYS Version = A.07.20.000
Data file : SQLMAST.NET.SYS Version = A.07.20.000
Data file : SQLSERV.NET.SYS Version = A.07.20.000
Information Access SQL Server verified correctly; Version = A.07.20.00
NOTE The following information about IASQL files applies to ALLBASE/SQL
and ORACLE only. It does not apply to INGRES.