Each row in this table identifies a step that required to install or uninstall a patch or service pack. The content 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 |
| install_pkg_uuid | byte(16) | not null | The uuid of the patch or service pack The uuid of the row in the ca_install_package table with which this step is associated. |
| type | integer1 | not null | "The operation type the step is for.1 = Attended
Installation
2 = Attended Uninstallation
3 = Unattended Installation
4 = Unattended Uninstallation
5 = Silent Installation
6 = Silent Uninstallation
7 = Pre-installation
8 = Post-installation
9 = Attended Dry Run
10 = Unattended Dry Run
11 = Silent Dry Run
12 = Attended Verify
13 = Unattended Verify
14 = Silent Verify
" |
| sequence | smallint | not null | The ordinal number of the step. Steps are process in sequence by this number. |
| source_type_id | integer | not null | The type code identifying the source of data. See the ca_source_type table. |
| command_line | nvarchar(512) | with null | The command required to execute the step. May be null if a script is present for this step. |
| home_path | nvarchar(1024) | with null | The home directory to set when executing the step. |
| successful_exit_code | integer | with null | The exit code that represents successful execution of the step. |
| log_file | nvarchar(255) | with null | The file to which the output of the step will be redirected. |
| script | long nvarchar | with null | The script to execute for this step if present or null if not. |
| script_type | smallint | with null | "The script type:
1 = Win batch script 2 = Win CMD script 3 = Unix SH script 4 = CA DMS script " |
| is_active | integer1 | with null | See ca_software_def.is_active |
| requires_reboot | integer1 | with null | 1 if the system must be rebooted after the step, 0 if not. |
| creation_user | nvarchar(64) | with null | |
| creation_date | integer | with null | |
| last_update_user | nvarchar(64) | with null | |
| last_update_date | integer | with null | |
| proc_uuid | byte(16) | with null | The uuid of the corresponding process in Unicenter Software Delivery. The value is null if the patch or service pack has not been packaged for use with USD. |
Product Name: Unicenter Patch Management
Table Type: Table