Archive for the ‘Sybase’ Category

How to rename database in Sybase

Stored procedure sp_renamedb is used to change the user database. sp_renamedb dbname, new_name Where dbname is existing database name. new_name is the new database name.

Replication Basic Commands in Sybase

Replication is an ongoing process of transferring completed transactions from primary database to the replicated database reading from the transaction logs creating an inbound and distributing the data through the outbound queue. Replication Basic Commands in Sybase admin who_is_down:it shows which servers are down admin who_is_up : it shows which servers are up admin who:shows […]

Create Role and assign permissions in Sybase

Roles are collections of privileges that allow the role user to perform their jobs. Roles can be created and granted to users, login profiles, or other roles by a system security officer. There are 16 default roles in ASE. sa_role sso_role oper_role sybase_ts_role navigator_role replication_role dtm_tm_role ha_role mon_role js_admin_role messaging_role js_client_role js_user_role webservices_role keycustodian_role sa_serverprivs_role […]

Difference between delete and truncate

Delete: Whenever we are using delete from tablename, then automatically deleted data internally stored in buffer. We can get it back by using rollback command.

Lock and Unlock user account in Sybase

What happens if account is locked? 1. User can not login. 2. If any schedule jobs with specified login. When login can be locked. 1. When maximum failed login attempts reached. 2. If password expires 3. System Security Officer locks login 4. Accounts are locked due to account inacrivity. How to know account is locked […]

Change password in Sybase

When password needs to changed? 1. If we forgot password. 2. When password expiration level reached(If customized). By default option is set to ever expiry password. What are the prerequisites to change password? 1. Caller password(Whoever is changing password of other user or him/herself) 2. Only System Security Officer can change the password. Syntax to […]

Sybase Interview Questions

How to stop Sybase(ASE) Server? 1> shutdown RUN_Servername 2> go How to stop Sybase backup server? 1> shutdown SYB_BACKUP 2> go How to start Sybase ASE server? To start the server Sybase ASE server, navigate to …./ASExxx/install/. Then, run following command 1> startserver –f RUN_servername 2> go How to start Sybase Backup server? To start […]

How to stop Sybase server forcefully

Sometimes it is required to shutdown the Sybase ASE server forcefully. This can be done with “shutdown with no wait” command. This disables the logins, does not issue checkpoint, and it terminates current transactions (processes). To stop Sybase server forcefully:

Stop and Start Sybase Replication Server

Replication Server maintains replicated data in multiple databases while ensuring the integrity and consistency of the data. It provides clients using databases in the replication system with local data access, thereby reducing load on the network and centralized computer systems. Stop Sybase Replication Server. We can stop replication server using isql utility.

Powered by k2schools