Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / prabhu
The Sybase Server
A Sybase server consists of:
a) Two processes, data server and backup server.
b) Devices which house the databases; one database
(master) contains system and configuration data.
c) A configuration file which contains the server
attributes.
Memory Model
The Sybase memory model consists of:
a) The program area, which is where the dataserver
executable is stored.
b) The data cache, stores recently fetched pages
from the database device.
c) The stored procedure cache, which contains
optimized sql calls.
A database device stores the objects that make up
databases.
The term device does not necessarily refer to a
distinct physical device: it can refer to any piece of a
disk (such as a disk partition) or a file in the file
system that is used to store databases and their objects.
Each database device or file must be prepared and made
known to Adaptive Server before it can be used for database
storage. This process is called initialization.
A segment is a label that points to one or more database
devices. When you first create a database, Adaptive Server
creates three segments in the database,
System: Stores the database?s system tables.
Logsegment: Stores the database?s transaction log.
Default: Stores all other database objects?unless you
create additional segments and store tables or indexes on
the new segments by using create table...on segment_name or
create index...on segment_name
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What you need to do is issue an ase kill command on the connection then un-suspend the db?
How do I create a database in sybase central?
What is server replication?
What is the difference in storage type of numeric and decimal data types in sybase ?
We have lost the sa password, what can we do?
How does sybase replication work?
Tempdb is full. How would you clear it?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
Explain the structure of adaptive server enterprise?
A single operation is failing to escalate?
What is sybase infomaker?
How would you configure identities in sybase?
How to divide by zero and nulls in sybase?
How do I add a sybase driver to sql developer?
Can I use a named pipe to bcp/dump data out or in in sybase?
