Unable to Delete iSeries Physical File
Share
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
More Stories
Quick Tip: IBM Navigator for i Default URL
This is a really quick one but I keep forgetting it: http://<SERVERNAME>:2004/ibm/console
Server Manager Agent Not Connecting To SMC
After a Java update, the server manager agent may not connect to the SMC because of parameters in the java.security...
Quick Tip: How To Delete Multiple SQLPKGs
Run the following command to delete all the SQLPKG's in the QRECOVERY library with a name beginning with "OW" DLTSQLPKG...
Quick Tip: IBM i (iSeries / AS400) Spool File Navigation
The following commands can be used to navigate spool files after using a command similar to WRKSPLF. Just enter the...
Needle: IBM iSeries (AS400) Power Outage JDE Recovery
Crazy to think but this issue has come up a few times in my years as an Oracle JD Edwards...
Quick Tip: Limit The Number Of Rows Returned From A SQL Query
This is pretty basic, but I had to look up the syntax to use for SQL on IBM DB2 so...
Average Rating