system catalog

This rule also applies to their definition -- privileges associated with a global variable are also defined within the system catalog.

An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists.

However, the system catalog data that was added at the time of creation of an external table will still be replicated.

In a relational language, such a query would require a join that might span several data tables and system catalog tables.

The index definition of a disabled index remains in the system catalog with no underlying index data .

The RUNSTATS utility updates the statistics in the system catalog tables to help with the query optimization process.

As the calculation of the savings is based just on statistics information in the system catalog, the calculation is fast.

The DB2 UDB system catalog (or simply "catalog" ) consists of a number of tables and views that are maintained by the database manager.

Setup was unable to complete the server rename operation. You must update the 'local' server in the system catalog yourself.

The database server does not update the statistics in the system catalog tables.

The database manager creates and maintains two sets of system catalog views that are defined on top of the base system catalog tables.

The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.

To ensure fast recovery of the partition containing system catalog tables, avoid placing user tables on the same database partition.

When a database is created, SELECT privilege on the system catalog views is granted to PUBLIC (Figure 6).

You can use system catalog information to locate objects, as shown in the following code.

You can use the system catalog views to retrieve information about the dependencies that objects have on one another.

You can also use the system catalog views to retrieve information about database partitions and database partition groups.

As mentioned earlier, no single system catalog view contains all the available authorization data.

SYSCAT: A set of read-only views for the system catalog tables.

When prompted, enter values for system catalog name, username, and password; for this example, you can use "dba" for all values.

The information about occurrences of NULL values is stored in the NUMNULLS column of the system catalog view SYSCAT. COLUMNS.

Each time the UPDATE STATISTICS query is run, the following system catalog tables are refreshed.

A set of system catalog tables is created and maintained for each database.

Almost everything that is known about a database can be found in a metadata repository called the system catalog.

Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.

There is a common system catalog named INFORMATION_SCHEMA shared by all MySQL databases in an instance.

It uses the information from the statistics in the system catalog.

Note that the new system catalog tables will be dropped during the reversion process.

The system catalog describes the logical and physical structure of the data.

Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces.

The index definition remains in the system catalog.

All databases in MySQL in an instance share same system catalog.

Update system catalog tables that the database server uses to optimize queries.

It queries the system catalog to find the database name corresponding to DatabaseID.

The SYSSTAT schema contains a small number of updatable views that are based on the system catalog tables.

The system catalog table SYSCAT. DATAPARTITIONS is then updated to reflect the change.

The distribution statistics are stored in the system catalog view SYSCAT. COLDIST.

You can use the system catalog views to retrieve information about storage management objects such as table spaces.

A new version column is added to sysfragments system catalog table to keep track of changes to statistics information.

Named SYSCATSPACE by DB2, the catalog table space holds the system catalog tables.

Regular dbspaces: Regular dbspaces hold database objects like system catalog tables, user tables, and indices.

System catalog tables reside in the same dbspace as the database itself.

Your application needs system catalog views to administer your XML data and XML schemas.

The values for ONLINE, MAXDOP, and SORT_IN_TEMPDB are not stored in the system catalog.

Table 4 lists the respective federated objects and the DB2 system catalog views that can be used to locate the information.

The DB2 UDB system catalog is a collection of tables that describe database objects.

Click Finish to log this entry into server system catalog.

Loss of the system catalog is a serious problem.

SQL Server 2005 introduces catalog views as a completely new relational interface to the system catalog metadata.

The DB2 event monitors keep information on owners and permissions, which are kept in the database system catalog.

System catalog changes: A FOT index creates a new entry in the existing sysindices table.

Prior to DB2 9, most of the objects have only definer in the corresponding system catalog table or view.

Statistics populate the DB2 system catalog when you execute the RUNSTATS or RUN STATISTICS utility.

IDS 11. 50. xC6 (or later) will appropriately convert all the databases to include these new system catalog tables.

You must hold DBADM or SYSADM authority to grant or revoke the SELECT privilege on system catalog views.

The SYSCAT. TABDEP system catalog view contains a row for every dependency that a materialized query table has on some other object.

In this article, I will show you, by way of working examples, how to retrieve useful information from the DB2 UDB system catalog.

Describes the various interfaces to the SQL Server system catalog.

Built-in tables that form the system catalog for SQL Server.

The SQL Server 2005 system catalog provides this information for SQL Server databases.

Direct system catalog updates are not allowed in SQL Server 2005.

Specifies how identifiers are treated by the data source when searching the system catalog.

The data source distinguishes identifier case when searching the system catalog.

The data source ignores identifier case when searching the system catalog.

This relationship is expressed in the system catalog as the foreign key

Use the following command to populate the CUSTOMER_INFO table with data using dummy information from the system catalog

The type of statistical information stored in the system catalog include

Examining the contents of the system catalog tables

The optimizer uses the following system catalog information as it creates a query plan

Use the following command to create a table based on the system catalog that simulates customer information

A large table space named SYSCATSPACE, which is used to store the system catalog tables and views associated with the database

Controling access to the system catalog

DB2 UDB stores information about privileges in seven system catalog views

Querying the SQL Server System Catalog FAQ