Search code examples
sqldb2

DB2 SYSIBM.SYSTABLES vs SYSCAT.TABLES

I'm using DB2 v9 LUW. I was wondering what the difference is between querying 

SELECT * FROM SYSIBM.SYSTABLES

vs

SELECT * FROM SYSCAT.TABLES

Is one preferred over the other?

Solution

  • SYSIBM.SYSTABLES is the system catalog table, while SYSCAT.TABLES is a system catalog view. It depends of what you need, but you may use SYSIBM.SYSTABLES more often.