|
|
|
Ingres lets you start, stop, manage, and monitor the Ingres installation using various GUI tools.
|
|
|
Ingres Visual Manager (IVM) provides a global view into the Ingres installation. It serves as a system console from which you can manage Ingres components and access other utilities. This utility captures events that are occurring in the system and allows them to be filtered for emphasis, based on your preferences.
You can access all other Ingres visual tools through IVM. For an overview of IVM tasks, see the chapter "Managing your System and Monitoring Performance." For instructions on using IVM screens, see the IVM online help. For information on IVM command line tasks, see the Command Reference Guide.
|
|
|
Visual Performance Monitor can be used as a monitoring tool, a performance analysis tool, and a system management tool.
Visual Performance Monitor lets you monitor the following:
You can view a list of the servers that are started on an Ingres installation, and information about each server. For example, you can view the sessions that are currently active for each server. You can also remove a session or stop a server (if you are a privileged user).
Visual Performance Monitor provides the following information for a particular server:
You can monitor users for whom there are open sessions. You can find out which sessions are open for a particular user, and drill down further to reveal all the related information about those sessions (lock lists, transactions locked, databases locked, and so on).
You can view logging system summaries, transaction lists, process, and database lists. Log information can be used to monitor transaction rates, log file activity, processes, and databases in the logging system. This information is useful in determining which logging parameters need to be adjusted.
You can monitor lock information to help determine which lock parameters need to be adjusted. Viewing locking system summaries, lock lists, and resources provides you with the information you need to spot conditions when, for example, additional locking system resources need to be added.
Viewing your lock lists is useful for locating transactions that cannot proceed because they are blocked by another transaction.
You can view your performance information from a "database" point of view. This means you can access performance information using a database branch, as opposed to the root branches of Visual Performance Monitor.
You can start, stop, and monitor Replicator servers that are required for the replication scheme that has been defined in a VDBA DOM window. You can set up startup parameters for these servers, send events to these servers, view and manage collisions, and display other miscellaneous replication monitor information.
Visual Performance Monitor lets you perform the following actions:
|
|
|
Visual DBA provides an alternative set of system administration tools. It allows you to perform system administrator functions including configuring, performance monitoring, backup and recovery, and remote database optimization. For an overview of Visual DBA tasks related to communications, see the Connectivity Guide. For instructions on using Visual DBA screens, see the Visual DBA online help. For information on Visual DBA command line tasks, see the Command Reference Guide
|
|
|
Some options and dialogs in Visual DBA result in the launch of an operating system level command (such as createdb or destroydb) on the server. These "remote commands" are performed by the Remote Command Server (RMCMD) process on behalf of Visual DBA.
The Remote Command Server (RMCMD) allows remote execution of operating system commands. It must be started in installations where a DBMS server is running for certain DBA tasks to be accessible remotely with Visual DBA. The Remote Command Server is started on the server side, not on the Visual DBA client.
DBA tasks are primarily those that do not have an equivalent through an SQL statement, for example, creating or dropping a database, displaying selected portions of the journal for a database, or starting a replication server remotely. By default, only the installation owner is authorized to perform such tasks remotely through Visual DBA.
The rmcmd process is started and stopped with Ingres, according to the settings for the Remote Command component in CBF or Configuration Manager.
|
|
|
To allow a user other than the installation owner to execute remote commands, you can use either of the following methods:
grant select,insert,update,delete on $ingres.remotecmdinview to user
grant select,insert,update,delete on $ingres.remotecmdoutview to user
grant select,insert,update,delete on $ingres.remotecmdview to user
grant execute on procedure $ingres.launchremotecmd to user
grant execute on procedure $ingres.sendrmcmdinput to user
grant register, raise on dbevent $ingres.rmcmdcmdend to user
grant register, raise on dbevent $ingres.rmcmdnewcmd to user
grant register, raise on dbevent $ingres.rmcmdnewinputline to user
grant register, raise on dbevent $ingres.rmcmdnewoutputline to user
grant register, raise on dbevent $ingres.rmcmdstp to user
Note: Grants must not be made directly to the underlying tables.
|
|
|
Operating system commands executed by the Remote Command (rmcmd) Server are executed on the server side under the user ID that launched that server (typically the installation owner).
For commands that support the –u option, the rmcmd server will accept the command execution request only if it contains a –uusername argument, where username is the user ID of the session through which the client application (typically VDBA) does the request.
For commands that do not support the –u option, such as sysmod, alterdb, or relocatedb, the request will be accepted only if the user ID of the session is the same as the user who launched the rmcmd server on the server side.
|
|
|
The Configuration Manager utility provides a GUI interface for configuring the Ingres installation. For more information, see Configuration Manager online help. For information on Configuration Manager command line tasks, see "vcbf" in the Command Reference Guide.
|
|
|
The Network Utility is a stand-alone tool that allows you to view and define virtual node (vnode) definitions, which are used to connect to remote Ingres installations through Ingres Net. The Network Utility provides all the same functionality as the virtual nodes toolbar in Visual DBA. The Network Utility also enables launching of the Database Object Manager, Visual Performance Monitor, and Visual SQL utilities for such installations.
For more information, see the Connectivity Guide and the Network Utility online help.
|
|
|
The Export Assistant allows you to export Ingres or Enterprise Access table data into external file formats such as CSV, XML or DBF. It can be run as a stand-alone utility or from within Visual DBA. For instructions on using the Export Assistant, see the Export Assistant online help.
|
|
|
The Import Assistant allows you to import an external text file into an Ingres or Enterprise Access table. It can be run as a stand-alone utility or from within Visual DBA. For instructions on using the Import Assistant, see the Import Assistant online help.
|
|
|
The Journal Analyzer utility allows you to view and analyze journaled transactions and individual underlying statements. It also enables you to create SQL scripts, which are used to recover or redo individual row operations without redoing or rolling back the whole database or table.
For instructions on using the Journal Analyzer, see the chapter "Analyzing and Recovering Journaled Transactions" and the Journal Analyzer online help.
|
|
|
The Visual SQL utility allows you to enter and execute SQL queries. As part of Visual SQL, the SQL Assistant helps you build SQL queries. Visual SQL can be run as a stand-alone utility or from within Visual DBA. For instructions on using this utility, see the Visual SQL online help.
|
|
|
The Visual Configuration Differences Analyzer (VCDA) allows you to compare configuration snapshots of an Ingres installation.
To learn about the benefits of this tool, see chapter "Managing Your System and Monitoring Performance". For instructions on using this tool, see the Visual Configuration Differences Analyzer online help.
|
|
|
The Visual Database Objects Differences Analyzer (VCDA) allows you to compare the definition of Ingres database objects that are either currently installed or saved in a snapshot file. For instructions on using this tool, see the VCDA online help.