ASE Database forum - ASE resize device?

Author

ASE resize device?

Jayvee Vibar

2005-04-28, 8:26 pm

How do you resize a device to be larger, after disk init, after you had an
existing data on it?
And why is it that on master..sysdevices, column phyname should map to
filesystem file, but unlike the logical name master, which has d_master as
phyname not e.g. /sybase/master.dat? Thanks.

Bret Halford

2005-04-29, 3:26 am

use the DISK RESIZE command.

The master device is specified in the run server file using the -d parameter
to dataserver - ASE has to know what that path is before it can access
the sysdevices table. The master device itself may have been moved
(and the -d parameter modified to reflect that change) - so there any value
stored in sysdevices wouldn't necessarily be accurate anyway. However,
I believe the current version of ASE does populate the physname with the
value provided when ASE was created.

-bret

Jayvee Vibar wrote:

> How do you resize a device to be larger, after disk init, after you had an
> existing data on it?
> And why is it that on master..sysdevices, column phyname should map to
> filesystem file, but unlike the logical name master, which has d_master as
> phyname not e.g. /sybase/master.dat? Thanks.

Jayvee Vibar

2005-04-29, 3:26 am

I'm using 11.0.3. probably not supported. any other way? Thanks.

"Bret Halford" <bret@sybase.com> wrote in message
news:42719744.3CB5B143@sybase.com...
> use the DISK RESIZE command.
>
> The master device is specified in the run server file using the -d
parameter
> to dataserver - ASE has to know what that path is before it can access
> the sysdevices table. The master device itself may have been moved
> (and the -d parameter modified to reflect that change) - so there any
value

> stored in sysdevices wouldn't necessarily be accurate anyway. However,
> I believe the current version of ASE does populate the physname with the
> value provided when ASE was created.
>
> -bret
>
>
> Jayvee Vibar wrote:
>
an[color=darkred]
as[color=darkred]
>

Luc Van der Veurst

2005-04-29, 3:26 am

"Jayvee Vibar" <jcnvibar@hotmail.com> wrote in message
news:4271a039$1@foru
ms-1-dub...
[color=darkred]
d_master[color=darkr
ed]
> as

You can change the name in sysdevices :

sp_configure 'allow updates', 1

update sysdevices set phyname = '/sybase/master.dat' where name = 'master'

sp_configure 'allow updates', 0

Luc.

Jeffrey R. Garbus

2005-04-29, 11:26 am

But first, make a backup of master, and any databases that reside on that
device...

"Luc Van der Veurst" <dba_azvub@hotmail.com> wrote in message
news:4271e7b8$1@foru
ms-2-dub...
>
> "Jayvee Vibar" <jcnvibar@hotmail.com> wrote in message
> news:4271a039$1@foru
ms-1-dub...
>
to[color=darkred]
> d_master
>
> You can change the name in sysdevices :
>
> sp_configure 'allow updates', 1
>
> update sysdevices set phyname = '/sybase/master.dat' where name = 'master'
>
> sp_configure 'allow updates', 0
>
>
> Luc.
>
>
>

Bret Halford

2005-04-30, 3:26 am

Well, you can upgrade 11.0.3 - that is what I would recommend.

However, if staying on 11.0.x:

For resizing the device, you can also simply increase the "high"
value in sysdevices so that (high-low) = size you want.

If the device is on a raw partition, it better actually be that big.
If the device is on a file system, make sure there is that much
additional free space on the file system. The DISK RESIZE
command does that kind of sanity checking for you.

My recollection is there is no need to reboot.

-bret

Jayvee Vibar wrote:
[color=darkred]
> I'm using 11.0.3. probably not supported. any other way? Thanks.
>
> "Bret Halford" <bret@sybase.com> wrote in message
> news:42719744.3CB5B143@sybase.com...
> parameter
> value
> an
> as

Sponsored Links