Topic
  • 1 reply
  • Latest Post - ‏2013-03-13T09:38:12Z by vakkila
SystemAdmin
SystemAdmin
115 Posts

Pinned topic Determining the database size

‏2013-03-12T08:51:31Z |
I am trying to determine the database size by using this command
ADMIN COMMAND 'info dbsize logsize dbfreesize dbpagesize imdbsize dbconfigsize'

The result is displayed without any units.
8064
96
6848
16384
0
8388608.0

Now I know that the dbsize logsize are in KB, but I am not very sure about the dbfreesize.

Can you please let me know the units used in the result set?

Thanks,
Anu
Updated on 2013-03-13T09:38:12Z at 2013-03-13T09:38:12Z by vakkila
  • vakkila
    vakkila
    7 Posts

    Re: Determining the database size

    ‏2013-03-13T09:38:12Z  
    Hi,

    The ADMIN COMMAND 'info' options & units are described here:

    http://pic.dhe.ibm.com/infocenter/soliddb/v7r0/topic/com.ibm.swg.im.soliddb.admin.doc/doc/admin.command.html

    ADMIN COMMAND 'info options'
    Abbreviation: info
    ...
    dbsize - Database size (KB).
    logsize - Size of log files (KB).
    dbfreesize - Amount of free space remaining in database (KB).
    dbpagesize - Database page size (KB).
    imdbsize - Amount of space used by in-memory tables (including temporary tables and transient tables)
    dbconfigsize - The configured database size (MB), as set with the IndexFile.FileSpec parameter.
    ...

    -katriina