Previous Topic Next topic Print topic


System Table Overview

To view the contents of any system table, use the SQL SELECT command as follows:

SELECT * FROM authid.table-name

where authid is the owner of the table. The AuthID for system tables is either sysxdb, sysibm or xdbstat.

Only a super user has authority to edit (update) the system tables. A user with sysadm authority can edit selected columns in some of the tables within the authorized location. These sysadm-editable columns are so noted in the column descriptions.

All locations, including the system location, contain a set of system catalog tables. These are stored in the dsndb06 database in each location. Additional system tables reside in the xdbacf and dsnddf databases in the system location.

Important: For complete information on system tables, see the documentation for DB2 catalog tables located on the IBM Web site.
Previous Topic Next topic Print topic