PSQL System Analyzer (PSA)
 
PSQL System Analyzer (PSA)
Using PSA for Diagnostics
The following topics describe PSQL system analysis:
PSA Concepts
PSA GUI Visual Reference
PSA Tasks
PSA Concepts
PSQL System Analyzer (PSA) is a tool 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 where 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 the Supported Protocols configuration parameter found in Advanced Operations Guide.
The progress bar will finish for all selected tests. Here are the steps for testing network communication:
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 it verifies the following things:
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 tool 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 time stamp.
What happens to the information in the log file each time the tool 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 22). 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.
PSA GUI Visual Reference
The following dialog in PSA provides access to its functionality. Click an area of the figure to learn more about the item.
Figure 22 PSA Main Dialog
GUI Object
Description
Related Information
View loaded PSQL modules
Displays all current PSQL components and version information in a table. Also allows you to add additional components to the matrix.
Test active installation
Test the PSQL installation in three ways: network connectivity, functionality of the MicroKernel Engine, and functionality of the Relational Engine. Select the options that correspond to the tests you wish to perform.
Test network
Test the network connectivity to a machine running the database engine. The network tests display detailed information about any problems encountered during the test and provide suggestions on how to remedy the problems.
If you do not have Internet Explorer installed, this test is not available because the test uses an embedded HTML component to display results.
Test transactional engine
Tests the functionality of the MicroKernel Engine.
Test relational engine
Tests the functionality of the Relational Engine.
Log file
Allows you to specify a different log file location than the default. PSA logs detailed information on the tests it performs. You can use this log file to review tests at a later time or to forward them to PSQL Technical Support depending on the situation.
The Append to the log file option adds content to the end of the log file to provide a running history. If this option is cleared, the log file starts anew and only information from the current PSA session is captured.
PSA Tasks
General Tasks
To start PSA
View Modules Tasks
To select options for View Modules
Test Active Installation Tasks
To test your network
To test the MicroKernel (transactional) Engine
To test the Relational Engine
Log File Tasks
To specify a different location for the PSA log file
To view the log file after completing PSQL System Analyzer
General Tasks
To start PSA
1 Access PSQL System Analyzer from the operating system Start menu or Apps screen or execute psawizrd.exe from a command prompt.
For default locations of PSQL files, see Where are the PSQL files installed? in Getting Started with PSQL.
View Modules Tasks
To select options for View Modules
1 Start PSA and click Next.
2 Click View Loaded PSQL Modules.
3 Click Next.
A dialog appears similar to the following.
Figure 23 View Modules Section of PSA
If In Memory is selected, PSA searches for all PSQL components loaded in memory, regardless of whether they are located in the PATH or other specified locations.
If you want to add components to the search list, do the following:
a. Click Additional modules (if it is not already selected).
b. Enter the file name (without a drive letter or path).
c. Click Add Component .
d. If the component you added is not in the path, add the path to the searched locations.
If you want to add more paths to the search locations, do the following:
a. Click Additional locations.
b. Click Add Location .
c. Browse to the location, select it, and click OK.
d. If you also want all directories below the location to be searched, click Include subfolders.
4 Click Next.
5 View the grid that shows the components found.
If files of the same name are detected, the multiple occurrences are marked with an icon on the left side: .
If you see multiple occurrences of a component, you can adjust the list so that the occurrences sort together. To do this, click the Module column heading.
Multiple occurrences of a file does not necessarily represent a problem with your configuration. Their identification can help you troubleshoot issues with components depending on the situation. For example, if you see two PSQL components both marked with the same version, you may want to check which is loaded in memory and that the components are located where you expect.
6 Click Next.
7 Click Finish if you are finished using PSA, or click View Log File to view the log.
Test Active Installation Tasks
You can check the currently active installed server in three ways:
Test at the Network Level
Test at the MicroKernel Level
Test at the Relational Level
Test at the Network Level
To test your network
1 Start PSA and click Next.
2 On the Options dialog, click Test active installation (if it is not already selected).
3 Click Test network communication (if it is not already selected).
4 Click Next.
5 For Target machine, type the machine name or TCP/IP address of the machine you wish to test. You may also type “localhost” for the local machine. The machine can be the machine where you are currently located or a remote machine.
6 If you want to control how the tests are run, click Advanced Settings and do the following:
a. By default, PSA uses the first available protocol. You can force PSA to use one or more protocols by clicking Use Only These Protocols.
b. Select the protocol options that you want PSA to test. Note that the NetBIOS protocol is not supported on PSQL Server. The SPX protocol is not supported on PSQL Workgroup.
c. Specify the number of stress test messages to send by entering a value for test messages. The default is 75. After successfully connecting using any protocol, PSA sends stress test messages to ensure that the connectivity is functioning correctly.
d. Click OK to save the changes.
7 Click Next to start the test.
PSA runs a series of tests and displays the results.
If the test succeeds, PSA informs you that all test messages were successfully transmitted. If the test fails, PSA lists the issues along with tips on how to resolve them. The tips are also written to the PSA log file.
8 Click Next.
9 Click Finish if you are finished using PSA, or click View Log File to view the log.
Test at the MicroKernel Level
To test the MicroKernel (transactional) Engine
1 Start PSA and click Next.
2 On the Options dialog, click Test active installation (if it is not already selected).
3 Click Test transactional engine (if it is not already selected).
This test runs a series of transactional operations to simulate your client requester interacting with the database engine.
4 Click Next.
5 Provide a path name to the samples directory on the machine running the database engine. The default path should be correct if the database engine is running on the local machine. You can type a path, or browse to one if you click .
6 Select the operations you want to perform for the MicroKernel Engine (by default, all are selected):
Create Data File (write access required)
Read Data File
Update Data (write access required)
Insert Data (write access required)
7 Click Next.
PSA performs the tests and displays the results. A check mark indicates a test succeeds and an "x" indicates a test fails.
If all of the tests succeed, your client requester can communicate with the database engine.
8 Click Next.
9 Click Finish if you are finished using PSA, or click View Log File to view the log.
Test at the Relational Level
To test the Relational Engine
1 Start PSA and click Next.
2 On the Options dialog, click Test active installation (if it is not already selected).
3 Click Test relational engine (if it is not already selected).
This test runs a series of SQL operations to simulate your client requester interacting with the database engine.
4 Click Next.
5 For Machine Name, type the name or IP address of the machine where the engine data source name (DSN) resides, or browse to the machine (click ).
The name “localhost” is valid if you are testing the local machine.
6 For Engine DSN, type the name of the DSN for the data source you want to test. The default, demodata, uses the DSN for the sample database installed with the database engine.
7 Select the operations you want to perform for the Relational Engine (by default, all are selected):
Create Table
Read Data
Update Data
Insert Data
8 Click Next.
PSA performs the tests and displays the results. A check mark indicates a test succeeds and an "x" indicates a test fails.
If all of the tests succeed, your PSQL Client can communicate with the Relational Engine.
9 Click Next.
10 Click Finish if you are finished using PSA, or click View Log File to view the log.
Log File Tasks
To view the log file after completing PSQL System Analyzer
1 Click View Log File to open the PSA log file.
The file lists the tasks that PSA has completed.
To specify a different location for the PSA log file
1 Start PSA and click Next.
2 In the Log File field, enter a path to the PSA log file or browse to the desired location.
If you want a log file with information only about the current PSA session, clear the check box Append to the log file.
You can enter a different log file name and location, but these apply only for this PSA session. They revert to the default C:\ProgramData\Actian\PSQL\logs\PSA.log the next time the wizard runs.