Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.72 netmdm_system_delete

This table stores the deletion history of system configuration information.

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 Route information about the destination that consists of an ID key for operations (host ID or node identification key) --
dm_nodeattributes NUMBER 10 int 4 INTEGER -- Attributes of dm_nodename:
  • 0x00000001: Client
  • 0x00000002: Relay system
  • 0x00000008: Relay manager
--
dm_nodepath1 VARCHAR2 65 varchar 65 MVARCHAR 65 Name, prefixed by a backslash (\), of the highest host on the destination route
  • For the highest host: \ only
  • If not used: Space
--
dm_nodepath2 VARCHAR2 65 varchar 65 MVARCHAR 65 Name, prefixed by a backslash (\), of the second highest host on the destination route (if not used, spaces are set) --
dm_nodepath3 VARCHAR2 65 varchar 65 MVARCHAR 65 Name, prefixed by a backslash (\), of the third highest host on the destination route (if not used, spaces are set) --
dm_nodepath4 VARCHAR2 65 varchar 65 MVARCHAR 65 Name, prefixed by a backslash (\), of the fourth highest host on the destination route (if not used, spaces are set) --
dm_nodepath5 VARCHAR2 65 varchar 65 MVARCHAR 65 Name, prefixed by a backslash (\), of the fifth highest host on the destination route (if not used, spaces are set) --
dm_nodepath6 VARCHAR2 65 varchar 65 MVARCHAR 65 Name, prefixed by a backslash (\), of the sixth highest host on the destination route (if not used, spaces are set) --
dm_comment VARCHAR2 64 varchar 64 MVARCHAR 64 Comment --
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 information update date and time --
dm_systemkey RAW 1 binary 1 SMALLINT -- 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 Result 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 a node identification key (host name or IP address) --
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 time --
dm_deletetime DATE -- datetime 8 TIMESTAMP -- Client or relay system deletion time --
dm_deletefactor NUMBER 10 int 4 INTEGER -- Deletion cause:
  • 0x00: Deleted by the administrator
  • 0x01: Reception of uninstallation result
  • 0x02: Instructed by higher manager
--
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 obtaining the deletion date and time for a node --

Legend:
--: Not applicable