Table security - Documentation for ALTER and BMC AMI Change Manager for Db2 13.1
David Craig 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’)
