Gen. Reference: IBConsole

IBConsole is the user interface to the InterBase© 6 Relational Database Management System associated with Bundle-Track versions 3.6 and later.

• Starting IBConsole
• Exiting IBConsole
• Servers
  • Logging into a Server
  • Registering a Server
  • Administrative Login UserName and Password
• Databases
  • Connecting to a Database
  • Disconnecting from a Database
  • Registering a Database
  • Validating a Database
  • Checking for Connected Users
  • Shutting Down a Database
  • Restarting a Database
  • Creating a Database Backup
  • Restoring a Database from Backup
• SQL Scripts and Statements
  • Accessing InteractiveSQL (ISQL)
  • Loading a Script (.SQL) file
  • Executing a Query/Script/Statement/Command
  • Browsing Executed Queries
• Users
  • Creating New Users

Starting IBConsole

1. From the Windows Menu, open the Programs list.
2. From the Programs list, open the "InterBase 6" Program Group. (The name may be longer).
3. Select IBConsole.

If your Programs list does not include InterBase 6, you will need to locate the file manually:

1. On your Windows Desktop, double-click My Computer.
2. Navigate through the files to C:\Program Files\Borland\InterBase\Bin\
3. In that directory, you will find IBConsole.exe.
   • If your system may hide all '.exe' extensions, then choose the file that appears to be named simply 'IBConsole'.
4. Optional: make a shortcut to this file for easier access in the future.

Return Links:

• Database Maintenance
  • Locating a Database in IBConsole
  • Backup only
  • Backup and Restore
  • Restore only.
• General Reference
  • Readying ISQL
• User Management
  • Adding
  • Deleting
  • Updating

Exiting IBConsole

• Use the menu to select Console >> Exit.

Logging into a Server

1. Confirm that IBConsole is running.
2. Locate your Server in the left window of IBConsole, below the 'InterBase Servers' icon:
   • If you are working on the machine on which the database file resides, the server you want is called 'Local Server.' If this is not listed, register it
   • If the database file resides on another machine, the server you want is a Remote Server. If that server is not listed, register it.
3. If the server is disconnected () ,double-click the server icon to connect it.
   • If a dialog displays 'The server has not been started. Would you like to start it now?', click YES.
4. At the login prompt, enter a valid User Name and Password.
   • If a dialog displays "Error logging into the requested server," confirm that your keyboard's Caps Lock function is not engaged (as well as Num Lock, if that would affect password keys), confirm that the InterBase Server is Running, and try again.

Return Links:

• Database Maintenance
  • Locating a Database in IBConsole
  • Backup only
  • Backup and Restore
  • Restore only.
• General Reference
  • Readying ISQL
• User Management
  • Adding
  • Deleting
  • Updating

Registering a Server

1. Confirm that IBConsole is running.
2. Use the menu to select Server >> Register.
3. Consider where the database resides:
   • If the database resides on this machine, then select Local Server.
   • If the database resides on another machine, select Remote server, then specify the Server Name (as the network sees it) and the Network Protocol (which should be TCP/IP).
4. At the bottom of the panel, input the Administrator Login.

Return Links:

• Database Maintenance
  • Logging into a Server
• Installing
  • Network Server only
  • Network Server and Client.
• Reinstalling
  • Interbase
• Relocating
  • Network Server only
  • Network Server and Client.

Administrator Login UserName and Password

Some functions may be performed only by the Administrator Login. The Administrator UserName is 'sysdba'. Upon installation, the Administrator Password is 'masterke.' Note that this password can be (and may have been) changed by your system administrator.

Connecting to a Database

1. If IBConsole is running and you are logged into the server, you should see the database listed under the server.
   • If the database is not listed, register it.
2. Look at the icon next to the database name:
   • means you are already connected.
   • means you are not connected. Double-click the database name to connect.

Return Links:

• Backup only
• Backup and Restore
• Running/Executing a Query/Script/Statement/Command in ISQL

Disconnecting from a Database
You are already disconnected if any of the following are true:

• IBConsole is not yet running.
• There is a red X on the server icon ().
• There is a red X on the database icon ().

Otherwise, disconnect as follows:

1. Click once on the database you wish to disconnect.
2. Double-click 'Disconnect' in the right-hand window.

Return Links: Backup and Restore, Error 335544510 in IB Console.

Registering a Database

1. Confirm that IBConsole is running.
2. Confirm that you are logged into the server.
3. Click once on the server to select it.
4. From the Database menu, select Register.
   • This will open the 'Register Database and Connect' window.
