Job Management Partner 1/Software Distribution Description and Planning Guide
This table stores the package installation status for each client. You can search this table to determine the packages that are installed in each client.
Column name | Oracle | Microsoft SQL Server | Embedded RDB Edition | Description | Key No. | |||
---|---|---|---|---|---|---|---|---|
Data type | Size | Data type | Size | Data type | Size | |||
dm_dmtype | CHAR | 1 | char | 1 | MCHAR | 1 | Type of Packager used for packaging:
|
3 |
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 | 2 |
dm_nodename | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Client's host ID (node identification key if no host ID is used) | 1 |
dm_newversion | VARCHAR2 | 8 | varchar | 8 | MVARCHAR | 8 | Package version | -- |
dm_newgeneration | VARCHAR2 | 4 | varchar | 4 | MVARCHAR | 4 | Package generation number | -- |
dm_newdeliverydate | DATE | -- | datetime | 8 | TIMESTAMP | -- | Package transfer date | -- |
dm_newinstalldate | DATE | -- | datetime | 8 | TIMESTAMP | -- | Package installation date | -- |
dm_oldversion | VARCHAR2 | 8 | varchar | 8 | MVARCHAR | 8 | Older version of package | -- |
dm_oldgeneration | VARCHAR2 | 4 | varchar | 4 | MVARCHAR | 4 | Generation number of the older version of package | -- |
dm_olddeliverydate | DATE | -- | datetime | 8 | TIMESTAMP | -- | Transfer date of the older version of package | -- |
dm_oldinstalldate | DATE | -- | datetime | 8 | TIMESTAMP | -- | Installation date of the older version of package | -- |
dm_insstatus | CHAR | 6 | char | 6 | MCHAR | 6 | Status code (the left six digits of a job's maintenance code) | -- |
dm_installdate | DATE | -- | datetime | 8 | TIMESTAMP | -- | Installation date and time or software search date and time | -- |
dm_packagename | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Package name | -- |
dm_capacity | NUMBER | 10 | int | 4 | INTEGER | -- | Package size | -- |
dm_systeminf | BLOB | -- | image | -- | BINARY | 960 | JP1/Software Distribution Manager management information | -- |
dm_userstatus | CHAR | 2 | char | 2 | MCHAR | 2 | User status (in hexadecimal) | -- |
dm_drivetype | NUMBER | 3 | tinyint | 1 | SMALLINT | -- | Drive type:
|
-- |
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.