[Sybase] Sybase Foundation

(1) The historical version of Sybase;

Sybase Server 1.0 2.0, Sybase openclient/openserver, Sybase system, Sybase replication Server,sybase SQL Server 11.0, S Ybase 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, Password Sybase

——— corresponds to Oracle DBA User: Sysdba/oracle

(3) The relationship between Sybase database devices and databases:

——— the relationship to the Oracle database file: Data file and Tablespace

(4) Sybase Master Library:

——— The system table space that corresponds to Oracle

(5) Sybase Create library:

——— Create tablespace for Oracle

(6) Sybase building the library process;

The first step is to initialize the database device 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 two, view the database device

Sp_helpdevice U2_log

Step three, build the library

Create DATABASE U2

On u2=12

Log on u2_log=12

For load

(6) Sybase deletes database devices;

Sp_dropdevice U1_log

(7) Sybase system database type:

master database master, model database, System process database sybssystemproces, security Audit Database sybsecurity, temp database tempdb

(8) Sybase database user type:

SA super User, dbo database owner, database object owner, database normal user

(9) ISQL tools:

Support Sp_dropdevice,drop,truncate,update and other statements

(10) Backup tool

Bcp,ddlgen

(one) Sybase system table:

——— equivalent to the Oracles data dictionary

Sysdatabase,sysdevices,syslogins,sysobjects,sysusers, each database is also in the User_devices,user_users table structure

Configuration of Sybase client connections (dedite)

——— equivalent to Oracle's Netca:network manger

Includes service Name,server services and other information

(13) Client Connection interface file Sql.ini:

——— equivalent to Oracle's Tnsnames.ora

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 - for server startup;

Query - used when a client establishes a connection

Sybase database parameter configuration file sybase.cfg:

——— equivalent to Oracle's Pfile,spfile

Max shared memory: Max memeory: page *2k.

Adaptive Server Execution Program: not within Max memory

Server Structure: Store user connection information, database information, lock information, can be configured. (PGA)

Allocation of cache memory

Sp_cacheconfig "Default data Cache", "1000M

Sp_cacheconfig "Procedure cache Size", "1000M

(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 the use of database space

sp_spaceused

Sp_helpsegment

(17) Monitor User Login status:

Sp_displaylogin SA

SELECT * from syslogins;

[Sybase] Sybase Foundation