Hi,
While running job on a production environment. I am getting a error like below..I can visualize that something is happening worng in DB2.
[DataStage][SQL Client][ODBC][IBM][CLI Driver][DB2/NT] SQL0964C The transaction log for the database is full. SQLSTATE=57011
Can anybody help me out on this.
transaction log full
Moderators: chulett, rschirm, roy
transaction log full
/*Devashis*/
No
I guess no, I am using the ODBC driver provided by IBM. Well I am taking another trial. On the Target on Transaction ISolation, I have set the option to auto Commit.(Last tab on ODBC stage).
Waiting for that 46,000 record limit to passby where it failed last time.
Waiting for that 46,000 record limit to passby where it failed last time.
/*Devashis*/
Devashish,
These things will not work.
Transaction logs has a tendency to log every transaction taking place on the database.
I am giving you two solutions that work very well.
1) You truncate the transaction log of the database ,before running your transaction and change the recovery option to not log on the transaction log.
2) You ensure that enough disk space is there on which your transaction log exists.
You can tell me if anything else you want to know.
Regards,
Manoj
These things will not work.
Transaction logs has a tendency to log every transaction taking place on the database.
I am giving you two solutions that work very well.
1) You truncate the transaction log of the database ,before running your transaction and change the recovery option to not log on the transaction log.
2) You ensure that enough disk space is there on which your transaction log exists.
You can tell me if anything else you want to know.
Regards,
Manoj