SYBASE: sybase Basics

SYBASE: sybase Basics

(1) Historical versions of sybase;

Sybase server 1.0 2.0, Sybase openclient/openserver, Sybase system 10, sybase replication server, Sybase SQL server 11.0, Sybase ase 11.5, Sybase ase 11.9.2, ase 11.9.3, ase 12.0, ase 12.5, ase 15.5, ase 15.7.

(2) sybase dbms

Login: the default user is sa and the password is sybase.

--- Corresponding to oracle dba: sysdba/oracle

(3) Relationship between sybase Database devices and databases:

--- Corresponds to oracle Database Files: Relationship between data files and tablespaces

(4) sybase master database:

--- Corresponding to the oracle system tablespace

(5) sybase database creation:

--- Corresponding to creating a tablespace in oracle

(6) sybase database creation process;

Step 1: Initialize the database devices u2 and u2_log:

Disk init

Name = "u2 ",

Physname = "C: \ opt \ Sybase \ data \ u2.bat ",

Vdevno = 7,

Size = 10240

Go

Disk init

Name = "u2_log ",

Physname = "C: \ opt \ Sybase \ data \ u2_log.bat ",

Vdevno = 8,

Size = 10240

Go

Step 2: view the database Device

Sp_helpdevice u2_log

Step 3: Create a database

Create database u2

On u2 = 12

Log on u2_log = 12

For load

(6) sybase deletes the database device;

Sp_dropdevice u1_log

(7) sybase system database type:

Master database, model database model, system process database sybssystemproces, security audit database sybsecurity, temporary database tempdb

(8) sybase Database User Type:

Sa Super User, dbo database owner, database object owner, database common user

(9) isql tool:

Supports sp_dropdevice, drop, truncate, update, and other statements.

(10) backup tools

Bcp, ddlgen

(11) sybase system table:

--- Equivalent to the wide les Data Dictionary

Sysdatabase, sysdevices, syslogins, sysobjects, and sysusers; each database is also in table structures such as user_devices and user_users.

(12) configure the sybase client connection (dedite)

--- Equivalent to the netca: network manger of oracle

Including service name, server services, and other information

(13) Client connection interface file SQL. ini:

--- Equivalent to tnsnames. ora of oracle

SQL. ini format:

[CLARKPC_XP]

Master = NLWNSCK, clark-PC, 5002

Query = NLWNSCK, clark-PC, 5002

[CLARKPC]

Master = NLWNSCK, clark-PC, 5000

Query = NLWNSCK, clark-PC, 5000

[CLARKPC_BS]

Master = NLWNSCK, clark-PC, 5001

Query = NLWNSCK, clark-PC, 5001

[CLARKPC_JSAGENT]

Master = NLWNSCK, clark-PC, 4900

Query = NLWNSCK, clark-PC, 4900

Format:

Master-Used for server startup;

Query-Used when the client establishes a connection

 

(14) sybase database parameter configuration file sybase. cfg:

--- Equivalent to pfile and spfile of oracle

Maximum shared memory: max memeory: page * 2 K.

Adaptive server execution program: Not in max memory

Server struct: stores user connection information, database information, lock information, and can be configured. (Pga)

Cache memory allocation

Sp_cacheconfig "default data cache", "1000 M

Sp_cacheconfig "procedure cache size", "1000 M

(15) view database information:

Select * from sysdevices

Sp_helpdevice

Select * from sysdatabases;

Select * from sysusages: dbid

Sp_helpdb u2

Select db_name (4)

(16) monitoring database space usage

 

Sp_spaceused

Sp_hel1_gment

 

(17) monitoring user logon:

Sp_displaylogin sa

Select * from syslogins;