5. Set the Database fields (note that the field labels are below their fields):
   • File:
     • Specify the full path to the database file.
     • If registering under the Local Server, click the '…' button to open the file selector, then locate and select the database file.
       • The default location for BT30600PROD.gdb is
         'C:\Program Files\Bundle-Track\Databases\BT30600PROD.gdb'.
     • If registering under a Remote Server, type the local path to the file (not the network path).
       • For example, if the file is at 'SERVER:C:\Program Files\Bundle-Track\Databases\BT30600PROD.gdb' then input 'c:\Program Files\Bundle-Track\Databases\BT30600PROD.gdb' into the File field (even if that directory is shared under a different name like '\\ServerName\SharedName\').
   • Alias:
     • (This should fill in by itself.)
       
6. Set the Login Information fields:
   • In User Name and Password, set the database's administrator login.
   • Leave Role and Default Character Set blank.
7. Click OK.

Return Links:

• Database Maintenance
  • Locating a Database in IBConsole
  • Restore Only
• General Reference
  • Readying ISQL
• Installing
  • Network Server only
  • Network Server and Client.
• Reinstalling
  • Interbase
• Relocating
  • Network Server only
  • Network Server and Client.

Validating a Database

1. Confirm that IBConsole is running.
2. Confirm that you are logged into the server.
3. Under the server, locate the database you wish to validate.
4. Confirm that the database is disconnected (has a red X on the icon).
5. Click once on the database to select it, then double-click 'Validate' in the right-hand window.
6. Set the 'Read Only Validation' option to True. (Click the box to change the value.)
7. Click OK to begin Validation.
   • If no database errors are detected, click OK.
   • If database errors are detected, click Repair, then let the Validation process finish, and then repeat the Validation process. When you get a Validation with no errors, run a Backup and Restore.

Checking for Users Connected to a Database

1. Confirm that IBConsole is running.
2. Confirm that you are logged into the server.
3. Confirm that the database is connected (has a green check on its icon).
4. Use the menu to select Database >> Connected Users.

Return Links: Shutting Down a Database.

Shutting Down a Database

1. Instruct all Bundle-Track users to exit Bundle-Track and inform them that the database will be down for maintenance.
2. Confirm that IBConsole is running.
3. Confirm that you are logged into the server under the Administrator Login.
4. Confirm that the database is currently connected (has a green check on its icon) and selected.
5. Verify that the only user connected to the database is 'sysdba'. If others are connected, direct them to exit. (Otherwise, those users will encounter errors like this and this.)
6. Double-click 'Shutdown' in the right-hand window.
7. Set the 'Shutdown' option to 'Force shutdown after timeout.'
8. Set the 'Shutdown Timeout' value to one (1) minute.
9. Click OK and await shutdown confirmation.

Return Links:

• Database Deadlock
• Lock Conflict

Restarting a Database

1. Confirm that IBConsole is running.
2. Confirm that you are logged into the server under the Administrator Login.
3. Confirm that the database is currently connected (has a green check on its icon) and selected.
4. Use the menu to select Database >> Maintenance >> Database Restart.
5. Click OK and await Restart confirmation.
   • If you are unable to restart the database, you may be experiencing a database deadlock. Follow this procedure to clear it: Validate a Database.

Return Links:

• Backup and Restore
• Lock Conflict
• Sending us your Database

Creating a Database Backup File

See Making a Backup File (.GBK)

Restoring a Database from Backup

See DB Maintenance: Restore.

Accessing InteractiveSQL (ISQL)

1. Confirm that IBConsole is running.
2. Confirm that you are logged into the server.
3. Confirm that the database is currently connected (has a green check on its icon) and selected.
4. Click on the SQL icon or use the menu to select Tools >> Interactive SQL...

Return Links:

• Running/Executing a Query/Script/Statement/Command in ISQL

Loading a Script (.SQL) file into ISQL

1. Save the script (.sql) file to a location you can browse to from IB Console.
2. Confirm that ISQL is running.
3. Use the menu to select Query >> Load Script
4. Use the Open dialog to locate and open the file containing the script.

Return Links:

• Running/Executing a Query/Script/Statement/Command in ISQL

Running/Executing a Query/Script/Statement/Command in IB Console's ISQL

1. Open IB Console.
2. Connect to the database.
3. Open ISQL.
4. Into the upper portion of the Interactive SQL screen, type or paste a script/query/statement/command, or load a script file.
5. Execute by any one of the following means:
   • Click the lightning bolt icon.
   • Press Ctrl + E.
   • Use the menu to select Query >> Execute.

Return links:

• Network Server and Client Install
• Network Server only install
• Upgrading from 3.6 and higher

Browsing Executed Queries in ISQL
Any of the following methods will move you through the queries you have executed in your current ISQL session. You can then re-execute them as they are, or modify them.

• Click the Arrow icons.
• Select Previous or Next from the Query menu.
• Press Ctrl + P or Ctrl + N

Once you close the ISQL panel, the history is lost.

Creating New Users

Add a user in InterBase as follows:

1. Confirm that IBConsole is running.
2. Confirm that you are logged into the server.
3. Under the Server, click Users.
4. In the right-hand window, right-click on any user name, then click 'Add User ...'
5. Fill in the Required Information.
6. Click Apply.
7. Click Close.

Return Links: Adding a Bundle-Track User.

We welcome your comments at support@bundle-track.com.

If you would like our live assistance, you may hire us at our professional services rate.