Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.16 netmdm_execution_site

This table stores the execution status of each package for each host that is subject to ID group jobs executed at a relay system (Install package and Send package, allow client to choose jobs).

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_jobno CHAR 16 char 16 MCHAR 16 Number assigned to the job automatically --
dm_jobkind CHAR 1 char 1 CHAR 1 Job type code:
  • D: Install package
  • J: Send package, allow client to choose
--
dm_jobtype CHAR 1 char 1 CHAR 1 Job type subcode:
  • F: Forced installation
  • U: User installation
  • Space: Subcode not specified
--
dm_clientname VARCHAR2 64 varchar 64 MVARCHAR 64 Name of the lowest system at the destination (client) that is stored in the dm_nodename column --
dm_primarykey CHAR 16 char 16 MCHAR 16 Primary key (number assigned to each job detail) 1
dm_sitename VARCHAR2 64 varchar 64 MVARCHAR 64 Name of the highest system at the destination that is stored in the dm_nodename column --
dm_status CHAR 6 char 6 CHAR 6 Status code --
dm_installdate DATE -- datetime 8 TIMESTAMP -- Installation completion date --
dm_dmtype CHAR 1 char 1 MCHAR 1 Type of Packager used for packaging:
  • C: WS (UNIX)
  • D: PC (Windows)
--
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 --
dm_version VARCHAR2 8 varchar 8 MVARCHAR 8 Package version --
dm_generation VARCHAR2 4 varchar 4 MVARCHAR 4 Package generation number --
dm_deliverytime DATE -- datetime 8 TIMESTAMP -- Distribution date and time --
dm_installtime DATE -- datetime 8 TIMESTAMP -- Installation date and time --
dm_packagename VARCHAR2 50 varchar 50 MVARCHAR 50 Package name --
dm_deletetime DATE -- datetime 8 TIMESTAMP -- Deletion date and time --
dm_eventtime DATE -- datetime 8 TIMESTAMP -- Job execution date and time --
dm_systeminf BLOB -- image -- BLOB -- JP1/Software Distribution Manager management information --
dm_idname VARCHAR2 32 varchar 32 MVARCHAR 32 ID group name --
dm_userstatus CHAR 2 char 2 MCHAR 2 User status (in hexadecimal) --
dm_detailstatus VARCHAR2 28 varchar 28 MVARCHAR 28 Maintenance information --
dm_execday VARCHAR2 2 varchar 2 MVARCHAR 2 Execution date for periodic job --
dm_execweek NUMBER 3 tinyint 1 SMALLINT -- Periodic job execution day of the week:
  • 0x01: Sunday
  • 0x02: Monday
  • 0x04: Tuesday
  • 0x08: Wednesday
  • 0x10: Thursday
  • 0x20: Friday
  • 0x40: Saturday
--
dm_exectiming VARCHAR2 1 varchar 1 MVARCHAR 1 Job execution timing:
  • B: When client starts
  • E: While client is running
  • S: When client terminates
--
dm_nodename VARCHAR2 255 varchar 255 MVARCHAR 255 Route information about the destination that consists of an ID key for operations (host ID or node identification key) 2
dm_nodename2 VARCHAR2 255 varchar 255 MVARCHAR 255 Route information about the destination that consists of a node identification key (host name or IP address) --

Legend:
--: Not applicable