Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Unanswered: transaction log and connection time

    I'm using DB2-UDB 8.1 on Windows

    I'm in a migration process of my application and, apparently, the provided scripts are not written for my data size.

    Due to DB2 8.1 DDL limitations, it's necessary to recreate the main part of my tables and insert data from a copy.

    To be able to do that, I'm still using the option NOT LOGGING INITIALLY... it seems to work.

    Now I've a trouble with a big UPDATE. I still generated a transaction log space of 30 Gb, but it's still not sufficiant. Isn't it possible to "skip the log" for a specific transaction ? What is the normal sizing of a circular log for a db smaller than 20 Gb ?

    Other question : my machine rebooted and is now restarted. MY DB2 instance seems to work, but trying to connect to the impacted db, the connection seems to freeze for more than 2 hours. It is caused by the recovery process ?
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Try using the LOAD utility instead on INSERTing the data.

    You could turn off circular logging by turning on archive logging, but this may not fix you log size issue.

    It is highly possible that DB2 is in crash recovery after the reboot, and that is why you cannot log in right away. Things you should do: before reboot issue "db2stop". And backup the DB at least once a day.

    Andy

Posting Permissions

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