in reply to RE: Check Sybase data/log sizes
in thread Check Sybase data/log sizes

Cool! Thanks for checking it out. Unfortunately, I don't have a copy of ASE 12 around to test this out -- Sybase seems to be waiting to release 12.5 before they put a new version out for Linux. Can you do me a favor and dump the output of a 'sp_help mydbname' from isql or sqsh (or dbish or ...) and either post it here or email it to me?

I suspect the output of the same stored procedure on the two different versions is different, which is kind of a pain. This is a cheap way to do it anyway -- a real Sybase hacker would read information from the system tables anyway :-)

Thresholds are definitely a good idea, and we implement them where possible as well.

Replies are listed 'Best First'.
RE: RE: RE: Check Sybase data/log sizes
by cadfael (Friar) on Nov 03, 2000 at 02:39 UTC
    I had the same thought exactly, and yes, they ARE differerent. In fact, I see where the error messages I mentioned in my previous note are coming from, as there is a new section of information between the general info and the device usage section. The free space on the logsegment is "not applicable", so it would be problematical parsing out information that just does not exist (at least with the ASE 12.0 version of sp_helpdb).

    I tend to go to the system tables for my information, anyway.

    Here is what the new version looks like: 

    1> sp_helpdb mdb3
2> go
 name                     db_size       owner                    dbid  
        created       
        status                                                                  
                              
 ------------------------ ------------- ------------------------ ------
        --------------
        ------------------------------------------------------------------------
------------------------------
 mdb3                         1200.0 MB dhancock                      5
        Apr 01, 1999  
        select into/bulkcopy/pllsort                                            
                              

(1 row affected)
 name                           attribute_class               
        attribute                      int_value  
        char_value                                                              
                                                                                
                                                                                
                       
        comments                                                                
                                                                                
                                                                                
                       
 ------------------------------ ------------------------------
        ------------------------------ -----------
        ------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
        ------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
 mdb3                           buffer manager                
        cache binding                            1
        mdb3_cache                                                              
                                                                                
                                                                                
                       
        NULL                                                                    
                                                                                
                                                                                
                       

 device_fragments               size          usage               
        free kbytes     
 ------------------------------ ------------- --------------------
        ----------------
 db_disk                        100.0 MB      data only           
                   86322
 db_disk                        300.0 MB      data only           
                   46444
 db_disk                        300.0 MB      data only           
                  304976
 db_disk2                       100.0 MB      data only           
                  102000
 db_disk2                       200.0 MB      data only           
                   40822
 log_disk1                      100.0 MB      log only            
        not applicable  
 log_disk1                      100.0 MB      log only            
        not applicable  

                                                               
 --------------------------------------------------------------
 log only free kbytes = 126720                                 

 device                        
        segment                                                                 
                  
 ------------------------------
        ------------------------------------------------------------------------
------------------
 db_disk                       
        default                                                                 
                  
 db_disk                       
        system                                                                  
                  
 db_disk2                      
        index_seg                                                               
                  
 log_disk1                     
        logsegment                                                              
                  

(return status = 0)

    -----
    "Computeri non cogitant, ergo non sunt"

[reply]

In Section Code Catacombs