Ingres Corporation

Ingres DBA Tools Package


1.0 Welcome

2.0 Operating System Support
2.1 Supported Platforms

3.0 System Requirements

4.0 Installation Considerations
4.1 Install Ingres DBA Tools on Windows
4.2 Instance ID Behavior
4.3 Accessing DBA Tools
4.4 Post-installation Considerations—Configure Network Connections

5.0 DBA Tools Suite
5.1 Ingres Visual Manager (ivm)
5.2 Ingres Configuration Manger (vcbf)
5.3 Ingres Network Utility (ingnet)
5.4 Ingres Visual DBA (vdba)
5.5 Ingres Visual SQL (vdbasql)
5.6 Ingres Visual Performance Monitor (vdbamon)
5.7 Ingres Import Assistant (iia)
5.8 Ingres Export Assistant (iea)
5.9 Ingres Visual Configuration Differences Analyzer (vcda)
5.10 Ingres Visual Database Objects Differences Analyzer (vdda)
5.11 Ingres Journal Analyzer (ija)
5.12 Ingres Service Manager (winstart)
5.13 Configuration By Forms (cbf)
5.14 Network Management Utility (netutil)

6.0 General Considerations
6.1 Features Not Included in Ingres DBA Tools

7.0 Documentation

8.0 Your Support Options


1.0 Welcome

The Ingres DBA Tools Package is a stand-alone product designed to facilitate the download and installation of a set of tools for monitoring and administering Ingres. The package is available as a separate download from the Ingres product download.

The Ingres DBA Tools Package contains the following key components:

Ingres Net
Provides clients with transparent access to remote Ingres instances, enabling users to work in remote databases as if they were local.

Ingres Database Administration Tools
Provide a host of database, system and user tools for starting, stopping, managing and monitoring the Ingres instance. Click here for a brief description of these tools. For additional information on the tools, see the Ingres System Administrator Guide, Connectivity Guide and Command Reference Guide. For instructions on performing specific tasks, see the tool's online help.

Note: Ingres Net and the DBA Tools are also included with the Ingres DBMS product download for Windows.

Before you start using the software, you should review this readme file for important information to help you with your installation and use of the product.

For up-to-date information specific to your operating system, visit the Ingres page at:

http://www.ingres.com/products/ingres-database.php.

Note: Make sure that copies of this readme are distributed to the system administrator, database administrator, and applications developers using Ingres DBA Tools at your site. This document contains information of interest to each of these users.


2.0 Operating System Support

This section contains information pertaining to Ingres DBA Tools support on various operating systems.

For complete information about all Ingres products and the platforms and operating system releases they run on, see the Product Availability Matrix at:

http://www.ingres.com/products/prod-availability-matrix.php.


2.1 Supported Platforms

The following operating systems are supported (as of the publishing of this document):

Ingres DBA Tools also support the 64-bit versions of the operating systems listed above.

