--- title: "A Comprehensive Overview of DB2 Catalog Table Schemas" description: "DB2 catalog tables are system-generated during database creation, providing information about database objects and are organized under various schemas." url: https://srinimf.com/2023/12/17/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/ date: 2023-12-17 modified: 2026-10-13 author: "Srini" image: https://i0.wp.com/srinimf.com/wp-content/uploads/2018/11/pexels-photo-6851142.jpeg?fit=1880%2C1253&ssl=1 categories: ["DB2"] tags: ["SYSIBM catalog tables"] type: post lang: en --- # A Comprehensive Overview of DB2 Catalog Table Schemas Catalog tables in DB2 are system tables that are automatically created during the database creation process. There is no need to create them explicitly. Table of contents 1. [DB2 Catalog Tables](https://srinimf.com/2018/11/18/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/#db2-catalog-tables) 2. [DB2 Catalog Table Interview Questions](https://srinimf.com/2018/11/18/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/#db2-catalog-table-interview-questions) 3. [Database Object and Related Catalog View](https://srinimf.com/2018/11/18/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/#database-object-and-related-catalog-view) 4. [Conclusion](https://srinimf.com/2018/11/18/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/#conclusion) ![DB2 Catalog tables](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/11/pexels-photo-4622209.jpeg?resize=1880%2C1253&ssl=1)*Photo by cottonbro studio on Pexels.com* ## [DB2 Catalog Tables](https://srinimf.com/2014/11/23/db2-catalog-tables/) - Tables - Indexes - Views - Security information - Tables update information - Statistics Catalog Table Schemas Related[RDBMS: Schema Vs Instance Top Differences](https://srinimf.com/2014/11/01/dbms-database-schema-and-instance/) The tables under the SYSIBM schema are master tables. The tables under SYSCAT are views of SYSIBM. 1. SYSIBM 2. SYSCAT 3. SYSFUN 4. SYSPROC 5. SYSSTAT ## DB2 Catalog Table Interview Questions 01. Which is the schema used for user-defined functions? SYSFUN 02. What is the schema used for stored procedures? SYSPROC 03. The views created under SYSSTAT are user editable? Yes. These are editable. 04. Which command do you need to use to know tables defined under a schema? LIST TABLES FOR SCHEMA schema-name ## Database Object and Related Catalog View | **Database Object** | S**YSCAT 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[DB2 Schema creating process for a User](https://srinimf.com/2016/06/14/db2-schema-creating-process-for-a-user/) ## Conclusion The DB2 catalog tables play a crucial role in the database creation process. These system tables are automatically created, eliminating the need for explicit creation. The catalog tables provide important information about various database objects such as tables, indexes, views, security information, and statistics. The catalog tables are organized under different schemas, with SYSIBM containing the master tables and SYSCAT serving as views of SYSIBM. Additionally, there are schemas like SYSFUN and SYSPROC for user-defined functions and stored procedures, respectively. When it comes to managing the catalog tables, there are a few interview questions that may arise. For example, the schema used for user-defined functions is SYSFUN, while SYSPROC is used for stored procedures. It’s also worth noting that the views created under SYSSTAT are editable. To retrieve information about tables defined under a specific schema, the command “LIST TABLES FOR SCHEMA schema-name” can be used. In conclusion, understanding the DB2 catalog tables is essential for effectively managing and retrieving information about the database objects. They serve as a valuable resource for database administrators and developers alike. References - IDUG Blog for Learners - [Craig Mullens Blog on DB2](http://db2portal.blogspot.com/) ### Share this: - - [Tweet](https://twitter.com/share) - [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2023%2F12%2F17%2Fdb2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2018%2F11%2Fpexels-photo-6851142.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=A%20Comprehensive%20Overview%20of%20DB2%20Catalog%20Table%20Schemas) - - [Share on Tumblr](https://www.tumblr.com/share) - [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2023/12/17/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/?share=jetpack-whatsapp) - [More](#) - - [Print (Opens in new window) Print](https://srinimf.com/2023/12/17/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/?share=print) - [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2023/12/17/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/?share=reddit) - [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2023/12/17/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/?share=telegram) - [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20A%20Comprehensive%20Overview%20of%20DB2%20Catalog%20Table%20Schemas&body=https%3A%2F%2Fsrinimf.com%2F2023%2F12%2F17%2Fdb2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified%2F&share=email) - ### Like this: Like Loading…