Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006


Bcp in large scale obstruction

I BCP used in transplant database, a table is always guided the 1G not get, in general guide to the record of 777,000 T, where Sybase System on the cards for this big there any way ah, that loom 3G allocation of CPU, memory 1G

Table proposed split, then BCP bars, the best bars TEMPEST reservoir expansion.

Errorlog see if they had any information, or to see if there are any processes or lock

To see whether the log is full. Bcp -b1000 introduce the use of a form of 1000

Fast BCP proposal

BCP is when you bring in the right LOG
Fast BCP proposal
It is required as follows :
1, db_option 'select into' true
2, bound to remove all forms : (trigger, the index, primary key, constraint, foreign key)

Oh, Thank you, the problem is LOG, BCP at the log has grown extremely rapidly, mainly novice with careless ah, look at the log, in the hope that we can start the trunc log on chkpt, neither do checkpoint

Deleted index put first, and then bcp



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com