Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.22 netmdm_inspackage

This table stores the package installation status for each client. You can search this table to determine the packages that are installed in each client.

Column name Oracle Microsoft SQL Server Embedded RDB Edition Description Key No.
Data type Size Data type Size Data type Size
dm_dmtype CHAR 1 char 1 MCHAR 1 Type of Packager used for packaging:
  • C: WS (UNIX)
  • D: PC (Windows)
3
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 2
dm_nodename VARCHAR2 64 varchar 64 MVARCHAR 64 Client's host ID (node identification key if no host ID is used) 1
dm_newversion VARCHAR2 8 varchar 8 MVARCHAR 8 Package version --
dm_newgeneration VARCHAR2 4 varchar 4 MVARCHAR 4 Package generation number --
dm_newdeliverydate DATE -- datetime 8 TIMESTAMP -- Package transfer date --
dm_newinstalldate DATE -- datetime 8 TIMESTAMP -- Package installation date --
dm_oldversion VARCHAR2 8 varchar 8 MVARCHAR 8 Older version of package --
dm_oldgeneration VARCHAR2 4 varchar 4 MVARCHAR 4 Generation number of the older version of package --
dm_olddeliverydate DATE -- datetime 8 TIMESTAMP -- Transfer date of the older version of package --
dm_oldinstalldate DATE -- datetime 8 TIMESTAMP -- Installation date of the older version of package --
dm_insstatus CHAR 6 char 6 MCHAR 6 Status code (the left six digits of a job's maintenance code) --
dm_installdate DATE -- datetime 8 TIMESTAMP -- Installation date and time or software search date and time --
dm_packagename VARCHAR2 50 varchar 50 MVARCHAR 50 Package name --
dm_capacity NUMBER 10 int 4 INTEGER -- Package size --
dm_systeminf BLOB -- image -- BINARY 960 JP1/Software Distribution Manager management information --
dm_userstatus CHAR 2 char 2 MCHAR 2 User status (in hexadecimal) --
dm_drivetype NUMBER 3 tinyint 1 SMALLINT -- Drive type:
  • 0: Local drive
  • 1: Network drive
--

Legend:
--: Not applicable