Configuration work after Sybase is installed

Source: Internet
Author: User
Tags stop script sybase sybase database administrator password

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.