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.

versions of a given table

2 posts in General Discussion Last posting was on 2012-10-02 20:27:36.0Z
tartampion Posted on 2012-10-02 16:02:34.0Z
Sender: 1a8e.506b0f17.1804289383@sybase.com
From: tartampion
Newsgroups: sybase.public.iq
Subject: versions of a given table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <506b101a.1ad7.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Oct 2012 09:02:34 -0700
X-Trace: forums-1-dub 1349193754 172.20.134.41 (2 Oct 2012 09:02:34 -0700)
X-Original-Trace: 2 Oct 2012 09:02:34 -0700, 172.20.134.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4554
Article PK: 246691

sp_iqlocks give the list/type of locks on tables, I am new
to Sybae IQ and would like to know if there is an easy way
to find out the list of logins using a given table with
none-commited work, who are therefore accessing different
versions of that given table.


Tratampion Posted on 2012-10-02 20:27:36.0Z
Sender: 1a8e.506b0f17.1804289383@sybase.com
From: Tratampion
Newsgroups: sybase.public.iq
Subject: Re: versions of a given table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <506b4e38.294b.1681692777@sybase.com>
References: <506b101a.1ad7.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Oct 2012 13:27:36 -0700
X-Trace: forums-1-dub 1349209656 172.20.134.41 (2 Oct 2012 13:27:36 -0700)
X-Original-Trace: 2 Oct 2012 13:27:36 -0700, 172.20.134.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4555
Article PK: 246696


> sp_iqlocks give the list/type of locks on tables, I am new
> to Sybae IQ and would like to know if there is an easy way
> to find out the list of logins using a given table with
> none-commited work, who are therefore accessing different
> versions of that given table.

Also used sp_iqtransaction and sp_iqversionuse, which are
very helpful, but still seeking a simpler way to have info
on the versions in use on a particular table, your help is
appreciated.