Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2013
    Posts
    9

    Unanswered: How to reduce the database size

    Hello,
    I want to reduce my database size in such a way that i would be able to store the large data but the space should be free for the previous records by using archiving or some other method,
    so please help me out for archiving my database in an efficient way.

  2. #2
    Join Date
    Mar 2003
    Posts
    280
    Quote Originally Posted by kiara jeckson View Post
    Hello,
    I want to reduce my database size in such a way that i would be able to store the large data but the space should be free for the previous records by using archiving or some other method,
    so please help me out for archiving my database in an efficient way.
    It depends. See: http://www.dbforums.com/db2/854783-m...e-posting.html
    --
    Lennart

  3. #3
    Join Date
    Sep 2013
    Posts
    9
    My database is created in db2 9.7 version

  4. #4
    Join Date
    Mar 2003
    Posts
    280
    Quote Originally Posted by kiara jeckson View Post
    My database is created in db2 9.7 version
    Have a look at range partitioning.
    --
    Lennart

  5. #5
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by lelle12 View Post
    Have a look at range partitioning.
    and compression
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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