Administrating CA Dataquery

This section provides information about and procedures for performing CA Datacom/DB systems tasks.
datacom151
This section provides information about and procedures for performing
CA Datacom®/DB
systems tasks, including:
  • Establishing the operating environment
  • Creating the system databases and areas
  • Maintaining the system databases and areas
  • Customizing the
    CA Datacom®
    environment
  • Creating databases
  • Maintaining databases
  • Writing and interfacing exit programs
  • Monitoring system performance
  • Tuning system performance
  • Diagnosing and resolving system problems
This section is intended for
CA Dataquery™ for CA Datacom®
Administrators, systems programmers, and Database Administrators who are responsible for one or more of the following:
  • Installing
    CA Dataquery™ for CA Datacom®
    system software
  • Supporting
    CA Dataquery™ for CA Datacom®
    system software
  • Administering the operations of the
    CA Dataquery™ for CA Datacom®
    system
  • Maintaining data integrity
  • Ensuring data accessibility
  • Maintaining system performance
CA Dataquery™ for CA Datacom®
Administrator Role
To effectively administer the
CA Dataquery™ for CA Datacom®
system, you must have the following qualifications:
  • You must have a thorough knowledge of
    CA Datacom®/DB
    and at least a general knowledge of the other CA products that execute with
    CA Dataquery™ for CA Datacom®
    . You must be able to determine if problems that can arise are a result of
    CA Dataquery™ for CA Datacom®
    or
    CA Dataquery™ for CA Datacom®
    's interaction with one of these other products.
  • You must have a general knowledge of the operating system environment. You should know the CICS environment when
    CA Dataquery™ for CA Datacom®
    online operates under CICS.
  • You must have a general knowledge of
    CA Dataquery™ for CA Datacom®
    . Depending on the environment, you may either be actively involved in creating queries or may use
    CA Dataquery™ for CA Datacom®
    only when there are problems to be solved. You must understand
    CA Dataquery™ for CA Datacom®
    well enough to know how
    CA Dataquery™ for CA Datacom®
    impacts the operation of the
    CA Datacom®/DB
    system and how to optimize
    CA Dataquery™ for CA Datacom®
    operation and the operation of
    CA Datacom®/DB
    when
    CA Dataquery™ for CA Datacom®
    is being used.
    It is important that you know that:
    • Users can update databases if authorized.
    • A data authorized user can read any database.
    • A user cannot log on to more than one terminal with the same user ID and password.
Tasks
CA Dataquery™ for CA Datacom®
Administrators handle the day-to-day administration of
CA Dataquery™ for CA Datacom®
. Following are tasks for which a
CA Dataquery™ for CA Datacom®
Administrator can be responsible:
  • Modification and tailoring following
    CA Dataquery™ for CA Datacom®
    installation.
    • User Requirements Tables. See Defining the
      CA Dataquery™ for CA Datacom®
      User Requirements Tables.
    • Creating user signons/passwords and setting up authorizations.
    • DQSYSTBL (assemble
      CA Dataquery™ for CA Datacom®
      system table macro (DQOPTLST) and link edit using name DQSYSTBL).
    • Other
      CA Dataquery™ for CA Datacom®
      tasks contained in members that are available on the
      CA Datacom®
      page on Broadcom Support. See the
      CA Datacom®
      Release Notes
    • Programming user exits.
    • Implementing
      CA Dataquery™ for CA Datacom®
      security.
  • Maintenance after
    CA Dataquery™ for CA Datacom®
    is operational.
    • Supporting users and diagnosing problems.
    • Managing query and JCL libraries.
    • Performing backups and restores of
      CA Dataquery™ for CA Datacom®
      tables.
    • Using batch maintenance utilities.
    • Upgrading supporting products and implementing required changes following upgrades.
    • Modifying the batch
      CA Dataquery™ for CA Datacom®
      systems options table to meet site requirements.
    • Executing deferred batch queries.
    • Maintaining
      CA Dataquery™ for CA Datacom®
      system tables.
    • Loading and backing up CA-supplied languages.
  • Monitoring and tuning
    CA Dataquery™ for CA Datacom®
    .
