Managing Active Users

You can manage the activities of any user currently signed on to your CA Dataquery system.
datacom
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. For more information about assigning printer control, see Adding a New User.
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 users, as shown in the following example:
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.
    We recommend that you warn users by sending a message so they can terminate current processes.
  • Broadcast a message.
    1. Press <PF4> CREATE MSG.
    2. Enter a one-line message on the Create a Message panel.
    3. Press <PF2> RETURN.
    4. Mark users, with any character, to receive the current message.
    5. Press <PF5> SEND MSG.
  • Interrupt query or dialog processing during data selection.
    1. Select a user.
    2. Check that Stage is Find.
    3. 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.
  • 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.