Posts Tagged ‘Sybase ASE’

The maximum number of configured devices has already been reached

Following error recieved when tried to create raw device in the server. disk init name=’data43′, physname=’/data/devices/sb_device_data43′, size=’40000M’ Msg 5162, Level16, State1: Server ‘SKN_UAT1’,Line1: The maximum number 42 of configured devices has already been reached. Please reconfigure ‘number of devices’ to a larger value and retry disk initialization. Solution:The maximum number of configured devices has already […]

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

Powered by k2schools