![[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 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.