UNLOAD TABLESPACE

This option is valid only when DIRECT YES is in effect. 

BMC AMI Unload generates a SELECT statement for each table in the table space. When you specify UNLOAD TABLESPACE, you obtain the same results as if you had specified SELECT * FROM for every table in the table space. Therefore, the rules for assigning the SYSREC and SYSCNTL output data sets are the same as if you had specified SELECT * FROM for every table in the table space.

This option can help you avoid maintenance of a large list of SELECT statements. When new tables are added to the table space or deleted from it, you need not change the syntax to unload the data.

Restrictions

The following restrictions apply to UNLOAD TABLESPACE:

• If you specify any of the following options with the UNLOAD TABLESPACE command, BMC AMI Unload issues an error message and terminates:
  • DIRECT NO, or DIRECT AUTO that results in DIRECT NO processing. 
  • Any SELECT statement clause
• If you specify UNLOAD TABLESPACE when unloading table spaces that contain the following, BMC AMI Unload terminates:
  • A LOB or XML column
  • A clone table
• BMC AMI Unload does not support UNLOAD TABLESPACE if you specify ORDER YES or ORDER-BY.

Exceptions

The following exceptions apply to UNLOAD TABLESPACE processing:

• FORMAT CSV and UNLOAD TABLESPACE jobs are blocked and fail in the parser with a mutually exclusive error.  
• FORMAT DELIMITED and UNLOAD TABLESPACE jobs are blocked and fail in the parser with a mutually exclusive error.  
• FORMAT DSNTIAUL and UNLOAD TABLESPACE jobs create RECFM FB data.  

Additional considerations

The following considerations apply to the UNLOAD TABLESPACE command:

• The SELECT statements are generated in OBID order. 
• If you do not specify the name of the database, BMC AMI Unload uses the default database name DSNDB04.
• BMC AMI Unload automatically uses AUTOTAG YES.