Results 1 to 5 of 5

Thread: DataBase Size

  1. #1
    Join Date
    Mar 2007
    Posts
    20

    Unanswered: DataBase Size

    Hi all,

    Version DB@ U8.2
    OS : Linux/Windows

    One way to find the size of the databse is DB2 "call get_dbsize_info(?,?,?,0)"


    Is there any other ways to find the dtabase size?
    Please do let me know.

    Regards,

    M.Sampath.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    I am at present on 8.2.7 on windows, not sure when the functionality was added . Check if ur level supports that

    goto CC
    right click to database >manage storage > view storage
    this will cause new tables to be created which will store tables and indexes storage info
    U can trace storage info at regular interval by calling it.
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Mar 2007
    Posts
    20
    hi,

    I need to calculate the database size in the command prompt, not in GUI

    Is there any other alternative?
    Please do help me out.

    Regards,

    M.Sampath.

  4. #4
    Join Date
    Mar 2007
    Posts
    20

    DataBase Size

    hi,

    I need to calculate the database size in the command prompt, not in GUI

    Is there any other alternative?
    Please do help me out.

    Regards,

    M.Sampath.

  5. #5
    Join Date
    Mar 2007
    Posts
    20

    DataBase Size

    hi,

    I need to calculate the database size in the command prompt, not in GUI

    Is there any other alternative?
    Please do help me out.

    Regards,

    M.Sampath.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •