Top
Systemwalker Service Quality Coordinator Reference Guide
Systemwalker

1.7.5 sqcSetPDBManage (PDB Retention Period Modification Command)

Privileges required for execution

[Windows]

The privileges of a user belonging to the "Administrators" group are required to execute this command.

[UNIX]

The privileges of a system administrator (superuser) are required to execute this command.

Execution environment

This command can be executed on a Manager or Enterprise Manager.

Note

The Systemwalker Service Quality Coordinator DCM service/dcmd process must already be started when this command is executed. Refer to "Chapter 2 Starting and Stopping Resident Processes" for information on how to check it.

Format

[Windows]

Note

Please move current directory to <Installation directory>\bin, and then execute this command.

sqcSetPDBManage.bat -M <retention period> | -m <retention period> | -h <retention period> | -d <retention period> | -s

[UNIX]

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

Function

In Manager or Enterprise Manager environment, this command changes the retention period parameters for the summary, Drilled-Down and report data being managed.

Note

Do not execute multiple sqcSetPDBManage command simultaneously.


Options

There is no upper limit for the values specified for the -m, -h and -d options.

-M <retention period>

Specify the retention period for summary data using an integer between 1 and 31. (Unit: days)


-m <retention period>

Specify the retention period for resource data (10 minutes) using a positive, non-zero integer. (Unit: days)


-h <retention period>

Specify the retention period for resource data (one hour) using a positive, non-zero integer. (Unit: weeks)


-d <retention period>

Specify the retention period for resource data (one day) using a positive, non-zero integer. (Unit: months)


-s

Displays the current value for the retention period.

Note

If the retention period is increased, the amount of disk space used will increase proportionately. Refer to "Estimating the size of the performance database/archive file" in the Installation Guide for information about how to estimate the volume of data when the retention period is changed.

Return values

0: Normal termination

1: Parameter error

10: Other error


Example

To change the resource data (10 minutes) retention period to 10 days:

[Windows]

C:\>cd C:\Program Files\SystemwalkerSQC\bin

C:\Program Files\SystemwalkerSQC\bin\sqcSetPDBManage.bat -m 10

[UNIX]

/opt/FJSVssqc/bin/sqcSetPDBManage.sh -m 10


Execution results/Output format

Normal termination (changing the retention period; option specification: -M/-m/-h/-d)

The following normal completion message will be sent to standard output:

(Success)sqcSetPDBManage succeeded.


Normal termination (displaying the current retention period; option specification: -s)

Information about the current retention period (data type, retention period) will be sent to standard output:

DataType, Maintenance period

-------, ----------------

Monitor, 3 days

DrillDown, 7 days

Reprot(1Hour), 6 weeks

Reprot(1Day), 13 months

(Success)sqcSetPDBManage succeeded.


Point

Data types displayed are as follows

  • Monitor: Summary data

  • Drill Down: Resource data (10 minutes)

  • Report: Resource data (one hour) and Resource data (one day)

Abnormal termination

The following error message will be sent to standard error output:

(Error) : error number, message


Error message output format (CSV)

Error number

Message

Content

000

sqcSetPDBManage succeeded.

Normal

010

Parameter error. (Error detail code)

Parameter specification error

100

System error. (Error detail code)

Other error

Point

The new definitions will be used as the retention period information for the PDB maintenance processing (executed at 2:00 AM every day). In this processing, any data that has exceeded the retention period is deleted, so complete all change operations before this processing starts.