Results 1 to 2 of 2

Thread: log file full

  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: log file full

    hi to all
    pl tell me how increase the log file size?
    y it is comming?
    004-01-10-16.27.12.794482 Instance:db2inst1 Node:000
    PID:20599(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.040110105712
    data_protection sqlpgrsp Probe:50 Database:TESTKALA

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

    2004-01-10-16.27.12.816517 Instance:db2inst1 Node:000
    PID:20599(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.040110105712
    data_protection sqlpWriteLR Probe:80 Database:TESTKALA


    thank u

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The log fills up when an application (or utility) that updates DB2 has processed more transactions in a single unit of work (without any commits) than can be stored in the circular log files.

    First you will need to complete the disposition of application handle 27 (COMMIT, ROLLBACK or FORCE APPLICATION), which I assume is the application that caused the problem.

    To increase the logs size you need to change one or more (preferably all) of the following parameters:

    Logprimary (the number of primary log files default is 3)
    Logsecond (the number of secondary log files default is 2)
    Logfilsiz (the number of 4K pages of each logfile default is 1000 on Unix, 250 on Windows)

    You can increase these with the following syntax (example values are given):

    db2 connect to testkala
    db2 update db cfg using logprimary 5
    db2 update db cfg using logsecond 10
    db2 update db cfg using logfilsiz 10000
    db2 connect reset

    You can also use the Control Center database configuration to change these values. These parameters will take affect after all applications have disconnected from the database.

    To help alleviate this problem in the future, make sure your application or utility (such as import) does frequent commits every 100 1000 updates. For the import utility, you can specify the COMMITCOUNT n parameter.
    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
  •