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 each known configured server name and IP address + port number.
The ability to directly locate the interfaces file opens and open the Dsedit.exe under the Sybase\ocs-15_0\bin folder. For example, with:
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 and add the name of the previous server. 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" and "go" to see if the database has been started
Sybase Database Learning Notes (i)
