SYBASE: sybase Basics

Source: Internet
Author: User
Tags sybase sybase client sybase database

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;

 

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.