PSA Concepts
PSQL System Analyzer (PSA) is a utility that allows you to perform the following actions:
•
View the PSQL components on your system with version information, usage status, size, and location.
•
Identify duplicate components on your system.
•
Test your network communications to verify connectivity.
•
Test connectivity to the MicroKernel Engine.
•
Test connectivity to the Relational Engine.
View Modules
This option allows you to view all PSQL components and any other files you specify. You can add additional components to the search list. Their versions, usage status, file size, and location is displayed. Duplicate files are identified so you can resolve any potential conflicts.
View modules scans a machine for PSQL components to determine which ones are loaded into memory.
Test Active Installation
This option allows tests of the network connectivity between a PSQL client and the MicroKernel Engine and Relational Engine. If errors are detected, PSA gives you detailed troubleshooting information to help you resolve the problem.
Network
The Network Communication tests verify that your client or workstation can communicate with network protocols to reach the machine on which the PSQL database engine is installed. For the TCP/IP protocols, both IPv4 and IPv6 numeric and named addresses are supported. See also Drive-based Formats in Getting Started With PSQL for additional details about IPv6.
Using Advanced Settings, you can select the protocols to test as well as the number of stress test messages to send. By default, the network test connects using any available protocol that is installed on the system and configured for use in PSQL. See Supported Protocols configuration parameter found in Advanced Operations Guide.
The progress bar will complete for all selected tests. The steps involved in testing network communication are:
1
Verify Available Protocols
2
Verify Network Client Availability
3
Qualify Target Name
4
Resolve Target Location to network address
5
Verify Server Address
6
Verify Server Connection
7
Run Stress Test
Transactional Engine
This test verifies the ability of your client to connect to the PSQL database through the MicroKernel Engine.
When you run this test, PSA attempts to perform basic database operations that are common to most MicroKernel Engine applications. If your machine passes this test, then the following is verified:
•
The MicroKernel Engine is responding
•
Your client interface components are installed correctly
•
The network communication between the client and the database engine is functioning correctly
•
MicroKernel Engine applications running on your computer should function correctly.
Relational Engine
This test verifies the ability of your client to connect to the PSQL database engine through the Relational Engine. When you run this test, PSA attempts to perform common SQL database operations. A dialog box displays during the tests to show progress.
If your machine passes this test, then the following is verified:
•
The Relational Engine relational engine is running
•
Your client interface components are installed correctly
•
The network communication between the client and the database engine is functioning correctly
•
SQL applications running on your computer should function correctly.
Frequently Asked Questions
Listed below are some frequently asked questions about PSA.
•
What is the default log file name?
•
Can I use a different log file name?
•
What is the local default location for the log file?
•
What is the remote default location for the log file?
•
What kind of information is contained in the log file?
•
What happens to the information in the log file each time the utility is run?
•
How do I run PSA?
•
When would I want to use PSA?
What is the default log file name?
The default file name for the log file is PSA.log.
Can I use a different log file name?
You can rename the file, but the name applies only for that session of PSA. PSA defaults the name to PSA.log the next time you execute PSA.
What is the local default location for the log file?
The default local location for the log file is under the application data directory in the logs folder.
For default locations of PSQL files, see Where are the PSQL files installed? in Getting Started With PSQL.
What is the remote default location for the log file?
The default location for the log file is always the directory where psawizrd.exe is located on a Windows machine.
What kind of information is contained in the log file?
The log file records any process performed by PSA and includes the associated timestamp.
What happens to the information in the log file each time the utility is run?
New information is appended to the log file each time PSA runs if the option Append to log file is selected (see Figure 26). If the option is cleared, the log file contains only information for that particular execution of PSA.
How do I run PSA?
See To start PSA.
When would I want to use PSA?
The following lists the most common situations where you would want to use PSA:
•
You are encountering network errors and wish to test your client’s connectivity to a machine running a PSQL database engine.
•
Your application is not functioning correctly and you wish to test connectivity to the database engine.
•
You wish to view the PSQL components on the system, loaded in memory, or both.