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 21 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. DB2 UDB for z/OS SQL Reference explains the DROP statement. DB2 QMF Reference explains the ERASE command.