Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dump to /dev/null stripe

7 posts in Backup and Recovery Last posting was on 2010-03-15 23:41:50.0Z
rick_806 Posted on 2010-03-12 18:38:47.0Z
Sender: 60fb.4b95425b.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.backup+recovery
Subject: dump to /dev/null stripe
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b9a8a37.f14.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Mar 2010 10:38:47 -0800
X-Trace: forums-1-dub 1268419127 10.22.241.41 (12 Mar 2010 10:38:47 -0800)
X-Original-Trace: 12 Mar 2010 10:38:47 -0800, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4102
Article PK: 48188

ASE 12.5.2

I need to test compress option on dumps. I don't have enough
disk space to keep an extra dump so I was wondering if I
could dump to 5 stripes with 4 of the stripes pointing to
/dev/null? That would leave one stripe to use for size
estimate based on various compression settings (1-9) and not
use up all my disk space.

thx,
rick_806


Sherlock, Kevin [TeamSybase] Posted on 2010-03-12 19:41:14.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.backup+recovery
References: <4b9a8a37.f14.1681692777@sybase.com>
Subject: Re: dump to /dev/null stripe
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b9a98da$1@forums-1-dub>
Date: 12 Mar 2010 11:41:14 -0800
X-Trace: forums-1-dub 1268422874 10.22.241.152 (12 Mar 2010 11:41:14 -0800)
X-Original-Trace: 12 Mar 2010 11:41:14 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4103
Article PK: 48189

Use named pipes.

#unix command shell
mkfifo p2 p3 p4 p5

# isql command line
1> dump database yourdb to "/<yourpath>/stripe1.dmp"
2> stripe on "/<yourpath>/p2"
3> stripe on "/<yourpath>/p3"
4> stripe on "/<yourpath>/p4"
5> stripe on "/<yourpath>/p5"
6> go

#in a separate unix shell session
cat p2 >> /dev/null &
cat p3 >> /dev/null &
cat p4 >> /dev/null &
cat p5 >> /dev/null &

put in your "with compress" clauses on the dump database command, etc.

once you "cat" all of your named pipes to /dev/null, your backup should
finish and result in one file "/<yourpath>/stripe1.dmp" in the example
above.

<rick_806> wrote in message news:4b9a8a37.f14.1681692777@sybase.com...
> ASE 12.5.2
>
> I need to test compress option on dumps. I don't have enough
> disk space to keep an extra dump so I was wondering if I
> could dump to 5 stripes with 4 of the stripes pointing to
> /dev/null? That would leave one stripe to use for size
> estimate based on various compression settings (1-9) and not
> use up all my disk space.
>
> thx,
> rick_806


rick_806 Posted on 2010-03-12 21:29:35.0Z
Sender: 60fb.4b95425b.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: dump to /dev/null stripe
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b9ab23f.148b.1681692777@sybase.com>
References: <4b9a98da$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Mar 2010 13:29:35 -0800
X-Trace: forums-1-dub 1268429375 10.22.241.41 (12 Mar 2010 13:29:35 -0800)
X-Original-Trace: 12 Mar 2010 13:29:35 -0800, 10.22.241.41
Lines: 66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4104
Article PK: 48191

Hi,

Do I need to delete or drop the fifo 's after test is
concluded?
Is this correct (current directory /usr/sybase)?

mkfifo p2, p3 .p4

dump database test to "compress::/dbbackup/test.dmp"
stripe on "compress::p2"
stripe on "compress::p3"
stripe on "compress::p4"
go

----
new putty session

cat p2 >> /dev/null &
cat p3 >> /dev/null &
cat p4 >> /dev/null &


thx,
rick_806

