Job Management Partner 1/Software Distribution Description and Planning Guide
This table stores system configuration information. The table contains one record for each client and each relay system and manages the route during job execution.
Column name | Oracle | Microsoft SQL Server | Embedded RDB | Description | Key No. | |||
---|---|---|---|---|---|---|---|---|
Data type | Size | Data type | Size | Data type | Size | |||
dm_nodename | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Host ID (or the node identification key if no host ID is used) | 1 |
dm_nodeattributes | NUMBER | 10 | int | 4 | INTEGER | -- | Attributes of dm_nodename:
|
2 |
dm_nodepath1 | VARCHAR2 | 65 | varchar | 65 | MVARCHAR | 65 | Host ID, prefixed by a backslash (\), of the highest relay on the destination route (or the node identification key if no host ID is used). If the host is directly below the manager, only \ is stored. |
-- |
dm_nodepath2 | VARCHAR2 | 65 | varchar | 65 | MVARCHAR | 65 | Host ID, prefixed by a backslash (\), of the second highest relay/manager system on the destination route (or the node identification key if no host ID is used). If there is no applicable relay manager/system, NULL is stored. |
-- |
dm_nodepath3 | VARCHAR2 | 65 | varchar | 65 | MVARCHAR | 65 | Host ID, prefixed by a backslash (\), of the third highest relay/manager system on the destination route (or the node identification key if no host ID is used). If there is no applicable relay manager/system, NULL is stored. |
-- |
dm_nodepath4 | VARCHAR2 | 65 | varchar | 65 | MVARCHAR | 65 | Host ID, prefixed by a backslash (\), of the fourth highest relay/manager system on the destination route (or the node identification key if no host ID is used). If there is no applicable relay manager/system, NULL is stored. |
-- |
dm_nodepath5 | VARCHAR2 | 65 | varchar | 65 | MVARCHAR | 65 | Host ID, prefixed by a backslash (\), of the fifth highest relay/manager system on the destination route (or the node identification key if no host ID is used). If there is no applicable relay manager/system, NULL is stored. |
-- |
dm_nodepath6 | VARCHAR2 | 65 | varchar | 65 | MVARCHAR | 65 | Host ID, prefixed by a backslash (\), of the sixth highest relay/manager system on the destination route (or the node identification key if no host ID is used). If there is no applicable relay manager/system, NULL is stored. |
-- |
dm_comment | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Comment | -- |
dm_systeminf | RAW | 255 | varbinary | 136 | BINARY | 136 | JP1/Software Distribution Manager management information | -- |
dm_hostname | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Host name | -- |
dm_ipaddress | VARCHAR2 | 15 | varchar | 15 | MVARCHAR | 15 | IP address | -- |
dm_commonname | VARCHAR2 | 32 | varchar | 32 | MVARCHAR | 32 | Client identification name | -- |
dm_connectkind | NUMBER | 10 | int | 4 | INTEGER | -- | PPP connection:
|
-- |
dm_updatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | System configuration update date and time | -- |
dm_uinvtranstime | DATE | -- | datetime | 8 | TIMESTAMP | -- | User inventory information transfer date and time | -- |
dm_uinvupdatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | User inventory information last update date and time | -- |
dm_systemkey | RAW | 1 | binary | 1 | SMALLINT | 1 | Node identification key:
|
-- |
dm_managername | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Supervising manager name | -- |
dm_holdflag | RAW | 1 | binary | 1 | BINARY | 1 | Results file hold flag:
|
-- |
dm_hostid | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Host ID | -- |
dm_nodepathview | VARCHAR2 | 255 | varchar | 255 | MVARCHAR | 255 | Destination route information, consisting of node identification keys (host name or IP address) | -- |
dm_regtranstime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Registry collection item transfer date and time | -- |
dm_regupdatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Last update date and time for registry collection item | -- |
dm_invupdatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Last update date and time for system information | -- |
dm_inspupdatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Last update date and time for installed package information | -- |
dm_sinvupdatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Last update date and time for software inventory information | -- |
dm_nodename2 | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Host name of client or relay system (the value is not converted to lowercase letters) | -- |
dm_macaddress | VARCHAR2 | 12 | varchar | 12 | MVARCHAR | 12 | MAC address | -- |
dm_createtime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Client or relay system creation date | -- |
dm_transholdflag | NUMBER | 10 | int | 4 | INTEGER | -- | File transfer suspension flag:
|
-- |
dm_lastupdatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Last update date and time for an inventory (system configuration information, system information, installation package information, and software information) | -- |
dm_monupdatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Last update date and time for operation monitoring information | -- |
dm_monpolicy | VARCHAR2 | 85 | varchar | 85 | MVARCHAR | 85 | Operation monitoring policy information | -- |
dm_version | VARCHAR2 | 8 | varchar | 8 | MVARCHAR | 8 | Policy version | -- |
dm_generation | VARCHAR2 | 4 | varchar | 4 | MVARCHAR | 4 | Policy generation number | -- |
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.