Environment: Red Hat or SUSE Linux
Installation Steps:
- On your linux machine, create a new user 'sybase'
- Switch to this new user, create the database installation directory (e.g. /databases/sybase)
- Create another folder for the installer (e.g. /databases/installation)
- Upload and unzip the installer
$ unzip sqla1201linux3264_advanced.zip
- Folder structure after unzip
$ ls -al
total 421004
drwxr-xr-x 4 root root 4096 Jan 25 11:00 .
drwxr-xr-x 6 sybase dba 4096 Jan 25 10:59 ..
-r--r--r-- 1 root root 0 Feb 1 2011 linux-x86-x64
dr-xr-xr-x 8 root root 4096 Feb 1 2011 monitor
-r--r--r-- 1 root root 387 Feb 1 2011 readme.txt
-rw-r--r-- 1 root root 431087213 Jan 25 11:00 sqla1201linux3264_advanced.zip
dr-xr-xr-x 8 root root 4096 Feb 1 2011 sqlanywhere
- Under the 'Sybase' user, start the installer
$ ./sqlanywhere/setup
- Follow the on-screen instruction
7.1. Press ENTER
7.2. Select the country you are in
7.3. In the terms of license screen, click q to skip, then type Y to agree
7.4. Type 1 for new installation
7.5. Enter license key
7.6. Select the components you’d like to install
7.7. Once everything is selected, type S to continue
7.8. Enter your desired installation directory (the one you created in step 2)
7.9. Finally, confirm and start the installation
- After the installation is completed, go to the installation directory, you should see the following files and folders:
$ ls
bin32 demo.db java readme_de.txt res selinux tix bin32s demo.log lib32 readme_en.txt samonitor.db sun ultralite bin64 deployment lib64 readme_ja.txt samples support uninstall.sh bin64s install_20130125-1107.log mobilink readme_zh.txt scripts vcsagent charsets installed.ini readme relayserver sdk thirdpartylegal
New Database Configuration Steps:
- Under the new ‘sybase’ user, edit .bash_profile
$ vim ~/.bash_profile
add the following lines:
LD_LIBRARY_PATH=/databases/sybase/SQLAnywhere/12.01/lib64
export LD_LIBRARY_PATH export LANG=en_US.utf8
- Logout from Sybase user and log in again to apply new profile
- Check that the new environment variables are added
$ env | grep LANG
LANG=en_US.utf8
$ env | grep LD
LD_LIBRARY_PATH=/databases/sybase/SQLAnywhere/12.01/lib64
- In your SQL Anywhere installation directory, create a new folder for your new database
$ mkdir <database_name>
- Create temp folder in database directory
$ cd <dir_from_step_4>
$ mkdir tmp
- Source SQLAnywhere environment
$ source <installation_dir>/bin64/sa_config.sh
- Learn dbinit options
$ </installation_dir><installation_dir>/bin64/dbinit -h
- Go to your new database folder, create startup script
$ vim init.conf
copy and paste the following lines:
-p 8192
-ze utf8
-dba <admin_username>,<password>
-dbs 2G
-o <dir_from_step_4>/output_msg.trc
-t </dir_from_step_4><dir_from_step_4>/transaction.log
-m </dir_from_step_4><dir_from_step_4>/transaction_mirror.log
</dir_from_step_4><dir_from_step_4>/data.db
- Initialize new database
$ <installation_dir>/bin64/dbinit @<dir_from_step_4>/init.conf
- Learn dbsrv12 options
$ <installation_dir>/bin64/dbsrv12 -h
- Create new database configuration parameters file
$ vim <dir_from_step_4>/db.conf
copy and paste the following lines:
-ud
-n <new_db_name>
-x "tcpip (PORT=65000)"
-gm 64
-c 128M
-ch 512M
-dt <dir_from_step_5>
-gn 10
-o <dir_from_step_4>/sysa12d01.trc
-os 10M
-ze
-zl
-zp
-zt
-cs
</dir_from_step_4><dir_from_step_4>/data.db
- Start db server
$ <installation_dir>/bin64/dbsrv12 @<dir_from_step_4>/db.conf &
- Stop db server
$ <installation_dir>/bin64/dbstop –y –c “eng=<new_db_name>;uid=<admin_username>;pwd=<password>”
