3.3 pgx_fjqssinf

Name

pgx_fjqssinf - Collects failure investigation data.

pgx_fjqssinf.bat - Collects failure investigation data.

Synopsis

pgx_fjqssinf  -i {1|2|3} [-w directory]

pgx_fjqssinf  -i {1|2|3} -s installdir -w directory

Description

When the cause of a trouble that occurred during the construction or operation of the environment is not identified, information for the initial investigation is collected. The collected investigation information is created in the destination directory as pgx_fjqssinf_YYYYMMDD_HHMMSS/.

Options

-i {1|2|3}: Specifies the incident of the trouble that occurred. 1 is specified for for process error, 2 for process result error, and 3 for no response. This option must be specified for the database server to gather information. Specify 1 when collecting information with the arbitration server.

-s installdir: Specify the directory where you installed Fujitsu Enterprise Postgres.

-w directory: Specifies the destination directory for the collected data. The default is /tmp.
Specifies the destination directory for the collected data.

Environment (When the information is collected by a database server)

PGDATA: Specifies the data directory.

PGDATABASE: Specifies the name of the database to connect to. Any database that can be connected to may be specified.

PGPORT: Specifies the port number of the instance. This should not be specified if the default port number (27500) has not been changed.

PGUSER: Specifies the user name of the database superuser. The database superuser must be configured to allow client authentication.

MCCONTROLDIR: Specifies the Mirroring Controller management directory. This should only be specified when database multiplexing operation is set up.

Environment (When information is collected by an arbitration server)

ARBCONTROLDIR: Specifies the management directory for the Mirroring Controller arbitration process.

ARBUSER: Specifies the OS user that initialized the Mirroring Controller arbitration process.

Diagnostics

0: Normal end

Other than 0: Abnormal end

Notes

This command must be executed as a superuser (root) account.

Execute this command as a user with the "Administrator" privilege (operating system user ID that belongs to the Administrator group).

Example

Below is an example of collecting information for initial investigation in the event of a process failure.

    # pgx_fjqssinf -i 1

    > pgx_fjqssinf.bat -i 1 -s "C:\Program Files\Fujitsu\fsepv<x>server64\" -w "C:\Users\fep\fjqss"

Below is an example of collecting information for an initial investigation by an arbitration server.

    # pgx_fjqssinf -i 1