Administrating CA Dataquery
This section provides information about and procedures for performing CA Datacom/DB systems tasks.
This section provides information about and procedures for performing
CA Datacom®/DBsystems tasks, including:
- Establishing the operating environment
- Creating the system databases and areas
- Maintaining the system databases and areas
- Customizing theCA 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:
- InstallingCA Dataquery™ for CA Datacom®system software
- SupportingCA Dataquery™ for CA Datacom®system software
- Administering the operations of theCA 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 ofCA Datacom®/DBand at least a general knowledge of the other CA products that execute withCA Dataquery™ for CA Datacom®. You must be able to determine if problems that can arise are a result ofCA Dataquery™ for CA Datacom®orCA 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 whenCA Dataquery™ for CA Datacom®online operates under CICS.
- You must have a general knowledge ofCA Dataquery™ for CA Datacom®. Depending on the environment, you may either be actively involved in creating queries or may useCA Dataquery™ for CA Datacom®only when there are problems to be solved. You must understandCA Dataquery™ for CA Datacom®well enough to know howCA Dataquery™ for CA Datacom®impacts the operation of theCA Datacom®/DBsystem and how to optimizeCA Dataquery™ for CA Datacom®operation and the operation ofCA Datacom®/DBwhenCA 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.
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 followingCA Dataquery™ for CA Datacom®installation.
- User Requirements Tables. See Defining theCA Dataquery™ for CA Datacom®User Requirements Tables.
- Creating user signons/passwords and setting up authorizations.
- DQSYSTBL (assembleCA Dataquery™ for CA Datacom®system table macro (DQOPTLST) and link edit using name DQSYSTBL).
- Programming user exits.
- ImplementingCA Dataquery™ for CA Datacom®security.
- Maintenance afterCA Dataquery™ for CA Datacom®is operational.
- Supporting users and diagnosing problems.
- Managing query and JCL libraries.
- Performing backups and restores ofCA Dataquery™ for CA Datacom®tables.
- Using batch maintenance utilities.
- Upgrading supporting products and implementing required changes following upgrades.
- Modifying the batchCA Dataquery™ for CA Datacom®systems options table to meet site requirements.
- Executing deferred batch queries.
- MaintainingCA Dataquery™ for CA Datacom®system tables.
- Loading and backing up CA-supplied languages.
- Monitoring and tuningCA Dataquery™ for CA Datacom®.
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®/DBto 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 aboutCA Dataquery™ for CA Datacom®end-user needs.
- Being knowledgeable aboutCA 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 useCA Dataquery™ for CA Datacom®diagnostics andCA Datacom®/DBaccounting statistics in monitoring system and user performance.
- Maintaining signon information.
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.
CA Dataquery™ for CA Datacom®Skills
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.
- 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.
- GetCA 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 allCA 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 theCA 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.