SuSE GmbH

SuSE Support Database

Title: Adabas D - Howto

----------

Mainpage o Searchform o History o Versions o Categories o Contents
Deutsch

----------

Adabas D - Howto

Installing Adabas D and putting it into operation

Request:

You want to install Adabas D from CD and set up a database. The description is supposed for version 11.0 but most things are still right for the previous versions.

Procedure:

Installation

Mount the CD-Rom as user root readonly and executable. Now you can start the installation program from CD. Use the following mount command :
   mount -t iso9660 -o exec,ro /dev/cdrom /cdrom
Is is also possible to execute mount /cdrom as a normal user, if the user option and the other options mentioned above are specified in /etc/fstab for the CD-Rom. Please note, that activating the user option automatically sets the CD-Rom to noexec. It is therefore necessary to explicitly use the -o exec option.

In addition you should create a new user for the database. E.g., you might want to create a user adabas with group database. It is of course possible to choose arbitrary names.

If the database gets started by the user root, the kernel aborts with the following message :

   09.11-10:52:15   675 -11987 ABEND: Server should not run as superuser
The name of the user must later be specified in the installation program. You should also modify the .profile of that user :
   export DBROOT=/opt/adabas
   export PATH=$DBROOT/bin:$PATH
The user can then call the Adabas utilities without an absolute path. The variable DBROOT must contain the Adabas installation directory. If the export commands are entered into the /etc/profile, then they are valid for all users.

It is also a good idea to recompile the kernel. It is necessary to increase the variable SHMMAX in /usr/src/linux/include/asm/shmparam.h. Search for a line that starts with #define SHMMAX. The value that is specified there (0x1000000) corresponds to hexadecimal 16 MB. Adabas D uses a huge shared memory segment even for small databases. In most cases it is enough to set this variable to 0x2000000. With this setting the system has a segment of 32 MB at its disposal. If the segment is too small, the database kernel will abort with the following error message :

   09.05 14:19:33  2482 -11070 creating shared section size   18956288
   09.05 14:19:33  2482 -11987 sql41_create_shm: shmget error, Invalid argument
   09.05 14:19:33  2482 -11987 ABEND: cannot create kernel shared section
If all conditions mentioned above are fulfilled, you can start the installation. You should login as the database user (here adabas) and start the installation with /cdrom/install &. If you do the installation under X, it is necessary to allow other users the access to your X server using the command xhost +, before you change the user with su.

A window appears, in which you can set the installation options. First choose the packages that should be installed in the upper part of the window. It is recommended to install the first two topics as well as the documentation. The first package contains the database programs, the second a preconfigured sample database. The sample database is well suited to obtain experiences with the Adabas D handling. Then execute the steps 1-8 further below one after the other.

If you don't install under X a text based install is started automatically. For version 10, the following commands had to be executed manually :

   /cdrom/install.lnx
   x_install
When you've succesfully finished these steps, you can begin to "play" with the sample database MYDB. If you haven't installed the sample database, then a new database can be created using xcontrol. xcontrol upon startup asks you for the user name and the name of the database. Please enter a name for the control user here (the control user starts and terminates the database but cannot access the database directly) and the name of the database that should be created.

The following pages allow you to specify further details about the database. First you specify further settings for the users. The control user (see above) administers the database kernel. He starts and stops the database. The SysDBA administers the database itself, i.e. he can create users and tables. The tables of the data dictionaries belong to the domain user.

Attention : It is necessary to enter the passwords twice for verification purposes and non special characters are allowed.

The following pages specify the internal parameters of the database. You can make changes to the size of the database here. Please take care to change the following settings :

Usage of the database

There are only three possible states that the database can be in :

offline The database kernel isn't currently started.
cold The database kernel has been started, however the database doesn't accept user requests.
warm The database kernel has been started and accepts user requests.

If the database has the status warm, then it is possibe to access the database using the programs delivered with the system. This short introduction shall only give you an overview about the functionality of the individual programs. A detailed description can be found in the online documentation delivered with the system.

Version 11.0 program names:

adcontrol This program makes available a frontend written in TK under X. It can be used to put the database into different states.
adquery A query tool for X with TK frontend.
xcontrol Administration tool for the console.
xload A tool for the loading and unloading of database patterns and data
xquery See adquery. Query tool for the console.

Version 10 program names:

panel This program makes available a frontend written in TK under X. It can be used to put the database into different states.
tkquery A query tool for X with TK frontend.
xcontrol Administration tool for the console.
xeasy A query tool for endusers without any knowledge of SQL. Works according to the Query-by-Example principle.
xload A tool for the loading and unloading of database patterns and data
xquery See tkquery. Query tool for the console.

If any problems should arise please read the other articles concerning Adabas D in our support database.

Further information can also be found in the ADABAS D Online Documentation

----------

Keywords: ADABAS

----------

Categories: Adabas D

----------

Mainpage o Searchform o History o Versions o Categories o Contents
Deutsch

----------

SDB-adabas_d_howto, Copyright SuSE GmbH, Nuremberg, Germany - Version: 24. Aug 1998
SuSE GmbH - Last generated: 07. Oct 1999 16:28:05 by maddin with sdb_gen 1.00.0