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.

Extending the database on the wrong device

4 posts in General Discussion Last posting was on 2010-10-28 18:21:00.0Z
Dan Daradan Posted on 2010-10-27 08:29:07.0Z
From: "Dan Daradan" <x@invalid.invalid>
Newsgroups: sybase.public.ase.general
Subject: Extending the database on the wrong device
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cc7e2d3$1@forums-1-dub>
Date: 27 Oct 2010 01:29:07 -0700
X-Trace: forums-1-dub 1288168147 10.22.241.152 (27 Oct 2010 01:29:07 -0700)
X-Original-Trace: 27 Oct 2010 01:29:07 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29669
Article PK: 78901

On my server ASE 15.0.3 or RHEL I have 2 databases, PRODDB (on device
proddb_dev) and TESTDB (on device testdb_dev)
Overnight, I make a DUMP from PRDDB and a load on TESTDB
When the databases gets too big, I expand them of 1 GB every time
Yesterday I made a mistake, and I expanded PRODDB on testdb_dev
Is there a way to correct this mistake? Clearly, the database has already
started using the new space.


Bret Halford Posted on 2010-10-27 15:20:14.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.11) Gecko/20101013 Thunderbird/3.1.5
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Extending the database on the wrong device
References: <4cc7e2d3$1@forums-1-dub>
In-Reply-To: <4cc7e2d3$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cc8432e@forums-1-dub>
Date: 27 Oct 2010 08:20:14 -0700
X-Trace: forums-1-dub 1288192814 10.22.241.152 (27 Oct 2010 08:20:14 -0700)
X-Original-Trace: 27 Oct 2010 08:20:14 -0700, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29671
Article PK: 78898


On 10/27/2010 2:29 AM, Dan Daradan wrote:
> On my server ASE 15.0.3 or RHEL I have 2 databases, PRODDB (on device
> proddb_dev) and TESTDB (on device testdb_dev)
> Overnight, I make a DUMP from PRDDB and a load on TESTDB
> When the databases gets too big, I expand them of 1 GB every time
> Yesterday I made a mistake, and I expanded PRODDB on testdb_dev
> Is there a way to correct this mistake? Clearly, the database has
> already started using the new space.

Sure. After you dump the database, drop the database.
Then do a create database for load, placing the fragments
on the desired devices (i.e. all the same as before except
the last one).


Dan Daradan Posted on 2010-10-28 06:39:45.0Z
From: "Dan Daradan" <x@invalid.invalid>
Newsgroups: sybase.public.ase.general
References: <4cc7e2d3$1@forums-1-dub> <4cc8432e@forums-1-dub>
In-Reply-To: <4cc8432e@forums-1-dub>
Subject: Re: Extending the database on the wrong device
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cc91ab1$1@forums-1-dub>
Date: 27 Oct 2010 23:39:45 -0700
X-Trace: forums-1-dub 1288247985 10.22.241.152 (27 Oct 2010 23:39:45 -0700)
X-Original-Trace: 27 Oct 2010 23:39:45 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29672
Article PK: 78902


"Bret Halford" <bret@sybase.com> wrote in message
news:4cc8432e@forums-1-dub...
> On 10/27/2010 2:29 AM, Dan Daradan wrote:
>> On my server ASE 15.0.3 or RHEL I have 2 databases, PRODDB (on device
>> proddb_dev) and TESTDB (on device testdb_dev)
>> Overnight, I make a DUMP from PRDDB and a load on TESTDB
>> When the databases gets too big, I expand them of 1 GB every time
>> Yesterday I made a mistake, and I expanded PRODDB on testdb_dev
>> Is there a way to correct this mistake? Clearly, the database has
>> already started using the new space.
>
> Sure. After you dump the database, drop the database.
> Then do a create database for load, placing the fragments
> on the desired devices (i.e. all the same as before except
> the last one).

Thanks.
Is there a way to do it without downtime?


Bret Halford Posted on 2010-10-28 18:21:00.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.11) Gecko/20101013 Thunderbird/3.1.5
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Extending the database on the wrong device
References: <4cc7e2d3$1@forums-1-dub> <4cc8432e@forums-1-dub> <4cc91ab1$1@forums-1-dub>
In-Reply-To: <4cc91ab1$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cc9bf0c$1@forums-1-dub>
Date: 28 Oct 2010 11:21:00 -0700
X-Trace: forums-1-dub 1288290060 10.22.241.152 (28 Oct 2010 11:21:00 -0700)
X-Original-Trace: 28 Oct 2010 11:21:00 -0700, vip152.sybase.com
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29674
Article PK: 78903


On 10/27/2010 11:39 PM, Dan Daradan wrote:
> "Bret Halford" <bret@sybase.com> wrote in message
> news:4cc8432e@forums-1-dub...
>> On 10/27/2010 2:29 AM, Dan Daradan wrote:
>>> On my server ASE 15.0.3 or RHEL I have 2 databases, PRODDB (on device
>>> proddb_dev) and TESTDB (on device testdb_dev)
>>> Overnight, I make a DUMP from PRDDB and a load on TESTDB
>>> When the databases gets too big, I expand them of 1 GB every time
>>> Yesterday I made a mistake, and I expanded PRODDB on testdb_dev
>>> Is there a way to correct this mistake? Clearly, the database has
>>> already started using the new space.
>>
>> Sure. After you dump the database, drop the database.
>> Then do a create database for load, placing the fragments
>> on the desired devices (i.e. all the same as before except
>> the last one).
>
> Thanks.
> Is there a way to do it without downtime?

I don't think so.

-bret