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 appendix describes how to collect data for initial investigation.
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.
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" under the procedure for creating an instance in "Using the initdb Command" in the Installation and Setup Guide for Server for information on the values to be set in the environment variables.
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.
See
Refer to "Collecting Failure Investigation Data" in the Cluster Operation Guide (Database Multiplexing) for information on how to collect failure investigation data when performing database multiplexing.
