Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unhappy Unanswered: DB2 Transactional Log.

    Hi. i'm new with DB2, any way to set non loging mode more DB2 ? like the concept in informix by setting the log device to null ?

    Reason is we need to import big amount of table creation, now it's always failed the the log is full.

  2. #2
    Join Date
    May 2003
    Here are some options you have with DB2 utilities and regular SQL:

    1. To prevent logging of an SQL statement, alter the table to not logged initially, do the SQL, and run the script with auto-commit off. This will prevent logging, but make sure you commit at the end of the script (since auto-commit is off).

    2. Use the COMMITCOUNT option during the import. If you set it to 1000 or so, then the logs will not fill up.

    3. Do a LOAD with NONRECOVERABL option.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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