Periodically, you might need to delete obsolete user profiles from the Q.PROFILES table. Delete a user profile from Q.PROFILES when you are sure that objects created by the primary authorization ID or the TSO logon ID in that profile have been either deleted or safely transferred to other users:
Use a query similar to the one shown in Figure 67 to delete a user profile.
If you are using an NLF: Include a value for the TRANSLATION column if you want to delete the user profile in a single NLF environment. If you do not specify a value for TRANSLATION, QMF deletes the profile in all NLF environments.
If the user whose profile you deleted had a private table space, use the SQL DROP TABLE SPACE statement from the SQL query panel if the space contains nothing you want to save. Also, you can use the SQL DROP TABLE statement or QMF ERASE commands if you want to delete specific QMF or database objects. The DB2 UDB for OS/390 SQL Reference manual explains the DROP statement. The QMF Reference manual explains the ERASE command.
[ Previous Page | Next Page | Contents | Index ]