The IBConsole Environment
Go Up to IBConsole
Overview
IBConsole is an all-in-one database tool. It combines database administration, interactive SQL and communications testing capabilities in one easy to use application.
IBConsole provides you with the ability to:
- Manage local and remote servers.
- Manage server security: Authorize new users, change user passwords, and remove users.
- Manage server certificates (licenses).
- Manage databases: Create new databases and set database properties.
- Backup and restore databases.
- Perform database maintenance: Validate the integrity of a database, repair a corrupted database, sweep a database, and recover "limbo" transactions.
- Shut down and restart a database.
- Execute SQL.
- View database metadata in DDL script format.
All from within a single graphical application!
IBConsole consists of:
- A Main Window, the control center of IB Console.
- An Object View Window, which display detailed information about database objects.
- SQL Windows, which can be used to execute SQL statements and scripts.
- A Text Viewer, used to display metadata, logfiles etc.
- Several Visual Editors to create and alter database object definitions.
Shortcuts and Context Menus
Throughout this help system, you will find that only one or two methods of accessing the actions and tasks available in IBConsole are discussed. All tasks can be accessed via the main menu. However, the IBConsole interface provides many additional methods of accessing most features so that you can use IBConsole in the way you prefer.
Other ways to access most available features include:
- Toolbars
- Context menus. Clicking on an item with the secondary mouse button (usually the right button for right-handed users) will cause a context menu to appear. Selecting an item from the context menu will cause the associated dialog box to appear, usually with some or all of the fields filled in with the data of the item you right-clicked on.
- Double clicking on an item that has an associated context menu performs the default action. The default action is the bold item in the popup menu.
- Highlighting certain items in the tree causes action items to be displayed in the right pane, under the Actions tab. Clicking an action item is equivalent to selecting it from the main menu.
- Highlighting certain items in the tree causes a summary of associated items or instances of the highlighted item to be displayed in the right pane. Summary items may also have an associated popup menu. Right-click to view and select from the context menu. Double-click to perform the default action.
Experiment with the objects in the window to become familiar with the locations of controls and to find your favorite way of doing the tasks you perform most often.
Toolbars
The IBConsole interface provides a number of toolbars which enable you to perform common tasks efficiently. Each toolbar contains buttons to perform related tasks. Click the links below to learn about each toolbar
The available toolbars are:
- Main Window Toolbar
- Object View General Toolbar
- Object View Data Toolbar
- SQL Toolbar
- Text Viewer Toolbar