dbcc gettrunc

A Transact-SQL command to retrieve current RepAgent (or LTM) 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	LTM
secondary trunc page	ltm_truncpage	The first page that is not truncated in the database log
secondary trunc state	ltm_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	dp_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	gen_id	The database generation ID
database id	dbid	The Adaptive Server ID number of the database
database name	dbname	The name of the database
ltl version	lti_version	RepAgent: The log transfer language (LTL) version LTM: The log transfer interface (LTI) version