1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Performing Administrative Operations
  4. Changing Database Attributes
  5. Performing an ALTER TABLE to Add a Column on DB2 z/OS Tables

Performing an ALTER TABLE to Add a Column on DB2 z/OS Tables

To add a fixed length column to a table that is in reordered row format and contains one or more variable length columns, one of the following will be required, depending on whether the table can be quiesced or not.

If the Table can be Quiesced

  1. Allow Extract to finish capturing transactions that happened prior to the quiesce.

  2. Alter the table to add the column.

  3. Reorganize the tablespace.

  4. Restart Extract.

  5. Allow table activity to resume.

If the Table cannot be Quiesced

  1. Stop Extract.
  2. Remove the table from the TABLE statement in the parameter file.
  3. Restart Extract.
  4. Alter the table to add the column.
  5. Reorganize the tablespace.
  6. Stop Extract.
  7. Add the table back to the TABLE statement.
  8. Resynchronize the source and target tables.
  9. Start Extract.
  10. Allow table activity to resume.