Thursday, March 18, 2010

Commit counts on db2 imports

I couldn't remember how to import into a db2 table with a specific commit count.  A quick google search found this page:

The Music of Time: DB2 Import Commands Failing With "transaction log for db is full" Errors
db2 "import from [your_csv_file_name] of del commitcount 1000 insert into [table_name]([column A], [column B], [column C], ...)"


No comments:

Post a Comment