How do I find the oldest open transaction in Syb

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do I find the oldest open transaction in Sybase?

select h.spid, u.name, p.cmd, h.name, h.starttime,
p.hostname, p.hostprocess, p.program_name
from master..syslogshold h,
master..sysprocesses p,
master..sysusers u
where h.spid = p.spid
and p.suid = u.suid
and h.spid != 0 /* not replication truncation point */

(Continued on next question...)

Other Job Interview Questions

• How do I remove duplicate rows from a table in Sybase?
• On what platforms is ASA supported?
• How To Change varchar(m) to varchar(n) in Sybase?
• Explain about Open switch business continuity software?
• Are there any alternatives to isql in Sybase ?
• Recovery from Large Identity value gaps in Sybase
• What is this TDS protocol in Sybase?
• What is Open Client in Sybase?
• How do I generate Sequential Keys w/o the Identity feature in Sybase?
• Explain about Open switch business continuity software?
• More...