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.

Trapping a large query

2 posts in General Discussion Last posting was on 2004-05-07 14:18:11.0Z
Charles Strauss Posted on 2004-05-06 19:28:31.0Z
Sender: 4aa2.409a909c.1804289383@sybase.com
From: Charles Strauss
Newsgroups: ianywhere.public.general
Subject: Trapping a large query
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <409a91df.4ab3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 May 2004 12:28:31 -0700
X-Trace: forums-1-dub 1083871711 10.22.241.41 (6 May 2004 12:28:31 -0700)
X-Original-Trace: 6 May 2004 12:28:31 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3034
Article PK: 6505

Is there anyway to see what cursors are open in the
database? I would like to be able to issue some type of
command is ISQL that would show me any active cursors that
are being executed. I have a feeling that somewhere in our
application, there is a cursor that is retruning umpteen
million rows but I can't determine where it is because all
the users access the DB from the web using Powerdynamo. Can
you log just the queries to a DB and if so, does it impact
performance? Is it possible to look at the connections in
Sybase Central to determine what is happening? Any help is
thourougly appreciated.


Greg Fenton Posted on 2004-05-07 14:18:11.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 MultiZilla/1.6.2.0c
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Trapping a large query
References: <409a91df.4ab3.1681692777@sybase.com>
In-Reply-To: <409a91df.4ab3.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <409b9aa3@forums-1-dub>
Date: 7 May 2004 07:18:11 -0700
X-Trace: forums-1-dub 1083939491 10.25.100.188 (7 May 2004 07:18:11 -0700)
X-Original-Trace: 7 May 2004 07:18:11 -0700, gfenton-xp.sybase.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3037
Article PK: 6501


Charles wrote:

> Is there anyway to see what cursors are open in the
> database?

Please always post the version and build number of ASA that you are using.

There are some tools that provide you with information you are after:

- request_level_logging
- remember_last_statement

Both of these can be enabled at server startup, via ISQL or via Sybase
Central.

See the online docs for more information.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/