Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Question Unanswered: PeopleSoft DB2 running out of log files

    We are using PeopleSoft AP to process all of our checks. We are having a problem with our log files when we run a large process with over 3,000 rows for one vendor. The progam does not have a commit statement until all items have been processed per vendor. We have increased our log files to the max DB2 suggests.

    PeopleSoft of course says it is a DB2 problem. Has any one else had this problem or might be able to suggest a fix.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: PeopleSoft DB2 running out of log files

    Originally posted by gorbie7
    We are using PeopleSoft AP to process all of our checks. We are having a problem with our log files when we run a large process with over 3,000 rows for one vendor. The progam does not have a commit statement until all items have been processed per vendor. We have increased our log files to the max DB2 suggests.

    PeopleSoft of course says it is a DB2 problem. Has any one else had this problem or might be able to suggest a fix.
    I don't think you have a lot of options except trying to increase the log size even more...

  3. #3
    Join Date
    Feb 2003
    Posts
    20

    Re: PeopleSoft DB2 running out of log files

    Can you give some more details, such as

    - Type of Logging
    - primary and secondary log files

    3000 is not a big number and should not cause any problem.

    In DB2 upper limit of active logspace is 256 GB (primary + secondary). Have you used this much space in your configuration?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Where did you see "the max DB2 suggests?" You can increase the number (primary and secondary) and size of log files.
    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
  •