This table holds the applications used to represent the execution of a procedure on a target system. The applications are linked to an activity (Job).
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectid | byte(16) | not null | Primary key, it is a uuid. |
| installation | byte(16) | with null | If the application object represents an installation then this is the same as objectid. In case of configuration, activation or uninstallation, this links to the application that represents the installation. |
| firstrenew | byte(16) | with null | This is the link to the first application of the renew chain, typically the original application, FK to usd_applic. |
| nextrenew | byte(16) | with null | This is the link to the next application of the renew chain, an application may be renewed more than once, FK to usd_applic. |
| racassoc | byte(16) | with null | In case a RAC application has been created this is a link to the original application, FK to usd_applic. |
| version | integer | not null | Version number is used to maintain cache and an optimistic transaction policy |
| status | integer | not null | Application status, typically waiting, executing etc. |
| errorcause | integer | not null | This is an ID of a error or warning message. |
| errorparam | nvarchar(255) | not null | These are the parameters used with ErrorCause to create the error/warning message. |
| creationtime | integer | not null | Creation time of the application. |
| activationtime | integer | not null | Activation time of the application. |
| completiontime | integer | not null | Completion time of the application. |
| administrator | nvarchar(129) | not null | States who ordered the job to a target, typically a userId or ordered by System or Catalog. |
| applicationid | nvarchar(129) | not null | This is the application id. |
| comment | nvarchar(255) | not null | This is the comment of the target job. |
| task | byte(4) | not null | This is the task to be performed by the target job, typically INSTALL, UNINSTALL, DELIVER etc. |
| percentsent | integer | not null | Stores progress fo this target job. |
| retentiontime | integer | not null | This is the retention time of this application. |
| renewstatus | integer | not null | In case this application has been renewed, this is a the status of that renewal. |
| userparams | nvarchar(255) | not null | This is the same as was used in the activity, in case the activity is removed and we still want to do a renewal. |
| uuid | nvarchar(32) | not null | This is the host uuid from the target, this is used to handle RAC: |
| uninstallstate | integer | not null | Stores the uninstall state fo the application, typically not uninstalled, uninstalling, uninstalled. |
| permmask | integer | not null | Operations/Functions allowed on the job in its current state, it is not object level security related. |
| activity | byte(16) | with null | This is the activity to which this application is linked, FK to usd_activity. |
| applicationgroup | byte(16) | with null | This column has changed, it used to point to a collection
of application groups (c_jcappgr) but that was not used yet,
it was designed so that multiple types of application groups
could be defined. It has now changed to be a pointer to one
single applicationgroups.
The alternative would have been to create a linktable for a many-many relation, even though it was only used for a one-many relation. When e.g. a user-centric applicationgroup is fully implemented this linktable will have to be created. |
| target | byte(16) | with null | This is the target of the application, FK to usd_target |
| actproc | byte(16) | with null | This is the procedure used in this application, FK to usd_actproc |
| starttime | integer | not null | Start time |
| uuid2 | nvarchar(32) | not null | UUID 2 |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| objectid | usd_v_product_procedures | uninstallstate userparams object_uuid completiontime task creationtime state activationtime errorcause errorparam |
| objectid | usd_v_nr_of_waiting_applics usd_v_nr_of_renew_wait_applics usd_v_nr_of_renew_ok_applics usd_v_nr_of_renew_active_applics usd_v_nr_of_ok_applics usd_v_nr_of_active_applics usd_applic |
racassoc |
| objectid | usd_applic | nextrenew |
| objectid | usd_applic | firstrenew |
| objectid | usd_applic | installation |
| objectid | usd_link_act_inst | installation |