Problem statement/ pain point: When making changes to Db2 tables there are times when you need to put the table space into a read only status to prevent update from occurring but allow the users the most time with the table being changed. The problem comes during certain ALTER table or index operations and when you must drop and recreate the table that Db2 wants the table space in a read / write status.
Proposed solution: Create a new access for the -START DATABASE (Db2) command so that only individuals that hold DBADM authority on the database or System DBADM authority can access the table in read / write status, allow utilities to run, and everyone else that tries to access the table space is in read only. The access could be called “DBA”.
Benefits/value: This will allow the DBA to be certain that no updates can occur to the table while they are in the process of performing table changes.