IBConsole Database Menu
Go Up to IBConsole - Main Menu
The Database menu has the following options:
- Add...
- Remove
- Connect
- Connect As...
- Disconnect
- Create Database...
- Drop Database
- Maintenance
- Performance Monitor
- View Metadata...
- Connected Users...
- Properties...
Contents
Add...
Select Database>Add... to include a Database from a specified location.
Remove
Select the database you want to remove from the left pane and click Database>Remove.
Note: You should Disconnect the Database before removing it.
Connect
Select Database>Connect to connect to a database.
Connect As...
If you want to connect to a database with a diferent user, select Database>Connect As...
Disconnect
Disconnects from the Database.
Create Database...
You can create a new Database from scratch using this option Database>Create Database.
Drop Database
This option drops the selected database.
Maintenance
The Database>Maintenance provides the following options:
- Backup/Restore
Allows you to backup and restore a database. You can also do other operations such as creating a journal.
- Database Statistics...
This option displays information about the operations performed. You can then save the statistics as a text file.
- Sweep
Sweeping a database is a systematic way of removing outdated records. See Sweep Interval and Automated Housekeeping for more information.
- Transaction Recovery...
This option recovers the information of the transactions that have been interrupted.
- Shutdown...
You can configure a timeout to shutdown the database. Additionally, you can deny new connections or transactions while waiting.
- Database Restart
Restarts the selected database.
Performance Monitor
You can monitor a database with this option. You can decide the time of refreshment, setup logging, manually trigger the database sweep, etc. The performance monitor form has several tabs to display different types of data (Attachments, Database, Memory, Procedures, Statements, Tables&Views, Transactions and Triggers).
View Metadata...
This option shows the metadata related to the selected database.
Connected Users...
This option displays a list of the users that are connected to the database. The list shows the User Name, PC Name of the user and the IP address.
Properties...
This option shows all the properties related to the selected Database, such as the configuration properties and alias name. You can edit this data.
