How do I check if log truncation is blocked in S

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

(Continued from previous question...)

How do I check if log truncation is blocked in Sybase?

System 11 and beyond:
select h.spid, convert(varchar(20), h.name), h.starttime
from master..syslogshold h,
sysindexes i
where h.dbid = db_id()
and h.spid != 0
and i.id = 8 /* syslogs */
and h.page in (i.first, i.first+1) /* first page of log = page of oldest xact */

(Continued on next question...)

Other Job Interview Questions

• How do I find the oldest open transaction in Sybase?
• Optimizing your Identity setup for performance and maintenance in Sybase
• How do I set a password to be null?
• Calling OS commands from a trigger or a stored procedure in Sybase
• How to Shrink a Database
• How do I set a password to be null?
• How to start/stop ASE when CPU reboots ?
• Convert months to financial months in Sybase
• How can I return number of rows that are returned from a grouped query without using a temporary table?
• How do I check if log truncation is blocked in Sybase?
• More...