Consultor Eletrônico



Kbase P19608: How to determine number of users connected to AS/400
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   3/18/2003
Status: Unverified

FACT(s) (Environment):

IBM AS/400 (RISC)

FACT(s) (Environment):

Progress/400 DataServer

SYMPTOM(s):

How to determine number of users connected to AS/400

FIX:

There are several methods of doing this, but the easiest is to start a broker for the schema holder and then count the user entries in the _Connect virtual system table. In this case a broker must be started because the VST will not be updated with a -RO connection.

Other possible alternatives using AS/400 tools are:

1. Use PROCALL to call 4GL programs from an RPG prog that has counted the number of users.
2. Use QCMD to run RPG progs to count the proserver jobs and output to text or to DB table.
3. Use stored procedures to call RPG progs (can pass parameters back to 4GL).
4. Use a data queue to continually monitor user connections.