Page 1 of 1
The transaction log for the database is full
Posted: Mon Jan 17, 2011 10:24 pm
by jack_125
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
Posted: Mon Jan 17, 2011 11:14 pm
by chulett
What database would that be? Have you involved your DBA?
Posted: Tue Jan 18, 2011 9:10 am
by jack_125
Its DB2 database and I dont have a DBA support but I have admin privelages
On my id.
Posted: Tue Jan 18, 2011 9:54 am
by MT
jack_125 wrote:Its DB2 database and I dont have a DBA support but I have admin privelages
On my id.
Hi Jack
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
Posted: Tue Jan 18, 2011 3:49 pm
by ray.wurlod
Is this the XMETA database (or IADB or QSDB) or a database containing your organization's data?