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.

sysprocesses

2 posts in General Discussion Last posting was on 2007-11-20 12:30:40.0Z
Herman Miller Posted on 2007-11-20 11:15:53.0Z
Sender: 12d8.4742c17c.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: sysprocesses
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4742c1e9.12df.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Nov 2007 03:15:53 -0800
X-Trace: forums-1-dub 1195557353 10.22.241.41 (20 Nov 2007 03:15:53 -0800)
X-Original-Trace: 20 Nov 2007 03:15:53 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6593
Article PK: 4842

Does this view exists in ASA 9? It doesn't seem to return
any information. How can I tell what processes are running?
Also, is a database event considered a process? I would like
to stop a database event to update it. I currently get
database event in use when trying to delete and re-write.


Chris Keating (Sybase iAnywhere) Posted on 2007-11-20 12:30:40.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: sysprocesses
References: <4742c1e9.12df.1681692777@sybase.com>
In-Reply-To: <4742c1e9.12df.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Message-ID: <4742d370$1@forums-1-dub>
Date: 20 Nov 2007 04:30:40 -0800
X-Trace: forums-1-dub 1195561840 99.236.107.169 (20 Nov 2007 04:30:40 -0800)
X-Original-Trace: 20 Nov 2007 04:30:40 -0800, cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Lines: 12
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6596
Article PK: 4846

That is an ASE view. See

ASA SQL Reference
System Views
Views for Transact-SQL compatibility

Herman Miller wrote:
> Does this view exists in ASA 9? It doesn't seem to return
> any information. How can I tell what processes are running?
> Also, is a database event considered a process? I would like
> to stop a database event to update it. I currently get
> database event in use when trying to delete and re-write.