![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1/Software Distribution Description and Planning Guide
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
This table stores the execution status of each package for each host that is subject to ID group jobs executed at a relay system (Install package and Send package, allow client to choose jobs).
| 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 | -- |
| 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 | -- | Distribution 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 for 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) | 2 |
| 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) | -- |
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.