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.

NICE TO HAVE FEATURES

5 posts in Product Futures Discussion Last posting was on 2009-12-01 08:57:34.0Z
Eddie_A Posted on 2009-11-27 07:12:40.0Z
From: Eddie_A <renzo.aquino@gmail.com>
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: NICE TO HAVE FEATURES
Date: Thu, 26 Nov 2009 23:12:40 -0800 (PST)
Organization: http://groups.google.com
Lines: 14
Message-ID: <e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com>
NNTP-Posting-Host: 167.230.104.94
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1259305961 23625 127.0.0.1 (27 Nov 2009 07:12:41 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 27 Nov 2009 07:12:41 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f16g2000yqm.googlegroups.com; posting-host=167.230.104.94; posting-account=tGPBogoAAADskRZsAjqsJ5xZWzZ8rxax
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.20) Gecko/20081217 Firefox/2.0.0.20,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.news2me.com!nx01.iad01.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!f16g2000yqm.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2050
Article PK: 97648

1 - A system table that records info from errorlog
-- you don't need a sybase account just to read the /opt/sybase/ase-*/
install/errorlog

2 - create database mydb on mydev_dat("/opt/sybase/data/mydb.dat")
="1000m"
log on mydev_log("/opt/sybase/
data/mydb.log")="500m"
-- The shortcut way creating both db and device -- (other RDBMS
already have this feature)

3 - set forcereadisk on - turns on to force the server to read from
disk instead of cache for debugging and optimization purposes


Carl Kayser Posted on 2009-11-27 12:04:18.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com>
Subject: Re: NICE TO HAVE FEATURES
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b0fc042$1@forums-1-dub>
Date: 27 Nov 2009 04:04:18 -0800
X-Trace: forums-1-dub 1259323458 10.22.241.152 (27 Nov 2009 04:04:18 -0800)
X-Original-Trace: 27 Nov 2009 04:04:18 -0800, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2052
Article PK: 97649


"Eddie_A" <renzo.aquino@gmail.com> wrote in message
news:e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com...
>1 - A system table that records info from errorlog
> -- you don't need a sybase account just to read the /opt/sybase/ase-*/
> install/errorlog
>
> 2 - create database mydb on mydev_dat("/opt/sybase/data/mydb.dat")
> ="1000m"
> log on mydev_log("/opt/sybase/
> data/mydb.log")="500m"
> -- The shortcut way creating both db and device -- (other RDBMS
> already have this feature)
>
> 3 - set forcereadisk on - turns on to force the server to read from
> disk instead of cache for debugging and optimization purposes
>

(1) Apparently you meant "you don't need an OS account ..." And Rob
provided two solutions for this functionality. (I agree with the feature
intent and personally use the RPC solution for this functionality.)

(2) This brings up a problem in my mind. The sizes are for both the
database and the device. If you have a limited number of OS partitions (as
I do with Solaris) and many databases (250+ on one of my ASE servers) then
this feature won't really buy you anything. I also like to see how the
space is allocated on devices used for ASE. This includes "device free
space" which I can't see from within ASE using the above shortcut.

(3) Interesting. I can see the tuning possibility but don't see the
debugging aspect. Could you provide a particular example? What happens at
the end of the set forcereadisk command /batch/session? I'm guessing that
the data is discarded else you have two versions of the same data - a DBA
no-no.


Carl Kayser Posted on 2009-11-27 19:47:10.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com> <4b0fc042$1@forums-1-dub>
Subject: Re: NICE TO HAVE FEATURES
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b102cbe$1@forums-1-dub>
Date: 27 Nov 2009 11:47:10 -0800
X-Trace: forums-1-dub 1259351230 10.22.241.152 (27 Nov 2009 11:47:10 -0800)
X-Original-Trace: 27 Nov 2009 11:47:10 -0800, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2053
Article PK: 97651


"Carl Kayser" <kayser_c@bls.gov> wrote in message
news:4b0fc042$1@forums-1-dub...
>
> "Eddie_A" <renzo.aquino@gmail.com> wrote in message
> news:e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com...
>>1 - A system table that records info from errorlog
>> -- you don't need a sybase account just to read the /opt/sybase/ase-*/
>> install/errorlog
>>
>> 2 - create database mydb on mydev_dat("/opt/sybase/data/mydb.dat")
>> ="1000m"
>> log on mydev_log("/opt/sybase/
>> data/mydb.log")="500m"
>> -- The shortcut way creating both db and device -- (other RDBMS
>> already have this feature)
>>
>> 3 - set forcereadisk on - turns on to force the server to read from
>> disk instead of cache for debugging and optimization purposes
>>
>
> (1) Apparently you meant "you don't need an OS account ..." And Rob
> provided two solutions for this functionality. (I agree with the feature
> intent and personally use the RPC solution for this functionality.)
>
> (2) This brings up a problem in my mind. The sizes are for both the
> database and the device. If you have a limited number of OS partitions
> (as I do with Solaris) and many databases (250+ on one of my ASE servers)
> then this feature won't really buy you anything. I also like to see how
> the space is allocated on devices used for ASE. This includes "device
> free space" which I can't see from within ASE using the above shortcut.
>
> (3) Interesting. I can see the tuning possibility but don't see the
> debugging aspect. Could you provide a particular example? What happens
> at the end of the set forcereadisk command /batch/session? I'm guessing
> that the data is discarded else you have two versions of the same data - a
> DBA no-no.
>

Ahh, headaches with (1). Only an SA granted mon_role can select from the
monErrorLog table; this can't be overriden. Using the RPC technique could
open up some security concerns with xp_cmdshell.


Eddie_A Posted on 2009-12-01 08:57:34.0Z
From: Eddie_A <renzo.aquino@gmail.com>
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: NICE TO HAVE FEATURES
Date: Tue, 1 Dec 2009 00:57:34 -0800 (PST)
Organization: http://groups.google.com
Lines: 67
Message-ID: <f1518e23-0672-4298-9cd0-9395e04c966b@e23g2000yqd.googlegroups.com>
References: <e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com> <4b0fc042$1@forums-1-dub> <4b102cbe$1@forums-1-dub>
NNTP-Posting-Host: 167.230.104.94
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1259657854 15235 127.0.0.1 (1 Dec 2009 08:57:34 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 1 Dec 2009 08:57:34 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e23g2000yqd.googlegroups.com; posting-host=167.230.104.94; posting-account=tGPBogoAAADskRZsAjqsJ5xZWzZ8rxax
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.20) Gecko/20081217 Firefox/2.0.0.20,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!e23g2000yqd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2054
Article PK: 97652


On Nov 28, 3:47 am, "Carl Kayser" <kayse...@bls.gov> wrote:
> "Carl Kayser" <kayse...@bls.gov> wrote in message
>
> news:4b0fc042$1@forums-1-dub...
>
>
>
>
>
> > "Eddie_A" <renzo.aqu...@gmail.com> wrote in message
> >news:e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com...
> >>1 - A system table that records info from errorlog
> >> -- you don't need a sybase account just to read the /opt/sybase/ase-*/
> >> install/errorlog
>
> >> 2 - create database mydb on mydev_dat("/opt/sybase/data/mydb.dat")
> >> ="1000m"
> >> log on mydev_log("/opt/sybase/
> >> data/mydb.log")="500m"
> >> -- The shortcut way creating both db and device -- (other RDBMS
> >> already have this feature)
>
> >> 3 - set forcereadisk on - turns on to force the server to read from
> >> disk instead of cache for debugging and optimization purposes
>
> > (1) Apparently you meant "you don't need an OS account ..." And Rob
> > provided two solutions for this functionality. (I agree with the feature
> > intent and personally use the RPC solution for this functionality.)
>
> > (2) This brings up a problem in my mind. The sizes are for both the
> > database and the device. If you have a limited number of OS partitions
> > (as I do with Solaris) and many databases (250+ on one of my ASE servers)
> > then this feature won't really buy you anything. I also like to see how
> > the space is allocated on devices used for ASE. This includes "device
> > free space" which I can't see from within ASE using the above shortcut.
>
> > (3) Interesting. I can see the tuning possibility but don't see the
> > debugging aspect. Could you provide a particular example? What happens
> > at the end of the set forcereadisk command /batch/session? I'm guessing
> > that the data is discarded else you have two versions of the same data - a
> > DBA no-no.
>
> Ahh, headaches with (1). Only an SA granted mon_role can select from the
> monErrorLog table; this can't be overriden. Using the RPC technique could
> open up some security concerns with xp_cmdshell.

Reasons:
Feature 1- In my experience as a DBA I don't care about all about
these things. But now I am on a different project were I don't have
access to the errorlog. It brought me to realize that as an ordinary
user am just left out with nothing if I get a message "ASE is
terminating this process" or a process just went dead or something. It
would be nice if there is something I can look at the errors

Feature 2- This would be just an added feature to what is already
there. In cases were you have limited partitions, you can use the old
method. Why would you sacrifice a nice feature just because because
one OS will not benefit from it.

Feature 3- Again as an ordinary user you don't have all the tuning
rights of a DBA in optimizing an SQL. You cannot unbind a cache, etc.
So don't blame the SQL Dev or DEV DBA for a slow running SQL. This
feature will primarily be for tuning purposes only. What is on the
cache don't touch it, just read it from the disk.


Rob V [ Sybase ] Posted on 2009-11-27 08:51:23.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com>
Subject: Re: NICE TO HAVE FEATURES
Lines: 49
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b0f930b@forums-1-dub>
Date: 27 Nov 2009 00:51:23 -0800
X-Trace: forums-1-dub 1259311883 10.22.241.152 (27 Nov 2009 00:51:23 -0800)
X-Original-Trace: 27 Nov 2009 00:51:23 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2051
Article PK: 97653

Just commenting on #1: this is already possible in two different ways:

(i) you can define a proxy table mapping to the errorlog file, so you can
read it by querying the proxy table. This is pretty simple (also see section
2.3.5 of my book "Tips, Tricks & Recipes for Sybase ASE" should you have
that)

(ii) the MDA table monErrorLog contains the last N lines written to the
errorlog (N is configurable).

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"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"Eddie_A" <renzo.aquino@gmail.com> wrote in message
news:e6e375fd-c574-4666-8c0e-e845f274c782@f16g2000yqm.googlegroups.com...
>1 - A system table that records info from errorlog
> -- you don't need a sybase account just to read the /opt/sybase/ase-*/
> install/errorlog
>
> 2 - create database mydb on mydev_dat("/opt/sybase/data/mydb.dat")
> ="1000m"
> log on mydev_log("/opt/sybase/
> data/mydb.log")="500m"
> -- The shortcut way creating both db and device -- (other RDBMS
> already have this feature)
>
> 3 - set forcereadisk on - turns on to force the server to read from
> disk instead of cache for debugging and optimization purposes
>