Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming


Starting administration

This section describes what you must do at the start of each administration session.

Starting the Text Extender command line processor (optional)

Summary

When
At the beginning of each administration session.

Command
db2tx

Authorization
Any

Enter the following command to start the Text Extender command line processor:

     db2tx

The db2tx prompt is displayed; all subsequent commands are interpreted as Text Extender commands.

     db2tx =>

To leave this mode, enter QUIT.

For Windows 95 and Windows 98, you can use the db2tx command as described above, or you can click the Start button, point to Programs, point to DB2 Client for Windows 95/98, and then click DB2 Command Window.

If you leave out this step, you can issue Text Extender commands directly from the operating system prompt by prefixing them with db2tx. Here is an example of a command issued from the operating system prompt:

       db2tx enable database
Tip

If you are doing administration from a client, you must be in the Text Extender command environment and use the full form of the connect statement, specifying your user ID and password.

     db2tx => connect to database-name user user-id using  password

Connecting to a database

Summary

When
Optional. To start an administration session with a database other than the default specified in the DB2DBDFT environment variable.

Command
CONNECT

Authorization
CONNECT on the database

Before you can issue further administration commands in a Text Extender session, you must be connected to a database . You can connect to a database explicitly using the Text Extender CONNECT TO command. If you issue an administration command without being connected to a database , Text Extender connects you to the default database specified in the DB2DBDFT environment variable.

     db2tx "CONNECT TO sample-database"

The following is displayed (as seen on AIX):

     >------------Database Connection Information ------------<
     Database Product     = DB2/6000 05.02.0000
     User                 = user-name
     Database alias       = sample-database

Note:If you subsequently issue a Text Extender command outside of the command processor by prefixing it with db2tx, the current database connection is lost and a new connection is made to the default database .

If you are using an OS/2 client, and this is the first time that you are connecting to a database after you have started the system, you are prompted for a user ID and a password by User Profile Management (UPM). If you are already logged on, UPM takes the user ID and password from this session and tries to connect to the remote database on the server.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]