-BMCB (BMC BASIC UNLOAD utility)
The -BMCB command invokes the BMC BASIC UNLOAD utility to unload data for the tables that need to be rebuilt.
The BASIC UNLOAD utility is included with ALTER and BMC AMI Change Manager for Db2. The utility runs as a subtask.
ALTER and Change Manager run the BASIC UNLOAD utility to perform the following functions:
- Unload data by using a Db2 SQL SELECT statement
- Migrate tables with ROWID columns
The BASIC UNLOAD utility uses a portion of the functionality of the UNLOAD PLUS utility. For more information about the UNLOAD PLUS utility, see UNLOAD PLUS for DB2 documentation.
Use of -BMCB to unload data
The BASIC UNLOAD utility uses Db2 dynamic SQL programming techniques to process a SELECT statement and read data in a table.
The utility retains the format of the data (EBCDIC, ASCII, or Unicode). The BASIC UNLOAD utility takes advantage of the functionality that the Db2 SQL SELECT statement provides.
Example of -BMCB command
UNLOAD UNLOADDN (SYSR1001)
ACTIVE (YES,NO)
DISCARDS 1
NULLTYPE T1 NULLCHAR ?
EBCDIC CCSID(37,0,0)
DIRECT NO
SELECT *
FROM RDACRJ.NEWCLAIM
Use of -BMCB to migrate tables with ROWID columns
You can modify or migrate tables that contain ROWID columns with data.
If the ROWID column is defined as GENERATED ALWAYS, ALTER and Change Manager omit the ROWID column in the UNLOAD and LOAD statements. If the ROWID column is defined as GENERATED BY DEFAULT, ALTER and Change Manager include the ROWID column in the UNLOAD and LOAD statements. The column is unloaded last in the sequence of columns and is also loaded last, even though it might not be the last column in the table. When a table that contains a ROWID column is unloaded, Analysis lists all of the columns that are unloaded in the UNLOAD statement in the worklist.
Related topic