Administering Blackfish SQL

This chapter provides a brief overview of basic Blackfish SQL administrative procedures and tools. For related information see the SQL Reference.

Using the Graphical Consoles for Administrative Tasks
Using SQL for Administrative Tasks
Starting the Blackfish SQL Server

Using the Graphical Consoles for Administrative Tasks

You can use visual tools to administer Blackfish SQL.

For Blackfish SQL for Windows:

You can use RAD Studio DataExplorer to perform many administrative tasks. DataExplorer has been enhanced with a connection string editor for Blackfish SQL for Windows, and the ability to create or alter Blackfish SQL databases. DataExplorer enables you to browse and view stored procedures. Some DataExplorer tasks are not yet supported for Blackfish SQL for Windows. See the DataExplorer help for more information.

For Blackfish SQL for Java:

You can use one of the JBuilder administrative consoles.

JdsExplorer
ServerConsole

Documentation for both JdsExplorer and ServerConsole are provided with JBuilder.

Using SQL for Administrative Tasks

You can perform virtually all Blackfish SQL administrative tasks either by using SQL commands or by using the built-in administrative stored procedures in the DB_ADMIN class.

Use administrative SQL commands to:

Create, alter, and drop tables and views
Create, alter, and drop users and roles
Create and drop stored procedures and triggers

For details, see the SQL Reference.

Use DB_ADMIN stored procedures to:

Alter database properties
Verify database integrity
Configure Database logging
View open server connections
Create, alter, and drop database mirrors
Miscellaneous mirror administration capabilities

For details, see the Stored Procedures Reference.

Starting the Blackfish SQL Server

A server must be running before you can establish a remote connection. The server may be started as a .NET process or a Java process.

Starting and Stopping the Server as a .NET Process

To start or stop the server as a .NET process use either:

The BSQLServer.exe command
The Windows Management Console

Using BSQLServer.exe

To start the server: BSQLServer.exe
To stop the server: BsqlServer.exe -shutdown or Type Ctrl-C in the Console window
To install the server as a Windows service: BsqlServer.exe -install
To remove the Windows server: BsqlServer.exe -remove
To explore other options for server configuration: BsqlServer.exe -?

Using the Windows Management Console

To start the server: net start BlackfishSQL
To stop the server: net stop BlackfishSQL

Starting the Server as a Java Process

To start or stop the server as a .NET process use either:

The JdsServer.exe command
The Windows Management Console

Using JdsServer.exe

To start the server: JdsServer.exe
To stop the server: JdsServer.exe -shutdown or Type Ctrl-C in the Console window
To install the server as a Windows service: JdsServer.exe -install JDataStore
To remove the Windows server: JdsServer.exe -remove JDataStore
To explore other options for the server configuration: JdsServer.exe -?

Using the Windows Management Console

To start the server: net start JDataStore
To stop the server: net stop JDataStore