> Use named pipes.
>
> #unix command shell
> mkfifo p2 p3 p4 p5
>
> # isql command line
> 1> dump database yourdb to "/<yourpath>/stripe1.dmp"
> 2> stripe on "/<yourpath>/p2"
> 3> stripe on "/<yourpath>/p3"
> 4> stripe on "/<yourpath>/p4"
> 5> stripe on "/<yourpath>/p5"
> 6> go
>
> #in a separate unix shell session
> cat p2 >> /dev/null &
> cat p3 >> /dev/null &
> cat p4 >> /dev/null &
> cat p5 >> /dev/null &
>
> put in your "with compress" clauses on the dump database
> command, etc.
>
> once you "cat" all of your named pipes to /dev/null, your
> backup should finish and result in one file
> "/<yourpath>/stripe1.dmp" in the example above.
>
> <rick_806> wrote in message
> > news:4b9a8a37.f14.1681692777@sybase.com... ASE 12.5.2
> >
> > I need to test compress option on dumps. I don't have
> > enough disk space to keep an extra dump so I was
> > wondering if I could dump to 5 stripes with 4 of the
> > stripes pointing to /dev/null? That would leave one
> > stripe to use for size estimate based on various
> > compression settings (1-9) and not use up all my disk
> space. >
> > thx,
> > rick_806
>
>


Sherlock, Kevin [TeamSybase] Posted on 2010-03-12 21:55:17.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.backup+recovery
References: <4b9a98da$1@forums-1-dub> <4b9ab23f.148b.1681692777@sybase.com>
Subject: Re: dump to /dev/null stripe
Lines: 112
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b9ab845$1@forums-1-dub>
Date: 12 Mar 2010 13:55:17 -0800
X-Trace: forums-1-dub 1268430917 10.22.241.152 (12 Mar 2010 13:55:17 -0800)
X-Original-Trace: 12 Mar 2010 13:55:17 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4105
Article PK: 48190

well. you should have everything here that you need...

How about this:


#### create a script for isql (let's call it /dbbackup/dump.sql)

dump database test to "compress::/dbbackup/test.dmp"
stripe on "compress::/dbbackup/p2"
stripe on "compress::/dbbackup/p3"
stripe on "compress::/dbbackup/p4"
go

#### create a shell script (let's call it /dbbackup/dump_test.sh)

#!/bin/sh
# create your pipes
mkfifo /dbbackup/p2 /dbbackup/p3 /dbbackup/p4
# run the dump database script in the background
$SYBASE/$SYBASE_OCS/bin/isql -U<login> -P<password> -S<server> -i
/dbbackup/dump.sql &
# wait a few seconds for above ASE connection and command to start
sleep 5
# send the pipe outputs to /dev/null in the background
cat /dbbackup/p2 >> /dev/null &
cat /dbbackup/p3 >> /dev/null &
cat /dbbackup/p4 >> /dev/null &
# wait for all background commands above to finish
wait
# cleanup the pipes (they don't consume any space though)
rm /dbbackup/p2 /dbbackup/p3 /dbbackup/p4
exit

### Now, with these two scripts written, simply run your shell script:

/dbbackup/dump_test.sh

<rick_806> wrote in message news:4b9ab23f.148b.1681692777@sybase.com...
> Hi,
>
> Do I need to delete or drop the fifo 's after test is
> concluded?
> Is this correct (current directory /usr/sybase)?
>
> mkfifo p2, p3 .p4
>
> dump database test to "compress::/dbbackup/test.dmp"
> stripe on "compress::p2"
> stripe on "compress::p3"
> stripe on "compress::p4"
> go
>
> ----
> new putty session
>
> cat p2 >> /dev/null &
> cat p3 >> /dev/null &
> cat p4 >> /dev/null &
>
>
> thx,
> rick_806
>
>
>> Use named pipes.
>>
>> #unix command shell
>> mkfifo p2 p3 p4 p5
>>
>> # isql command line
>> 1> dump database yourdb to "/<yourpath>/stripe1.dmp"
>> 2> stripe on "/<yourpath>/p2"
>> 3> stripe on "/<yourpath>/p3"
>> 4> stripe on "/<yourpath>/p4"
>> 5> stripe on "/<yourpath>/p5"
>> 6> go
>>
>> #in a separate unix shell session
>> cat p2 >> /dev/null &
>> cat p3 >> /dev/null &
>> cat p4 >> /dev/null &
>> cat p5 >> /dev/null &
>>
>> put in your "with compress" clauses on the dump database
>> command, etc.
>>
>> once you "cat" all of your named pipes to /dev/null, your
>> backup should finish and result in one file
>> "/<yourpath>/stripe1.dmp" in the example above.
>>
>> <rick_806> wrote in message
>> > news:4b9a8a37.f14.1681692777@sybase.com... ASE 12.5.2
>> >
>> > I need to test compress option on dumps. I don't have
>> > enough disk space to keep an extra dump so I was
>> > wondering if I could dump to 5 stripes with 4 of the
>> > stripes pointing to /dev/null? That would leave one
>> > stripe to use for size estimate based on various
>> > compression settings (1-9) and not use up all my disk
>> space. >
>> > thx,
>> > rick_806
>>
>>


