Unloading a TSS Table from a TSS Data Set

If you want to copy a TSS table to another TSS table, replace a TSS table, or repair a damaged TSS table, you must first perform a TSS unload to copy the TSS table to a sequential data set.

Figure 1. Panel Flow – Unloading a TSS Table from a TSS Data Set

GUID-86379E0A-5777-488E-AEBE-64071ED3E79F-low.png

Before you begin

You must have created a TSS data set and at least one TSS table within that data set. See TSS-Data-Sets and Allocating-and-Formatting-a-TSS-Data-Set as well as Defining-a-TSS-Table for instructions .

You must have authority to modify the TSS data set. Contact your system administrator.

The special unload data sets that are allocated through the following instructions have an LRECL and BLKSIZE of 4096. If this is unacceptable at your facility, use the JCL in the ETACNTL library to allocate the TSS data set with a different LRECL and BLKSIZE. See Batch-Features-and-ETA-Macros for information.

Note

Unloading a TSS table does not delete the TSS table or free space in the TSS data set.

To Unload a TSS Table from a TSS Data Set

  1. Go to the ETA Translate Sub-System panel. From the ETA Main Menu, type 1 in the Selection field and press Enter. The ETA Translate Sub-System panel is displayed.
  2. Specify basic TSS information, then go to the Unload a Table pop-up window.
    1. Type 7 in the Selection field.

    2. If you will be unloading only one table and you know its name, you can specify the name in the Table name field. 

      Note

      You cannot specify a table name mask in this field, and a selection list of table names is not available for this function.

    3. Verify or change the following data:
      • TSS table data set name
      • TSS data set disposition
    4. Press Enter. The Unload a Table pop-up window is displayed.
  3. Specify the table(s) to unload and information about the output data set that will contain the unloaded table(s).
    1. If you have not already specified a table name, type a table name or masking pattern in the Table name or mask field. If you type a wildcard character as the last character in a table masking pattern, the wildcard pads to the end of the field.
    2. Type an output data set name in the Data set name field.

    3. Perform one of the following actions:

      If the output data set...

      Then...

      Is new

      Type NEW in the Disposition status field.

      Already exists

      Type OLD in the Disposition status field.

    4. Allocate the data set.

      If you want to allocate the data set via...

      Then...

      Non-SMS allocation parameters

      Type a VOLSER in the Volume serial field and type a unit name in the Unit name field. Leave the SMS Storage class and SMS Management class fields blank.

      SMS allocation parameters

      Type an SMS storage class in the SMS Storage class field. Type an SMS management class in the SMS Management class field if your facility requires this parameter for SMS configuration; otherwise, you may leave this field blank. Leave the Volume serial and Unit name fields blank.

      Note

      The VOLSER and unit name are mutually exclusive with the SMS parameters.

    5. Use the New Space quantity field to specify the number of blocks that should be reserved for the data set when it is allocated.
    6. Press Enter. ETA prompts you to verify the data.

    7. Accept or change the table and data set information.

      If the information is...

      Then...

      Correct

      Press Enter.

      Incorrect

      Change the attributes as necessary, and press Enter.

      ETA unloads the table(s) and displays the ETA Translate Sub-System panel and any applicable messages.

  4. To unload other TSS tables, repeat Step 2 and Step 3 as required.
  5. Press F3 to return to the ETA Main Menu.

Where to go from here

Perform one of the following actions:

If you want to...

Then...

Load the TSS table into a TSS data set other than the data set from which you unloaded it

Change the name of the TSS table and reload it into the TSS data set from which you unloaded it

Reload the TSS table into the TSS data set from which you unloaded it

Delete the TSS table from the TSS data set, reorganize the TSS data set, and then load the TSS table back into the TSS data set.

See Deleting-a-TSS-Table-from-a-TSS-Data-Set, Reorganizing-a-TSS-Data-Set-While-Not-in-Use or Reorganizing-a-TSS-Data-Set-While-in-Use as well as Loading-a-TSS-Table-into-a-TSS-Data-Set for instructions.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*