APM application response data: Hourly Summarization
| Column Name | Column Datatype | Column Null Option | Column Comment |
| trans_id | integer | with null | Unique transaction id |
| app_id | integer | with null | Application ID |
| op_id | integer | with null | Operation ID |
| host_id | integer | with null | Host ID |
| client_id | integer | with null | Client ID |
| user_id | integer | with null | User ID |
| server_id | integer | with null | Server ID |
| start_datetime | date | with null | Date/Time of transaction start |
| gmt_datetime | date | with null | Date/Time of transaction start (GMT) |
| local_time | integer | with null | Local time |
| local_date | integer | with null | Local date |
| gmt_time | integer | with null | GMT time |
| gmt_date | integer | with null | GMT date |
| duration | float | with null | Total transaction time |
| local_dur | float | with null | Fraction of total transaction spent locally |
| wire_dur | float | with null | Fraction of total transaction spent on the network |
| server_dur | float | with null | Fraction of total transaction spent on the server |
| num_complete | integer | with null | Number of completed transactions |
| num_cancelled | integer | with null | Number of cancelled transactions |
| num_exception | integer | with null | Number of transactions with exceptions |
| delta_threshold | float | with null | Percentage of threshold |
| cpu_util | integer | with null | CPU utilization at the time of transaction |
| mem_util | integer | with null | Memory utilization at the time of transaction |
| net_global | integer | with null | Total network traffic for all applications during transactions |
| net_total | integer | with null | Total network traffic for this transaction |
| packet_loss | integer | with null | Reserved |
| source_id | smallint | with null | Subnet ID |
| old_data | integer1 | with null | Reserved |
| trans_cached | integer1 | with null | Used by Web Application Performance Agent to indicate a page was rendered from cache |
| trans_wellness | integer1 | with null | Indicates whether transaction caused an exception |
| exception_threshold | integer | with null | Threshold setting for transaction |
| trans_detail | varchar(255) | with null | Reserved |
| trans_title | varchar(255) | with null | Reserved |
| old_hourly | integer1 | with null | Indicates hourly consolidation was performed on this record |
| old_daily | integer1 | with null | Indicates daily consolidation was performed on this record |
Product Name: Unicenter Application Performance Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| e2e_apm_webresponsedetail_hourv e2e_apm_cancellationdetail_hourv e2e_apm_appopsummary_hourv e2e_apm_nonexceptdetail3_hourv e2e_apm_exceptiondetail3_hourv e2e_apm_exceptiondetail2_hourv |