Please can some tell me how to identify tables that have been Block-level compressed using SQL.
Hopefully from one of the DBC. <tables>.
Note: I do not have access to Ferret tool or anyother tools an admin has access to.
In TD15.10, below SQL will reveal if there is BLC on the table.
show stats values on <databasename.tablename>;
BLCPctCompressed > 0 in the answerset will indicate BLC is on.