Displaying the list of OUTDDN files

The OUTDDN list panel is used to display the list of OUTDDN files.

Procedure

  1. Specify the OUTDDN command.
    The OUTDDN List panel is displayed, as shown in the following figure:
    Figure 1. OUTDDN List panel
     INZB601I ---- DZ7M IBMUSER  . TSTEST16           - OUTDDN List ---- Row 1 of 2
 Command ===>                                                  Scroll ===> CSR

 Commands :  FORMAT    COLUMNS    WHERE    ORDERBY    FUSER     LOADDDN    JCL
            *         *                   *

 Line commands: E - Edit, D - Delete, C - Copy

 SELECT Description . . IBMUSER .TSTEST16                                     

 Select a data set or enter a new data set name :

                                              ( PF3 to return to "Select List")

 S Data set name                                                      Disposition
 - ----------------------------------------------------------------   -----------
 _ ________________________________________________________________   <=== NEW
 _ IBMUSER.UNLOAD01                                                    ( N , C , D )
 _ IBMUSER.UNLOAD02                                                    ( N , C , D )

 ******************************* Bottom of data ********************************

    You can use the following selection codes on the OUTDDN List panel:

    The OUTDDN List panel contains the following fields:

    S
    Use this column to specify the partitions to be selected or deselected. You can enter one of the following selection codes in this column:
    S
    Use the S selection code to specify values for output data sets.
    D
    Deletes a file.
    C
    Copies a file to a new file.
    Data Set Name
    Indicates the name of the OUTDDN data set. The following variables can be used, during the generation of the JCL, a substitution occurs.
    • &DBNAME: this variable is replaced by the database name that contains the unloaded tablespace.
    • &TSNAME: this variable is replaced by the name of the unloaded tablespace.
    • &SPACE: this variable is replaced by the name of the unloaded tablespace. &SPACE is a synonym of &TSNAME.
    • &ZUSER: this variable is replaced by the user name used to connect, where the interactive menu is running.
    • &DB2: this variable is replaced by the SSID where the generated JCL will run.
    • &PART: this variable is replaced by the partition number:
      • 000: when the unloaded tablespace is not partitioned or
      • nnnn: 4 digits for the partition number
    • &CREATOR: this variable is replaced by the owner of the table specified in the SELECT.
    • &TBNAME: this variable is replaced by the owner of the table specified in the SELECT. This variable can be used only if the name of the table has at most 8 characters. When above, an ISPF message is issued.
    Indicates the name of the data set that will contain the result of the SELECT statement.

    For partitioned table spaces, to define one output file for each partition, use the &PART variable in the generic data set name, which allows Db2 HPU to process in parallel.

    If Db2 HPU was requested to perform parallel processing for partitioned table spaces, you must specify this processing for all files.

    Disp
    Indicates the disposition of the OUTDDN files.
    New/Old/Mod
    Indicates the disposition to use as the first parameter.
    Del/Keep/Catlg
    Indicates the disposition to use as the second and third parameters.
  2. Specify the S selection code in the S field.
    The OUTDDN File panel is displayed, as shown in the following figure:
    Figure 2. OUTDDN File panel
    INZB61 ------ DZ7M IBMUSER  . TSTEST16           - OUTDDDN File ------- 12:04
 Command ===>


                     Data set with formated result of SELECT

 Data set name IBMUSER.UNLOAD03
 Disposition . . . . . ( _ , _ , _ )  (New/Old/Mod) (Del/Keep/Catlg)
 Generic unit  . . . . . ________
 Volume serial . . . . . ______ - ______ - ______ - ______ - ______
 Space units . . . . . . _____        (BLKS, TRKS, CYLS)
 Primary quantity  . . . ________
 Secondary quantity  . . ________
 Record format . . . . . __           (F, FB, V, VB)
 Record length . . . . . _____
 Block size  . . . . . . _____

 SMS
 Data class . . . . . . ________
 Management class . . . ________
 Storage class . . . . ________


 for tape unit
 Label . . . . . . . . . _____

                                               ( PF3 to return to "OUTDDN List")
  3. Edit the following fields:
    Data Set Name

    For partitioned table spaces, to define one output file for each partition, use the &PART variable in the generic data set name, which allows Db2 HPU to process in parallel.

    If Db2 HPU was requested to perform a processing in parallel for partitioned table spaces, you must specify this processing for all files.

    Disposition
    Specify whether the OUTDDN data set is shared.
    New/Old/Mod
    Specify the disposition to use as the first parameter.
    Del/Keep/Catlg
    Specify the disposition to use as the second and third parameters.
    Generic unit
    Specify the DASD unit name.
    Volume serial
    Specify the volume serial number.
    Space units
    Specify the volume allocation unit (BLKS, TRKS, or CYLS).
    Primary quantity
    Specify the primary allocation for the data set.
    Secondary quantity
    Specify the secondary allocation for the data set.
    Record format
    Specify the format of the records as F, FB, V, or VB.
    Record length
    Specify the length of the records with a value less than or equal to 32760.
    Block size
    If FB or VB was specified in the FORMAT field, you must specify the block size. The BLKSIZE value must be less than or equal to 32760 and it must be a multiple of LRECL (+4 if V or VB).
    SMS
    Specify the Data Class, Management Class, and Storage Class parameters for allocation data sets that are managed by SMS. The values that are entered for these parameters are in the DD statement that is generated in the JCL.
    for tape unit/Label
    Specify the tape sequence number if the file is to be written to tape.