Archive for the ‘Sybase’ Category

Create table in Sybase

Few rules to create table in Sybase: To create table user must added to the database. To create table user must be granted create table permission on the database. To create table in a database, use database_name . There are can be 2,000,000,000 tables per database. 1) Add user to the database 1> use k2schools […]

Create temporary tables in sybase

General Rules and Information about temporary tables: Temporary tables are created in tmpdb database. To Create temporary table, we must have create table permission in tempb database. To Create temporary table, we can use #(pound) in front of tablename or use tempdb..table_name. If we don’t use # (Pound) symbol or tempdb.., then table is created […]

How to create physical devices in Sybase

Sybase devices are storage areas, which are necessary for creating databases. A database can have one or more devices and single device can be used for multiple databases. The device information is stored in master database. When we install server, master device which is used for master database and sysprocsdev which is used for sybsysteprocs […]

How to start Sybase Database

If we have installed Sybase ASE on your host serever. By Sybase ASE is not started. We have to start the Sybase ASE server by using RUN_files(RUN_Server_Name and RUN_Server_BS). To check whether the Sybase database started or not run the following command. ps -eaf | grep dataserver To start the Sybase database server: 1. Navigate […]

Sybase Installation on Linux

Sybase ASE is RDBMS database. Most of finance institutions are using sybase as their database product. Sybase Installation on Linux Step by Step guide: Download Sybase ASE software from SAP Site, then unzip the ase160_linuxx86-64.tgz. 1. Open the terminal and navigate to Sybase ASE extracted file. 2. Then, run the setup.bin file to start Sybase […]

How to check the long running transaction in Sybase ASE

If the transactions are running more time means, those transaction consumes the memory. If it is non-critical we can kill the respective process. Step by step process Process for “How to check the long running transaction in Sybase ASE”: 1) Login into isql utility: isql -U[user_name] -S[server_name] -w9999 -PPassword 2) We can find the long […]

Sybase dbccdb database Installation

DBCC(database consistency checker) Using dbcc, we can check the logical and physical consistency of a database. Sybase DBCC database installation: By default DBCC database is not installed in Sybase ASE. We have to install this manually(using script). 1. To check whether the dbccdb has installed or not: 1> use master 2>go 1> select name from […]

bcp command in sybase

bcp: The bulk copy program(bcp) is command line utility which copies data from a table/view to OS file or from OS file to a table/view. If we are copying data from a OS file to a table/view, the data is appended to existing data in the table. If we we copying data from a table/view, […]

How to change database ownership in Sybase

SAP ASE database ownership can changed using sp_changedbowner system stored procedure. Syntax: sp_changedbowner loginame [, true ] Example: 1> use k2admin 2>go 1> sp_changedbowner admin 2> go Conditions to change the Database owership:

How to create database in Sybase

Database is collection of objects like tables, indexes, triggers, views, stored procedures, system tables.. etc. BY default master, model, tempdb, sybsystemprocs, syssystempd databases are created when SAP ASE is installed. To create database, we must have device existed. If you devices are not created yet, Create Physical Devices now. It is good practice to cretae […]

Powered by k2schools