Cleaning Up the Sessions Records and SessionBalanceChanges Records from the SRC VTA Database (SRC CLI)
To remove the VTA sessions records and SessionBalanceChanges records automatically from the SRC VTA database, use the edit shared vta group name database cleanup configuration statement with the interval, host-ip, and vta-sessions-max-age or session-balance-changes-max-age options.
The automatic cleanup mechanism periodically deletes the numerous stale database records from the SRC VTA database and keeps only the user specified time–line of data in the SRC VTA database. Hence, reduces the database table size, requires less storage and eliminates the performance degradation with the SRC VTA database access.
The automatic cleanup mechanism supports on Oracle and MySql database servers.
The automatic cleanup mechanism removes the following:
Stopped session records that are older than the value configured using the vta-sessions-max-age option.
Unstopped orphan session records that did not receive an interim update for the entire period of the value configured using the vta-sessions-max-age option.
SessionBalanceChange records that are older than the value configured using the session-balance-changes-max-age option.
The automatic cleanup mechanism does not remove the records from the balance change table.
Use the following statements to clean up the VTA sessions records and SessionBalanceChanges records automatically:
When you execute the edit shared vta group name database cleanup configuration statement, ensure that the VTA database contains only the VTA sessions records and SessionBalanceChanges records not older than the value planned to be set for vta-sessions-max-age vta-sessions-max-age and session-balance-changes-max-age session-balance-changes-max-age options. Else it is recommended to remove the old records manually using third party vendor support or cleanup scripts or using the following commands:
request vta delete balance-changes
request vta delete sessions
You must configure an appropriate value for vta-sessions-max-age vta-sessions-max-age and session-balance-changes-max-age session-balance-changes-max-age, because you cannot recover any deleted records and that may have an impact on billing or revenue.
To automatically clean up the VTA sessions records and SessionBalanceChanges records from the SRC VTA database:
- From configuration mode, access the statement that runs
the cleanup mechanism. [edit]user@host# edit shared vta group vta1 database cleanup
- Configure the time interval (daily or weekly or monthly)
for running the cleanup mechanism.
Use the options described in Table 47 to configure the cleanup interval.
For example,
[edit shared vta group vta1 database cleanup]user@host# set interval daily hour hour minute minuteYou can clean up the SRC VTA database tables in the following time interval:
Table 47: Options Used to Configure the Cleanup Interval
Option
Description
daily
(Optional) Cleans up the data every day for the specified hour and minute of the day.
weekly
(Optional) Cleans up the data weekly for the specified day of week, hour, and minute of the day.
monthly
(Optional) Cleans up the data monthly for the specified day of month, hour, and minute of the day.
To specify the day of week, month, day of month, hour, and minute, use the day-of-week, month, day-of-month, hour, and minute options.
The values allowed for these options are described in Table 48:
Table 48: Values Allowed for the Options
Options
Values
day-of-week
1-7 or SUN-SAT
month
1-12
day-of-month
1-31
hour
0-23
minute
0-59
- (Optional) Configures the maximum age for the records
(in number of months) in the VTA_SESSIONS table. The value range is
1 through 24.[edit shared vta group vta1 database cleanup]user@host# set vta-sessions-max-age vta-sessions-max-age
- (Optional) Configures the maximum age for the records
(in number of months) in the in SESSION_BALANCE_CHANGE table. The
value range is 1 through 24.[edit shared vta group vta1 database cleanup]user@host# set session-balance-changes-max-agesession-balance-changes-max-age
- Specifies the VTA host name or the IP address of the SRC
VTA node. In a cluster of SRC VTA nodes, only one SRC VTA performs
the database cleanup. If the host-ip value is changed to
an IP address other than the current VTA node’s IP address,
then the scheduler is cancelled in the current VTA node.[edit shared vta group vta1 database cleanup]user@host# set host-ip host-ip
- (Optional) Defines the maximum time for which the cleanup
task can take. The cleanup task suspends when it reaches the time
limit value. The value range is 30 through 900 minutes. The default
value is 60 minutes. [edit shared vta group vta1 database cleanup]user@host# set time-duration time-duration
- (Optional) Verify your configuration.
user@host# show host-ip 10.212.10.20; interval { daily { hour 12; minute 30; } } session-balance-changes-max-age 2; time-duration 60; vta-sessions-max-age 3;