SQL Output Parameters

If you enter Yes for Save SQL/DSN Output on the Install menu, the SQL Output Parameters panel prompts for the output parameters.

Figure: SQL Output Parameters

---------------------------- SQL Output Parameters --------------------------
COMMAND ===>

 SQL Output Parameters:
   Output Type      ===> S            D-Dataset, S-SYSOUT

   If Dataset: DSN  ===>
               Disposition   ===>     M-MOD, O-OLD

   If SYSOUT:  SYSOUT Class  ===> *   A - Z, 0 - 9, *
               Destination   ===>
               Hold          ===> N   Y-Yes, N-No

Press ENTER key to Allocate Output
Press END Command to Cancel Allocation

********************************** N O T E S ********************************
*    Many DB2 objects (e.g. tables,indexes) are created as a result of this *
*    installation.  You may want to save the generated SQL if you will be   *
*    installing Optim in multiple subsystems, or if you simply want to      *
*    document what the installation facility did.  In either case, you must *
*    specify a destination for the output on this panel.                    *
*****************************************************************************

The SQL Output Parameters panel includes:

Output Type
The destination for stored SQL statements and DSN subcommands generated by the current install procedure.

Specify D for Dataset or S for Sysout.

If Dataset:
Information needed if Output Type is D for Dataset. Specify the following:
DSN
Name of a sequential dataset. If the dataset does not exist, you are prompted to allocate it.
Disposition
Specify M or O.
  • M means append current SQL to that in the dataset.
  • O means save current SQL only (overwrite any information in the dataset).
If SYSOUT:
Information needed if Output Type is S for Sysout. Specify:
SYSOUT Class
The output class for the printed output. Specify an alphabetic or numeric character, or an asterisk (*).
Destination
The SYSOUT destination. Specify a valid local or remote terminal, a node in the JES network, a local or remote printer or workstation, or a TSO User ID.
Hold
Disposition of the output. Specify Y to hold the output until released or deleted by an operator. Specify N to not hold the output.

If the output is to an existing dataset that conforms to the dataset requirements (sequential dataset with 0 directory blocks, FB, and LRECL=80), the dataset is used. If the dataset does not conform to the requirements, a message is displayed and you must respecify the dataset name.

If the named dataset does not exist, the Allocate Dataset panel prompts you for allocation information.

Figure: Allocate Dataset Panel

 +-----------------------------Allocate Dataset--------------—----------–--+
 ¦                                                                          ¦
 ¦ Data Set Name: Z13600MP.TEST.DSN                                         ¦
 ¦ Management Class     ===>        (Blank for Default Management Class)    ¦
 ¦ Storage Class        ===>        (Blank for Default Storage Class)       ¦
 ¦   Use Stored Values  ===> N      (Y-Yes, N-No, V-View Stored Values)     ¦
 ¦   Volume Serial      ===>        (Blank for Authorized Default Volume)   ¦
 ¦   Device Type        ===>        (Generic Unit or Device Address)        ¦
 ¦ Data Class           ===>        (Blank for Default Data Class)          ¦
 ¦   Space Units           : BLKS   (BLKS, CYLS, TRKS, KB or MB)            ¦
 ¦   Primary Quantity   ===> 1      (In Above Units)                        ¦
 ¦   Secondary Quantity ===> 1      (In Above Units)                        ¦
 ¦   Directory Blocks      : 0                                              ¦
 ¦   Record Format         : FB                                             ¦
 ¦   Record Length         : 80     (Value will be set to Block Size)       ¦
 ¦   Block Size         ===> 3200   (Must be a multiple of Record Length)   ¦
 ¦   Data set name type ===>        (BASIC, LARGE, EXTREQ, EXTPREF or Blank)¦
 ¦                                                                          ¦
 ¦                                                                          ¦
 ¦Calculated Values Shown, Change to Profiled Values ===> N (Y-Yes N-No)    ¦
 +----------------------------------------------------------------------–---+

Allocate Dataset Panel

The allocate dataset panel includes these prompts:

Dataset Name
Name of the dataset specified on the SQL Output Parameters panel. Use CANCEL to redisplay the panel and respecify the dataset name, if needed.
Management Class
The management class used to obtain the data management-related information (migration, backup, and retention criteria) for the allocation of the dataset. Leave blank for default. Management Class is active only if SMS is active.
Storage Class
The storage class used to obtain the storage-related information for the allocation of the dataset. Leave blank for default. Storage Class is active only if SMS is active.
Use Stored Values
The source of volume information. Specify:
Y
Use the volume information specified on the File Unit Parameters panel, accessed from User Options.
If you select Y, but no explicit or default volume information was specified on the File Unit Parameters panel, an error message is displayed.
N
Use the volume information specified on the Allocate Dataset panel.
V
Display the File Unit Parameters panel to specify values for unit, volume number, and one to six volume serial numbers.
Volume Serial
The serial number of the volume on which the dataset is to reside. This value must contain only alphanumerics, national characters, and the hyphen. Alternatively, you can leave Volume Serial blank to use a default volume for which you are authorized. You cannot provide both Volume Serial and Device Type.
Device Type
The generic unit or device address of the device on which the dataset is to reside. Only alphanumeric characters are valid. Alternatively, you can leave Device Type blank to use the default device type. You cannot provide both Device Type and Volume Serial.
Data Class
The data class used to obtain the data-related information (SPACE, LRECL, and so on) for the allocation of the dataset. Leave blank for default. Data Class is active only if SMS is active.
Space Units
The DASD space for the dataset to be allocated.
BLKS
Blocks, abbreviated BLK or B.
TRKS
Tracks, abbreviated TRK or T.
CYLS
Cylinders abbreviated CYL or C.
Primary Quantity
The primary quantity of space to be allocated in the indicated space units. Site management may provide guidelines regarding appropriate values.
Secondary Quantity
The secondary quantity of space to be allocated in the indicated space units. Site management may provide guidelines.
Directory Blocks
The number of directory blocks to be allocated. This value is 0 and cannot be modified.
Record Format
The record format is FB and cannot be modified.
Record Length
The logical record length is specified as 80 and cannot be modified.
Block Size
The block size in bytes. The value must be a multiple of 80. Site management may provide guidelines.
Data set name type
The type of data set being allocated. Specify:
BASIC
The data set is not an extended or large format data set.
LARGE
Allocates a large format sequential data set.
EXTREQ
Specifies that an extended data set is required.
EXTPREF
Specifies that an extended data set is preferred.
blank
Allocates a partitioned or sequential data set based on the values entered on the panel.
Calculated Values Shown, Change to Profiled Values
The values used to allocate the file. Specify:
Y
Use values previously specified and profiled. Also, if you have modified the values on this panel, they are profiled and replace any previously specified values.
N
Use the values calculated by Optim™.

Calculated values are based on the “worst case.” Any unused space is freed when the process using the dataset is complete.