Top
Systemwalker Service Quality Coordinator Installation Guide
Systemwalker

6.6.2 Changing the PDB Retention Time

This section explains the procedure used to change the period of time that summary/resource data is stored in the PDB.

6.6.2.1 Changing the retention period for summary data

This section explains the procedure used to change the retention period for monitor data. To change the summary data retention period, a number of tasks must be performed on both the Agent and Manager environments.

Point

Note that if the summary data retention period is extended, there will be a proportional increase in the time needed to display information in the summary window.

Refer to "2.1.1.2 Estimating the size of the performance database/archive file" when determining the retention period.


Required privileges

Windows version

The user must belong to the Administrators group.

UNIX version

The user must be a system administrator (superuser).


Procedure

Tasks to perform on the Agent

  1. Stop the Agent service/daemon and confirm that it has stopped
    Stop the service or daemon by referring to "A.8 How to Start and Stop Resident Processes". Also check that the resident processes have stopped correctly.


  2. Edit the definition file

    Storage location

    The definition file is in the ini format.

    Windows version

    <Variable file storage directory >\control\template.dat

    UNIX version

    /etc/opt/FJSVssqc/template.dat


    Change the following definition in the [TIS] section:

    Before adjustment:

    #################################

    [TIS]

    RETENTION=3 <- Edit here

    :

    #################################

    The specified value indicates the retention period in days (default = 3).

    Specify the summary data retention period using an integer between 1 and 31.


  3. Execute the Policy Application Command (sqcSetPolicy)

    Windows

    <installation directory>\bin\sqcSetPolicy.exe [-h <host name>] [-p <IP address>]

    UNIX

    /opt/FJSVssqc/bin/sqcSetPolicy.sh [-h <host name>] [-p <IP address>]

    Refer to "sqcSetPolicy (Policy Application Command)" in the Reference Guide for details on sqcSetPolicy.


  4. Start the Agent service or daemon and confirm that it operates normally

    Start the service or daemon by referring to "A.8 How to Start and Stop Resident Processes". Also check that the resident processes have started correctly.


Tasks to perform on the Manager

  1. Execute sqcSetPDBManage
    Execute sqcSetPDBManage (PDB Retention Period Modification Command).

    Refer to "sqcSetPDBManage (PDB Retention Period Modification Command)" in the Reference Guide for details.


    Format

    Windows

    <Installation directory >\bin\sqcSetPDBManage.bat [-M <retention period>]|-s

    UNIX

    /opt/FJSVssqc/bin/sqcSetPDBManage.sh| -s


    Options

    -M <retention period>

    Set the summary data retention period as an integer between 1 and 31. (Unit: days)

    -s

    Displays the current retention period.

Note

Set the summary data retention period for all Agents. If different retention periods are specified for different Agents, the system may malfunction.


6.6.2.2 Changing the retention period for resource data

This section explains the procedure used to change the retention period for resource data (10-minute data, hourly data and daily data).


The default retention period settings for performance data stored in the PDB are as follows:

Use the procedure described below when it is necessary to change the retention period.

Note

Note that if the retention period is extended, there will be a proportional increase in disk usage. Refer to "2.1.1.2 Estimating the size of the performance database/archive file" for information on how to estimate changes in the amount of data that result from changes to the retention period.


Required privileges

Windows version

The user must belong to the Administrators group.

UNIX version

The user must be a system administrator (superuser).


Execution environment

This procedure is performed on a Manager.


Procedure

Execute sqcSetPDBManage

Execute sqcSetPDBManage (PDB Retention Period Modification Command).

Refer to "sqcSetPDBManage (PDB Retention Period Modification Command)" in the Reference Guide for details.


Format

Windows

<Installation directory>\bin\sqcSetPDBManage.bat -m <retention period> | -h <retention period> | -d <retention period> | -s

UNIX

/opt/FJSVssqc/bin/sqcSetPDBManage.sh -m <retention period> | -h <retention period> | -d <retention period> | -s


Options

There is no maximum limit to the values that can be specified.

-m <retention period>

Set the retention period for Resource data (10-minute data) as an integer of 1 or more. (Unit: days)

-h <retention period>

Set the retention period for Resource data (hourly data) as an integer of 1 or more. (Unit: weeks)

-d <retention period>

Set the retention period for Resource data (daily data) as an integer of 1 or more. (Unit: months)

-s

Displays the current retention period setting.