No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ-How to View the Used Log Space of the Database in Sybase Through Command Line Mode

Publication Date:  2012-07-24 Views:  31 Downloads:  0
Issue Description
Q:
How to View the Used Log Space of the Database in Sybase Through Command Line Mode?
Alarm Information
Null
Handling Process
A:
Telnet to the NM server during problem-processing, and graphic interface cannot be transferred. View through the command line. Query by running the following commands (take BMSDB for example):
1>use BMSDB
2>go
1>sp_helpsegment logsegment
2>go 
segment name                           status
 ------- ------------------------------ ------
       2 logsegment                          0
 device                         size
 ------------------------------ ----------------------
 BMSDLog                       1524.0MB
 free_pages
 -----------
      777238
 table_name                     index_name                     indid
 ------------------------------ ------------------------------ ------
 syslogs                        syslogs                             0
 total_size             total_pages free_pages  used_pages
 ---------------------- ----------- ----------- -----------
 1524.0MB                    780288      777238        3050
(return status = 0)
 free_pages
 -----------              
Here it is the remaining space of log. This value is converted as KB by multiplying two.
      777238
Root Cause
Null
Suggestions
Null

END