Results 1 to 13 of 13
  1. #1
    Join Date
    Nov 2009
    Posts
    9

    Unanswered: Turning off logging on individual tables

    [withdrawn]
    Last edited by Keymaker; 11-28-09 at 17:04.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    The only option I'm aware of is "not logged initially". With nonrecoverable load, the tablespaces associated with the target table are not put into the backup pending state - logging is minimal by default with load.

  3. #3
    Join Date
    Nov 2009
    Posts
    9
    Thank you. As I mentioned earlier, these options have already been explored and are well understood. Looking for alternatives.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    I don't believe what you're trying to do is possible.

  5. #5
    Join Date
    Nov 2009
    Posts
    9
    Everything is possible - the impossible just takes longer!

    Thank you

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    In this case, define everything as LOB and not log it.

  7. #7
    Join Date
    Nov 2009
    Posts
    9
    I may be adventurous, but not completely nuts

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    What is "no-op user exit"?

  9. #9
    Join Date
    Nov 2009
    Posts
    9
    Quote Originally Posted by db2girl View Post
    What is "no-op user exit"?
    User exit that does nothing ... What is no op? Definition from WhatIs.com


    ... inoperable ... like Obama - the no-op president YouTube - obama SNL

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    How does "no-op user exit" help to perform I/U/D without logging?

  11. #11
    Join Date
    Nov 2009
    Posts
    9
    User exit helps to turn off archiving - not logging. Still working on the logging part ...

  12. #12
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    I must have misunderstood your original post where you listed three options used to turn off logging for the duration of UOW:
    NOT LOGGED INITIALLY
    LOAD NONRECOVERABLE
    no-op user exit


    Now, you're saying that the last option is used to turn off archiving... interesting It's time for beer or vodka with Lenny77

  13. #13
    Join Date
    Nov 2009
    Posts
    9
    Log archiving is one aspect of logging. Sometimes it helps to turn it off to improve overall picture. Especially with SSA, may it burn in ...

    As for L77, I don't think he drinks - too busy with sudoku and other useless stuff

    Gotta go now - it's party time

Posting Permissions

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