Managing Active Users

DQ Internal Security › Accessing User Information › Managing Active Users

Managing Active Users

Summary

You can manage the activities of any user currently signed on to your CA Dataquery system. You are able to:

Force a user off.
Send a message to one or more users.
Cancel any query processing during a FIND.
Cancel printing for any user.
(Anyone with PRINTER CONTROL authorization can start, stop, restart, and cancel spooled print jobs using the PRINTER CONTROL option on the Administrative Menu. See Adding a New User to assign printer control.)

Purpose

This section describes how to operate the ACTIVE command and tells how to perform these activities.

Choose one of the following to display the active users:

Select the USERS option from the Administrative Menu, then press <PF5> ACTIVE USERS from the Directory of DATAQUERY USERS panel.
Type ACTIVE on the command line and press Enter.

CA Dataquery displays the Directory of Active Users panel, allowing you to view the active CA Dataquery users, an example of which follows:

Directory of Active Users (DQAJ0)

 =>
 Place any character next to the name and press the appropriate PF key
 --------------------------------------------------------------------------DQAJ0
 DATAQUERY:  DIRECTORY OF ACTIVE USERS    START WITH: => _______________________
 -------------------------------------------------------------------------------
 SEL |       USER NAME                  | TERMID | STAGE | TIME ON  |  ELAPSED
 -------------------------------------------------------------------------------
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |
  _  |                                  |        |       |          |

Panel Description

Each column on the Directory of Active Users panel is explained in the following list:

SEL

Type any character on the blank to select a user.

USER NAME

Alphabetical listing of all users currently signed on.

TERMID

Terminal ID for the user.

STAGE

Function the user is performing.

ADMIN: The user is performing an ADMINISTRATION function.
DISPL: The user is using a display function (PF keys or commands).
EDIT: The user is on the EDIT panel.
EXEC: The user is executing a query.
FIND: The FIND function is running for an executing DQL query.
GRAPH: The GRAPH function is operating.
GUIDE: The GUIDE function is operating.
HELP: The HELP function is operating.
LIST: A LIST function is operating.
MENU: The user is on the MAIN Menu.
PDB: The user is using the Personal Database Facility.
PERR: An error is being displayed.
SELECT: An executing SQL query is processing the SELECT clause.
SQL: The user is using SQL Mode.

TIME ON

Time this user signed on in hours, minutes, and seconds.

ELAPSED

Amount of time this user has been signed on to CA Dataquery.

Activities

Refer to the following list for instructions on managing active users:

Terminate an active user.

Enter a character next to one or more users' names and press <PF3> FORCE OFF.

Note: We recommend that you warn users by sending a message so they can terminate current processes.

Broadcast a message.

Press <PF4> CREATE MSG.
Enter a one-line message on the Create a Message panel.
Press <PF2> RETURN.
Mark users, with any character, to receive the current message.
Press <PF5> SEND MSG.

Interrupt query or dialog processing during data selection.

Select a user.
Check that Stage is Find.
Press <PF6> CANCEL FIND.

SQL Mode

The CANCEL FIND function may not be used for an SQL query in the SELECT stage. If long running SQL queries appear to be a problem at your site, contact your Database Administrator for assistance with canceling the long running SQL query and/or reducing the value of the REQTHD parameter of the CA Datacom CICS Services DBCVTPR macro.

The Database Administrator can cancel a long running SQL query in either of two ways:

Use the COMM function of DBUTLTY to cancel the query's CA Datacom/DB request. The Database Administrator can temporarily reduce the size of the REQTHD parameter of the CA Datacom CICS Services DBCVTPR macro by using the DBOC GENOPTS function. For more information, see the CA Datacom CICS Services documentation.
Note: For more information, see the CA Datacom/DB DBUTLTY Reference Guide.
Limit the future occurrence of any long running queries (both SQL and DQL) by permanently reducing the size of the REQTHD parameter. This parameter limits the number of CA Datacom/DB requests that any logical unit of work can make. Any tasks exceeding this limitation will abend. For more information, see the CA Datacom CICS Services documentation.