Red Brick RISQL, RISQL Reporter and rb_ctmu on a UNIX Client

Answer

INTRODUCTION

You can install the client tools risql, risql reporter and rb_ctmu on a UNIX server that does not have Red Brick Warehouse installed. Installing them allows you to connect to Red Brick Warehouses running on other computers.


BEFORE YOU BEGIN

Find out the name of the computer that is running the Red Brick Warehouse that you want to connect to. Use the name of that computer as it is given in the /etc/hosts file of the computer you are installing on.

Find out the port used by the Red Brick Warehouse that you want to connect to. This will be the number following the RB_HOST SERVER parameter in the rbw.config file on the computer that is running the Red Brick Warehouse.

Example:

Here is an excerpt from the rbw.config file for a server using port 5050


# The following is used to specify the communication port for connections
# to the Red Brick Warehouse rbwapid daemon.
RB_HOST SERVER 5050

1. Create the directory into which to install the programs.


mkdir redbrick_dir
redbrick_dir
Any valid UNIX directory name.

2. Change directories to the new installation directory


cd redbrick_dir

redbrick_dir
The directory you created in step 1.

3. Mount the Red Brick installation cd and execute the INSTALL.ISO script from it by entering this at the command line:


/cdrom/rbw/platform_name/INSTALL.ISO
cdrom
The directory where your CD-ROM device is mounted.
platform_name
Use the appropriate value from the following table.


Platform	Platform_Name
AIX	aix, aix644, aix645
Tru 64 UNIX	dec
HP-UX	hpx, hpx64
Solaris	sol, sol64
Silicon Graphics IRIX	SGI
Linux	lnx


4. Choose "Install Client Connectivity" (option 3) from the IBM Red Brick Warehouse Installation Menu.

5. Choose "Install RISQL Entry Tool, RISQL Reporter, Client TMU" (option 1) from the Red Brick Client Products Installation Menu.

6. At this prompt:


Install RISQL Entry Tool, RISQL Reporter,
Client TMU in current directory? (y|n) [y]:

Press y to install into the current directory.

7. At this prompt:


Do you want to use the following default locale?

English_UnitedStates.US-ASCII@Binary (y|n) [y]:

Press y to accept the default locale or n to select another locale. If you choose n you will be asked several questions to help you choose a locale.

8. At this prompt:


Enter the host name of the machine which is
running the Red Brick Warehouse you wish to connect to:

Enter the name of the of the computer where the Red Brick Warehouse that you want to connect to is running.

9. At this prompt:


Enter the TCP/IP port number used to connect to the
Red Brick Warehouse daemon [5050]:

Enter the TCP/IP port number used to connect to the Red Brick Warehouse.

10. Exit each menu that comes up by entering "q" at the command line prompt.

rbhost SERVER rbserver:port


rbhost
The name of the connection. By default this is RB_HOST.

rbserver
The name of the computer on which Red Brick Warehouse is running.

port
The number of the port where the Red Brick Warehouse is listening.


Example:


Here is an excerpt from the rbw.config of a client. The connection is named RB_HOST and it connects to a computer named RB_SERVER using port 5050.


# The following is used to specify the communication port for connections
# to the Red Brick Warehouse rbwapid daemon.
RB_HOST SERVER RB_SERVER:5050

risql -h host -d database username password


host
The client name for the connection to the server running the Red Brick Warehouse. This will be RB_HOST by default.

database
The logical database name as defined in the rbw.config file on the UNIX server running the Red Brick Warehouse.

username
Red Brick user name.

password
Red Brick password.


Example:


This shows a successful connection to the database aroma using the connection RB_HOST. The connection was made as the aroma default user named system, using the aroma default password manager.


$  risql -h RB_HOST -d aroma system manager
(C) Copyright IBM Corp. 1991-2002. All rights reserved.
RISQL Entry Tool Version 06.20.0000(0)
RISQL>