Find remaining database space

[#1]

How can I run a command to find the total database space and the remaining database space? The dbinfo command doesn't seem to have the information I am looking for.

[chris_keating]

Are you using dbinfo -u.

That output is very detailed about number of pages - used and free, usage percentages by table for table and index pages.

Here is an example dbinfo -u output. If it is not sufficient for your needs, can you describe what other information is needed:

SQL Anywhere Information Utility Version 17.0.8.4003
Database  : c:\\sa\\sa17\\samples\\demo.db
Log file  : c:\\sa\\sa17\\samples\\demo.log
Free pages: 565275
Page size : 4096

     Table   Table            Index           Percent  Name
      id     Pages    %used   Pages    %used  of File
     -----  --------  -----  --------  -----  -------  ----
         1        11  ( 84)        10  ( 44)      0    ISYSTAB
...
      3008         1  (  3)         2  (  9)      0    Departments
            ========         ========
Total:           355 table +      496 index + 565275 free + 0 bit map + 162 other = 566288 pages