Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

 

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.

Note

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:

Note
  1. 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

  2. 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:

  1. From configuration mode, access the statement that runs the cleanup mechanism.
  2. Configure the time interval (daily or weekly or monthly) for running the cleanup mechanism.

    Use the options described in Table 1 to configure the cleanup interval.

    For example,

    You can clean up the SRC VTA database tables in the following time interval:

    Table 1: 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 2:

    Table 2: 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

  3. (Optional) Configures the maximum age for the records (in number of months) in the VTA_SESSIONS table. The value range is 1 through 24.
  4. (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.
  5. 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.
  6. (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.
  7. (Optional) Verify your configuration.