/text/shared/explorer/database/30000000.xhp Sun Microsystems, Inc. UFI: fixed #i21955# FPE: Switched for SO only (#i10510#) Adabas D Database The Adabas D database that you may have installed together with $[officename] is a limited version of the database. For more information on Adabas, visit the Software AG Web site at http://www.softwareag.com/adabas/. About Adabas The Adabas database that you may have installed together with $[officename] is restricted to a size of 100 MB, and a maximum of three users on a network. See the "License.txt" file in the Adabas directory for more details. The Adabas database must be installed in a separate directory from $[officename]. The name of an Adabas file cannot exceed 8 characters. The path to the Adabas file, including the file name, cannot exceed 30 characters, and must be compliant with the 7-bit ASCII code. Both the path and the file name cannot contain spaces. Under Windows, the Adabas setup application adds the DBROOT environment variable that contains the path information for the database. If the setup application finds this variable, it does not install the database. Create New Adabas Database Use the Create New Adabas Database dialog to create an Adabas database: Choose File - New - Database to open the Database Wizard. Click Connect to an existing database, and then select "Adabas" in the listbox (scroll up in the listbox). Follow the remaining pages of the Database Wizard. Deleting an Adabas Database To delete the reference to an Adabas database, choose Tools - Options - %PRODUCTNAME Base - Databases. Select the database, and then click Delete. To delete an Adabas database: Determine which directories are referred to by the system variables DBCONFIG and DBWORK. Under Windows these variables are defined in the system settings or in the c:\Autoexec.bat file. Under Unix these variables are defined in a start script. In the $DBCONFIG$ directory, delete the three files that have the same name as the database, but with different extensions. For example, for a database named "Big", delete the "Big.sys", "Big.trs", and "Big.dat" files in the "C:\Adabas\". In the $DBCONFIG$\Config directory, delete the file that has the same name as the database, for example, " C:\Adabas\Sql\Config\Big". In the $DBWORKS$\Wrk directory, delete the directory that has the same name as the database., for example "C:\Adabas\Sql\Wrk\Big". Starting and Shutting Down an Adabas Database strt -d <DBNAME> -NoDBWindow -NoDBService switches the database to COLD. xutil -d <DBNAME> -u <CONTROLUSER>,<CONTROLPASSWORD> shutdown switches the database to COLD. xutil -d <DBNAME> -u <CONTROLUSER>,<CONTROLPASSWORD> restart switches the database to WARM. stp -d <DBNAME> -NoDBService completely shuts down the database Error Messages in an Adabas Database The following is a list of possible error messages and solutions for working with the Adabas D database. The database cannot be shut down / restarted as a user is still connected to it. Close any other open tasks that show the database contents. On multi-user systems, ensure that all users are disconnected from the database, and then restart $[officename]. Client unable to establish connection; -813 SERVERDB MUST BE RESTARTED This error occurs if you try to access an Adabas D database that has not been started. Ensure that you have defined a Control User for the database, and then start the database. Client unable to establish connection; -8022 USER ALREADY CONNECTED This error occurs if you try to access an Adabas D database more than one time. Errors occurring when writing the data in the database Restart $[officename], and then change the database properties. Running an Adabas Server on a Network To run Adabas on a network, you need to install the Adabas server on one machine and the client on the workstations that you want to access the database from. You can only create a new database on the server. Enabling a Remote Connection Under Windows, start the xtcpupd.exe support program on both the client and the server, and ensure that "Remote SQL via TCP/IP" is selected in the xtcpupd.exe dialog. On the server, start the x_server program in adabas\bin Adabas\bin directory. Choose File - New - Database. Click Connect to an existing database, and select "Adabas D" in the listbox. Click Next. In the Name of the Adabas D database box, enter the name of the server, a colon, and the name of the database on the server, for example, computername:database. Fill in the remaining pages of the Database Wizard. Adabas D by Software AG is installed when you install the commercial office software by Sun Microsystems, Inc. If you are using OpenOffice.org software, the Adabas D software package can be downloaded and installed separately (see www.adabas.com).