Responsibilities
As the
CA Dataquery™ for CA Datacom®
Administrator, you are responsible for ensuring that all the system tasks required for optimum
CA Dataquery™ for CA Datacom®
performance are performed. During use of
CA Dataquery™ for CA Datacom®
, you ensure that the system needs of the users are met and that the system maintenance includes the
CA Dataquery™ for CA Datacom®
needs. You tune
CA Dataquery™ for CA Datacom®
and
CA Datacom®/DB
to improve or maintain the performance. To perform these tasks, you need to work with the Database Administrator, the systems programmer, the Security Administrator, the
CA Datacom® Datadictionary™
Administrator, and possibly the
CA Dataquery™ for CA Datacom®
users.
Your system responsibilities include:
  • Knowing the system defaults that affect end users.
  • Providing the Database Administrator with information about
    CA Dataquery™ for CA Datacom®
    end-user needs.
  • Being knowledgeable about
    CA Dataquery™ for CA Datacom®
    batch utilities.
  • Understanding the operation of any user exits designed at your site which affect the end user.
  • Knowing how to use
    CA Dataquery™ for CA Datacom®
    diagnostics and
    CA Datacom®/DB
    accounting statistics in monitoring system and user performance.
  • Maintaining signon information.
Site Standards
Your site can have one
CA Dataquery™ for CA Datacom®
Administrator who performs all of the
CA Dataquery™ for CA Datacom®
administrative functions, or it could have several
CA Dataquery™ for CA Datacom®
Administrators among whom the tasks are divided, or performed for a particular group of users, such as an office with more than one department.
Required
CA Dataquery™ for CA Datacom®
Skills
Learn about
CA Dataquery™ for CA Datacom®
so that you can support your users. Also, you need to be fully authorized so that you can use all the
CA Dataquery™ for CA Datacom®
features if you need to. The following highlights those subjects that are of particular importance to you. You should know how to perform the following tasks:
  • Establish security.
    Choose the SECURITY CONTROL option from the Administrative Menu. With this panel you can:
    • Authorize users to access tables and perform the FIND, UPDATE, INSERT, or ERASE functions.
    • Authorize users to access columns protected by profile-codes.
  • Authorize a user.
    • Use the USERS option from the Administrative Menu.
    • Type USERS on the command line.
    With this you can add, delete, or maintain users.
  • Force a user to log off.
    Use the USERS option from the Administrative Menu. Use the PF key to display the Directory of Active Users. Use a PF key to FORCE OFF the active user.
  • Override predefined system defaults for a user.
    Use the USERS option on the Administrative Menu.
  • Use diagnostics.
    See Using DQL Diagnostics for details.
  • Get
    CA Dataquery™ for CA Datacom®
    statistics.
    See Using CA Datacom Core Statistics for details.
  • Create and modify JCL members for batch submission.
  • Maintain the Query Library Table (DQQ).
  • Perform online library maintenance with the online Administrator functions described in Accessing the Online Administrative Functions.
    You can use the DQLIBRMT utility to:
    • Delete all or selected members for selected users or groups
    • Back up all queries, dialogs, terms, JCL, and PROC members or selected members from the Query Library Table to tape or disk
    • Restore all or selected members to the Query Library Table from a tape or disk file
    • Print maintenance reports that:
      • List each user's query and type
      • Show selected user's query text or JCL
      • Show maintenance functions per query
      • List any errors that occur during query maintenance
  • Create and send a message.
    Use the USERS option from the Administrative Menu. Use the PF key to get to the Directory of Active Users. Then use the PF keys to do a CREATE MSG or a SEND MSG.
  • Broadcast a message.
    CA Dataquery™ for CA Datacom®
    displays a bulletin board immediately after a user signs on. The bulletin board can be used to distribute information to all
    CA Dataquery™ for CA Datacom®
    users. Select the LANGUAGE option on the Administrative Menu. For details, see Changing the Bulletin Board.
  • Cancel a user's query while it is processing.
    Use the USERS option from the Administrative Menu. Use the PF key to get to the Directory of Active Users. Then use the PF key to do a CANCEL FIND.
  • Use the Printer Control option on the Administrative Menu. For details, see Using the Printer Control.
  • Disallow use of a query.
    If a query is being used that is causing system problems, you can use the
    CA Dataquery™ for CA Datacom®
    Administrator Library Maintenance function to change the author's name to an unknown author and make the query private. This keeps the query from appearing in the user's library. This does not delete the query but keeps it from being used until the problem is resolved.