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

you for more input. In the non-interactive mode, if any options are not specified, PRUN
uses the default values.
• The -d or -defaults option cannot be specified with any other option.
• The PRUN log files also contain the log end time.
• PRUN does not support the SPOOL or LOG commands. Those commands are ignored in
PRUN script files.
• The environment values from the main session (which are available through the SET
commands) are propagated to new sessions started via PRUN. However, prepared statements
and parameters are bound only to the main user session.
• 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).
Example
• To use PRUN, enter the PRUN command in the NCI session:
SQL>prun
Enter * as input to stop the current prun session
--------------------------------------------------
Enter the scripts directory : c:\ddl_scripts
Enter the script file extension[sql] :
Enter the logs directory[scripts dir] : c:\log
Overwrite the log files (y/n)[n]? : y
Enter the number of connections(2-248)[2]: 3
After you enter the number of connections, PRUN starts to process the script files and
displays this status:
Status: In Progress.......
After executing all the script files, PRUN returns a summary of the operation:
_____________________________________________
PARALLELRUN(PRUN) SUMMARY
_____________________________________________
Total files present ........................3
Total files processed ......................3
Total queries 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>
NOTE: In the PRUN summary, the Total queries processed is the total number of
commands that PRUN processes. Those commands can include SQL statements, WMS
commands, connectivity commands, security management commands, and NCI commands.
The total errors, warnings, and successes also include commands other than SQL statements.
• 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
PRUN Command 101