Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.55 netmdm_ospatch_patchinf

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:
  • 0x0000: Neither the patch nor the script has been acquired.
  • 0x0001: Only the patch has been acquired.
  • 0x0002: Only the script has been acquired.
  • 0x0004: The patch and the script have both been acquired.
  • 0x0010: Already packaged
--
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 --

Legend:
--: Not applicable