PeopleSoft DB2 running out of log files

gorbie7 · #1 (**permalink**) 01-12-04, 16:21

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.

n_i · #2 (**permalink**) 01-12-04, 17:56

Quote:

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...

anil4321 · #3 (**permalink**) 01-12-04, 18:09

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?

Marcus_A · #4 (**permalink**) 01-12-04, 19:27

Where did you see "the max DB2 suggests?" You can increase the number (primary and secondary) and size of log files.

Internet Services

Web Development

Digital Marketing

Consumer Tech