July 1st, 2000
This is the Private Edition of YARD-SQL. Everyone is permitted to
copy and distribute this kit (for instance placing it on FTPServer
or distribution CDs), as long as no modifications are made to it.
Usage of this kit is restricted to private use, which
means that it may not be used for sale or for commercial purposes
(In general, to make money off it).
THIS KIT STILL REMAINS PROPERTY OF YARD SOFTWARE GMBH, COLOGNE, GERMANY.
Contents of this README:
- What is the Private Edition ?
- Installation
- Support
- Further information
1) What is the Private Edition
The difference between this Private Edition and a regular version is that this Private Edition is limited to one user (Versions before version 04.06.00 have a database size limit of 5 MB; this limit no longer exists).
Depending on the distribution you will receive either one cpioed/tared file or a complete directory tree. A cpioed file is either compressed (.Z) or gzipped (.gz).
This kit includes a YARD-SQL development system
2) Installation
Follow the follwing steps to install the software:
- Login as root
- After extracting the tar archive you downloaded (or received otherwise) you'll find four files:
port????.tar
install
README
etc/portlist
3) Run "sh install". The menu driven script will
set up your system for using YARD-SQL.
Choose at least menu 1, which will install the software
(with a Private Edition serial number). For your convenience
menus 8 and 9 can be used for installing a sample DBS and
a YARD-SQL startup script.
6) The installation of the software is now completed
If you didn't install a sample DBS through menu 8 of the main installation program, you can create a DBS by following the following points:
- Login as user yard
- Modify .profile that it contains the following entries
YARDHOME=the directory You installed the software
YARDDBS=a name You can choose, e.g. mercury
YARDLANG=eng # for english message files
# the default is geriso (german)
# if you set YARDLANG to eng, you also
# have to set YARDNLS to eng!
PATH=$YARDHOME/bin:$PATH
export PATH YARDDBS YARDHOME YARDLANG
- Change to $YARDHOME/etc
- Copy STANDARD.cfg to $YARDDBS.cfg
- Modify $YARDDBS.cfg for your configuration (see below for a sample)
The device /dev/ryard3 is just an example for using a raw device.
You even can use a cooked file, that you created somewhere in the
filesystem e.g. with "touch <filename>".
Some operating systems (e.g. Linux) do not have Raw devices.
Use block devices in these cases.
- Initialize the DBS by "yardinit -q -v -i"
- Enter the dba password as you like, but don't forget it
- Change to online mode by "yardinit -o"
- Create a new user by "yarduser -a <username>"
- Create an entry "yardsql 1142/tcp" in /etc/services
and start yardnetd. yardnetd is required for all clients that
will connect through a network connection, eg. perl and ODBC.
- Now the system is ready to work.
- IMPORTANT: Don't forget to shut down the DBS before switching off
the machine by "yardinit -m" and "yardinit -s". Otherwise
your data may be damaged.
How you can use the system:
- The most simple way. Execute the server in batch mode, where it reads commands from a file and writes the output to stdout.
$ yardsrv -b - # Read from stdin
connect user dba [ using '<password>' ];
create database db1;
create table tab1 (col1 integer);
^D
- The more comfortable way. Start the program yardsql, which provides
a more dialog oriented interface.
- Write a C-program containing SQL-commands using the Precompiler
yardpc.
Sample configuration file:
#
# Sample Configurationfile for a database system
#
# All sizes in kB
DBSID
D 3
#
#
# Raw device used for storing data. If you don't have a free partition, just
# use a cooked file (e.g. /home/yard/dev/part1)
#
# dbspace device size offset
#
F ROOTDBS /dev/ryard3 20000 0
#
# Logfiles
# dbspace logfiles logsize (per logfile)
#
L ROOTDBS 4 200
#
# Physical Log
# logsize
#
P 500
#
# Tape devices
#
B /dev/null 20 1200000 T /dev/null 20 1200000
#
# Shared memory
#
# The shared memory base adress must be used depending on the platform:
#
# Unisys SYSVR4 0x80330000 # Onsite SYSVR4 0x80380000 # Unixware SYSVR4 0x80380000 # SCO UNIX 0x80400000 # Sparc/Solaris 0x00000000 # or # Sparc/Solaris 0x80400000 # Linux 1.2.9 0x80400000 # Linux 1.2.13 0x80400000 # RM 200/400/600 0x00000000 # HP 9000(PA-RISC) 0x00000000
#
# Users Locks Buffers Tables SHM Base adress
#
S 4 1000 300 160 0x80400000 10 1
#
# SQL-Server timeout Part of buffers for blob I/O (%)
#
O 0 10
#
# Checkpoint Number of Number of Physical Logical # interval page flusher LRU queues log buffer log buffer # (sec.) (1 or a (No. Pages) (No. Pages) # multiple of 2) C 300 1 4 32 8
#
# Backup buffer flusher # size (No. pages) rate (%) R 128 30
#
# end of configuration file
#
3) Support
Contact support@yard.de if you have any problems.
4) Further information
Additional information regarding product information and pricing is available from http://www.yard.de.
For any questions feel free to contact
YARD Software GmbH YARD Software Ltd. Wikingerstr. 18 - 20 Wikingerstr. 18 - 20 51107 Köln 51107 Cologne
FAX.: +492219886499 E-Mail: yard@yard.de