Sybase Central is a graphical user interface (GUI) management tool. Sybase Central accepts a variety of “plug-ins” that allow you to manage specific Sybase products. The Adaptive Server plug-in allows you to manage Adaptive Server and helps you perform complex administration tasks without the need to remember the syntax of Transact-SQL commands or system stored procedures.

一.Installing Adaptive Server Sybase Central Plug-in

1.Download Adaptive Server Sybase Central Plug-in  from sybase website.For AIX,the package name is EBF20414.tgz.Ensure that you have a account on sybase website then you can download it.

2.Login as user sybase to install.

  1. #cd /u01/tmp2 
  2. # gunzip -S .tgz EBF20414.tgz|tar xf - 
  3. #su – sybase 
  4. $cd /u01/tmp2/ebf20414 
  5. $ ./setup.bin 
  6. Preparing to install...  
  7. Extracting the JRE from the installer archive...  
  8. Unpacking the JRE...  
  9. Extracting the installation resources from the installer archive...  
  10. Configuring the installer for this system's environment... 
  11.  
  12. Launching installer... 

p_w_picpath

p_w_picpath

p_w_picpath

p_w_picpath

p_w_picpath

p_w_picpath

After above,click done to finish installation.

二.Starting and stopping sybase central

1.Excute /sybase/shared/sybcentral600/scjview.sh script to start.

  1. $ /sybase/shared/sybcentral600/scjview.sh 

p_w_picpath

Click connect from file menu:

p_w_picpath

Enter User name and Password connect to Sybase server then you can do followint things.

p_w_picpath

p_w_picpath

2.Click Exit from file menu to stop sybase central.

三.Performing common tasks

1.Create a database:

Right-click database folder.The Create a New Database wizard opens.

(1).Enter database name:

p_w_picpath

(2).Specify the device for database mydb.

p_w_picpath

(3).Using override option for mydb.

p_w_picpath

(4).Using full level for mydb.

p_w_picpath

(5).Summary

You can click preview to view SQL Language.

p_w_picpath

Click finish to create mydb database.

2.Add a user

Right-click logins folder,The Create a New User wizard opens.

p_w_picpath

Specify the default database for user candon:

p_w_picpath

Click finish to create user candon.

For more information:

1.Managing and Monitoring Adaptive Server