SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

connections
Enter a number for the maximum number of connections for the data sources. The data source
must support the specified number of connections.
Considerations
• You must enter the command in one line.
• If the prun command is run without any parameters, RMXCI prompts for the prun parameters.
If one or more options are specified, the prun command runs without prompting for more
input. In the noninteractive mode, if any options are not specified then the default value is
used.
• The -d or -defaults option cannot be specified with any other option.
• The prun log files also contain the log end time.
• The prun command does not support the spool or log commands. These 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.
Example
• On Linux, enter the prun command in RMXCI:
SQL>prun
Enter * as input to stop the current prun session
--------------------------------------------------
Enter the scripts directory : /usr/home/rmxci/ddl_scripts
Enter the script file extension[sql] :
Enter the logs directory[scripts dir] : /usr/home/rmxci/log
Overwrite the log files (y/n)[n]? : y
Enter the number of connections(2-64)[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 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 /usr/home/rmxci/log/error/prun.err.log
SQL>
• On Linux, The following 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 /usr/home/rmxci/prun
-logsdir /usr/home/rmxci/prun/logs
-extension sql
-overwrite y
-connections 5
Status: Complete
_____________________________________________
PARALLELRUN(PRUN)SUMMARY
_____________________________________________
100 RMXCI commands