On what parameter does Database Capacity depend

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Rahul Babbar
    #1

    On what parameter does Database Capacity depend

    Hi,

    I wanted to know on which parameters does database capacity depend on?
    Is it only dependent on the tablespaces size that i have allocated?
    I am getting the following.

    C:\Program Files\IBM\SQLLI B\BIN>db2 call get_dbsize_info (?, ?, ?, 0)

    Value of output parameters
    --------------------------
    Parameter Name : SNAPSHOTTIMESTA MP
    Parameter Value : 2007-09-13-00.21.25.978868

    Parameter Name : DATABASESIZE
    Parameter Value : 40445849600

    Parameter Name : DATABASECAPACIT Y
    Parameter Value : 50768454132

    Return Status = 0


    Currently, the diff is around 10 GB and i have to create some more
    schemas which might reduce the difference even further.

    Will the database capacity be resolved and database capacity increased
    if i extend the tablespaces?

    Thanks a lot

    Rahul

    Tags: None
    • rahul
      #2
      Re: On what parameter does Database Capacity depend

      On Sep 12, 8:13 am, Rahul Babbar <rahul.babb...@ gmail.comwrote:
      Hi,
      >
      I wanted to know on which parameters does database capacity depend on?
      Is it only dependent on the tablespaces size that i have allocated?
      I am getting the following.
      >
      C:\Program Files\IBM\SQLLI B\BIN>db2 call get_dbsize_info (?, ?, ?, 0)
      >
      Value of output parameters
      --------------------------
      Parameter Name : SNAPSHOTTIMESTA MP
      Parameter Value : 2007-09-13-00.21.25.978868
      >
      Parameter Name : DATABASESIZE
      Parameter Value : 40445849600
      >
      Parameter Name : DATABASECAPACIT Y
      Parameter Value : 50768454132
      >
      Return Status = 0
      >
      Currently, the diff is around 10 GB and i have to create some more
      schemas which might reduce the difference even further.
      >
      Will the database capacity be resolved and database capacity increased
      if i extend the tablespaces?
      >
      Thanks a lot
      >
      Rahul
      yes , i think by increasing the tablespaces you can increase the
      capacity.
      you can try with a sample DB first

        Comment

        • g.deogirikar@gmail.com
          #3
          Re: On what parameter does Database Capacity depend

          On Sep 12, 12:13 pm, Rahul Babbar <rahul.babb...@ gmail.comwrote:
          Hi,
          >
          I wanted to know on which parameters does database capacity depend on?
          Is it only dependent on the tablespaces size that i have allocated?
          I am getting the following.
          >
          C:\Program Files\IBM\SQLLI B\BIN>db2 call get_dbsize_info (?, ?, ?, 0)
          >
          Value of output parameters
          --------------------------
          Parameter Name : SNAPSHOTTIMESTA MP
          Parameter Value : 2007-09-13-00.21.25.978868
          >
          Parameter Name : DATABASESIZE
          Parameter Value : 40445849600
          >
          Parameter Name : DATABASECAPACIT Y
          Parameter Value : 50768454132
          >
          Return Status = 0
          >
          Currently, the diff is around 10 GB and i have to create some more
          schemas which might reduce the difference even further.
          >
          Will the database capacity be resolved and database capacity increased
          if i extend the tablespaces?
          >
          Thanks a lot
          >
          Rahul
          ###
          Database capacity depends upon the DMS tablespace container size and
          pagesize. In DMS the space is pre allocated.

          deogirikar./
          #####

            Comment

            Previous template Next
            Working...