![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1/Software Distribution Description and Planning Guide
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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:
|
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:
|
-- |
All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.