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.
Subject: ASE 12 - Can "devices" that are files grow??
Date: Wed, 29 Nov 2000 17:40:29 -0500
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: ip-216-73-174-220.hqglobal.net 220.127.116.11
Xref: forums-1-dub sybase.public.sqlserver.nt:1443
Article PK: 1088917
Date: Wed, 29 Nov 2000 17:29:13 -0700
From: Bret Halford <firstname.lastname@example.org>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
Subject: Re: ASE 12 - Can "devices" that are files grow??
Content-Type: text/plain; charset=us-ascii
NNTP-Posting-Host: bret-pc.sybase.com 18.104.22.168
Xref: forums-1-dub sybase.public.sqlserver.nt:1442
Article PK: 1088912
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
and the alter the database onto it, or (dump and drop the database, drop the
recreate device larger, reload database). That said, it is actually possible to
the size of a device by increasing the value of the "high" field in sysdevices -
it is up to you to check that the filesystem (or raw partition) actually has
Date: Thu, 14 Dec 2000 23:53:28 -0500
Subject: Use Oracle OR MSSQL 7
References: <C9DnWblWAHA.email@example.com> <3A259F59.59834A2B@sybase.com>
Content-Type: text/plain; charset="us-ascii"
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.