rick_806 Posted on 2010-03-12 22:59:44.0Z
Sender: 60fb.4b95425b.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: dump to /dev/null stripe
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b9ac760.18f2.1681692777@sybase.com>
References: <4b9ab845$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Mar 2010 14:59:44 -0800
X-Trace: forums-1-dub 1268434784 10.22.241.41 (12 Mar 2010 14:59:44 -0800)
X-Original-Trace: 12 Mar 2010 14:59:44 -0800, 10.22.241.41
Lines: 136
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4106
Article PK: 48192

Hi,

I tried several times, it starts writing to the one stripe &
sends all others to pipes. But it dies with the following
error long before finishing.

Mar 12 14:52:56 2010: Backup Server: 4.124.2.1: Archive API
error for device='compress::p7::07': Vendor application
name=Compress API, Library version=1, API
routine=syb_write(), Message=
Mar 12 14:52:56 2010: Backup Server: 4.58.1.1: Database
ifilerpt: 13783226 kilobytes DUMPed.
Mar 12 14:52:57 2010: Backup Server: 4.124.2.1: Archive API
error for device='compress::p9::09': Vendor application
name=Compress API, Library version=1, API
routine=syb_write(), Message=
Mar 12 14:52:58 2010: Open Server Error: 16238.10.0:
srv_senddone(): Invalid result type(1010) for event(2)

> well. you should have everything here that you need...
>
> How about this:
>
>
> #### create a script for isql (let's call it
> /dbbackup/dump.sql)
>
> dump database test to "compress::/dbbackup/test.dmp"
> stripe on "compress::/dbbackup/p2"
> stripe on "compress::/dbbackup/p3"
> stripe on "compress::/dbbackup/p4"
> go
>
> #### create a shell script (let's call it
> /dbbackup/dump_test.sh)
>
> #!/bin/sh
> # create your pipes
> mkfifo /dbbackup/p2 /dbbackup/p3 /dbbackup/p4
> # run the dump database script in the background
> $SYBASE/$SYBASE_OCS/bin/isql -U<login> -P<password>
> -S<server> -i /dbbackup/dump.sql &
> # wait a few seconds for above ASE connection and command
> to start sleep 5
> # send the pipe outputs to /dev/null in the background
> cat /dbbackup/p2 >> /dev/null &
> cat /dbbackup/p3 >> /dev/null &
> cat /dbbackup/p4 >> /dev/null &
> # wait for all background commands above to finish
> wait
> # cleanup the pipes (they don't consume any space though)
> rm /dbbackup/p2 /dbbackup/p3 /dbbackup/p4
> exit
>
> ### Now, with these two scripts written, simply run your
> shell script:
>
> /dbbackup/dump_test.sh
>
>
>
>
>
>
>
> <rick_806> wrote in message
> > news:4b9ab23f.148b.1681692777@sybase.com... Hi,
> >
> > Do I need to delete or drop the fifo 's after test is
> > concluded?
> > Is this correct (current directory /usr/sybase)?
> >
> > mkfifo p2, p3 .p4
> >
> > dump database test to "compress::/dbbackup/test.dmp"
> > stripe on "compress::p2"
> > stripe on "compress::p3"
> > stripe on "compress::p4"
> > go
> >
> > ----
> > new putty session
> >
> > cat p2 >> /dev/null &
> > cat p3 >> /dev/null &
> > cat p4 >> /dev/null &
> >
> >
> > thx,
> > rick_806
> >
> >
> >> Use named pipes.
> >>
> >> #unix command shell
> >> mkfifo p2 p3 p4 p5
> >>
> >> # isql command line
> >> 1> dump database yourdb to "/<yourpath>/stripe1.dmp"
> >> 2> stripe on "/<yourpath>/p2"
> >> 3> stripe on "/<yourpath>/p3"
> >> 4> stripe on "/<yourpath>/p4"
> >> 5> stripe on "/<yourpath>/p5"
> >> 6> go
> >>
> >> #in a separate unix shell session
> >> cat p2 >> /dev/null &
> >> cat p3 >> /dev/null &
> >> cat p4 >> /dev/null &
> >> cat p5 >> /dev/null &
> >>
> >> put in your "with compress" clauses on the dump
> database >> command, etc.
> >>
> >> once you "cat" all of your named pipes to /dev/null,
> your >> backup should finish and result in one file
> >> "/<yourpath>/stripe1.dmp" in the example above.
> >>
> >> <rick_806> wrote in message
> >> > news:4b9a8a37.f14.1681692777@sybase.com... ASE 12.5.2
> >> >
> >> > I need to test compress option on dumps. I don't have
> >> > enough disk space to keep an extra dump so I was
> >> > wondering if I could dump to 5 stripes with 4 of the
> >> > stripes pointing to /dev/null? That would leave one
> >> > stripe to use for size estimate based on various
> >> > compression settings (1-9) and not use up all my disk
> >> space. >
> >> > thx,
> >> > rick_806
> >>
> >>
>
>


