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:
Specify D for Dataset or S for Sysout.
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) ¦ +----------------------------------------------------------------------–---+
The allocate dataset panel includes these prompts:
Calculated values are based on the “worst case.” Any unused space is freed when the process using the dataset is complete.