Table security - Documentation for ALTER and BMC AMI Change Manager for Db2 13.1

Storage group

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NEWNAME_PART1, TIMESTMP)

VALUES

('SG','oldName','newName','timeStamp')

Database

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NEWNAME_PART1, TIMESTMP)

VALUES

('DB','oldName','newName','timeStamp')

Table space

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

('TS','oldDatabase','oldTableSpace’,’newDatabase’, 'newTableSpace', 'timeStamp')

Table

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

('TB','oldCreator','oldName', 'newCreator', 'newName', 'timeStamp')

Table column

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, CONAME, NEWNAME_PART1, NEWNAME_PART2, NEWCONAME, TIMESTMP)

VALUES

('CO','oldCreator','oldTable', 'oldColumn', 'newCreator', 'newTable', 'newColumn', 'timeStamp')

Check constraint

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NAME_PART3, NEWNAME_PART1, NEWNAME_PART2, NEWNAME_PART3, TIMESTMP)

VALUES

('CK','oldCreator','oldTable', 'oldName', 'newCreator', 'newTable', 'newName', 'timeStamp')

Index

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

('IX','oldCreator','oldName', 'newCreator', 'newName', 'timeStamp')

Unique constraint

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NAME_PART3, NEWNAME_PART1, NEWNAME_PART2, NEWNAME_PART3, TIMESTMP)

VALUES

('UC','oldCreator','oldTable', 'oldName', 'newCreator', 'newTable', 'newName', 'newTimeStamp')

Trigger

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

('TR','oldSchema','oldName', 'newSchema', 'newName', 'timeStamp')

Foreign key

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NAME_PART3, NEWNAME_PART1, NEWNAME_PART2, NEWNAME_PART3, TIMESTMP)

VALUES

('FK','oldCreator','oldTable', 'oldName', 'newCreator', 'newTable', 'newName', 'timeStamp')

View

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

('VW','oldCreator','oldName', 'newCreator', 'newName', 'timeStamp')

View column

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, CONAME, NEWNAME_PART1, NEWNAME_PART2, NEWCONAME, TIMESTMP)

VALUES

('VC','oldCreator','oldView', 'oldColumn', 'newCreator', 'newView', 'newColumn', ' timeStamp')

Stored procedure (external)

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

('SP','oldSchema','oldName', 'newSchema', 'newName', 'newTimeStamp')

Stored procedure (native SQL)

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NAME_PART3, NEWNAME_PART1, NEWNAME_PART2, NEWNAME_PART3, TIMESTMP)

VALUES

('SP','oldSchema','oldName', 'newSchema', 'newName', 'newTimeStamp')

Synonym

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

('SY','oldCreator','oldName', 'newCreator', 'newName', 'timeStamp')

Alias

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

('AL',' oldCreator',' oldName', ' newCreator', ' newName', ' timeStamp')

Sequence

INSERT INTO CM_RENAME

(OBJECT, NAME_PART1, NAME_PART2, NEWNAME_PART1, NEWNAME_PART2, TIMESTMP)

VALUES

(‘SQ’, ‘oldSchema’, ‘oldName’, ‘newSchema’, ‘newName’, ‘timeStamp’)