Sherlock, Kevin Posted on 2010-03-13 04:07:48.0Z
From: "Sherlock, Kevin" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.backup+recovery
References: <4b9ab845$1@forums-1-dub> <4b9ac760.18f2.1681692777@sybase.com>
Subject: Re: dump to /dev/null stripe
Lines: 142
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b9b0f94$1@forums-1-dub>
Date: 12 Mar 2010 20:07:48 -0800
X-Trace: forums-1-dub 1268453268 10.22.241.152 (12 Mar 2010 20:07:48 -0800)
X-Original-Trace: 12 Mar 2010 20:07:48 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4107
Article PK: 48193

doesn't really look anything related to our script. Can you try without
compression?

<rick_806> wrote in message news:4b9ac760.18f2.1681692777@sybase.com...
> Hi,
>
> I tried several times, it starts writing to the one stripe &
> sends all others to pipes. But it dies with the following
> error long before finishing.
>
> Mar 12 14:52:56 2010: Backup Server: 4.124.2.1: Archive API
> error for device='compress::p7::07': Vendor application
> name=Compress API, Library version=1, API
> routine=syb_write(), Message=
> Mar 12 14:52:56 2010: Backup Server: 4.58.1.1: Database
> ifilerpt: 13783226 kilobytes DUMPed.
> Mar 12 14:52:57 2010: Backup Server: 4.124.2.1: Archive API
> error for device='compress::p9::09': Vendor application
> name=Compress API, Library version=1, API
> routine=syb_write(), Message=
> Mar 12 14:52:58 2010: Open Server Error: 16238.10.0:
> srv_senddone(): Invalid result type(1010) for event(2)
>
>
>
>> well. you should have everything here that you need...
>>
>> How about this:
>>
>>
>> #### create a script for isql (let's call it
>> /dbbackup/dump.sql)
>>
>> dump database test to "compress::/dbbackup/test.dmp"
>> stripe on "compress::/dbbackup/p2"
>> stripe on "compress::/dbbackup/p3"
>> stripe on "compress::/dbbackup/p4"
>> go
>>
>> #### create a shell script (let's call it
>> /dbbackup/dump_test.sh)
>>
>> #!/bin/sh
>> # create your pipes
>> mkfifo /dbbackup/p2 /dbbackup/p3 /dbbackup/p4
>> # run the dump database script in the background
>> $SYBASE/$SYBASE_OCS/bin/isql -U<login> -P<password>
>> -S<server> -i /dbbackup/dump.sql &
>> # wait a few seconds for above ASE connection and command
>> to start sleep 5
>> # send the pipe outputs to /dev/null in the background
>> cat /dbbackup/p2 >> /dev/null &
>> cat /dbbackup/p3 >> /dev/null &
>> cat /dbbackup/p4 >> /dev/null &
>> # wait for all background commands above to finish
>> wait
>> # cleanup the pipes (they don't consume any space though)
>> rm /dbbackup/p2 /dbbackup/p3 /dbbackup/p4
>> exit
>>
>> ### Now, with these two scripts written, simply run your
>> shell script:
>>
>> /dbbackup/dump_test.sh
>>
>>
>>
>>
>>
>>
>>
>> <rick_806> wrote in message
>> > news:4b9ab23f.148b.1681692777@sybase.com... Hi,
>> >
>> > Do I need to delete or drop the fifo 's after test is
>> > concluded?
>> > Is this correct (current directory /usr/sybase)?
>> >
>> > mkfifo p2, p3 .p4
>> >
>> > dump database test to "compress::/dbbackup/test.dmp"
>> > stripe on "compress::p2"
>> > stripe on "compress::p3"
>> > stripe on "compress::p4"
>> > go
>> >
>> > ----
>> > new putty session
>> >
>> > cat p2 >> /dev/null &
>> > cat p3 >> /dev/null &
>> > cat p4 >> /dev/null &
>> >
>> >
>> > thx,
>> > rick_806
>> >
>> >
>> >> Use named pipes.
>> >>
>> >> #unix command shell
>> >> mkfifo p2 p3 p4 p5
>> >>
>> >> # isql command line
>> >> 1> dump database yourdb to "/<yourpath>/stripe1.dmp"
>> >> 2> stripe on "/<yourpath>/p2"
>> >> 3> stripe on "/<yourpath>/p3"
>> >> 4> stripe on "/<yourpath>/p4"
>> >> 5> stripe on "/<yourpath>/p5"
>> >> 6> go
>> >>
>> >> #in a separate unix shell session
>> >> cat p2 >> /dev/null &
>> >> cat p3 >> /dev/null &
>> >> cat p4 >> /dev/null &
>> >> cat p5 >> /dev/null &
>> >>
>> >> put in your "with compress" clauses on the dump
>> database >> command, etc.
>> >>
>> >> once you "cat" all of your named pipes to /dev/null,
>> your >> backup should finish and result in one file
>> >> "/<yourpath>/stripe1.dmp" in the example above.
>> >>
>> >> <rick_806> wrote in message
>> >> > news:4b9a8a37.f14.1681692777@sybase.com... ASE 12.5.2
>> >> >
>> >> > I need to test compress option on dumps. I don't have
>> >> > enough disk space to keep an extra dump so I was
>> >> > wondering if I could dump to 5 stripes with 4 of the
>> >> > stripes pointing to /dev/null? That would leave one
>> >> > stripe to use for size estimate based on various
>> >> > compression settings (1-9) and not use up all my disk
>> >> space. >
>> >> > thx,
>> >> > rick_806
>> >>
>> >>
>>
>>


