var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem with Transaction Protocol
i have a local DB2 (a kind of copy) with our DWH Structure.
Sometimes i want to update the records (only for testing purpose).
I use Informatica (ETL-Tool) to load the Data into the DB2
(first Truncate the Tables)
No i have problems with the Transaction protocol...
concerning huge tables...
Error: No space available in transaction protocol...
I tryed to increase the size of the protocol and changed the settings concerning "commit" but with no success
I there a way to load data WITHOUT the protocol?
Thanks in advance.
I think you are hitting on an Informatica error and not a db2 error .. Do you have a db2 error message associated with it ..
Visit the new-look IDUG Website
, register to gain access to the excellent content.
i found a logfile:
PRE-SESS> CMN_1022 Database driver error...
FnName: Execute -- [IBM][CLI Driver][DB2/NT] SQL0964C Kein Platz mehr im Transaktionsprotokoll für die Datenbank. SQLSTATE=57011
You'll need to either increase the number or size of DB2 log files, or re-configure your ETL process to update less data at one time.
i increased the logfiles to 10 logfiles a 25000 MB.
i looked at the logfiles and the max was 5 files a 4 MB ?
the problem is that there are NO updates but
inserts (initial load).
is there a possibility to load without logging?
we dont need the poss. of a roolback..
I don't know if Informatica allows you to execute custom SQL within the bounds of the same transaction that inserts the data; if it does, issue "ALTER TABLE ... ACTIVATE NOT LOGGED INITIALLY".
By the way, DB2 v8 allows "unlimited" log space...