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

    Unanswered: Infinite Logging

    Hi,
    I know that if we set db cfg parameter LOGSECOND=-1,it sets up the db for Infinite logging. But what is the practical use of this infinite logging feature? In which kind of environment will I be benifitting with this feature?

    Thanks,
    Anirban.

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Log capacity. When you configure the number primary & secondary logfiles you also limit your log (and transaction) capacity. So when you've got an update on a large table without a where clause it could hit the log limits after a few hours and do a rollback (spending that same time again).
    When you have infinite logging, you are limited by disk-space only (for the logs).

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Infinite logging is the devil's work. Any momentary advantages will be seriously regretted in the future.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Nov 2009
    Posts
    5
    Quote Originally Posted by Marcus_A View Post
    Infinite logging is the devil's work. Any momentary advantages will be seriously regretted in the future.
    Yes - a truly religious experience ..... what a schmuck!

  5. #5
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    @Javaharlal : i know who has created this fake id ......
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  6. #6
    Join Date
    Nov 2009
    Posts
    6

    @dr_te_z

    Thanks for the reply. But from practical perspective is this something which we do in a transient state, say when we want to delete/update a large table which might cause huge logging? Or are there some systems where we permanently enable this infinite logging ?

    Thanks,
    Anirban.

  7. #7
    Join Date
    Nov 2009
    Posts
    5
    Quote Originally Posted by rahul_s80 View Post
    @Javaharlal : i know who has created this fake id ......
    That's nice! But the real question is - do you know anything about infinite logging?

    P.S. I know who assassinated Gandhi! Do you?

  8. #8
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    Quote Originally Posted by Javaharlal View Post
    P.S. I know who assassinated Gandhi! Do you?
    ? Stalin Died naturally or Rat Poison did the trick ?
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  9. #9
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by anirbanpal View Post
    say when we want to delete/update a large table which might cause huge logging? Or are there some systems where we permanently enable this infinite logging ?
    What do you want? When, due to an application error, the system starts to modify far too much data, the "no more log space" could save you. But when you are running some kind of upgrade script in the weekend, that same message will drive you crazy. Some else cannot decide for you.

Posting Permissions

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