Question & Answer
Question
DLTUSRPRF MYUSR fails with CPF2215 "User profile MYUSR not deleted"
WRKOBJOWN MYUSR shows no object found.
Answer
When a user presses F3 to exit STRSQL session and chooses option 1 = "Save and Exit session" at the "Exit Interactive SQL" screen, the system creates ISQLEN* and ISQLST* internal objects to save the iSQL Session.
These are internal objects that are not found by using WRKOBJ and can not be saved and restored. A DMPOBJ of the user profile will show these internal objects under AUTHORIZED OBJECTS.
Run DMPOBJ for the user profile to be deleted:
DMPOBJ MYUSR *USRPRF
Look for QDBSRVDMP spooled file by doing WRKSPLF and Take option 5 to Display.
You will find the following objects under AUTHORIZED OBJECTS:
AUTHORIZED OBJECTS-
19 EE ISQLENMYUSR QPADEV00080000 04 01 QRECOVERY
19 EE ISQLSTMYUSR QPADEV00080000 04 01 QRECOVERY
0E C4 MYUSR 04 01 QSYS
08 01 MYUSR MACHINE CONTEXT
PRIMARY ASSOCIATED SPACE-
19 EE ISQLENMYUSR QPADEV00080000 04 01 QRECOVERY
19 EE ISQLSTMYUSR QPADEV00080000 04 01 QRECOVERY
0E C4 MYUSR 04 01 QSYS
08 01 MYUSR MACHINE CONTEXT
PRIMARY ASSOCIATED SPACE-
These objects can not be owned other than by the original owner and will result in CPF2215 if PARM DLTUSRPRF OWNOBJOPT(*NODLT) or OWNOBJOPT(*CHGOWN) is used.
This is an issue found where the system was not deleting these user spaces correctly. This has been fixed and documented in the following Known issue:
Apply the fixes recommended in the Known issue to allow the DLTUSRPRF to delete these spaces correctly.
Workarounds:
1) If you have confirmed these are the only remaining objects owned by this user you will need to issue the following to delete the user profile:
DLTUSRPRF USRPRF(USER1) OWNOBJOPT(*DLT)
2) You can also have the user delete them by signing on and running the following steps:
-STRSQL
-F3 to exit and choose option 2=Exit without saving session
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001i3qAAA","label":"IBM i Db2-\u003EDB Objects"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;7.6.0"}]
Was this topic helpful?
Document Information
Modified date:
29 May 2025
UID
ibm17150246