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.

View Currently running SQL in ASA 7.0.3?

4 posts in General Discussion Last posting was on 2005-01-28 21:50:07.0Z
Daniel Williams Posted on 2005-01-28 16:50:33.0Z
From: "Daniel Williams" <daniel@aniworld.com>
Newsgroups: ianywhere.public.general
Subject: View Currently running SQL in ASA 7.0.3?
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 69.17.103.9
X-Original-NNTP-Posting-Host: 69.17.103.9
Message-ID: <41fa6d59@forums-1-dub>
Date: 28 Jan 2005 08:50:33 -0800
X-Trace: forums-1-dub 1106931033 69.17.103.9 (28 Jan 2005 08:50:33 -0800)
X-Original-Trace: 28 Jan 2005 08:50:33 -0800, 69.17.103.9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4105
Article PK: 7990

I am using ASA 7.0.3, and I would like to see that queries are being
processed, or at least which ones have run in the past few minutes or so.
How could I get this information?

Thanks,
Daniel Williams


Glenn Paulley Posted on 2005-01-28 17:38:30.0Z
Newsgroups: ianywhere.public.general
Subject: Re: View Currently running SQL in ASA 7.0.3?
From: Glenn Paulley <paulley@ianywhere.com>
References: <41fa6d59@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns95EC809688772paulleyianywherecom@10.22.241.106>
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: paulley-t41.sybase.com
X-Original-Trace: 28 Jan 2005 09:38:26 -0800, paulley-t41.sybase.com
Lines: 28
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Jan 2005 09:38:27 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Jan 2005 09:38:30 -0800
X-Trace: forums-1-dub 1106933910 10.22.108.75 (28 Jan 2005 09:38:30 -0800)
X-Original-Trace: 28 Jan 2005 09:38:30 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4106
Article PK: 7991

"Daniel Williams" <daniel@aniworld.com> wrote in
news:41fa6d59@forums-1-dub:

>
> I am using ASA 7.0.3, and I would like to see that queries are being
> processed, or at least which ones have run in the past few minutes or
> so. How could I get this information?
>
> Thanks,
> Daniel Williams
>
>
>

Look in the help under "Request-level logging".

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288


Daniel Williams Posted on 2005-01-28 20:09:36.0Z
From: "Daniel Williams" <daniel@aniworld.com>
Newsgroups: ianywhere.public.general
References: <41fa6d59@forums-1-dub> <Xns95EC809688772paulleyianywherecom@10.22.241.106>
Subject: Re: View Currently running SQL in ASA 7.0.3?
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Original-NNTP-Posting-Host: 69.17.103.9
Message-ID: <41fa9bfb$1@forums-2-dub>
X-Original-Trace: 28 Jan 2005 12:09:31 -0800, 69.17.103.9
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Jan 2005 12:09:33 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Jan 2005 12:09:36 -0800
X-Trace: forums-1-dub 1106942976 10.22.108.75 (28 Jan 2005 12:09:36 -0800)
X-Original-Trace: 28 Jan 2005 12:09:36 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4107
Article PK: 7989

Thanks Glenn,

That gets me somewhere. But it looks as though the request I'm trying to
track down is:

[large string unavailable]

Do you know what this is, and whether I can get the contents of that
request?

Thanks,
Daniel Williams

"Glenn Paulley" <paulley@ianywhere.com> wrote in message
news:Xns95EC809688772paulleyianywherecom@10.22.241.106...
> "Daniel Williams" <daniel@aniworld.com> wrote in
> news:41fa6d59@forums-1-dub:
>
>>
>> I am using ASA 7.0.3, and I would like to see that queries are being
>> processed, or at least which ones have run in the past few minutes or
>> so. How could I get this information?
>>
>> Thanks,
>> Daniel Williams
>>
>>
>>
>
> Look in the help under "Request-level logging".
>
> --
> Glenn Paulley
> Research and Development Manager, Query Processing
> iAnywhere Solutions Engineering
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288


Glenn Paulley Posted on 2005-01-28 21:50:07.0Z
Newsgroups: ianywhere.public.general
Subject: Re: View Currently running SQL in ASA 7.0.3?
From: Glenn Paulley <paulley@ianywhere.com>
References: <41fa6d59@forums-1-dub> <Xns95EC809688772paulleyianywherecom@10.22.241.106> <41fa9bfb$1@forums-2-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns95ECAB41C3150paulleyianywherecom@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: paulley-t41.sybase.com
X-Original-NNTP-Posting-Host: paulley-t41.sybase.com
Date: 28 Jan 2005 13:50:07 -0800
X-Trace: forums-1-dub 1106949007 10.25.99.149 (28 Jan 2005 13:50:07 -0800)
X-Original-Trace: 28 Jan 2005 13:50:07 -0800, paulley-t41.sybase.com
Lines: 68
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4109
Article PK: 7993

"Daniel Williams" <daniel@aniworld.com> wrote in
news:41fa9bfb$1@forums-2-dub:

>
> Thanks Glenn,
>
> That gets me somewhere. But it looks as though the request I'm trying
> to track down is:
>
> [large string unavailable]
>
> Do you know what this is, and whether I can get the contents of that
> request?
>
> Thanks,
> Daniel Williams
>
>
> "Glenn Paulley" <paulley@ianywhere.com> wrote in message
> news:Xns95EC809688772paulleyianywherecom@10.22.241.106...
>> "Daniel Williams" <daniel@aniworld.com> wrote in
>> news:41fa6d59@forums-1-dub:
>>
>>>
>>> I am using ASA 7.0.3, and I would like to see that queries are being
>>> processed, or at least which ones have run in the past few minutes
>>> or so. How could I get this information?
>>>
>>> Thanks,
>>> Daniel Williams
>>>
>>>
>>>
>>
>> Look in the help under "Request-level logging".
>>
>> --
>> Glenn Paulley
>> Research and Development Manager, Query Processing
>> iAnywhere Solutions Engineering
>>
>> EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>>
>> SQL Anywhere Studio Supported Platforms and Support Status
>> http://my.sybase.com/detail?id=1002288
>
>

I believe what you should see is a line of log output with [large string
unavailable] (meaning that the string is > 350 bytes), followed
immediately, on a subsequent line, with the value of that string. Is this
not what you see?

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288