Results 1 to 4 of 4

Thread: Pctfree

  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Unanswered: Pctfree

    HI

    What is the significance of having -1 as the value for PCTFREE.

    Regards
    Ranga

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Pctfree

    I always thought PCTFREE can be an integer from to 99 ...

    Please let us know where you came acroos the value of -1 for PCTFREE ..

    Cheers

    Sathyaram

    Originally posted by ranga
    HI

    What is the significance of having -1 as the value for PCTFREE.

    Regards
    Ranga

  3. #3
    Join Date
    Dec 2002
    Posts
    3

    Re: Pctfree

    Originally posted by sathyaram_s
    I always thought PCTFREE can be an integer from to 99 ...

    Please let us know where you came acroos the value of -1 for PCTFREE ..

    Cheers

    Sathyaram
    In the db2 database we have
    When I use Control Center and view the details of any given table
    I see a value of -1 for "Percentage of free space to be left during
    load or reorganization". When we do reorgchk everyday we find
    at least 6 tables to be reorganized everyday and we do reorganization
    everyday. Thought this could be something realted to pctfree hence wanted a clarification on this. Would request you to kindly enlighten
    me on this.

    Regards
    Ranga

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Pctfree

    Honestly, I'm not sure what -1 signifies ...

    When doing a reorgchk, the output will contain information on why you need REORG(F1 to F6) .,, Observe them over a period of time and you will understand why you need reorganization

    HTH

    Cheers

    Sathyaram

    Originally posted by ranga
    In the db2 database we have
    When I use Control Center and view the details of any given table
    I see a value of -1 for "Percentage of free space to be left during
    load or reorganization". When we do reorgchk everyday we find
    at least 6 tables to be reorganized everyday and we do reorganization
    everyday. Thought this could be something realted to pctfree hence wanted a clarification on this. Would request you to kindly enlighten
    me on this.

    Regards
    Ranga

Posting Permissions

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