Job Management Partner 1/Software Distribution Description and Planning Guide
This table stores patch information and acquired patch data.
Column name | Oracle | Microsoft SQL Server | Embedded RDB | Description | Key No. | |||
---|---|---|---|---|---|---|---|---|
Data type | Size | Data type | Size | Data type | Size | |||
dm_patchid | NUMBER | 10 | int | 4 | INTEGER | -- | Patch ID | -- |
dm_title | VARCHAR2 | 800 | varchar | 800 | MVARCHAR | 800 | Title | -- |
dm_description | VARCHAR2 | 1,500 | varchar | 1,500 | MVARCHAR | 1,500 | Description | -- |
dm_classification | NUMBER | 10 | int | 4 | INTEGER | -- | Class | -- |
dm_products | NUMBER | 10 | int | 4 | INTEGER | -- | Products (If there is more than one product, the XOR of each product's numeric bits is stored.) |
-- |
dm_releasedate | DATE | -- | datetime | 8 | TIMESTAMP | -- | Release date | -- |
dm_details | VARCHAR2 | 2,083 | varchar | 2,083 | MVARCHAR | 2,083 | Detailed information | -- |
dm_kbarticle | VARCHAR2 | 16 | varchar | 16 | MVARCHAR | 16 | Technical information number for support | -- |
dm_msrcnumber | VARCHAR2 | 16 | varchar | 16 | MVARCHAR | 16 | Security number | -- |
dm_msrcseverity | VARCHAR2 | 15 | varchar | 15 | MVARCHAR | 15 | Security level | -- |
dm_updateid | VARCHAR2 | 36 | varchar | 36 | MVARCHAR | 36 | Security update ID | -- |
dm_updateurl | VARCHAR2 | 1,024 | varchar | 1,024 | MVARCHAR | 1,024 | URL from which patch is downloaded | -- |
dm_language | VARCHAR2 | 32 | varchar | 32 | MVARCHAR | 32 | Supported languages | -- |
dm_ospatchfilename | VARCHAR2 | 260 | varchar | 260 | MVARCHAR | 260 | Name of executable patch file | -- |
dm_scripturl | VARCHAR2 | 128 | varchar | 128 | MVARCHAR | 128 | URL of the script file | -- |
dm_ospatchstatus | NUMBER | 10 | int | 4 | INTEGER | -- | OS patch acquisition status:
|
-- |
dm_ospatchfile1 | BLOB | -- | image | -- | BLOB | -- | Patch data (Patches that exceed 100 megabytes are partitioned into 100-megabyte segments for storage.) |
-- |
dm_ospatchfile2 | BLOB | -- | image | -- | BLOB | -- | -- | |
dm_ospatchfile3 | BLOB | -- | image | -- | BLOB | -- | -- | |
dm_ospatchfile4 | BLOB | -- | image | -- | BLOB | -- | -- | |
dm_ospatchfile5 | BLOB | -- | image | -- | BLOB | -- | -- | |
dm_ospatchfile6 | BLOB | -- | image | -- | BLOB | -- | -- | |
dm_ospatchfile7 | BLOB | -- | image | -- | BLOB | -- | -- | |
dm_ospatchfile8 | BLOB | -- | image | -- | BLOB | -- | -- | |
dm_ospatchfile | -- | -- | -- | -- | BLOB | -- | Patch data (maximum of 1,840 megabytes) | -- |
dm_patchsize | NUMBER | 10 | int | 4 | INTEGER | -- | Patch size | -- |
dm_cabinetname | VARCHAR2 | 83 | varchar | 83 | MVARCHAR | 83 | Name of the storage destination cabinet, and package name | -- |
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.