ICMSTItemsToDelete (Item To Be Deleted Table)

The ICMSTItemsToDelete table identifies all items in resource managers to be deleted by asynchronous recovery.

Primary Key

(ItemID, VersionID, RMCode, SMSCollCode)

Indexes

Index = (RMCode ascending, SMSCollCode ascending)
z/OS only:
Unique Index = (ItemID ascending, VersionID ascending, 
                RMCode ascending, SMSCollCode ascending)

Referential Constraints

Foreign key = (RMCode, SmsCollCode)
  references ICMSTCOLLNAME (RMCode, SmsCollCode)
    on delete restrict

Column Definitions

ItemID

Item identifier.

The value for ItemID is generated in Content Manager the application requests to create an item. For details, see Table 2.

VersionID

The version id of an item.

RMCode

A unique identifier of the resource manager where the BLOB is stored.

RMAccessType

Type of the resource manager. It determines the access method.

SmsCollCode

The Systems Management criteria that are used to manage the BLOB on resource manager storage.

RepType

Indicates when to delete and destroy. Can have the following values:

'D'

Delete and destroy the object in the resource manager. The ability to destroy the associated content is dependent on the media type. Not all media types support destroy. In this context, destroy means to irrevocably delete so that recovery tools cannot restore the content of the object. The content is overwritten multiple times and then deleted from the storage media by using the normal delete mechanism.

'' (empty string)

Delete normally. An asynchronous process checks for and deletes the object. No associated content is destroyed. The content is simply removed by using the normal delete mechanism from the storage media.

UserID

The ID of the user who inserted this row.

Created

The timestamp when the object was last updated, before it was inserted into the table.

URLAddress

Web address.