Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.15 netmdm_execution

This table stores the execution status of each package for each host that is a target of executed jobs. For jobs that do not use packages, such as a Get system information from client job, one record is created for each host.

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:
  • A: Acquire collected files from relay system
  • C: Batch delete packages on relay system
  • D: Install package
  • E: Report job deletion
  • F: Resume file transfer
  • G: Collect files from client
  • H: Hold report
  • I: Get software information from client
  • J: Send package, allow client to choose
  • K: Delete collected files from relay system
  • L: ID group operation
  • M: Transfer package to relay system
  • N: Get system configuration information
  • O: Edit system configuration information
  • P: Suspend file transfer
  • S: Collect files from client to relay system
  • T: Hold-report release
  • U: Transfer user inventory schema to client
  • V: Get system configuration information
  • Y: Transfer registry collection definition
  • 1: Report message
  • 8: Set the software monitoring policy
  • 9: Get software monitoring information from the client
--
dm_jobtype CHAR 1 char 1 CHAR 1 Job type subcode:
  • D: Daily execution
  • F: Forced installation
  • M: Monthly execution
  • U: User installation
  • W: Weekly execution
  • 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 2
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 -- Package transfer 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 of 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) --
dm_attrflag RAW 1 binary 1 BINARY 1 Attribute flag:
  • 0x00: Job of the local system
  • 0x01: Job transferred from another system
--
dm_userinfoption RAW 1 binary 1 BINARY 1 User inventory acquisition option:
  • 0x00: Acquire both system information and user inventory information
  • 0x01: Acquire only user inventory information
--
dm_managername VARCHAR2 64 varchar 64 MVARCHAR 64 Supervising manager name --
dm_orgprimekey CHAR 16 char 16 MCHAR 16 Primary key for an all-lower-clients job --
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) --
dm_woloption CHAR 1 char 1 VARCHAR 1 Client control and distribution method:
  • 0x01: Start the destination
  • 0x02: Shut down the destination
  • 0x04: Execute multicast distribution
  • 0x08: Distribute (even to suspended destination)
  • 0x40: Do not archive the software operation information
--
dm_splitsize NUMBER 10 int 4 INTEGER -- Split size --
dm_transsize NUMBER 10 int 4 INTEGER -- Transfer package size --
dm_transinterval NUMBER 10 int 4 INTEGER -- Distribution interval --
dm_downlevel CHAR 1 char 1 MCHAR 1 Hierarchical level --

Legend:
--: Not applicable