Top
Systemwalker Service Quality Coordinator Reference Guide
Systemwalker

1.7.3 sqcPDBerase (Data Deletion 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 Managers and Enterprise Managers.


Before executing this procedure

If the Enterprise Manager/Manager resident processes are running, then stop the service/daemon (refer to "Chapter 2 Starting and Stopping Resident Processes" for details). Additionally, make sure that the resident processes have stopped correctly.


Syntax

[Windows]

<Installation directory>\bin\sqcPDBerase.exe system [-r record_id]

[UNIX]

/opt/FJSVssqc/bin/sqcPDBerase.sh system [-r record_id]

Function

This command deletes the data in a PDB that relates to a specified system.

When this command is executed, the user will be prompted to confirm the deletion. Enter either "Y" (Yes) to delete the applicable data or "N" (No) to cancel.

Note

Do not execute multiple sqcPDBerase (Data deletion command) simultaneously.

Operand

system

Specifies the name of the system from which data is to be deleted.

This operand is case sensitive.


Option

-r record_id

Specify the ID of the record to be deleted. Refer to "Chapter 4 Data Formats" for details on record IDs.


Return values

0: Normal termination

1: Abnormal termination

Usage example

Example of execution when -r option is not specified:

[Windows]

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

C:\Program Files\SystemwalkerSQC\bin>sqcPDBerase TEST1

Do you erase data of system_name"TEST1"?(Y/N)

y

sqcPDBerase succeeded

[UNIX]

# cd /opt/FJSVssqc/bin/

# ./sqcPDBerase.sh TEST1

Do you erase data of system_name"TEST1"?(Y/N)

y

sqcPDBerase succeeded.


Example of execution when -r option is specified:

[Windows]

C:\Program Files\SystemwalkerSQC\bin>sqPDBerase TEST1 -r UDATA_1

##############The condtions to erase ###################

Record ID : UDATA_1

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

Do you erase data of system_name "TEST1"?(Y/N)

y

sqcPDBerase succeeded.

[UNIX]

# /opt/FJSVssqc/bin/sqcPDBerase TEST1 -r UDATA_1

##############The condtions to erase ###################

Record ID : UDATA_1

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

Do you erase data of system_name "TEST1"?(Y/N)

y

sqcPDBerase succeeded.


Execution results/Output format

Normal termination

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

sqcPDBerase succeded.

Abnormal termination

An error message will be sent to standard error output:

Parameter Error

Configuration Information of "TEST1" does not exist.

The specified system name might be incorrect.