INFO TRANDATA
Valid for all supported databases for the current release.
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.
«««< HEAD
Note: In the microservices environment, the INFO TRANDATA wildcard command, such as INFO TRANDATA PDB.SCHEMA.*, is limited to the first 100 tables. If there are more tables than that limit, the first 100 are returned along with a warning message requesting the user to narrow the schema or table pattern.
The following warning message appears in such cases:
OGG-06661 : The INFO TRANDATA wildcard request returned the first 100 matching tables. More matching tables may exist. Use a narrower wildcard for complete output.
{ .infoboxnote}
=======
edcab3774137b45f744eda5f6b4c59d7f98c9c95
Use the DBLOGIN command to establish a database connection before using this command.
Syntax
INFO TRANDATA [*container*.]*owner.table*[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 DBLOGIN command. A wildcard can be used for the table name but not the owner name.
Examples
INFO TRANDATA hr.employeesINFO TRANDATA hr.reg*