Neoview Command Interface (NCI) Guide (R2.4)

Starting the Logging Process
To start logging, enter one of these commands:
• SPOOL ON or LOG ON
• SPOOL log-file or LOG log-file
For more information, see the “LOG Command” (page 105) and the “SPOOL Command” (page 155).
SPOOL ON or LOG ON Command
The SPOOL ON or LOG ON command logs information about a session in the sqlspool.lst
file, which NCI stores in the Neoview Command Interfacebin directory:
• On Windows:
hpnci-installation-directory\Neoview Command Interface\bin\sqlspool.lst
hpnci-installation-directory is the directory where you installed the NCI software
files. For more information, see Table 2-1 (page 39).
• On Linux or UNIX:
hpnci-installation-directory/nci/bin/sqlspool.lst
hpnci-installation-directory is the directory where you installed the NCI software
files. For more information, see Table 2-1 (page 39).
For example, this SPOOL ON command starts logging the session in the sqlspool.lst file:
SQL>spool on
SPOOL log-file or LOG log-file Command
The SPOOL log-file and LOG log-file commands record information about a session in
a log file that you specify. If you specify a directory for the log file, the directory must exist as
specified. Otherwise, an error occurs when you try to run the SPOOL or LOG command. If you
do not specify a directory for the log file, NCI uses the Neoview Command Interface bin directory.
For example, this SPOOL log-file command starts logging the session in the
persnl_updates.log file in the C:\log directory:
SQL>spool C:\log\persnl_updates.log
Using the CLEAR Option
The CLEAR option clears the contents of an existing log file before logging new information to
the file. If you omit CLEAR, NCI appends new information to existing information in the log
file.
For example, this SPOOL log-file CLEAR command clears existing information from the
specified log file and starts logging the session in the log file:
SQL>spool C:\log\persnl_updates.log clear
Logging Concurrent NCI Sessions
If you plan to run two or more NCI sessions concurrently on the same workstation, use the
SPOOL log-file or LOG log-file command and specify a unique name for each log file.
Otherwise, each session writes information to the same log file, making it difficult to determine
which information belongs to each session.
Stopping the Logging Process
To stop logging, enter one of these commands:
• SPOOL OFF
• LOG OFF
72 Running Commands Interactively in the NCI