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.
To scan the system configuration of a database
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