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.
- #cd /u01/tmp2
- # gunzip -S .tgz EBF20414.tgz|tar xf -
- #su – sybase
- $cd /u01/tmp2/ebf20414
- $ ./setup.bin
- Preparing to install...
- Extracting the JRE from the installer archive...
- Unpacking the JRE...
- Extracting the installation resources from the installer archive...
- Configuring the installer for this system's environment...
- Launching installer...
After above,click done to finish installation.
二.Starting and stopping sybase central
1.Excute /sybase/shared/sybcentral600/scjview.sh script to start.
- $ /sybase/shared/sybcentral600/scjview.sh
Click connect from file menu:
Enter User name and Password connect to Sybase server then you can do followint things.
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:
(2).Specify the device for database mydb.
(3).Using override option for mydb.
(4).Using full level for mydb.
(5).Summary
You can click preview to view SQL Language.
Click finish to create mydb database.
2.Add a user
Right-click logins folder,The Create a New User wizard opens.
Specify the default database for user candon:
Click finish to create user candon.
For more information:
