Sybase Database Learning Notes (i)

Source: Internet
Author: User
Tags sybase sybase database

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)

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.