If the cause of an error that occurs while building the environment or during operations is unclear, data must be collected for initial investigation.
This subsection describes how to collect information for the initial check of the database server.
Use FJQSS (Information Collection Tool) to collect data for initial investigation. However, if you are asked by a Fujitsu technical support representative to collect investigation information, use the pgx_fjqssinf command to collect the information.
Use the pgx_fjqssinf command to collect data for initial investigation.
See
Refer to the FJQSS manual for information on how to use FJQSS.
Refer to "pgx_fjqssinf" in the Reference for informations about the pgx_fjqssinf command.
To collect information about the arbitration server in a database multiplexing, refer to "Collecting Failure Investigation Data" in the Installation and Setup Guide for Server Assistant.
Setting environment variables
When using FJQSS to collect data for initial investigation, you must set the following environment variables:
Environment variables required for using Fujitsu Enterprise Postgres
Refer to "Configure the environment variables" in "4.3.2.2 Creating an Instance".
PGDATA
Set the data storage destination.
PGDATABASE
Set the database name from which you want to collect data for initial investigation.
PGPORT
Set the instance port number. This does not need to be set if the default port number (27500) has not been changed.
PGUSER
Set the database superuser.
Set the database superuser so that client authentication is possible.
FJQSS establishes a TCP/IP connection with the template1 database and collects data from the database.
FSEP_HOME
Set the Fujitsu Enterprise Postgres installation directory.
If you are using database multiplexing, you must set the following environment variables:
MCCONTROLDIR
Specify the Mirroring Controller management directory.
For details about the Mirroring Controller management directory, refer to "Mirroring Controller Resources" in the Cluster Operation Guide (Database Multiplexing).
