Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

Considerations for unloading Db2 catalog data

Db2 stores catalog data as Unicode and stores many commonly used fields as UTF-8 data. To unload catalog data, you must specify DIRECT NO.

The following considerations apply when unloading catalog data:

  • To avoid contention in your Db2 subsystem, consider specifying the WITH UR clause in your SELECT statements.
  • If you are unloading catalog data to ASCII or EBCDIC, see the information about data translation, particularly supported character conversions, in Data-translation.

Related topics

Operational-considerations

DIRECT

 

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

UNLOAD PLUS for DB2 11.2