Sybase命令集（国外英文资料）.docVIP

Sybase命令集（国外英文资料） Sybase_isql command collection (1) Shutdown with nowait go - - close the sybase service Shutdown SYB_BACKUP (service name) - - close the sybase service Sp_helpserver go -- -- view the service name Select @version go -- - view the sybase version 5, sp_version -- -- view the sybase version Id root -- - view the users attributes The kill -9 process number (which can be queried from the view service name command) -- directly kills the sybase process The sp_password null, lonton go - sets the password for the sa user The sp_helpdevice go -- -- view the data device information for sybase Select name, phyname, vdevno, low from master.. Sysdevices where name = master go 10, use master go Disk init Name = spamms, Physname = / opt/sybase/data/spamms. Vdevno = 6, Size = 100 m Cntrltype = 0 go - - creates the database device The sp_diskdefault spamms, defaulton/defaultoff go - sets the device as the default device and vice versa. Drop database spamms go -- -- delete the database 1 sp_dropdevice spamms 2 go - - delete the database device 1 sp_configure number of devices, 25 2 go - - modify the largest virtual device number 1 sp_configure disable disk mirroring go - - check the value of the mirror device for a non-mirrored device 1 sp_configure disable disk mirroring 0 2 go - - activation image (restart) The use master go -- -- use the main device Disk mirror Name = spamms -- the device name that needs to be mirrored Mirror = / opt/sybase/spamms. MRR - - mirror physical file system The weites = serial/ noserial - writes in serial and parallel Go -- -- mirror database device 18, disk unmirror Name = spamms Go -- - stop the image operation 19, disk remirror Name = spamms Go -- - restore the image operation The sp_helpdb/spamms (database details) go -- -- view the database information 21, create database spamms on spamms = 30 meters, spamms1 = 40M Go -- create a database on two data devices The create database spamms on spamms = 30 m, spamms1 = 40M log on