Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# stat_gen_daily

The stat_gen_daily table contains general metrics information on procedures, cases, users, queues and machine at the daily resolution level.

## Structure

The stat_gen_daily table has the following structure:

     TABLE stat_gen_daily(    seq_idINTEGERNOT NULL,  cap_dateTIMESTAMP,  proc_sumINTEGER,  proc_ver_sumINTEGER,  proc_idINTEGER,  proc_nameVARCHAR(32),  proc_most_verINTEGER,  max_casenumNUMERIC(20),  max_reqidbigint,  case_information_sizeNUMERIC(20),  case_data_sizeNUMERIC(20),  audit_trail_sizeNUMERIC(20),  user_sumINTEGER,  group_sumINTEGER,  queues_sumINTEGER,  max_log_countINTEGER,  avg_log_countINTEGER,  max_outstanding_countINTEGER,  min_outstanding_countINTEGER,  avg_outstanding_countINTEGER,  max_dbtimingINTEGER,  min_dbtimingINTEGER,  avg_dbtimingINTEGER,  ci_stats_updateTIMESTAMP,  at_stats_updateTIMESTAMP,  cd_stats_updateTIMESTAMP)

Column | Description
`seq_id` | Generated sequence number to maintain uniqueness. This is also the Primary Key.
`cap_date` | Date and time when these details were captured/recorded.
`proc_sum` | Total number of procedures.
`proc_ver_sum` | Total number of versions of all procedures.
`proc_id` | Id of the procedure with most versions.
`proc_name` | Name of the procedure with most versions.
`proc_most_ver` | Number of versions on that procedure with most versions.
`max_casenum` | Max CASENUM in the system.
`max_reqid` | Maximum REQID in the system.
`case_information_size` | Number of rows in Case Information database table
`case_data_size` | Number of rows in Case Data database table.
`audit_trail_size` | Number of rows in Audit Trail database table.
`user_sum` | Number of Users in the system at the start of the day.
`group_sum` | Number of Groups in the system at the start of the day.
`queues_sum` | Number of Queues in the system at the start of the day.
`max_log_count` | Maximum active logins in the last 24 hours.
`avg_log_count` | Average active logins in the last 24 hours.
`max_outstanding_count` | Maximum of Outstanding_Addr count in the last 24 hours.
`min_outstanding_count` | Minimum of Outstanding_Addr count in the last 24 hours.
`avg_outstanding_count` | Average of Outstanding_Addr count in the last 24 hours.
`max_dbtiming` | Maximum database connection time in the last 24 hours.
`min_dbtiming` | Minimum database connection time in the last 24 hours.
`avg_dbtiming` | Average database connection time in the last 24 hours.
`ci_stats_update` | Last status update on Case Information table.
`at_stats_update` | Last status update on Audit Trail table.
`cd_stats_update` | Last status update on Case Data table.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_stat_day_seqid` | `seq_id`

## Foreign Keys

None

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed
`idx_stat_gen_d` | `cap_date`

## Table Activity

The stat_gen_daily table contains one record for every minute the server is running and recording data.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | Rows are added every day.
updated | Never
deleted | After the configured retention period defined by process attributes (value is in days). METRICS_DATA_DAILY_KEEP

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine