DB2 is IBM's offering to the highend database market. The latest version of DB2 (Universal Database) is ideal for OLTP, Data Warehousing, Decision Support and everything in between. It's well priced, extremely scalable and runs on virtually every platform out there from handhelds to mainframes.
Today I got a problem with new table insertion in data base. Presently we are using linux os, and on that db2 7.2.5.
Today I want a table creation through import command. like
import from vstr4 of ixf create into bill_master
then the out put is . -964 error database log full. can not create the table.
error code 57011 . this is practiced on remote server., i am not having x windows.
i want this problem, how to control thru command line.
i want syntax for this problem control. plz help me.
Thanks & Regards
what you could do is specifying commitcount
import from file of ixf commitcount 1000 create into ....
or create the table yourself and do alter table xx not logged initially - import.. insert into tablename