RMOBJECTS
This table holds one row for each physical file managed or referenced.
| Column Name | Data Type | Attribute |
|---|---|---|
| OBJ_LIBRARYID | SMALLINT | NOT Null |
| OBJ_ITEMID | CHAR(26) | NOT Null |
| OBJ_VERSION | SMALLINT | NOT Null WITH DEFAULT 1 |
| OBJ_COLLECTIONID | INTEGER | NOT Null |
| OBJ_MGTCLASSID | SMALLINT | NOT Null |
| OBJ_STGCLASSID | SMALLINT | NOT Null |
| OBJ_ATTRIBUTES | SMALLINT | NOT Null WITH DEFAULT 0 |
| OBJ_RETENTION | INTEGER | NOT Null WITH DEFAULT 0 |
| OBJ_VOLUMEID | INTEGER | NOT Null |
| OBJ_STAGEDVOLUMEID | INTEGER | NOT Null WITH DEFAULT -1 |
| OBJ_PATH | INTEGER | NOT Null |
| OBJ_STATUS | CHAR | NOT Null |
| OBJ_SIZE | BIGINT | NOT Null |
| OBJ_CREATEDATE | [DB2] TIMESTAMP, [ORACLE] CHAR(26) | NOT Null WITH DEFAULT CURRENT TIMESTAMP |
| OBJ_UPDATEDATE | [DB2] TIMESTAMP, [ORACLE] CHAR(26) | NOT Null WITH DEFAULT CURRENT TIMESTAMP |
| OBJ_REFERENCEDDATE | [DB2] TIMESTAMP, [ORACLE] CHAR(26) | NOT Null WITH DEFAULT CURRENT TIMESTAMP |
| OBJ_ACTIONDATE | DATE | NOT Null |
| OBJ_MGTCLASSDATE | DATE | NOT Null |
| OBJ_STGCLASSDATE | DATE | NOT Null |
| OBJ_PLAYSTATUS | CHAR | NOT Null |
| OBJ_VOLSTATUS | CHAR | NOT Null |
| OBJ_OBJECTNAME | VARCHAR(128) | Nullable WITH DEFAULT '' |
| OBJ_ORGFILENAME | VARCHAR(1024) | Nullable WITH DEFAULT '' |
| OBJ_FILENAME | VARCHAR(128) | Nullable WITH DEFAULT '' |
| OBJ_MIMETYPE | VARCHAR(128) | NOT Null WITH DEFAULT 'text/html' |
| OBJ_OFFSET | BIGINT | NOT Null WITH DEFAULT -1 |
| OBJ_SIGNATURE | [DB2] VARCHAR(514) FOR BIT DATA, [CSP] BIT VARYING(1052672), [SQLSERVER] VARBINARY(514), [ORACLE] RAW(514) | |
| OBJ_HASH | VARCHAR(256) | Nullable WITH DEFAULT '' |
- Primary Key
- (OBJ_COLLECTIONID, OBJ_ITEMID, OBJ_VERSION, OBJ_LIBRARYID)
- Indexes
- For DB2 Universal Database
only:
For Oracle only:CREATE INDEX IDX_OBJ_STATUS ON RMOBJECTS (OBJ_STATUS ASC, OBJ_REFERENCEDDATE ASC, OBJ_STAGEDVOLUMEID ASC); RUNSTATS ON TABLE schema name.RMOBJECTS WITH DISTRIBUTION AND DETAILED INDEXES ALL;CREATE INDEX IDX_OBJ_STATUS ON RMOBJECTS (OBJ_STATUS ASC, OBJ_REFERENCEDDATE ASC, OBJ_STAGEDVOLUMEID ASC) COMPUTE STATISTICS TABLESPACE OBJECTS;Tip: This index is not built during upgrade, however adding this index is recommended as a post-upgrade operation. - Referential Constraints
-
(OBJ_LIBRARYID) REFERENCES RMSERVER ON DELETE RESTRICT ON UPDATE RESTRICT ) IN OBJECTS;
Column Definitions
- OBJ_LIBRARYID
- An ID value that maps to the RMServer table. The currently single Library server is expected to be ID 1.
- OBJ_ITEMID
- Library server Item ID.
- OBJ_VERSION
- Library server Version number.
- OBJ_COLLECTIONID
- An ID value that maps to the RMCollections table. ID's may not match between the library server and the resource manager. Collections are accessed externally by name.
- OBJ_MGTCLASSID
- An ID value that maps to the RMMgtClass table.
- OBJ_STGCLASSID
- An ID value that maps to the RMStorageClass table.
- OBJ_ATTRIBUTES
- The type of resource manager object or what to do with the object. The possible values
are:
- DK_ICM_NORMALMEDIA - 0
- Normal object. Applies to everything except for BLOB objects.
- DK_ICM_NONNORMALMEDIA - 16
- Object that is stored as a BLOB datatype in the database.
- ATTRDESTROY - 1
- This object needs to be destroyed (scrambled).
- ATTRVERIFYDESTROY - 2
- This object needs to be deleted.
- ATTR_TSM_ARCHIVE - 4
- This object is retention managed. For example, the object resides on a Tivoli Storage Manager Centera device.
- OBJ_RETENTION
- Retention managed by the library server.
- OBJ_VOLUMEID
- An ID value that maps to the RMVolumes table.
- OBJ_STAGEDVOLUMEID
- An ID value that maps to the RMVolume that is VideoCharger.
- OBJ_PATH
- The subdirectory under the collection where the actual file stored. For example,
C:\lbosdata\collection_ID\obj_path\obj_itemid. - OBJ_STATUS
- A character that denotes the objects status. The objects are:
- "A" object
- Resides on a SMS volume.
- "B" object
- Resides on a SMS volume and one on a cache volume (staging or VideoCharger).
- "C" object
- LAN cache pending.
- "D" object
- Ready to be deleted from a SMS volume.
- "G" object
- Staged discarded.
- "L" object
- LAN cached object.
- "P" object
- Delete pending.
- "R" object
- Store pending.
- "S" object
- Deprecated. Used in Version 7 to mean that the object resided in the staging (temporary) area. In Version 8, the object always bypasses this step and moves directly to the file system.
- "U" object
- Has been updated. Update is not complete. Old and new objects exist.
- OBJ_SIZE
- Object size in bytes.
- OBJ_CREATEDATE
- TIMESTAMP object created.
- OBJ_UPDATEDATE
- TIMESTAMP object updated.
- OBJ_REFERENCEDDATE
- TIMESTAMP object last referenced.
- OBJ_ACTIONDATE
- Date of the next migrator activity.
- OBJ_MGTCLASSDATE
- Date placed in this mgt class.
- OBJ_STGCLASSDATE
- Date placed in this storage class.
- OBJ_PLAYSTATUS
- Not currently used.
- OBJ_VOLSTATUS
- Not currently used.
- OBJ_OBJECTNAME
- Not currently used.
- OBJ_ORGFILENAME
- Name (if provided by the client) or name of the FTP imported file.
- OBJ_FILENAME
- The file name as stored in the file system. New object names are not randomly generated, but have a format similar to the old name as referenced by the library server. LSid.ItemID.Version.possible-name-extension-for-uniqueness.
- OBJ_MIMETYPE
- MIME type provided by the user. Returned to the accessor. No conversions or checking is done at this time.
- OBJ_HASH
-
Hash information of the object that is stored in the resource manager.