Results 1 to 3 of 3

Thread: db2 issue

  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: db2 issue

    Hi,

    I am using ECC 6.0 and db2 database.I have deleted some clients in sap.The total size of that client is 10GB.After deleting i done the reorg for all the tables through db13.The filesystem size not reducing is increasing why this problem?Please help me.

    Regards,
    Raj

  2. #2
    Join Date
    Aug 2009
    Posts
    8
    I think.. it may be due to High Water Mark for that tablepsace.
    If possible, can you unload data, drop the table and then recreate it ?

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ibm_db2_rocks
    If possible, can you unload data, drop the table and then recreate it ?
    That does not at all guarantee that the HWM will be lowered. db2dart with the /lhwm switch can be used to suggest ways to lower the tablespace high water mark (if this is indeed the problem).
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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