The catalog tables in DB2 also called System tables. You no need to create these tables. These will be created automatically when an administrator creates a database.
Information You Can Read from Catalog Tables
- Tables
- Indexes
- Views
- Security information
- Tables update information
- Statistics
Related: Top DB2 Interview Questions
Types of Catalog Tables Schemas
- SYSIBM
- SYSCAT
- SYSFUN
- SYSPROC
- SYSSTAT
The tables under SYSIBM schema are master tables. The tables under SYSCAT are views of SYSIBM.
Catalog Table Interview Questions
1). Which is the schema used for user-defined functions?
Ans) SYSFUN
2). Which is the schema used for stored procedures?
Ans) SYSPROC
3). The views created under SYSSTAT are user editable?
Yes. These are editable.
4) Which command you need to use to know tables defined under a schema?
Ans) LIST TABLES FOR SCHEMA schema-name
Database Object vs SYSCAT Views
| Database Object | SYSCAT System Catalog View |
| Table | TABLES |
| View | VIEWS |
| Index | INDEXES |
| Data type | DATATYPES |
| Column | COLUMNS |
| Table space | TABLESPACES |
| Buffer pool | BUFFERPOOLS |
| Package | PACKAGES |
| Constraints | CHECKS |
| Referential integrity | REFERENCES |
| Partition groups | NODEGROUPS |
| Partition group definitions | NODEGROUPDEF |
| XML values index | INDEXXMLPATTERNS |
| Stored procedures | PROCEDURES |
| Sequences | SEQUENCES |
| Event Monitors | EVENTMONITORS |
Related Posts
- 3 SQL tuning ideas on Table Columns to apply
- DB2 derived Table key knowledge Points you need to learn
- DB2 Date SQL Queries to Use in Your Current Project
Top DB2 Blogs
The Bottom Line
- Catalog tables you can read.
- During performance management, the data is very much useful
- Security catalog tables useful to know who did data change in a particular table.
Advertisements
