(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