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"

In reply to RE: RE: RE: Check Sybase data/log sizes by cadfael
in thread Check Sybase data/log sizes by lachoy

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.