Hello Olek,
There are various non-database specific techniques like using less frequent
commits and large log buffer. One DB2 specific thing also helped us is
APPEND ON option in ALTER TABLE. DB2 will spend less resources looking for
space to insert rows.
--
Best regards, Dmitry Tolpeko
SQLWays - Data, Schema transfer for DB2, Oracle, SQL Server, Sybase,
Informix and MySQL
www.ispirer.com
"Smutny30" <sm******@poczta.onet.pl> wrote in message
news:cr**********@news.onet.pl...
Hello,
I need to implement a solution where db2 Workgroup v. 8.1 is used for
storing quite huge amount of data. The data will be rarely read and
searched and those operations do not need to be fast. In opposite many writes
(inserts , not updates) should work fast.
I am open for any suggestions on techniques and database configurations
that will be good for such a purpose. Any opinions are welcome !
sincerely Olek