File system delete table (FSDELETE)

The file system delete table (FSDELETE) is used to identify objects to be ultimately physically deleted by OAM from the Unix file system hierarchy. These objects are not represented in the OAM object directory. The objects to be deleted can be a result of normal deletion activity (application initiated delete or OSMC expiration processing) or cleanup cases for objects written to the file system that have not been committed (application rollback).

The File System Delete Table has one index: a unique, ascending cluster index on the unique identifier.

Table 1. Description of file system delete table (FSDELETE)
Column description	Name	DB2 type	DB2 attribute	Value	Report label
Row ID	ID	INTEGER	Primary Key Generated Always as Identity		ID
Delete Time	DELTIME	INTEGER	NND		DELETE_TIME
Delete Reason	DELREAS	CHAR(1)	NND	One of: D, O, or R	REASON
System Name	SYSNAME	CHAR(8)	NND		SYS_NAME
Storage Group Name	SGNAME	CHAR(8)	NND		SG_NAME
Collection Name	COLNAME	CHAR(44)	NND		COLLECTION_NAME
Object Name	OBJNAME	CHAR(44)	NND		OBJECT_NAME
Instance ID	INSTID	INTEGER	NND		INSTANCE_ID

The following describes the columns in the file system delete table:

ID

A system generated value uniquely identifying this row in the FSDELETE table .

DELTIME

The time (expressed as the high-order word of the system clock) after which the object identified by this row can be removed from the file system

DELREAS

The reason for the removal of the object from the file system:

D: This is the normal deletion of an object as a result of an application delete request for a primary object that resides in the file system
O: This is the normal deletion of an object as a result of OSMC related transition or expiration processing for a primary object that resides in the file system
R: This a "rollback" of an application store request for an object that was written to the file system when the application has issued a "rollback" or when the store has not been committed by the application within the required amount of time.

SYSNAME

The name of the system from which the request to remove the file from the file system originated

SGNAME

The name of the Object storage group in which the object to be removed from the file system resides

COLNAME

The name of the collection to which the object to be removed from the file system belongs

OBJNAME

The name of the object to be removed from the file system

INSTID

The unique identifier for this instance of the named object to be removed from the Unix file system hierarchy