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.

sp__optdiag on ASE 15.02.

7 posts in Performance and Tuning Last posting was on 2007-11-14 20:16:15.0Z
Isabella Posted on 2007-11-09 17:42:55.0Z
From: Isabella <isabella.ghiurea@nrc-cnrc.gc.ca>
User-Agent: Thunderbird 1.5.0.12 (X11/20070530)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.performance+tuning
Subject: sp__optdiag on ASE 15.02.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: fw.hia.nrc.ca
X-Original-NNTP-Posting-Host: fw.hia.nrc.ca
Message-ID: <47349c1f$1@forums-1-dub>
Date: 9 Nov 2007 09:42:55 -0800
X-Trace: forums-1-dub 1194630175 204.174.103.3 (9 Nov 2007 09:42:55 -0800)
X-Original-Trace: 9 Nov 2007 09:42:55 -0800, fw.hia.nrc.ca
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10451
Article PK: 89074

Hello Gurus,
Would like to know if anyone of you managed to use sp__optdiag procs
utility in ASE 15.0.2, I'm getting an error when trying to compile the
procs,

thank you,
Isabella


"Mark A. Parsons" <iron_horse Posted on 2007-11-09 22:04:07.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.performance+tuning
Subject: Re: sp__optdiag on ASE 15.02.
References: <47349c1f$1@forums-1-dub>
In-Reply-To: <47349c1f$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ool-4357fce9.dyn.optonline.net
X-Original-NNTP-Posting-Host: ool-4357fce9.dyn.optonline.net
Message-ID: <4734d957$1@forums-1-dub>
Date: 9 Nov 2007 14:04:07 -0800
X-Trace: forums-1-dub 1194645847 67.87.252.233 (9 Nov 2007 14:04:07 -0800)
X-Original-Trace: 9 Nov 2007 14:04:07 -0800, ool-4357fce9.dyn.optonline.net
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10453
Article PK: 89077

The ASE 12.x version of sp__optdiag won't work in ASE 15.x ("Duh, Mark!" ?).

You'll either need to do some customization on the version you have ... or see if Kevin Sherlock's got any plans for an
ASE 15.x version of sp__optdiag. (You should be able to find Kevin's contact info in these newsgroups or at the
teamsybase.com website.)

Isabella wrote:
> Hello Gurus,
> Would like to know if anyone of you managed to use sp__optdiag procs
> utility in ASE 15.0.2, I'm getting an error when trying to compile the
> procs,
>
> thank you,
> Isabella


Isabella Posted on 2007-11-13 23:02:11.0Z
Message-ID: <473A2CF2.2060106@nrc-cnrc.gc.ca>
From: Isabella <isabella.ghiurea@nrc-cnrc.gc.ca>
User-Agent: Thunderbird 1.5.0.12 (X11/20070530)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.performance+tuning
To: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
Subject: Re: sp__optdiag on ASE 15.02.
References: <47349c1f$1@forums-1-dub> <4734d957$1@forums-1-dub>
In-Reply-To: <4734d957$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: fw.hia.nrc.ca
X-Original-NNTP-Posting-Host: fw.hia.nrc.ca
Date: 13 Nov 2007 15:02:11 -0800
X-Trace: forums-1-dub 1194994931 204.174.103.3 (13 Nov 2007 15:02:11 -0800)
X-Original-Trace: 13 Nov 2007 15:02:11 -0800, fw.hia.nrc.ca
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10462
Article PK: 89086

Thanks Mark, this was my first hope : maybe Kevin will see this message
from the user groups and reply .
Isabella

Mark A. Parsons wrote:
> The ASE 12.x version of sp__optdiag won't work in ASE 15.x ("Duh, Mark!"
> ?).
>
> You'll either need to do some customization on the version you have ...
> or see if Kevin Sherlock's got any plans for an ASE 15.x version of
> sp__optdiag. (You should be able to find Kevin's contact info in these
> newsgroups or at the teamsybase.com website.)
>
> Isabella wrote:
>> Hello Gurus,
>> Would like to know if anyone of you managed to use sp__optdiag procs
>> utility in ASE 15.0.2, I'm getting an error when trying to compile
>> the procs,
>>
>> thank you,
>> Isabella


Sherlock, Kevin Posted on 2007-11-14 04:33:29.0Z
From: "Sherlock, Kevin" <ksherlock@saionline.com>
Newsgroups: sybase.public.ase.performance+tuning
References: <47349c1f$1@forums-1-dub> <4734d957$1@forums-1-dub> <473A2CF2.2060106@nrc-cnrc.gc.ca>
Subject: Re: sp__optdiag on ASE 15.02.
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: cm-204-193-199-251.omah.tconl.com
X-Original-NNTP-Posting-Host: cm-204-193-199-251.omah.tconl.com
Message-ID: <473a7a99$1@forums-1-dub>
Date: 13 Nov 2007 20:33:29 -0800
X-Trace: forums-1-dub 1195014809 204.193.199.251 (13 Nov 2007 20:33:29 -0800)
X-Original-Trace: 13 Nov 2007 20:33:29 -0800, cm-204-193-199-251.omah.tconl.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10463
Article PK: 89087

