Verify which users are logged into maestro* with Actian PSQL Monitor v11.xx

objective

Using PSQL Monitor to ensure there are no more users logged into maestro*.

 

prerequisites

• Working from the maestro* database server;
• Have Windows Administrator privileges.

 

steps

Validate There Are No Active maestro* Connections

1. Click on the Windows Start menu icon.
2. Open All Programs > Pervasive PSQL 11 > Utilities.
3. Launch PSQL Monitor.
4. Open the MicroKernel menu and select the Active Sessions... option. You will then be able to see if there are still active connections and who is still logged in.

You can force the disconnection of the selected user by clicking on Delete Current session or of all users by clicking on Delete All sessions. If you force a disconnection, the disconnected user will have a multitude of error messages and will have to close maestro* completely before being able to reuse it.

 

If the SYSTEM or SRDE:MASTER user is displayed, a service (in other words, a user) is connected.

If you are using one of the maestro* services like Web Service, mobility, duplication or BI Service, you must stop these services to disconnect them (see next section). Peruse the next section of this document for the details.

 

Stop a maestro* service

It is necessary to stop the following services before starting the maestro*update process.

1. Click the Windows Start icon on the toolbar.
2. The Services window is displayed. In the Execute section, enter services.msc and press the Enter key. The Services window is displayed.
   • If you are using the BI Service: Drag the mouse pointer over maestro*BIJobExecutorService and, using the right mouse button, stop the service.
   • If you are using the Web Service: Drag the mouse pointer over Maestro Web/Winsock service and, using the right mouse button, stop the service.

 

Last modification: September 19, 2024