Ingres supports these operating systems for the duration of their life cycle (as determined by the operating system's manufacturer or until Ingres Corporation announces that it is dropping support). For the latest information about supported operating systems, visit http://www.ingres.com/support


3.0 System Requirements

For Ingres DBA Tools to install and run correctly, the following requirements must be met or exceeded:


4.0 Installation Considerations

The Ingres DBA Tools Package is easy to install, requiring no user input unless a change to the default installation location (C:\Programs Files\Ingres\DBA Tools) is desired.


4.1 Install Ingres DBA Tools on Windows

To install Ingres DBA Tools

  1. Extract all files from the Ingres DBA Tools installation Zip file.

  2. Run setup.exe and follow the installation wizard prompts.


4.2 Instance ID Behavior

For an initial installation, Ingres DBA Tools shortcuts are installed to:

StartProgramsIngresDBA Tools

In the unlikely event that you wish to install multiple Ingres DBA Tools instances, subsequent installations of Ingres DBA Tools automatically add an instance identifier to the DBA Tools name to distinguish the default installation path and shortcuts from previous installs. For example, a second installation installs the Ingres DBA Tools shortcuts to:

StartProgramsIngresDBA Tools VU

Note: The default service name for an initial DBA Tools installation is Ingres DBA Tools [VT].


4.3 Accessing DBA Tools

You can access the GUI-based DBA Tools in the following ways:

To access the forms-based DBA Tools, select the Windows Command Prompt from the DBA Tools menu and enter the desired command.


4.4 Post-installation Considerations—Configure Network Connections

If you did not configure virtual nodes during the installation of Ingres DBA Tools, then you must do so by running the GUI-based Ingres Network Utility (ingnet) or the forms-based Net Management Utility (netutil). The virtual node definitions contain the login and connection data for the servers you want to access. For instructions on defining virtual nodes, see the Ingres Network Utility or Network Management Utility online help. For an overview of network communications, see the Ingres Connectivity Guide.


5.0 DBA Tools Suite

The Ingres DBA Tools Package includes 11 GUI-based tools and 2 forms-based tools. All tools provide screen-level online help. For additional information, see the Ingres System Administrator Guide or the Connectivity Guide. A brief description of each tool is provided here. Commands to invoke these tools are shown in parentheses and documented in the Command Reference Guide.


5.1 Ingres Visual Manager (ivm)

Ingres Visual Manager provides a global view into the Ingres installation and serves as a system console from which you can manage Ingres servers and components, and access other DBA tools. Specifically, Ingres Visual Manager enables you to:


5.2 Ingres Configuration Manger (vcbf)

Ingres Configuration Manager displays current parameter values for an Ingres installation's servers and components, and provides menus for changing them. Specifically, Ingres Configuration Manager enables you to:


5.3 Ingres Network Utility (ingnet)

Ingres Network Utility is dedicated to defining and managing Ingres Net virtual nodes (vnodes), which then allows you to connect to remote Ingres installations through Ingres Net.

System Administrators (or any user with the appropriate Ingres privileges) can use Ingres Network Utility to perform the following tasks:

End users can use Ingres Network Utility to:

Note: Ingres Network Utility can be accessed stand-alone, through Ingres Visual Manager, and as an integrated program in Ingres Visual DBA.


5.4 Ingres Visual DBA (vdba)

Ingres Visual DBA provides ways to monitor, manage, and secure servers and other database resources. Specifically, Ingres Visual DBA enables you to:


5.5 Ingres Visual SQL (vdbasql)

Ingres Visual SQL lets you work with SQL queries. Specifically, Ingres Visual SQL enables you to:


5.6 Ingres Visual Performance Monitor (vdbamon)

Ingres Visual Performance Monitor lets you monitor, analyze and manage the Ingres installation. Specifically, Ingres Visual Performance Monitor enables you to:


5.7 Ingres Import Assistant (iia)

Ingres Import Assistant lets you import a data file into an Ingres database table. Specifically, Ingres Import Assistant enables you to:


5.8 Ingres Export Assistant (iea)

Ingres Export Assistant lets you export Ingres table data into external file formats. Specifically, Ingres Export Assistant enables you to:


5.9 Ingres Visual Configuration Differences Analyzer (vcda)

Ingres Visual Configuration Differences Analyzer lets you compare configuration snapshots of an Ingres installation. Specifically, Ingres Visual Configuration Differences Analyzer enables you to:


5.10 Ingres Visual Database Objects Differences Analyzer (vdda)

Ingres Visual Database Objects Differences Analyzer lets you compare the definitions of Ingres database objects. Specifically, Ingres Visual Database Objects Differences Analyzer enables you to:


5.11 Ingres Journal Analyzer (ija)

Ingres Journal Analyzer lets you view and analyze journaled transactions and individual underlying statements. Specifically, Ingres Journal Analyzer enables you to:


5.12 Ingres Service Manager (winstart)

Ingres Service Manager lets you start or stop Ingres. Specifically, Ingres Service Manager enables you to:


5.13 Configuration By Forms (cbf)

Configuration-By-Forms is a forms-based tool invoked from the Ingres command line. This tool lets you perform all the configuration tasks listed under the Ingres Configuration Manager section. See the Ingres Command Reference Guide for command syntax.


5.14 Network Management Utility (netutil)

Network Management Utility is a forms-based tool invoked from the Ingres command line. This tool lets you perform all the virtual node definition tasks listed under the Ingres Network Utility section. See the Ingres Command Reference Guide for command syntax.


6.0 General Considerations

The following are general considerations for using DBA Tools.


6.1 Features Not Included in Ingres DBA Tools

Response File
There is no response file support for performing a silent install of the Ingres DBA Tools Package at this time.

Product Upgrades
Ingres DBA Tools is a stand-alone product with its own registry entry. Ingres DBA Tools cannot be upgraded with the Ingres DBMS product, nor can Ingres DBMS be upgraded with the Ingres DBA Tools product.


7.0 Documentation

In addition to online help, the Ingres documentation includes information on all DBA Tools. The Ingres documentation is provided in Portable Document Format (PDF). The full documentation set can be downloaded at:

http://esd.ingres.com/product/docs.

Open the file Bookshelf.pdf for a list of all included documentation. You can perform a cross-documentation set search from the bookshelf or any guide in the documentation set.

To view PDF files, you must download and install Adobe Reader from the Adobe website if it is not already installed on your computer.


8.0 Your Support Options

Enterprise customers with active maintenance and support contracts have full access to Ingres Support, including telephone support and online use of our call tracking system and knowledge base, Service Desk. For Customer Support contact details, see http://www.ingres.com/support/contact.php.

If you have an active support contract and want to register for access to Service Desk (https://servicedesk.ingres.com ), use the enrollment form at http://www.ingres.com/users/register.php. (Your six-digit Account Number/Site ID is required.)

If you do not have a support agreement for Ingres Corporation products and are interested in purchasing support, contact us at sales@ingres.com.

For more information about support options, visit http://www.ingres.com/support.php.

Free support is available from the Ingres Open Source Community. Community members may obtain assistance for Ingres Corporation products by registering with the Ingres Community Site and using the available tools. To register, go to http://community.ingres.com/forums/home.php and click Register.

The Community Forums also provide Ingres Open Source Community members the opportunity to ask questions and interact with other community members and Ingres Corporation technical staff. For more information, visit http://community.ingres.com/forums/index.php.


Copyright © 2010 Ingres Corporation. All rights reserved.