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

Total sqls processed ......................40
Total errors ...............................4
Total warnings .............................0
Total successes ...........................36
Total connections ..........................5
Total connection failures...................0
Please verify the error log file c:\log\error\prun.err.log
SQL>
• This PRUN command initiates a parallel run operation with the -d option:
SQL>prun -d
SQL> prun -scriptsdir ./prun/sql –e sql –ld ./prun/logs –o y –connections 5
PRUN options are -scriptsdir c:/_nci/prun
-logsdir c:/_nci/prun/logs
-extension sql
-overwrite y
-connections 5
Status: Complete
_____________________________________________
PARALLELRUN(PRUN)SUMMARY
_____________________________________________
Total files present ......................99
Total files processed ....................99
Total sqls processed ....................198
Total errors ..............................0
Total warnings ............................0
Total warnings ............................0
Total connections .........................5
Total connection failures..................0
============================================================================
PRUN completed at Jul 20, 2007 9:33:21 AM
============================================================================
You can execute this command only in SQL mode.
• PRUN can be started in non-interactive mode using the –q parameter, thus requiring no
input:
hpnci.cmd -h neo0101.caclab.cac.cpqcorp.net -dsn
TDM_Default_DataSource -u super.services -p host1
-q "prun –sd c:/_nci/prun -o y -c 3"
• PRUN can be started in non-interactive mode from an obey file:
SQL>obey startPrun.txt
SQL>prun -sd c:/_nci/prun -ld c:/_nci/prun/logs -e sql -o y -c 5
PRUN options are -scriptsdir c:/_nci/prun
-logsdir c:/_nci/prun/logs
-extension sql
-overwrite yes
-connections 5
Status: Complete
For a summary of all errors and warnings that occurred during the PRUN operation, go to the
error subdirectory in the same directory as the log files (for example, C:\log\error) and
open the prun.err.log summary file.
For details about the errors that occurred during the execution of a script file, open each individual
log file (<script-file.sql>.log)
QUIT Command
The QUIT command disconnects from and exits the NCI.
QUIT Command 113