MX Release 3.1 (H06.23+, J06.12+)

The following command prompts the user to enter the script filename or a pattern. The default

value is *.sql.

SQL>obey;

Enter the script filename [*.sql]:

PRUN command

The prun command runs script files in parallel.

Syntax

PRUN [-d | -defaults] | PRUN [-sd | -scriptsdir directoryName]

[-e | -extension extension]

[-ld | -logsdir logDirectory]

[-o | -overwrite {y | n}]

[-c | -connections num]

scriptsdir

In this directory, prun processes every file with the specified extension. If you do not specify

a directory or if you specify an invalid directory, an error message is returned and you are

prompted to re-enter the directory.

NOTE: Verify that the specified directory contains valid script files.

extension

The default is .sql.

logsdir

In this directory, prun creates a log file for each script file by appending the .log extension

to the name of the script file. If you do not specify a log file directory, prun places the log files

in the same directory as the script files.

NOTE: The prun command puts the prun.err.log summary file in the error subdirectory.

overwrite

If you specify (y), prun command overwrites the contents of existing log files. By default, prun

command keeps the original information in the log files and appends new information at the

end of each file.

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.

PRUN command 77