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
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