Hi All,
I've datastage 8.5. My datastage director is showing me error i.e.
transaction log for the database is full.
So how should I increase the size? Delete the log file as well?
Thnks
The transaction log for the database is full
Moderators: chulett, rschirm, roy
Hi Jackjack_125 wrote:Its DB2 database and I dont have a DBA support but I have admin privelages
On my id.
this means the DB2 log ran full because your Transaction was too long (too many rows where changed).
Several solutions for that - here is one:
1. Increase your number of secondary logs (logsecond parameter in the db cfg)
2. Ensure your transactions commits more oftern (see "Transactions size" in the DB2 stage in DataStage)
By the way it is worth having a DBA!
best regards
Michael
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: