Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2017
    Posts
    1

    Unanswered: SYbase ASE BCP out in parallel

    Hi All,

    I am trying to bcp out a table which is non-partitioned into a csv file. I am trying to achieve parallel bcp export option using something like below in a shell scripts:

    #!/bin/ksh
    bcp table_name out test.dat1 -c -t '<EOFD>' -r '<EORD>' -F 1 -L 1500000 -S server -U user -P pass &
    bcp table_name out test.dat2 -c -t '<EOFD>' -r '<EORD>' -F 1500001 -L 3000000 -S server -U user -P pass &
    bcp table_name out test.dat3 -c -t '<EOFD>' -r '<EORD>' -F 3000001 -L 4500000 -S server -U user -P pass &
    wait
    exit 0

    But, when I run the above, the commands don't run in parallel. The 2nd one doesnt trigger until the first complete and 3rd one doesn't until 1st and 2nd complete. The Unix OS has 2 CPUS and 2 GB RAM.
    Can someone advise if the parallel extract is possible?

  2. #2
    Join Date
    Jun 2017
    Posts
    5

    use windows start

    yes, it's possible.

    create 3 windows batch files with 3 bcp separately.
    create 4th windows batch files to call the 3 in order but with windows command start in
    for example start bcp....

    then the 3 bcp thread will be started in parallel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •