Hi,

I am looking for our famous Oracle column statistics query alternative in db2. I looked into DB2 catalog tables and didn't find anything.
Can you please help me or guide me in right direction?

Oracle Query :
select r.name as r_owner, o.name as r_table , c.name as r_column,
               equality_preds, equijoin_preds, nonequijoin_preds, range_preds,
            like_preds, null_preds, timestamp
            from sys.col_usage$ u, sys.obj$ o, sys.col$ c, sys.user$ r
         where o.obj# = u.obj# and c.obj# = u.obj# and c.col# = u.intcol#
          and o.owner# = r.user# and (u.equijoin_preds > 0 or u.nonequijoin_preds > 0)

------------------------------
Neeraj
------------------------------

#Db2

I'd love to see an answer to this as well if there is something available.  I have been chasing this for a bit, with no luck :(

------------------------------
David Anderson
------------------------------