What query can I run to find all Glob Tables in my database?

Thanks

What are "Glob Tables"? By the way, all table are listed in SYSCAT.TABLES

Sorry..... Typo..... They call them LOB or BLOB.......

I generally use

SELECT distinct rtrim(tabschema)||'.'||rtrim(TABNAME) from syscat.columns where typename like ('%LOB%')

The query may get more complicated if you have LOB UDTs, in which case, you will have to join syscat.columns with SYSCAT.DATATYPES

HTH
Sathyaram