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.
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