Shulou(Shulou.com)06/01 Report--

This article mainly explains "What are the common problems of Sybase ASE database". The explanation in this article is simple and clear, easy to learn and understand. Please follow the ideas of Xiaobian and go deep into it slowly to study and learn "What are the common problems of Sybase ASE database" together!

1 What is the form of disk space occupied by databases? What is the Master Database? What happens if the master fails?

Equipment documentation. Storing system tables, the system will not be available unless the master library is rebuilt

What is the essence of paragraph 2? Can segments already used by objects in SYBASE be deleted?

Logical subdivision of device files. Certainly not deleted. unless the segment being used by the object is replaced

3 What are the types of database objects that can be placed on segments?

table, index

4 How many segments does the database have after default installation?

Three. system, log, default

5 What database device is the best place for log segments? Can default and log segments be placed on the same database device?

Separate device files or bare devices. can. But not recommended.

6 Which system tables will be affected by creating a segment? How do I check the definition of system segments? Try two methods.

syssegments, sysusages

1) sp_helpsegment

2) sp_helpdb

7 How do I place database objects on specified segments?

create on

8 There is a large table containing 1 million records, occupying 500 megabytes of space, and we discuss possible optimization solutions.

1)Separate log device file (sufficient)

2)Implement table partitioning, creating separate segments for tables and their indexes

1 What is the general operational relationship between backup database and backup log? Can log backups be considered incremental backups?

Data first, transaction log later, that's pretty much an incremental backup, but there has to be a full backup.

Can remote backup be implemented? The way you imagined it?

Yes. There is a Backup Server on ASE Server and a Backup Server remotely.

Both servers register BackupServer entries with each other.

sp_addserver Local BackupServer in ASE Server

Then dump *** at RemoteBackupServer

3 Database and log shortcomings on the device reflected in the backup?

Mixed together, can only be backed up together, bad all bad, of course not very good. It's wise to divide it into different devices.

4 Discuss whether it is necessary to backup four system databases?

Yes.

5 Master database crashed, other databases are available, there is a complete backup of its database, can it be restored?

Rebuild Master Library, should be possible.

Thank you for reading, the above is "Sybase ASE database common problems which" the content, after the study of this article, I believe that we have a more profound understanding of the common problems of Sybase ASE database, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.