Posts Tagged ‘Sybase ASE’

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 […]

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 […]

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.

How to run script in Sybase

We can create scripts and execute using isql. This is useful when you need to execute the same set of commands. Script execution Syntax: isql -Uuser_name -Ppassword -Sserver_name -iscript_name -oscript_output How to create scripts: Create text file and paste the commands to be executed on SYBASE ASE. root$vi databaseslist.txt select name from sysdatabase go :wq!

isql history

What is isql? isql tool is interactive parser to ASE(Sybase). isql tool sends commands to ASE and displays the results on standard output. Syntax: isql [-b] [-e] [-F] [-n] [-p] [-v] [-W] [-X] [-Y] [-Q] [-a display_charset] [-A packet_size] [-c cmdend] [-D database] [-E editor] [-h header] [-H hostname] [-i inputfile] [-I interfaces_file] [-J client_charset] […]

Restore Master database in Sybase

Why master database? The master database controls the operation of Sybase(ASE) server and stores information about all user databases and database devices information. It stores User accounts, Remote User accounts, Ongoing process, System Error Messages, List of databases on Sybase server(ASE), Active locks,Character-sets, Server Roles, etc. If we want to create new database, we should […]

Get Sybase Database Information

We can get the information about databases and its objects using sytem procedures, built-in functions and system tables. sp_helpdb reports database(s) information like name,db_size,owner,dbid,created,durability,status. To get list of databases in ASE: We can get the list of databases(system and user databases) either using sp_helpdb or sysdatabases. Sysdatabases table gives us more information than sp_helpdb, but […]

Powered by k2schools