Job Management Partner 1/Software Distribution Description and Planning Guide
This table stores the execution status of each package for each host that is a target of executed jobs. For jobs that do not use packages, such as a Get system information from client job, one record is created for each host.
Column name | Oracle | Microsoft SQL Server | Embedded RDB | Description | Key No. | |||
---|---|---|---|---|---|---|---|---|
Data type | Size | Data type | Size | Data type | Size | |||
dm_jobno | CHAR | 16 | char | 16 | MCHAR | 16 | Number assigned to the job automatically | -- |
dm_jobkind | CHAR | 1 | char | 1 | CHAR | 1 | Job type code:
|
-- |
dm_jobtype | CHAR | 1 | char | 1 | CHAR | 1 | Job type subcode:
|
-- |
dm_clientname | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Name of the lowest system at the destination (client) that is stored in the dm_nodename column | 2 |
dm_primarykey | CHAR | 16 | char | 16 | MCHAR | 16 | Primary key (number assigned to each job detail) | 1 |
dm_sitename | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Name of the highest system at the destination that is stored in the dm_nodename column | -- |
dm_status | CHAR | 6 | char | 6 | CHAR | 6 | Status code | -- |
dm_installdate | DATE | -- | datetime | 8 | TIMESTAMP | -- | Installation completion date | -- |
dm_dmtype | CHAR | 1 | char | 1 | MCHAR | 1 | Type of Packager used for packaging:
|
-- |
dm_cabinetid | CHAR | 2 | char | 2 | MCHAR | 2 | ID of the cabinet containing the package | -- |
dm_packageid | VARCHAR2 | 44 | varchar | 44 | MVARCHAR | 44 | Package ID | -- |
dm_version | VARCHAR2 | 8 | varchar | 8 | MVARCHAR | 8 | Package version | -- |
dm_generation | VARCHAR2 | 4 | varchar | 4 | MVARCHAR | 4 | Package generation number | -- |
dm_deliverytime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Package transfer date and time | -- |
dm_installtime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Installation date and time | -- |
dm_packagename | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Package name | -- |
dm_deletetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Deletion date and time | -- |
dm_eventtime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Job execution date and time | -- |
dm_systeminf | BLOB | -- | image | -- | BLOB | -- | JP1/Software Distribution Manager management information | -- |
dm_idname | VARCHAR2 | 32 | varchar | 32 | MVARCHAR | 32 | ID group name | -- |
dm_userstatus | CHAR | 2 | char | 2 | MCHAR | 2 | User status (in hexadecimal) | -- |
dm_detailstatus | VARCHAR2 | 28 | varchar | 28 | MVARCHAR | 28 | Maintenance information | -- |
dm_execday | VARCHAR2 | 2 | varchar | 2 | MVARCHAR | 2 | Execution date of periodic job | -- |
dm_execweek | NUMBER | 3 | tinyint | 1 | SMALLINT | -- | Periodic job execution day of the week:
|
-- |
dm_exectiming | VARCHAR2 | 1 | varchar | 1 | MVARCHAR | 1 | Job execution timing:
|
-- |
dm_nodename | VARCHAR2 | 255 | varchar | 255 | MVARCHAR | 255 | Route information about the destination that consists of an ID key for operations (host ID or node identification key) | -- |
dm_attrflag | RAW | 1 | binary | 1 | BINARY | 1 | Attribute flag:
|
-- |
dm_userinfoption | RAW | 1 | binary | 1 | BINARY | 1 | User inventory acquisition option:
|
-- |
dm_managername | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Supervising manager name | -- |
dm_orgprimekey | CHAR | 16 | char | 16 | MCHAR | 16 | Primary key for an all-lower-clients job | -- |
dm_nodename2 | VARCHAR2 | 255 | varchar | 255 | MVARCHAR | 255 | Route information about the destination that consists of a node identification key (host name or IP address) | -- |
dm_woloption | CHAR | 1 | char | 1 | VARCHAR | 1 | Client control and distribution method:
|
-- |
dm_splitsize | NUMBER | 10 | int | 4 | INTEGER | -- | Split size | -- |
dm_transsize | NUMBER | 10 | int | 4 | INTEGER | -- | Transfer package size | -- |
dm_transinterval | NUMBER | 10 | int | 4 | INTEGER | -- | Distribution interval | -- |
dm_downlevel | CHAR | 1 | char | 1 | MCHAR | 1 | Hierarchical level | -- |
All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.