| Author |
Log Suspends while doing bcp
|
|
| Sudarshan 2005-04-20, 7:24 am |
| Hi all,
We are using sybase ase 12.5. While doing bcp in one table which is have around
1 million rows the log gets suspended. My database is 700MB of Dat and 500MB of
Log. We have same set of database in staging environment, there the bcp went
fine. Can anyone suggest in this regard.
Thanks in advance.
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
| |
|
| use smaller batch size with bcp. truncate the log during the process.
regards
Manoj
<Sudarshan> wrote in message news:426620f4$1@foru
ms-1-dub...
> Hi all,
>
> We are using sybase ase 12.5. While doing bcp in one table which is have
around
> 1 million rows the log gets suspended. My database is 700MB of Dat and
500MB of
> Log. We have same set of database in staging environment, there the bcp
went
> fine. Can anyone suggest in this regard.
>
> Thanks in advance.
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp
| |
|
| You could switch it to using a fast bcp
drop the indexes and triggers
do bcp with batch sizes -bnnn
reapply the indexes and triggers
> Hi all,
>
> We are using sybase ase 12.5. While doing bcp in one table
> which is have around 1 million rows the log gets
> suspended. My database is 700MB of Dat and 500MB of Log.
> We have same set of database in staging environment, there
> the bcp went fine. Can anyone suggest in this regard.
>
> Thanks in advance.
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp
| |
| Eugene Korolkov 2005-04-20, 9:24 am |
| + sp_dboption '<dbname>','select into/bulkcopy/pllsort',true
before doing bcp, otherwise error.
HTH,
Eugene
wk wrote:
[color=darkred]
>You could switch it to using a fast bcp
> drop the indexes and triggers
> do bcp with batch sizes -bnnn
> reapply the indexes and triggers
>
>
>
| |
| Jeffrey R. Garbus 2005-04-20, 11:24 am |
| I'd combine this one with the smaller batch sizes & trunc log.
Jeff
<wk> wrote in message news:4266529a.7252.1681692777@sybase.com...[color=darkred]
> You could switch it to using a fast bcp
> drop the indexes and triggers
> do bcp with batch sizes -bnnn
> reapply the indexes and triggers
>
|
|
|
|