0% found this document useful (0 votes)
119 views18 pages

Sybase

The document provides an introduction to the Sybase database including its history and components. It describes the system databases that come pre-installed with Sybase Adaptive Server Enterprise including the master, model, sybsystemprocs, sybsystemdb, tempdb, and dbccdb databases. It also outlines the responsibilities of a database administrator which include installing and managing Sybase databases, user accounts, backups and restoring databases, and monitoring performance.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
119 views18 pages

Sybase

The document provides an introduction to the Sybase database including its history and components. It describes the system databases that come pre-installed with Sybase Adaptive Server Enterprise including the master, model, sybsystemprocs, sybsystemdb, tempdb, and dbccdb databases. It also outlines the responsibilities of a database administrator which include installing and managing Sybase databases, user accounts, backups and restoring databases, and monitoring performance.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 18

By R.N. Sangwan-www.rnsangwan.

com
To Learn or Teach visit www.theskillpedia.com
• Introduction to Sybase database
• Define Components of Sybase SQL
• System Databases
• Responsibilities of a Database Administrator

Ram N Sangwan Visit www.hometutor.net.in for more.. 2


 Sybase was founded in 1984 by Mark Hoffman, Bob Epstein, Jane Doughty
and Tom Haggin in Epstein’s home in Berkeley, California.
 Currently Sybase is an SAP company.
 At first it was Known as “Sybase SQL Server”
 Microsoft and Sybase shared the source code after they parted ways.
 Sybase SQL Server 4.9 and MS- SQL Server 6.0 & 6.5 were virtually
identical. Till date the similarity can be seen in the T-SQL and basic process
architecture.

Ram N Sangwan Visit www.hometutor.net.in for more.. 3


Ram N Sangwan Visit www.hometutor.net.in for more.. 4
 Adaptive Server Enterprise is a client/server model.
 The client process which is running on a machine can communicate with a
database server which is available on the same machine or on a different
machine.
 Adaptive Server is executed as an application.
 The hardware that OS runs on, is transparent to Adaptive Server.
 What is visible to Adaptive Server is only user interfaces of the OS.

Ram N Sangwan Visit www.hometutor.net.in for more.. 5


Adaptive Server has two components :
 DBMS component: To process SQL statements, accesses data. and
 Kernel component: uses OS services for:
 process creation and manipulation
 device and file processing
 inter-process communication.

Ram N Sangwan Visit www.hometutor.net.in for more.. 6


Adaptive Server, when installed, comes with the following system databases:
 Master
 Model
 sybsystemprocs
 sybsystemdb
 tempdb
 dbccdb

Ram N Sangwan Visit www.hometutor.net.in for more.. 7


master database -
• Is used to control the operations of Adaptive Server.
• It stores information about all user databases along with their database
devices
model database –
• It gives a template for new user databases
• It has required system tables for each user database.
• We can alter model to customize structure of newly created databases.
• Everything we do to model will also be reflected in each new database.

Ram N Sangwan Visit www.hometutor.net.in for more.. 8


sybsystemprocs database –
The system procedures are stored in database, sybsystemprocs.
• When any user runs a system stored procedure, Adaptive Server looks for
that procedure in the user’s current database.
• If it is not found there, then Adaptive Server looks for this procedure in
sybsystemprocs.
• If there also it is not found, then Adaptive Server looks for the procedure in
master.
tempdb database -
It provides a storage area for temporary tables and other temporary working
storage needs.
The space in tempdb is shared among all users of all databases on the server.

Ram N Sangwan Visit www.hometutor.net.in for more.. 9


Sybsystemdb: has information about distributed transactions.
• Adaptive Server has transaction coordination services for transactions that get propagated
to remote servers.
• To achieve this, it uses remote procedure calls (RPCs) or Component Integration System
(CIS).
• Information about the remote servers used in distributed transactions, is recorded in
syscoordinations table.

Ram N Sangwan Visit www.hometutor.net.in for more.. 10


Optionally, you can install:
• The auditing database, sybsecurity
• The sample databases, pubs2 and pubs3
• The dbcc database : Tables used for input and output for the DBCC CHECKSTORAGE
commands.
• The Job Scheduler database, sybmgmtdb.

Ram N Sangwan Visit www.hometutor.net.in for more.. 11


• All communications with the server is via Sybase OpenClient/OpenServer
TDS (Tablular Data Stream) protocol on TCP/IP networks.
Read More at https://en.wikipedia.org/wiki/Tabular_Data_Stream
• All client connectivity uses TDS protocol natively.
• Client connectivity layers include: OpenClient (native), JDBC (Type 4),
ODBC, OLEDB, ADO .Net, Ruby, PERL
• Interoperability with Microsoft TDS and jTDS is not certified or supported
• Direct definition, interfaces/SQL.ini and directory services (LDAP/AD) are
supported for defining servers and connections
• IPv4 and IPv6 supported

Ram N Sangwan Visit www.hometutor.net.in for more.. 12


Ram N Sangwan Visit www.hometutor.net.in for more.. 13
• Sybase Control Center
A Web based utility to manage Multiple Servers and other resources and monitor servers
and memory.
• DBISQL
GUI Command line tool
• ISQL
Terminal type command line tool
• BCP
A bulk data copy program. Moves data between database tables and flat files.
• Sybmigrgate
Move schema and data from one ASE server to another
• sqldbgr
Utility to help debug stored procedures and triggers

Ram N Sangwan Visit www.hometutor.net.in for more.. 14


• Dsedit
Interfaces and sql.ini graphical editor
• Optdiag
Displays optimizer statistics for database tables
• Ddlgen
JAVA based tool the reverse engineers DDL for objects in the database
• srvbuild (Unix/Linux)
Interactive utilities for building new ASE and supplemental servers
• srvbuildres (Unix/Linux)
Non-interactive utilities to build ASE and supplemental servers from resource (.res) files

Ram N Sangwan Visit www.hometutor.net.in for more.. 15


• Installing SAP ASE and Backup Server
• Creating and managing SAP ASE login accounts
• Granting roles and permissions to SAP ASE users
• Managing and monitoring the use of disk space, memory, and connections
• Backing up and restoring databases
• Diagnosing system problems
• Configuring SAP ASE to achieve the best performance

Ram N Sangwan Visit www.hometutor.net.in for more.. 16


System administrators may also assist with certain database design tasks that
overlap with the work of application designers, such as enforcing integrity
standards.

Although a system administrator generally concentrates on tasks that are


independent of the applications running on SAP ASE, he or she is likely to
have the best overview of all applications.

Ram N Sangwan Visit www.hometutor.net.in for more.. 17

You might also like