openroad Command--Check OpenROAD Status
You can use the openroad.bat script to check the status of local and remote Ingres servers. You can specify parameters in any order. If no parameters are specified, a short usage is displayed.
The openroad command uses the following basic syntax:
openroad /option
where /option can be one of the following parameters:
These parameters, which can be specified in any order, are fully described as follows:
/applications database
Obtains a list of 4GL applications in the database whose name you specify
/check [database]
Provides the following information about the environment:
• Local client capabilities
• Capabilities of the target server (if accessible)
• List of databases on the target server (if accessible)
• Running servers on the target server
• List of global vnodes available
/database [option]
Connects to iidbdb in which this database resides using the passed or derived database name and displays a list of databases. When this option is used, the /check and /verbose options are forced on.
This parameter can takes the following options:
database
database/server
vnode::database
vnode::database/server
vnode[userid,password]::database
vnode[userid,password]::database/server
@hosthame,protocol,listen[userid,password]::database
@hosthame,protocol,listen[userid,password]::database/server
where the following are defined:
database
The name of the Ingres or Enterprise Access database that will be used. If a database name is not specified, it defaults to the value qtdemo.
server
The server class of an Ingres or Enterprise Access Database. Valid values are: INGRES, ORACLE, MSSQL, or DB2UDB.
vnode
An Ingres virtual node that can be used to connect to a remote Ingres or Enterprise Access Server. The vnode is a logical representation of a hostname, protocol, listen, userid, and password. This information is managed by the Ingres Network Utility application (netutil).
hostname
The logical machine name or the TCP/IP port address of a machine.
protocol
A protocol driver used to connect to a remote system. This is generally either wintcp or tcp_ip.
Note: Ingres 10.0 deprecates the use of wintcp.
listen
A logical port address. The default for Ingres is II.
userid
The user ID authenticated by Ingres/Net when making remote connections.
password
The password used to authenticate the userid. For more information, see the Ingres Connectivity Guide.
/?
Displays brief usage information for the openroad command.
/help
Displays complete usage information for the openroad command.
/logfiles
Displays the location of the OpenROAD logfiles default directory and the files in that directory. The location of the OpenROAD logfiles default directory is one of the following locations:
%II_LOG%
This location is set explicitly or implicitly at the process level by orwrap.exe.
%II_CONFIG%
If the %II_LOG% location is not set, then the value of II_CONFIG is used.
Files Directory
If neither %II_LOG% nor %II_CONFIG% is set, then the location defaults to %II_SYSTEM%\ingres\files.
This script sets II_LOG using one of the defaults if the value of II_LOG is either not set or is determined to not exist.
If the /logfiles flag is set, then after processing the script exits.
/profiles
This parameter displays the location of the OpenROAD profiles default directory and the files located in it. The location of the OpenROAD profiles default directory is one of the following locations:
%OR_CONFIG%
This location is set explicitly or implicitly at the process level by orwrap.exe.
%II_CONFIG%
If the %OR_CONFIG% location is not set, then the value of II_CONFIG is used.
Files Directory
If neither %OR_CONFIG% nor %II_CONFIG% is set, then the location defaults to %II_SYSTEM%\ingres\files.
This script sets OR_CONFIG using one of the defaults if the value of OR_CONFIG is either not set or is determined to not exist.
If the /profiles flag is set, then after processing the script exits.
/servers
Obtains a list of servers on the client installation or a remote installation. A database name that contains the vnode for the remote installation must be passed. The vnode will be extracted from the database and used to access the remote name server to obtain the list of running servers.
Use a database name of nmsvr if you want to pass a vnode to this script but are unsure of the database name.
/start
Starts qt.exe, the qtdemodb database. If this is the only parameter passed, then qt.exe is started immediately. If other parameters are passed, then starting qt.exe is deferred until the end. A compliance check is made to ensure that all deliverables are present before starting qt.exe.
/verbose
Specifies that detailed information should be printed during the processing of the script.
/vnodes
Obtains a list of global vnodes on the client installation.