This table is used as a queue for the download manager component of Unicenter Patch Management. When a service pack or patch (see ca_download_file, ca_install_package, and ca_software_def) is scheduled for download, UPM inserts a row in this table so that the download manager will download the file asynchronously. The contents of this table should not be modified directly by the user except on direct instructions from CA.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| download_file_uuid | byte(16) | not null | The uuid of the associated row in the ca_download_file table. See ca_download_file.download_file_uuid. |
| status | integer1 | with null | "1 = Scheduled 2 = Active 3 = Completed 4 = Failed 5 = Cancelled " |
| when_scheduled | integer | with null | The date/time that the download was scheduled by UPM. The date/time is recorded as the number of seconds that have elapsed since January 1, 1970 at midnight GMT. |
| when_started | integer | with null | The date/time that the download was started by UPM. The date/time is recorded as the number of seconds that have elapsed since January 1, 1970 at midnight GMT. |
| when_completed | integer | with null | The date/time that the download was completed. The date/time is recorded as the number of seconds that have elapsed since January 1, 1970 at midnight GMT. |
| attempts | integer | with null | The number of attempts. This column is used to count download attempts and report failures. |
Product Name: Unicenter Patch Management
Table Type: Table