IBConsole Menus
Go Up to IBConsole: The InterBase Interface
The IBConsole menus are the basic way to perform tasks with IBConsole. There are seven pull-down menus.
- Console menu enables you to exit from IBConsole.
- View menu enables you to indicate whether or not IBConsole displays system and temporary tables and dependencies, and to change the display and appearance of items listed in the Work pane.
- Server menu enables you to log in to and log out of a server, diagnose a server connection problem, manage user security, view the server log file, and view server properties. For more information, see Connecting to Servers and Databases.
- Database menu enables you connect to and disconnect from a database, create and drop a database, view database metadata, monitor database performance and activities, view a list of users connected to the database, view and set database properties, and perform database maintenance, validation, and transaction recovery. For more information, see Connecting to Servers and Databases.
- Tools menu enables you to add custom tools to the Tools menu and start the interactive SQL window. The interactive SQL window has its own set of menus, which are discussed in Interactive Query. This menu includes a ‘License Manager’ command that you can use to register a server.
- Note: If you are adding the very first certificate from IBConsole to an older database, the Add Certificate pop-up menu is shown. This will add an old style certificate. However, as of InterBase 2007, certificate information is not displayed, so it will be hidden, after the server version is determined.
- Windows menu enables you to view a list of active IBConsole windows and to manage them. See Switching Between IBConsole Windows for more information.
- Help menu enables you to access both IBConsole on-line help and InterBase on-line help.
Context Menus
IBConsole also enables you to perform certain tasks with context sensitive popup menus called context menus. Tables 1.1 and 1.2 are examples of context menus.
When you right-click a server icon, a context menu is displayed listing actions that can be performed on the selected server.
| Popup command | Description |
|---|---|
|
Login |
Login to the selected server. |
|
Logout |
Logout from the current server. |
|
Add Certificate |
Add certificate ID/keys for servers connected to older databases (InterBase 7.x or earlier). Use License Manager for newer databases (InterBase 7.x or later). |
|
User Security |
Authorize users on the current server. |
|
License Manager |
Add, edit, and verify license information. You can also launch the License Manager from the Tools menu. |
|
View Logfile |
Display the server log for the current server. |
|
Diagnose Connection |
Display database and network protocol communication diagnostics. |
|
Database Alias |
Add or delete a database alias. |
|
Properties |
View and update server information for the current server. |
When you right-click a connected database icon, a context menu is displayed listing actions that can be performed on the database:
| Popup command | Description |
|---|---|
|
Disconnect |
Disconnect from the current database. |
|
Maintenance |
Perform maintenance tasks including: view database statistics, shutdown, database restart, sweep, and transaction recovery. |
|
Backup/Restore |
Back up or restore a database to a device or file. |
|
Copy Database |
Copy the database to a different database and/or server. |
|
Performance Monitor |
View database activities including queries, transactions, trigger actions, tables, and memory status. For more information, see Monitoring Database Performance. |
|
View Metadata |
View the metadata for the selected database. |
|
Connected Users |
Displays a list of users connected to the database. |
|
Properties |
View database information, adjust the database sweep interval, set the SQL dialect and access mode, and enable forced writes. |
|
Decrypt Database |
SYSDSOs can use this option to encrypt the database password. |
IBConsole Toolbar
A toolbar is a row of buttons that are shortcuts for menu commands. The following table describes each toolbar button in detail.
| Button | Description |
|---|---|
|
|
Register server: opens the register server dialog, enabling you to register and login to a local or remote server. |
|
|
Un-register server: enables you to un-register a local or remote server. This automatically disconnects a database on the server and logout from the server. See Removing a Server for more information. |
|
|
Database connect: Connects to the highlighted database using the user name and password for the current server connection. See Connecting to a New Database for more information. |
|
|
Database disconnect: enables you to disconnect a database on the current server. See Disconnecting a Database for more information. |
|
|
Launch SQL: opens the interactive SQL window, which is discussed in detail in Interactive Query. |
