Job Management Partner 1/Software Distribution Description and Planning Guide

[Contents][Glossary][Index][Back][Next]

Appendix C.71 netmdm_system

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:
  • 0x00000001: Client
  • 0x00000002: Relay system
  • 0x00000008: Relay manager
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:
  • 0x00000000: Not used
  • 0x00000001: Used
--
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:
  • 0x00: Host name
  • 0x01: IP address
--
dm_managername VARCHAR2 64 varchar 64 MVARCHAR 64 Supervising manager name --
dm_holdflag RAW 1 binary 1 BINARY 1 Results file hold flag:
  • 0x00: Do not hold
  • 0x01: Hold
--
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:
  • 0x00: Not suspended
  • 0x01: Suspended
--
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 --

Legend:
--: Not applicable