dbcc gettrunc

A Transact-SQL command to retrieve current RepAgent information about an Adaptive Server database.

dbcc gettrunc

The dbcc gettrunc command returns a single row containing the columns shown in Table 5-1:

**Table 5-1: Columns returned by dbcc gettrunc**
Column name	Contents
RepAgent
secondary trunc page	The first page that is not truncated in the database log
secondary trunc state	One of the following values: 1 – Adaptive Server does not truncate the log on or after the truncpage 0 – Adaptive Server ignores the truncpage
db rep stat	A mask constructed of the following: 0x01 – truncpage is valid 0x02 – database contains replicated tables 0x04 – database contains replicated stored procedures 0x10 – replicate all to standby database RepAgent only: 0x20 – RepAgent enabled 0x40 – autostart RepAgent
generation id	The database generation ID
database id	The Adaptive Server ID number of the database
database name	The name of the database
ltl version	RepAgent: The log transfer language (LTL) version