Checking your system configuration

You can rescan, or refresh, database instances, datafiles, and tablespaces to make sure system information is up-to-date.

When the system configuration changes, for example, when a new database, datafile or tablespace is created or when existing datafiles or tablespaces are deleted, the changes are not automatically updated in the repository.

You can check the System Configuration only when using VERITAS Storage Foundation for DB2 Enterprise Edition.

To scan the system configuration of a database

  1. Select the database icon in the GUI.

  2. Select the Check System Configuration option in the GUI to scan the database.

  3. In the confirmation dialog, click Yes or No to continue.

  4. Click OK to return to the main window.

Sample rescan output:

         Examining File System and DB2 Container attributes.

            Total of 0 containers over 0 file systems.
            WARNING: No file systems to examine.
            Examining Quick I/O settings.
            Examining Cached Quick I/O settings.
            NOTICE: No file systems have Cached Quick I/O enabled.

            The database has:
             3 SMS Containers
             1 DMS File Containers
             0 DMS Device Containers

            Examining DB2 container fragmentation.

            NOTICE: Could not examine DB2 container fragmentation.

            Examining File System tunable settings.

            NOTICE: Parameters for all VxFS file systems used by PROD.

            Examining DB2 Volume layout and attributes.

            WARNING: Data for database PROD is spread over multiple volume
            groups.

            Examining DB2 internal information.

            DB2 Version is 8.1.

            Examining DB2 logging mode.

            The database has transaction logs in directory
            /udb_home/prod/inst01/NODE0000/SQL00001/SQLOGDIR/.

            WARNING: Transaction log directory is not mirrored using VxVM.

            The database is in circular log mode (not archivelog).
            WARNING: Database recovery is affected by this mode.

            The database is archiving logs in the default location.
            All archived logs remain under
            /udb_home/prod/inst01/NODE0000/SQL00001/SQLOGDIR/.

            Examining DB2 Database Free Space.

            DB20000I  The SQL command completed successfully.

             Name                                 = SYSCATSPACE
             Type                                 = System managed space
             Total pages                          = 5570
             Used pages                           = 5570
             Free pages                           = Not applicable
             Page size (bytes)                    = 4096

             Name                                 = TEMPSPACE1
             Type                                 = System managed space
             Total pages                          = 1
             Used pages                           = 1
             Free pages                           = Not applicable
             Page size (bytes)                    = 4096

             Name                                 = USERSPACE1
             Type                                 = System managed space
             Total pages                          = 1
             Used pages                           = 1
             Free pages                           = Not applicable
             Page size (bytes)                    = 4096

             Name                                 = TBS1
             Type                                 = Database managed space
             Total pages                          = 5000
             Used pages                           = 160
             Free pages                           = 4800
             Page size (bytes)                    = 4096