SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

Example
• 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-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 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>
• 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
_____________________________________________
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 11, 2011 9:33:21 AM
============================================================================
• The prun command can be started in noninteractive mode using the –q parameter:
rmxci.sh -h nsksys.ind.hp.com -dsn
TDM_Default_DataSource -u super.super -p host1
-q "prun –sd /usr/home/rmxci/prun -o y -c 3"
• The following prun command is started in non interactive mode from an obey file:
SQL>obey startPrun.txt
SQL>prun -sd /usr/home/rmxci/prun -ld /usr/home/rmxci/prun/logs -e sql -o y -c 5
78 RMXCI commands