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.

Cache

3 posts in General Discussion Last posting was on 2011-05-05 16:36:53.0Z
John Posted on 2011-05-04 21:32:34.0Z
Sender: 8c5.4dc16b66.1804289383@sybase.com
From: JOhn
Newsgroups: sybase.public.ase.general
Subject: Cache
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4dc1c5f2.1a09.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 May 2011 14:32:34 -0700
X-Trace: forums-1-dub 1304544754 10.22.241.41 (4 May 2011 14:32:34 -0700)
X-Original-Trace: 4 May 2011 14:32:34 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30155
Article PK: 72339

Hi

On ase 15 is there a command to clear the entire cache after
changing server optgoal?


Rob V [ Sybase ] Posted on 2011-05-04 22:05:18.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.17) Gecko/20110414 Lightning/1.0b2 Thunderbird/3.1.10
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Cache
References: <4dc1c5f2.1a09.1681692777@sybase.com>
In-Reply-To: <4dc1c5f2.1a09.1681692777@sybase.com>
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: <4dc1cd9e$1@forums-1-dub>
Date: 4 May 2011 15:05:18 -0700
X-Trace: forums-1-dub 1304546718 10.22.241.152 (4 May 2011 15:05:18 -0700)
X-Original-Trace: 4 May 2011 15:05:18 -0700, vip152.sybase.com
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30156
Article PK: 72334


On 04-May-2011 23:32, JOhn wrote:
> Hi
>
> On ase 15 is there a command to clear the entire cache after
> changing server optgoal?

You can use dbcc cachedataremove(dbid). If multipel databases are
involved, run this command multiple times. It is not supproted for
in-memory databases, and I've found it may not work for master DB.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


J Posted on 2011-05-05 16:36:53.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Cache
Reply-To: J@bogusemailAddress.com
Message-ID: <4dc2d1b5.1993235218@forums.sybase.com>
References: <4dc1c5f2.1a09.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 5 May 2011 09:36:53 -0700
X-Trace: forums-1-dub 1304613413 10.22.241.152 (5 May 2011 09:36:53 -0700)
X-Original-Trace: 5 May 2011 09:36:53 -0700, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30157
Article PK: 72335

On 4 May 2011 14:32:34 -0700, JOhn wrote:

If you're talking about clearing the statement cache:
use command "dbcc purgesqlcache"


http://manuals.sybase.com/onlinebooks/group-as/asg1252e/1252newfeatures/@ebt-link;hf=0;pt=1388?target=%25N%14_1129_START_RESTART_N%25#X

>Hi
>
>On ase 15 is there a command to clear the entire cache after
>changing server optgoal?