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.

ASE 12 - Can "devices" that are files grow??

3 posts in Windows NT Last posting was on 2000-12-15 04:53:28.0Z
Phil Shevrin Posted on 2000-11-29 22:40:29.0Z
From: "Phil Shevrin" <shevrin@opinionware.com>
Subject: ASE 12 - Can "devices" that are files grow??
Date: Wed, 29 Nov 2000 17:40:29 -0500
Lines: 9
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Message-ID: <C9DnWblWAHA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ip-216-73-174-220.hqglobal.net 216.73.174.220
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1443
Article PK: 1088917

Hi:

I'm new to Sybase. I'm running ASE 12 on NT. In looking at the docs, it
doesn't seem that a "device" that is a file will dynamically grow if it gets
full. Oracle, MS SQL Server and DB2 all can grow database files
dynamically, so I'm just assuming I missed something in the Admin guides.
Any help would be appreciated.


Bret Halford Posted on 2000-11-30 00:29:13.0Z
Message-ID: <3A259F59.59834A2B@sybase.com>
Date: Wed, 29 Nov 2000 17:29:13 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: ja,en
MIME-Version: 1.0
Subject: Re: ASE 12 - Can "devices" that are files grow??
References: <C9DnWblWAHA.203@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 25
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1442
Article PK: 1088912


Phil Shevrin wrote:

> Hi:
>
> I'm new to Sybase. I'm running ASE 12 on NT. In looking at the docs, it
> doesn't seem that a "device" that is a file will dynamically grow if it gets
> full. Oracle, MS SQL Server and DB2 all can grow database files
> dynamically, so I'm just assuming I missed something in the Admin guides.
> Any help would be appreciated.

Nope, you haven't missed anything. Devices are statically sized, as are the
allocations of databases upon those devices. There are no commands to
specifically resize devices, the normal procedure would be to create a new
device
and the alter the database onto it, or (dump and drop the database, drop the
device,
recreate device larger, reload database). That said, it is actually possible to
increase
the size of a device by increasing the value of the "high" field in sysdevices -
however
it is up to you to check that the filesystem (or raw partition) actually has
enough space.

-bret


Anonymous Posted on 2000-12-15 04:53:28.0Z
From: Anonymous@sybase.com
Date: Thu, 14 Dec 2000 23:53:28 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Use Oracle OR MSSQL 7
Message-ID: <440EE64009C2A51D001ADE10852569B6.00071265852569A7@webforums>
References: <C9DnWblWAHA.203@forums.sybase.com> <3A259F59.59834A2B@sybase.com>
Lines: 11
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1394
Article PK: 1088861

Sybase just doesn't get it.

Oracle and MSSQL7 permit you to dynamically alter
pieces of disk space containing database objects.

Sybase waited until ASE12 to support native file systems
rather than raw partitions.

It will be a cold day in EMERYVILLE before
Sybase gets with it.