Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
DB-Access User's GuideThis publication describes how to use the DB-Access utility to access, modify, and retrieve information from HCL® OneDB® database servers.
Getting started with DB-AccessDB-Access provides a menu-driven interface for entering, running, and debugging Structured Query Language (SQL) statements and Stored Procedure Language (SPL) routines. You can also run DB-Access interactively from the command line.
Start DB-AccessYou start DB-Access by running the dbaccess command from the command line. You can choose whether to use the DB-Access menu interface or the command-line interface.
dbaccess command: Start DB-AccessUse the dbaccess command to start DB-Access. Include options to specify the database, command files, or to go to a specific menu screen.
Example: Start DB-Access for a databaseThis example shows how to start DB-Access and specify a database to which to connect.

Example: Start DB-Access for a database

This example shows how to start DB-Access and specify a database to which to connect.

Assume that the database server that you have online contains a database named mystores. To make the mystores database the current database, start DB-Access with the following command:

dbaccess mystores

You can specify a database on a database server that is not online. For example, either of the following commands selects the newstores database on the xyz database server:

dbaccess newstores@xyz
dbaccess //xyz/newstores

When DB-Access starts, the database and database server name that you specify are displayed on the dashed line, as the following figure shows.

Figure 1: The DB-Access main menu with database and database server name

DB-Access:   Query-language  Connection  Database  Table  Session  Exit


---------------- newstores@xyz ---------------------Press CTRL-W for Help ---