Unable to Delete iSeries Physical File

August 20, 2013August 20, 2013

Read Time:51 Sec

This morning, I was unable to delete an unused physical file because of the following error:

Message ID . . . . . . : CPF3219 Severity . . . . . . . : 40
Message type . . . . . : Diagnostic
Date sent . . . . . . : 08/20/13 Time sent . . . . . . : 08:30:16
Message . . . . : Cannot delete file or member of file F083510001 in
PRODDTA.
Cause . . . . . : If a member was referred to, the member name is *N. If
this is a delete operation, file F083510001 in library PRODDTA or a
member of file F083510001 was not deleted because dependent files or members
are based on either the file or the member. If this is a restore operation,
a problem occurred preventing a successful restore of file F083510001 in
library PRODDTA. This problem occurred after the restore operation had
already created the file in preparation for the load of the file’s data from
media. The restore operation was not able to delete this unsuccessfully
restored file because dependent files or members are based on either the
file or the member.

I used the following SQL command to delete the file:

 DROP TABLE PRODDTA/F083510001 CASCADE

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com