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.

dynamic database sizing

8 posts in Product Futures Discussion Last posting was on 2002-01-25 21:47:18.0Z
Matt Connock Posted on 2002-01-22 23:50:10.0Z
Reply-To: "Matt Connock" <matthew.connock@au.pwcglobal.com>
From: "Matt Connock" <matthew.connock@au.pwcglobal.com>
Subject: dynamic database sizing
Date: Wed, 23 Jan 2002 10:50:10 +1100
Lines: 8
Organization: PricewatehouseCoopers
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <N#ASaG6oBHA.123@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 203.11.225.5
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:895
Article PK: 94424

Growing and shrinking databases would be great and would have saved me a
HEAP of time on my last project.

my .50c worth

Matt


Matt Rogish Posted on 2002-01-23 02:32:19.0Z
From: "Matt Rogish" <matt@fanhome.com>
References: <N#ASaG6oBHA.123@forums.sybase.com>
Subject: Re: dynamic database sizing
Date: Tue, 22 Jan 2002 21:32:19 -0500
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <uE71Ic7oBHA.140@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: dhcp065-031-054-014.woh.rr.com 65.31.54.14
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:894
Article PK: 94423

I agree with Matt.

Certainly not an infinite type thing (like MySQL for instance) but the
ability to, say:
1) Create spare database devices
2) Tell ASE that, if database XYZ gets down to X% free, go ahead and expand
by XXXMB.
2a) If there exists no more room on the current DB device, extend on X, Y,
Z (in that order)
3) Write a message to the error log, send an e-mail to some address, execute
a stored procedure, etc.

It doesn't have to be too terribly complicated and feature packed but kind
of like a last-chance, CYA (Cover Your A$$) thing -- if you're busy doing
100 different things at once you may only get to sp_helpsegment once or
twice a month -- which means you could run out of free space and have those
ugly 'out of space on extent ..' errors and costly downtime in the middle of
the day, for example.

--
Matt

"Matt Connock" <matthew.connock@au.pwcglobal.com> wrote in message
news:N#ASaG6oBHA.123@forums.sybase.com...
> Growing and shrinking databases would be great and would have saved me a
> HEAP of time on my last project.
>
> my .50c worth
>
> Matt


Roger Broadbent Posted on 2002-01-23 13:04:45.0Z
From: "Roger Broadbent" <RBroadbent@wilco-int.com>
References: <N#ASaG6oBHA.123@forums.sybase.com> <uE71Ic7oBHA.140@forums.sybase.com>
Subject: Re: dynamic database sizing
Date: Wed, 23 Jan 2002 13:04:45 -0000
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <lCBzp9ApBHA.313@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: wilcohost-180.wilco-int.com 212.36.174.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:887
Article PK: 94413

Is there any reason why thresholds can't be used to run this kind of logic?

--
Roger Broadbent
Technical Consultant
Wilco International Ltd

Matt Rogish <matt@fanhome.com> wrote in message
news:uE71Ic7oBHA.140@forums.sybase.com...
> I agree with Matt.
>
> Certainly not an infinite type thing (like MySQL for instance) but the
> ability to, say:
> 1) Create spare database devices
> 2) Tell ASE that, if database XYZ gets down to X% free, go ahead and
expand
> by XXXMB.
> 2a) If there exists no more room on the current DB device, extend on X,
Y,
> Z (in that order)
> 3) Write a message to the error log, send an e-mail to some address,
execute
> a stored procedure, etc.
>
> It doesn't have to be too terribly complicated and feature packed but kind
> of like a last-chance, CYA (Cover Your A$$) thing -- if you're busy doing
> 100 different things at once you may only get to sp_helpsegment once or
> twice a month -- which means you could run out of free space and have
those
> ugly 'out of space on extent ..' errors and costly downtime in the middle
of
> the day, for example.
>
> --
> Matt
>
> "Matt Connock" <matthew.connock@au.pwcglobal.com> wrote in message
> news:N#ASaG6oBHA.123@forums.sybase.com...
> > Growing and shrinking databases would be great and would have saved me a
> > HEAP of time on my last project.
> >
> > my .50c worth
> >
> > Matt
>
>


kevbo Posted on 2002-01-25 17:40:16.0Z
From: kevbo
Date: Fri, 25 Jan 2002 12:40:16 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: dynamic database sizing
Message-ID: <5E1AD990758D56890061121A85256B4C.004C2B1C85256B4A@webforums>
References: <N#ASaG6oBHA.123@forums.sybase.com> <uE71Ic7oBHA.140@forums.sybase.com> <lCBzp9ApBHA.313@forums.sybase.com>
Lines: 4
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.ase.product_futures_discussion:854
Article PK: 94382

yawa - yet another workaround

At least you can work around this, but it would be a nice feature. I'm
tired of coding workarounds for features that aren't there.


