Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010

    Unanswered: disable not logged initially

    Is there any way to control the 'not logged initially' from the server so that you can turn if off? Example: if a script ran which used 'not logged initially' if would get logged anyway and thus not get the hadr system out of sync.

  2. #2
    Join Date
    May 2003
    If you have DB2 9.5 (at least FP 4) or higher, then set the following to YES in the db config.

    Block non logged operations (BLOCKNONLOGGED) = YES

    It will not allow commands to be run that are not logged, such as NONRECOVERABLE Loads, and the situation you mentioned.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2010
    Great, were using 9.7, i see the option in the db cfg.
    Thanks a lot.

Posting Permissions

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