rick_806 Posted on 2010-03-15 23:41:50.0Z
Sender: 2c7.4b9ec550.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: dump to /dev/null stripe
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b9ec5be.306.1681692777@sybase.com>
References: <4b9b0f94$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Mar 2010 15:41:50 -0800
X-Trace: forums-1-dub 1268696510 10.22.241.41 (15 Mar 2010 15:41:50 -0800)
X-Original-Trace: 15 Mar 2010 15:41:50 -0800, 10.22.241.41
Lines: 151
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4112
Article PK: 48198

Even thought the pipe files are empty, you have to have a
"ulimit" value that allows for the total size of the dump
stripe.

got it done,

thx,
rick_806

> doesn't really look anything related to our script. Can
> you try without compression?
>
> <rick_806> wrote in message
> > news:4b9ac760.18f2.1681692777@sybase.com... Hi,
> >
> > I tried several times, it starts writing to the one
> > stripe & sends all others to pipes. But it dies with the
> > following error long before finishing.
> >
> > Mar 12 14:52:56 2010: Backup Server: 4.124.2.1: Archive
> > API error for device='compress::p7::07': Vendor
> > application name=Compress API, Library version=1, API
> > routine=syb_write(), Message=
> > Mar 12 14:52:56 2010: Backup Server: 4.58.1.1: Database
> > ifilerpt: 13783226 kilobytes DUMPed.
> > Mar 12 14:52:57 2010: Backup Server: 4.124.2.1: Archive
> > API error for device='compress::p9::09': Vendor
> > application name=Compress API, Library version=1, API
> > routine=syb_write(), Message=
> > Mar 12 14:52:58 2010: Open Server Error: 16238.10.0:
> > srv_senddone(): Invalid result type(1010) for event(2)
> >
> >
> >
> >> well. you should have everything here that you need...
> >>
> >> How about this:
> >>
> >>
> >> #### create a script for isql (let's call it
> >> /dbbackup/dump.sql)
> >>
> >> dump database test to "compress::/dbbackup/test.dmp"
> >> stripe on "compress::/dbbackup/p2"
> >> stripe on "compress::/dbbackup/p3"
> >> stripe on "compress::/dbbackup/p4"
> >> go
> >>
> >> #### create a shell script (let's call it
> >> /dbbackup/dump_test.sh)
> >>
> >> #!/bin/sh
> >> # create your pipes
> >> mkfifo /dbbackup/p2 /dbbackup/p3 /dbbackup/p4
> >> # run the dump database script in the background
> >> $SYBASE/$SYBASE_OCS/bin/isql -U<login> -P<password>
> >> -S<server> -i /dbbackup/dump.sql &
> >> # wait a few seconds for above ASE connection and
> command >> to start sleep 5
> >> # send the pipe outputs to /dev/null in the background
> >> cat /dbbackup/p2 >> /dev/null &
> >> cat /dbbackup/p3 >> /dev/null &
> >> cat /dbbackup/p4 >> /dev/null &
> >> # wait for all background commands above to finish
> >> wait
> >> # cleanup the pipes (they don't consume any space
> though) >> rm /dbbackup/p2 /dbbackup/p3 /dbbackup/p4
> >> exit
> >>
> >> ### Now, with these two scripts written, simply run
> your >> shell script:
> >>
> >> /dbbackup/dump_test.sh
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> <rick_806> wrote in message
> >> > news:4b9ab23f.148b.1681692777@sybase.com... Hi,
> >> >
> >> > Do I need to delete or drop the fifo 's after test is
> >> > concluded?
> >> > Is this correct (current directory /usr/sybase)?
> >> >
> >> > mkfifo p2, p3 .p4
> >> >
> >> > dump database test to "compress::/dbbackup/test.dmp"
> >> > stripe on "compress::p2"
> >> > stripe on "compress::p3"
> >> > stripe on "compress::p4"
> >> > go
> >> >
> >> > ----
> >> > new putty session
> >> >
> >> > cat p2 >> /dev/null &
> >> > cat p3 >> /dev/null &
> >> > cat p4 >> /dev/null &
> >> >
> >> >
> >> > thx,
> >> > rick_806
> >> >
> >> >
> >> >> Use named pipes.
> >> >>
> >> >> #unix command shell
> >> >> mkfifo p2 p3 p4 p5
> >> >>
> >> >> # isql command line
> >> >> 1> dump database yourdb to
> "/<yourpath>/stripe1.dmp" >> >> 2> stripe on
> "/<yourpath>/p2" >> >> 3> stripe on "/<yourpath>/p3"
> >> >> 4> stripe on "/<yourpath>/p4"
> >> >> 5> stripe on "/<yourpath>/p5"
> >> >> 6> go
> >> >>
> >> >> #in a separate unix shell session
> >> >> cat p2 >> /dev/null &
> >> >> cat p3 >> /dev/null &
> >> >> cat p4 >> /dev/null &
> >> >> cat p5 >> /dev/null &
> >> >>
> >> >> put in your "with compress" clauses on the dump
> >> database >> command, etc.
> >> >>
> >> >> once you "cat" all of your named pipes to /dev/null,
> >> your >> backup should finish and result in one file
> >> >> "/<yourpath>/stripe1.dmp" in the example above.
> >> >>
> >> >> <rick_806> wrote in message
> >> >> > news:4b9a8a37.f14.1681692777@sybase.com... ASE
> 12.5.2 >> >> >
> >> >> > I need to test compress option on dumps. I don't
> have >> >> > enough disk space to keep an extra dump so I
> was >> >> > wondering if I could dump to 5 stripes with 4
> of the >> >> > stripes pointing to /dev/null? That would
> leave one >> >> > stripe to use for size estimate based on
> various >> >> > compression settings (1-9) and not use up
> all my disk >> >> space. >
> >> >> > thx,
> >> >> > rick_806
> >> >>
> >> >>
> >>
> >>
>
>