Sherlock, Kevin Posted on 2002-01-25 21:44:26.0Z
Message-ID: <3C51D19F.2EE24969@qwest.com>
Date: Fri, 25 Jan 2002 15:44:26 -0600
From: "Sherlock, Kevin" <ksherlo@qwest.com>
Reply-To: ksherlo@qwest.com
Organization: QWEST DEX
X-Mailer: Mozilla 4.79 (Macintosh; U; PPC)
X-Accept-Language: en,pdf,ko
MIME-Version: 1.0
Subject: Re: dynamic database sizing
References: <N#ASaG6oBHA.123@forums.sybase.com> <uE71Ic7oBHA.140@forums.sybase.com> <lCBzp9ApBHA.313@forums.sybase.com> <5E1AD990758D56890061121A85256B4C.004C2B1C85256B4A@webforums>
Content-Type: multipart/mixed; boundary="------------4B1CE0C9531676E4CFC107D2"
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 28
NNTP-Posting-Host: np-10.dex.uswest.com 199.168.39.10
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:850
Article PK: 94379


kevbo wrote:
>
> yawa - yet another workaround
>
> At least you can work around this, but it would be a nice feature. I'm
> tired of coding workarounds for features that aren't there.

Who said thresholds are "workarounds"? Thresholds are features meant to
be used. A lot like ASE's support for SQL as an access language :)


Download VCard ksherlo.vcf


Sherlock, Kevin Posted on 2002-01-23 18:52:06.0Z
Message-ID: <3C4F0647.CD740342@qwest.com>
Date: Wed, 23 Jan 2002 12:52:06 -0600
From: "Sherlock, Kevin" <ksherlo@qwest.com>
Reply-To: ksherlo@qwest.com
Organization: QWEST DEX
X-Mailer: Mozilla 4.79 (Macintosh; U; PPC)
X-Accept-Language: en,pdf,ko
MIME-Version: 1.0
Subject: Re: dynamic database sizing
References: <N#ASaG6oBHA.123@forums.sybase.com> <uE71Ic7oBHA.140@forums.sybase.com> <lCBzp9ApBHA.313@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------407F5236F7B4F414815658AC"
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 26
NNTP-Posting-Host: np-10.dex.uswest.com 199.168.39.10
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:883
Article PK: 94410


Roger Broadbent wrote:
>
> Is there any reason why thresholds can't be used to run this kind of logic?
>

Exactly how we have done it here. Use thresholds to alter database
sizes. Now, this was only for increasing the size. Reducing database
size would be a little trickier...


Download VCard ksherlo.vcf


Carl Kayser Posted on 2002-01-23 20:09:58.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
References: <N#ASaG6oBHA.123@forums.sybase.com> <uE71Ic7oBHA.140@forums.sybase.com> <lCBzp9ApBHA.313@forums.sybase.com> <3C4F0647.CD740342@qwest.com>
Subject: Re: dynamic database sizing
Date: Wed, 23 Jan 2002 15:09:58 -0500
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <6WbP8qEpBHA.190@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 146.142.35.25
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:882
Article PK: 94416


"Sherlock, Kevin" <ksherlo@qwest.com> wrote in message
news:3C4F0647.CD740342@qwest.com...
> Roger Broadbent wrote:
> >
> > Is there any reason why thresholds can't be used to run this kind of
logic?
> >
>
> Exactly how we have done it here. Use thresholds to alter database
> sizes. Now, this was only for increasing the size. Reducing database
> size would be a little trickier...

Only "a little trickier"?


Sherlock, Kevin Posted on 2002-01-25 21:47:18.0Z
Message-ID: <3C51D24B.C0E30D98@qwest.com>
Date: Fri, 25 Jan 2002 15:47:18 -0600
From: "Sherlock, Kevin" <ksherlo@qwest.com>
Reply-To: ksherlo@qwest.com
Organization: QWEST DEX
X-Mailer: Mozilla 4.79 (Macintosh; U; PPC)
X-Accept-Language: en,pdf,ko
MIME-Version: 1.0
Subject: Re: dynamic database sizing
References: <N#ASaG6oBHA.123@forums.sybase.com> <uE71Ic7oBHA.140@forums.sybase.com> <lCBzp9ApBHA.313@forums.sybase.com> <3C4F0647.CD740342@qwest.com> <6WbP8qEpBHA.190@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------2CA6148C82C7543CB49F9B79"
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 41
NNTP-Posting-Host: np-10.dex.uswest.com 199.168.39.10
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:849
Article PK: 94377


Carl Kayser wrote:
>
> "Sherlock, Kevin" <ksherlo@qwest.com> wrote in message
> news:3C4F0647.CD740342@qwest.com...
> > Roger Broadbent wrote:
> > >
> > > Is there any reason why thresholds can't be used to run this kind of
> logic?
> > >
> >
> > Exactly how we have done it here. Use thresholds to alter database
> > sizes. Now, this was only for increasing the size. Reducing database
> > size would be a little trickier...
>
> Only "a little trickier"?

:)

Ok, A LOT trickier. Hey, very few things are impossible :)

If you can automate what it takes to reduce a database, you can always
call an extended proc from the threshold to do the work. Currently, I
have a threshold that drops tables from a database which reduces the
_used_ size of a database. To reduce the allocations, one could
probably cook that up too.


Download VCard ksherlo.vcf