The transaction log for the database is full

jack_125 · Post by **jack_125** » Mon Jan 17, 2011 10:24 pm

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

chulett · Post by **chulett** » Mon Jan 17, 2011 11:14 pm

What database would that be? Have you involved your DBA?

jack_125 · Post by **jack_125** » Tue Jan 18, 2011 9:10 am

Its DB2 database and I dont have a DBA support but I have admin privelages
On my id.

MT · Post by MT » Tue Jan 18, 2011 9:54 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Jan 18, 2011 3:49 pm

Is this the XMETA database (or IADB or QSDB) or a database containing your organization's data?