1. Configuring Database Parameters
- Configure Sybase maximum memory used by the database
Log in to the Sybase database server with the isql command-line utility, where servername is the Sybase server configured in the $sybase/interfaces file.
$ isql–usa–p–sservername
1>sp_configure ' Total Memory ', 614400 (unit 2k)
2>go
The above command configures Sybase to use 1200M of memory, typically configured as a 60-70% of system memory.
- Configure Sybase maximum number of engines that can be used by the database
sp_configure ' max online engines ', 2
Go
If the system CPU number is more than two configured to the system actual CPU number minus 1.
- Configure the maximum number of user connections available
sp_configure ' number of user connections ', 50
Go
- Configure the maximum number of available locks
sp_configure ' number of locks ', 100000
Go
Modify according to the actual requirements of the application. If you perform a large number of data insertions, updates, and deletions, consider increasing the number of locks.
- Configuring the number of stored-error procedure Caches
sp_configure "procedure cache size", 50000 (2K units)
Go
- Configure the number of objects, indexes, and partition descriptors that can be opened
sp_configure "Number of open indexes", 1000
Go
sp_configure "Number of open objects", 1000
Go
sp_configure "number of open partitions", 1000
Go
The above parameters depend on the number of tables in the actual application.
- Sybase server Start-up and stop
Start:
$ cd/sybase/ase-15_0/install
$ startserver–f run_servername
Stop it:
Isql–usa–p-sservername
1> shutdown
2> Go
2. Configure automatic startup, shutdown scripts for Sybase
- Configure Sybase start the script.
At the command line, edit the start_sybase.sh startup file as root.
#vi start_sybase.sh
The script reads as follows:
Su-sybase-l-C "/sybase/ase-15_0/install/startserver-f/sybase/ase-15_0/inst
All/run_syb_aix53 "
Sleep 35 (in seconds, depending on the time the field database starts)
Su-sybase-l-C "/sybase/ase-15_0/install/startserver-f/sybase/ase-15_0/inst
All/run_syb_aix53_bs "
Modify the permissions for the file to run.
#chmod start_sybase.sh
Note: on Aix under platform with Su when switching users, add-l option, or you cannot load Sybase environment variables.
- Configure the Sybase stop script.
At the command line, edit the stop_sybase.sh startup file as root.
#vi stop_sybase.sh
The script reads as follows:
Sybase=/sybaseexport Sybasesybase_ase=ase-15_0export Sybase_asesybase_ocs=ocs-15_0export SYBASE_OCSPATH=/sybase/ Ase-15_0/bin:/sybase/ocs-15_0/bin:/sybase/ase-15_0/install: $PATHexport pathlib=/sybase/ocs-15_0/libexport LIB/ Sybase/ocs-15_0/bin/isql-usa-p-ssyb_aix53 <<!shutdown Syb_backupgoexit!/sybase/ocs-15_0/bin/isql-usa-p- Ssyb_aix53 <<!use Mastergocheckpointgoshutdown with nowaitgo!
and modify the permissions for the file to run.
#chmod stop_sybase.sh
If the Sybase dual-machine server is configured, the operating system engineer adds both scripts to the script for the dual-machine hot-standby software. And by Sybase engineers and operating system engineers to complete the two-machine switching test work
3. Set the system administrator password
When you install the Sybase software, a user account named "sa" is created for the Sybase system administrator. Users who are logged on as "sa" can use any database on Adaptive server, including the master database, and have full permissions. The "SA" account does not have a password when a new installation has just been completed. The initial default value for the password is: NULL. In a production environment, Sybase system administrators should always use a non-default password.
The Sybase system administrator should log on to the new Adaptive Server as "sa" and use sp_password to set the password:
$SYBASE/$SYBASE _ocs/bin/isql-usa-p-sserver_name
1> sp_password NULL, New_password
2> Go
where "null" is the default password, New_password is the password assigned to the "SA" account. For maximum security, Sybase recommends that you set a password that contains at least eight characters, combined with uppercase and lowercase letters and numbers.
Configuration work after Sybase is installed