Search code examples
oracledb2db2-luw

Convert Oracle to Db2 query

I am trying to convert below oracle query to Db2 . Below is the Oracle query 

select stat.owner
                      ,stat.OBJECT_NAME
                      ,stat.STATISTIC_NAME
                      ,stat.VALUE AcsValue

                from v$segment_statistics stat

I want to Convert it to DB2 11 database supported query .This above query is to find frequency of table usage .So Far I have tried to find the equivalent metadata tables . I am very new to DB2 . any help would be greatly appreciated.

Solution

  • Try the MON_GET_TABLE table function https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0053945.html

    That will return things like logical reads by table. https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/r0058774.html