Default Value: 0
Valid Values: 0, 1, 2
Changes Take Effect: Immediately
Dynamically specifies the content of the gsys_partition field in IDB tables that contain this field.
- 0 - For all interactions, the gsys_partition field contains the date, in YYYYMMDD format, from the created_ts field.
- 1 - For all interactions, the gsys_partition field contains the UTC from the created_ts field.
- 2 - For multimedia interactions:
- In the G_IR, G_IR_HISTORY, G_CALL, and G_CALL_HISTORY tables, the gsys_partition field contains the UTC from the attr_itx_submitted_at attribute in the Interaction Server EventInteractionSubmitted event.
- In the G_AGENT_STATE_RC, G_CALL_STAT, and GM_L_USERDATA tables, the gsys_partition field contains the timestamp of interaction termination.
- In all other tables, the gsys_partition field contains the UTC from the created_ts field.
Configuring a Partitioned Oracle IDB
In Oracle environments with large amounts of data to maintain, you can choose to create a partitioned Oracle IDB, which you can then purge efficiently by truncating entire partitions using the purgePartitions811 stored procedure. During this purge, all records in the purged partitions—both terminated and non-terminated—are truncated unconditionally.
- If you need to purge only non-terminated records, use the GSYSPurge80/gsysPurge81 purge procedure.
- This partitioning and purge functionality is supported only for Oracle 11g and higher.
- Genesys strongly recommends that you do not use this purge mechanism for long-lived data types, such as multimedia. When used with long-lived data types, you might encounter situations in which some of the data for a still-active interaction is purged.
The procedure for deploying the purge-by-truncating-partitions functionality is outlined below.
- Start with a new Oracle database. There is no migration from a non-partitioned to a partitioned IDB.
- Run the SQL scripts to create your partitioned IDB, using the standard procedure given in Deploying IDB. However, the scripts used to create a partitioned IDB differ from those used for nonpartitioned IDBs, so be sure to see “Creating Your Database” (below) for a list of the correct scripts.
Creating Your Database
To create a partitioned Oracle IDB, follow the standard instructions for Deploying IDB, but run the following scripts rather than the scripts used for a nonpartitioned IDB. These two initialization scripts create a new partitioned IDB:
The following initialization script sets up the stored procedure used to purge the partitioned Oracle IDB:
As noted above, there is no migration path from a nonpartitioned to a partitioned database.
The number of partitions is fourteen, with each partition equivalent to one day. Data is written into the partitions in sequence, starting with Partition 1 on Day 1, Partition 2 on Day 2 and so on, circling back to Partition 1 on Day 15.
As with all purge methods, only operational tables are purged. Special tables used for internal data storage and retrieval are neither partitioned nor purged.
The tables that are available for partitioning include the gsys_partition field, which must be configured to contain the UTC value taken from the created_ts field. This parameter is set using the partition-type configuration option.
Each partitioned table also includes the virtual GSYS_SHORT_DAY column, based on value of the gsys_partition field.
You perform the purge by executing the purgePartitions811 stored procedure, which truncates all partitions except for [the number you specify in the days-to-keep parameter of the SQL statement] + [an additional safe-guard or tomorrow day].
Instructions for how to run the purgePartitions811 procedure, how to schedule it, and all other operational considerations are documented in Purging by Truncating Partitions.
The following tables are partitioned by the CoreSchemaPart_ora.sql script: