DB2 graphic  QMF Version 8

Deleting profiles from the Q.PROFILES table

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.

Figure 21. Deleting a QMF user profile
Base QMF (English)
German NLF
DELETE FROM Q.PROFILES
DELETE FROM Q.PROFILES
WHERE CREATOR='JONES'
WHERE CREATOR='SCHMIDT'
AND TRANSLATION='ENGLISH'
AND TRANSLATION='DEUTSCH'

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.

Deleting profiles on z/OS

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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004