INFO TRANDATA
Use INFO TRANDATA to get the following information:
-
Db2 LUW and Db2 z/OS: Determine whether
DATA CAPTUREis enabled or not. -
Oracle: Determine whether supplemental logging is enabled, and to show the names of columns that are being logged supplementary. If all columns are being logged, the notation
ALLis displayed instead of individual column names. Displays any SCN instantiation information. -
SQL Server: Determine whether or not extended logging is enabled for a table.
-
PostgreSQL: Determine whether supplemental logging is enabled and to show the current
REPLICA IDENTITYsetting.
Use the DBLOGIN command to establish a database
connection before using this command.
GGSCI Syntax
INFO TRANDATA [container.]owner.table [NOVALIDATE]-
[container.]owner.table -
The pluggable database (if this is an Oracle multitenant container database), owner and name of the table or file for which you want to view trandata information. The owner is not required if it is the same as the login name that was specified by the
DBLOGINcommand. A wildcard can be used for the table name but not the owner name. -
NOVALIDATE -
Suppresses additional information about the table being handled being processed by
ADD TRANDATA. By default, this option is enabled. The additional information processing creates a lapse time on command response so this option can be used to increase response time.