Sybase Database Learning Notes (i)

The basic framework of Sybase

The Sybase database consists of a system database, a user database, a database device, and a secondary file.

1. System Database

The Sybase database is a database management system with multiple database structures. Divided into the system database and user database.

The system database is created at the time of installation, including the following:

• Master database: Full Control and management of user databases and all operations on Sybase
• Temp database: Provides a storage area for temporary tables and other temporary workspaces, which is common
• Model database: Provide a prototype for the new user database
• Sybsystemproc database: Storage System stored procedures
• Other system databases: Audit Database (sybsecurity), sample database (PUBS2), Syntax database (sybsyntax)

2. Interfaces Fileinterfaces is located in the $sybase folder, the interface file is equivalent to an address book. The file lists the name and IP address + port number of each well-known configured server.

The ability to directly locate the interfaces file opens and open the Dsedit.exe under the "Sybase\ocs-15_0\bin" folder, for example:

the role of the interfaces file:

• The network address of each server that can be connected is listed in the client's interfaces file.
• On the server side. Each server is used for connections to other servers

you can add one to the interfaces file.

Or add a server in Dsedit.ext, add the name of the previous server, and then configure Ip+port in the server address.

Note: The format of the values for server address is ip,port. Separate the IP address and port number with commas.
Startup and shutdown of Sybase1. View the startup status of the database Login with Sybase user, use "isql-u xx-p xx-s XX" command to log in. then enter "Showserver". "Go" to see if the database has been started

Sybase Database Learning Notes (i)