I have a 15.0 compatible version which works, but only display's the 12.5.x
output style. The optdiag output in 15.x has changed somewhat but I haven't
had time to modify sp__optdiag to display 15.0 style yet.

I'll upload the 15.0 compatible version of sp__optdiag to my website as soon
as possible and post a message here when done.

"Isabella" <isabella.ghiurea@nrc-cnrc.gc.ca> wrote in message
news:473A2CF2.2060106@nrc-cnrc.gc.ca...
> Thanks Mark, this was my first hope : maybe Kevin will see this message
> from the user groups and reply .
> Isabella
>
> Mark A. Parsons wrote:
>> The ASE 12.x version of sp__optdiag won't work in ASE 15.x ("Duh, Mark!"
>> ?).
>>
>> You'll either need to do some customization on the version you have ...
>> or see if Kevin Sherlock's got any plans for an ASE 15.x version of
>> sp__optdiag. (You should be able to find Kevin's contact info in these
>> newsgroups or at the teamsybase.com website.)
>>
>> Isabella wrote:
>>> Hello Gurus,
>>> Would like to know if anyone of you managed to use sp__optdiag procs
>>> utility in ASE 15.0.2, I'm getting an error when trying to compile the
>>> procs,
>>>
>>> thank you,
>>> Isabella


Sherlock, Kevin Posted on 2007-11-14 10:43:32.0Z
From: "Sherlock, Kevin" <ksherlock@saionline.com>
Newsgroups: sybase.public.ase.performance+tuning
References: <47349c1f$1@forums-1-dub> <4734d957$1@forums-1-dub> <473A2CF2.2060106@nrc-cnrc.gc.ca> <473a7a99$1@forums-1-dub>
Subject: Re: sp__optdiag on ASE 15.02.
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: cm-204-193-199-251.omah.tconl.com
X-Original-NNTP-Posting-Host: cm-204-193-199-251.omah.tconl.com
Message-ID: <473ad154$3@forums-1-dub>
Date: 14 Nov 2007 02:43:32 -0800
X-Trace: forums-1-dub 1195037012 204.193.199.251 (14 Nov 2007 02:43:32 -0800)
X-Original-Trace: 14 Nov 2007 02:43:32 -0800, cm-204-193-199-251.omah.tconl.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10466
Article PK: 89089

Okay, it should be on my website now. Check:

http://www.teamsybase.net/kevin.sherlock/ASE.html

and use the direct link in the text to the stored procedures, or click the
"Stored Procedure" button to navigate.

"Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
news:473a7a99$1@forums-1-dub...
>I have a 15.0 compatible version which works, but only display's the 12.5.x
>output style. The optdiag output in 15.x has changed somewhat but I
>haven't had time to modify sp__optdiag to display 15.0 style yet.
>
> I'll upload the 15.0 compatible version of sp__optdiag to my website as
> soon as possible and post a message here when done.
>
> "Isabella" <isabella.ghiurea@nrc-cnrc.gc.ca> wrote in message
> news:473A2CF2.2060106@nrc-cnrc.gc.ca...
>> Thanks Mark, this was my first hope : maybe Kevin will see this message
>> from the user groups and reply .
>> Isabella
>>
>> Mark A. Parsons wrote:
>>> The ASE 12.x version of sp__optdiag won't work in ASE 15.x ("Duh, Mark!"
>>> ?).
>>>
>>> You'll either need to do some customization on the version you have ...
>>> or see if Kevin Sherlock's got any plans for an ASE 15.x version of
>>> sp__optdiag. (You should be able to find Kevin's contact info in these
>>> newsgroups or at the teamsybase.com website.)
>>>
>>> Isabella wrote:
>>>> Hello Gurus,
>>>> Would like to know if anyone of you managed to use sp__optdiag procs
>>>> utility in ASE 15.0.2, I'm getting an error when trying to compile the
>>>> procs,
>>>>
>>>> thank you,
>>>> Isabella
>
>


Isabella Posted on 2007-11-14 16:22:16.0Z
From: Isabella <isabella.ghiurea@nrc-cnrc.gc.ca>
User-Agent: Thunderbird 1.5.0.12 (X11/20070530)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.performance+tuning
Subject: Re: sp__optdiag on ASE 15.02.
References: <47349c1f$1@forums-1-dub> <4734d957$1@forums-1-dub> <473A2CF2.2060106@nrc-cnrc.gc.ca> <473a7a99$1@forums-1-dub> <473ad154$3@forums-1-dub>
In-Reply-To: <473ad154$3@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: fw.hia.nrc.ca
X-Original-NNTP-Posting-Host: fw.hia.nrc.ca
Message-ID: <473b20b8@forums-1-dub>
Date: 14 Nov 2007 08:22:16 -0800
X-Trace: forums-1-dub 1195057336 204.174.103.3 (14 Nov 2007 08:22:16 -0800)
X-Original-Trace: 14 Nov 2007 08:22:16 -0800, fw.hia.nrc.ca
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10467
Article PK: 89092

THANK YOU Kevin ! works fine

