IBM Verify Identity Access v11.x DB2 Schema File Includes REORG Operation

Abstract

In IBM Verify Identity Access (IVIA) v11.x, the DB2 schema update script isam_access_control_db2.sql includes a REORG operation to apply changes needed for bi-directional data synchronization between HVDB databases using IBM InfoSphere CDC.

To enable the synchronization, we added a modified timestamp column and updated constraints within the schema. As part of this, the script performs the following operations:

ALTER TABLE OAUTH20_TOKEN_EXTRA_ATTRIBUTE ALTER COLUMN STATE_ID SET NOT NULL;
ALTER TABLE OAUTH20_TOKEN_EXTRA_ATTRIBUTE ALTER COLUMN ATTR_NAME SET NOT NULL;
REORG TABLE OAUTH20_TOKEN_EXTRA_ATTRIBUTE;
ALTER TABLE OAUTH20_TOKEN_EXTRA_ATTRIBUTE ADD PRIMARY KEY (STATE_ID, ATTR_NAME);

Impact:
The REORG operation can be time-consuming on large tables in production environments. To avoid unexpected downtime, it is recommended that customers schedule schema updates, including this change, during planned maintenance windows.

Recommendation:
Ensure that appropriate downtime is planned before running the upgrade script in production.