Results 1 to 5 of 5

Thread: log full errors

  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: log full errors

    We keep getting the following errors in db2diag.log


    DIA3609C Log file was full.

    2003-08-04-09.20.32.595583 Instance:db2inst1 Node:000
    PID:146528(db2agent (OUR_DB) 0) Appid:0A02CD26.076B.030804151020
    data_protection sqlpgrsp Probe:50 Database:OUR_DB

    Log Full -- active log held by appl. handle 479
    End this application by COMMIT, ROLLBACK or FORCE APPLICATION.

    2003-08-04-09.20.32.624633 Instance:db2inst1 Node:000
    PID:146528(db2agent (OUR_DB) 0) Appid:0A02CD26.076B.030804151020
    data_protection sqlpWriteLR Probe:80 Database:OUR_DB
    DIA3609C Log file was full.

    ZRC=0xFFFFD509

    How can we resolve these log full problems? Thanks!

    Scott

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    Increase the # of your logprimary and/or logsecond and/or increase the size of your logfilsz. Make sure you have enough disk space to do this diskspace=(# of logprimary + logseconds ) * logfilsz

    Or make sure that your sql has enough commits in it so it doesn't use too much space.

    You can only allocaste 32gig of logspace in v7 and I think v8 is unlimited.

  3. #3
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    We had a similar problem while we were trying to run a large delete (15000 rows)

    I issued the following statements and the deletion worked.

    db2 alter table table_name ACTIVATE NOT LOGGED INITIALLY

    and the delete statement worked fine

    Mark

  4. #4
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74
    ..but don´t forgett that you just can activate not logged initially if you had created this table with not logged initially.
    Rui

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    And if something goes wrong with the unit of work the table is marked as inaccessible.

Posting Permissions

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