IBM UNLOAD Support

Full IBM UNLOAD support is now provided including support for templates and parallelism. This support provides reduced risk of outages due to manual processes when performing schema changes. This support also provides enhanced usability and flexibility in selection of utilities, and improved DBA productivity due to reduction of manual processes. You can now use IBM UNLOAD to process tables in rcm, rcc, and rcu. To use IBM UNLOAD, use Model Services to manually activate the following utility definitions in your utility models:
carcmdb219
Full IBM UNLOAD support is now provided including support for templates and parallelism. This support provides reduced risk of outages due to manual processes when performing schema changes. This support also provides enhanced usability and flexibility in selection of utilities, and improved DBA productivity due to reduction of manual processes. You can now use IBM UNLOAD to process tables in
CA RC/Migrator™ for DB2 for z/OS
,
CA RC/Compare™ for DB2 for z/OS
, and
CA RC/Update™ for DB2 for z/OS
. To use IBM UNLOAD, use Model Services to manually activate the following utility definitions in your utility models:
  • IBMULD
    Contains IBM UNLOAD control statements.
  • IBMULD_R
    Contains IBM UNLOAD control statements for recovery.
  • IBMULD_B
    Contains IBM UNLOAD control statements for backup.
You can use IBM UNLOAD with IBM LOAD or
CA Fast Load for DB2 for z/OS
 (CA Fast Load) for data load operations.
For more information about this support, review the following topics:
4
4
Supported Data Types and Conversions
The following data types and conversions are supported for IBM UNLOAD:
  • Basic data types, plus BLOB, CLOB, DBCLOB, ROWID, XML, and DISTINCT
  • Basic data type conversions (for example, changing a SMALLINT column to DECIMAL)
  • Data length conversions (for example, changing a FLOAT column from SINGLE PRECISION to DOUBLE PRECISION)
    Scale, length, and precision changes are supported for BINARY, BLOB, CHAR, CLOB, DBCLOB, DECFLOAT, DECIMAL, FLOAT, GRAPHIC, VARCHAR, VARGRAPHIC, TIMESTAMP, and TIMESTAMP WITH TIME ZONE.
  • NULL to NOT NULL conversion
    You can convert nullable columns to NOT NULL if the resulting column has a specified DEFAULT.
  • New columns:
    • If a new column is defined with DEFAULT, the default is applied automatically and the new column is not included in the unload or load process.
    • If a custom default is supplied, it is unloaded as a constant.
    • If a default value or custom value is not supplied, the system-defined default is unloaded as a constant.
      The system-defined defaults match the values that DB2 would insert if the column were defined as NOT NULL WITH DEFAULT with the exception of the following columns: DATE, TIME, TIMESTMP, and TIMESTZ defined columns. These columns use the CURRENT value at analysis time. The column name specified in the unload is a generated value in the form of DSN_NEW_
      nnnnn
      , where
      nnnnn
      is a unique number for the table being unloaded. The actual column name will appear in the load.
  • Generated always columns:
    CA RC/Migrator will generate the appropriate load control information for tables that have a column defined with a GENERATED ALWAYS clause. You can now use IBM UNLOAD and IBM Load or CA Fast Load on objects that have a column defined as generated always.
TEMPLATE Support
TEMPLATE support is now provided in the IBM UNLOAD utility models (IBMULD, IBMULD_R, and IBMULD_B). TEMPLATE statements are generated by default instead of .ALLOC statements for IBM UNLOAD.
A new user-defined model symbolic, USETMPLT, is provided. The following values are valid with this symbolic:
  • YES–Generates an IBM TEMPLATE statement. YES is the default setting.
  • NO–Generates a batch processor .ALLOC statement for data set allocation.
SYSREC00 is changed to UNLDDSN in IBMULD and IBMULD_R.
CA RC/Migrator symbolics are supported. However, Batch Processor symbolics (starting with %%) are not supported for IBM TEMPLATE.
Parallelism Support
You can now leverage IBM DB2 parallel processing for the IBM UNLOAD utility models (IBMULD, IBMULD_R, and IBMULD_B) for partitioned tablespaces. Support for IBM symbolics &PART and &PA in TEMPLATE statements is provided to enable parallelism. With this support, partitions can be unloaded in parallel. A new data set symbolic, PARTDSN, identifies the TEMPLATE data set name for parallel unloads.
Parallelism support is provided through Utility Profile Services. Alternatively, you can edit the DATADSN symbolic in the model.