Sybase knowledge needed for database administrator

Sybase Architecture is a client server architecture.The server is a single process at the os(operating system) level and takes about 40-60K physical memory. The server is called as ASE(Adaptive Server Environment) that has undergone several revisions and has been on 15.x.x version now Following are the few sybase commands needed to perform various tasks in the sybase server. 1) Identify a sybase process id : > sp_who > go 2) Kill a sybase process id : > kill (process-id) > go 3) Obtain information on sybase disk information : > sp_dkinfo > go 4) Alter database segment : >alter database db-name on segment-name = value 5) Information about a database : > sp_helpdb database-name 6) Make a logdump on a continuous fashion : > dump tran database-name to "/path of directory" 7) Truncate the transaction log without making a backup copy : > dump tran database-name with truncate_only 8) To truncate the log that is filled to the capacity : > dump tran database-name with no_log What is a sybase directory service? 1) A directory service is the service that manages the creation, modification(updation/deletion), retrieval of network service information 2) Oracle provides the file listener.ora to access information about the servers across networks 3) In case of sybase the configuration file $SYBASE/$SYBASE_OCS/config/libtcl.cfg is used for server-client communication Sybase ASE Adaptive Server Enterprise Get SQL Text For A Transaction : Sybase Architecture is a client server architecture.The server is a single process at the os(operating system) level and takes about 40-60K physical memory.The server is called as ASE(Adaptive Server Environment) that has undergone several revisions and has been on 15.x.x version now. Sybase ASE(Adaptive Server Enterprise) Get SQL Text For A Transaction can be achieved by following the steps given below: 1) Issue the following command : > dbcc traceon (spid of the process) > go If dbcc prints error messages, user with system administrator(SA) role can be contacted 2) Find the SQL text using the following command : > dbcc sqltext (spid of the process) > go This command displays the SQL Text of the transaction.