Isabella

Sherlock, Kevin wrote:
> Okay, it should be on my website now. Check:
>
> http://www.teamsybase.net/kevin.sherlock/ASE.html
>
> and use the direct link in the text to the stored procedures, or click the
> "Stored Procedure" button to navigate.
>
> "Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
> news:473a7a99$1@forums-1-dub...
>> I have a 15.0 compatible version which works, but only display's the 12.5.x
>> output style. The optdiag output in 15.x has changed somewhat but I
>> haven't had time to modify sp__optdiag to display 15.0 style yet.
>>
>> I'll upload the 15.0 compatible version of sp__optdiag to my website as
>> soon as possible and post a message here when done.
>>
>> "Isabella" <isabella.ghiurea@nrc-cnrc.gc.ca> wrote in message
>> news:473A2CF2.2060106@nrc-cnrc.gc.ca...
>>> Thanks Mark, this was my first hope : maybe Kevin will see this message
>>> from the user groups and reply .
>>> Isabella
>>>
>>> Mark A. Parsons wrote:
>>>> The ASE 12.x version of sp__optdiag won't work in ASE 15.x ("Duh, Mark!"
>>>> ?).
>>>>
>>>> You'll either need to do some customization on the version you have ...
>>>> or see if Kevin Sherlock's got any plans for an ASE 15.x version of
>>>> sp__optdiag. (You should be able to find Kevin's contact info in these
>>>> newsgroups or at the teamsybase.com website.)
>>>>
>>>> Isabella wrote:
>>>>> Hello Gurus,
>>>>> Would like to know if anyone of you managed to use sp__optdiag procs
>>>>> utility in ASE 15.0.2, I'm getting an error when trying to compile the
>>>>> procs,
>>>>>
>>>>> thank you,
>>>>> Isabella
>>
>
>


Sherlock, Kevin Posted on 2007-11-14 20:16:15.0Z
From: "Sherlock, Kevin" <ksherlock@saionline.com>
Newsgroups: sybase.public.ase.performance+tuning
References: <47349c1f$1@forums-1-dub> <4734d957$1@forums-1-dub> <473A2CF2.2060106@nrc-cnrc.gc.ca> <473a7a99$1@forums-1-dub> <473ad154$3@forums-1-dub> <473b20b8@forums-1-dub>
Subject: Re: sp__optdiag on ASE 15.02.
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: cm-204-193-195-196.omah.tconl.com
X-Original-NNTP-Posting-Host: cm-204-193-195-196.omah.tconl.com
Message-ID: <473b578f$2@forums-1-dub>
Date: 14 Nov 2007 12:16:15 -0800
X-Trace: forums-1-dub 1195071375 204.193.195.196 (14 Nov 2007 12:16:15 -0800)
X-Original-Trace: 14 Nov 2007 12:16:15 -0800, cm-204-193-195-196.omah.tconl.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10468
Article PK: 89091

Sure, just keep in mind that it doesn't produce the same output as ASE15
"optdiag" utility. So proceed with that in mind :)

"Isabella" <isabella.ghiurea@nrc-cnrc.gc.ca> wrote in message
news:473b20b8@forums-1-dub...
> THANK YOU Kevin ! works fine
>
> Isabella
>
>
> Sherlock, Kevin wrote:
>> Okay, it should be on my website now. Check:
>>
>> http://www.teamsybase.net/kevin.sherlock/ASE.html
>>
>> and use the direct link in the text to the stored procedures, or click
>> the "Stored Procedure" button to navigate.
>>
>> "Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
>> news:473a7a99$1@forums-1-dub...
>>> I have a 15.0 compatible version which works, but only display's the
>>> 12.5.x output style. The optdiag output in 15.x has changed somewhat
>>> but I haven't had time to modify sp__optdiag to display 15.0 style yet.
>>>
>>> I'll upload the 15.0 compatible version of sp__optdiag to my website as
>>> soon as possible and post a message here when done.
>>>
>>> "Isabella" <isabella.ghiurea@nrc-cnrc.gc.ca> wrote in message
>>> news:473A2CF2.2060106@nrc-cnrc.gc.ca...
>>>> Thanks Mark, this was my first hope : maybe Kevin will see this message
>>>> from the user groups and reply .
>>>> Isabella
>>>>
>>>> Mark A. Parsons wrote:
>>>>> The ASE 12.x version of sp__optdiag won't work in ASE 15.x ("Duh,
>>>>> Mark!" ?).
>>>>>
>>>>> You'll either need to do some customization on the version you have
>>>>> ... or see if Kevin Sherlock's got any plans for an ASE 15.x version
>>>>> of sp__optdiag. (You should be able to find Kevin's contact info in
>>>>> these newsgroups or at the teamsybase.com website.)
>>>>>
>>>>> Isabella wrote:
>>>>>> Hello Gurus,
>>>>>> Would like to know if anyone of you managed to use sp__optdiag
>>>>>> procs utility in ASE 15.0.2, I'm getting an error when trying to
>>>>>> compile the procs,
>>>>>>
>>>>>> thank you,
>>>>>> Isabella
>>>
>>