Home > Veritas Storage Foundation™ for DB2 Manual Pages
DB2ED_CHECKCONFIG (1) |
User Commands |
lslpp -L VRTSdb2ed
The command attempts to use certain basic rules on DB2 settings, file system parameters, volume parameters, and layout options to verify how resilient and well configured a DB2 database environment is. The information provided is valid for the supplied DB2 database (DB2DATABASE). All output is sent to stdout.
$ /opt/VRTS/bin/db2ed_checkconfig -D PROD Examining File System and DB2 Container attributes. Total of 13 containers over 2 file systems. All file systems are VxFS. Examining Quick I/O settings. Examining Cached Quick I/O settings. No file systems have Cached Quick I/O enabled. All file systems are VxFS Version 4 or higher layout. The database has: 2 SMS Containers 2 DMS File Containers 0 DMS Device Containers 13 containers are not configured to use Quick I/O. Examining DB2 container fragmentation. 0 SMS containers skipped fragmentation check. 11 files are fragmented. Examining File System tunable settings. Parameters for all VxFS file systems used by PROD. Filesystem i/o parameters for /udb_home/inst01_home/prod_temp read_pref_io = 65536 read_nstream = 1 read_unit_io = 65536 write_pref_io = 65536 write_nstream = 1 write_unit_io = 65536 pref_strength = 10 buf_breakup_size = 1048576 discovered_direct_iosz = 262144 max_direct_iosz = 1048576 default_indir_size = 8192 qio_cache_enable = 0 write_throttle = 0 max_diskq = 1048576 initial_extent_size = 8 max_seqio_extent_size = 2048 max_buf_data_size = 8192 hsm_write_prealloc = 0 read_ahead = 1 inode_aging_size = 0 inode_aging_count = 0 fcl_maxalloc = 31775 fcl_keeptime = 0 fcl_winterval = 3600 oltp_load = 0 Filesystem i/o parameters for /udb_home read_pref_io = 65536 read_nstream = 1 read_unit_io = 65536 write_pref_io = 65536 write_nstream = 1 write_unit_io = 65536 pref_strength = 10 buf_breakup_size = 1048576 discovered_direct_iosz = 262144 max_direct_iosz = 1048576 default_indir_size = 8192 qio_cache_enable = 0 write_throttle = 0 max_diskq = 1048576 max_diskq = 1048576 initial_extent_size = 8 max_seqio_extent_size = 2048 max_buf_data_size = 8192 hsm_write_prealloc = 0 read_ahead = 1 inode_aging_size = 0 inode_aging_count = 0 fcl_maxalloc = 222425 fcl_keeptime = 0 fcl_winterval = 3600 oltp_load = 0 Examining DB2 Volume layout and attributes. Data for database PROD is contained in one volume group. File system /udb_home is mirrored using VxVM. Examining Volume Group versions. Volume Group version for db2dg is: 140 See the vxdg(1M) man page for more information on Volume Group versions. Examining DB2 internal information. DB2 Version is 8.2. DB2COMM=tcpip Examining DB2 logging mode. The database has transaction logs in directory /udb_home/inst01_home/prod_re. Transaction log directory is mirrored using VxVM. The database is running in archivelog mode. The database is archiving logs in the default location. All archived logs remain under /udb_home/NODE0000/. Examining DB2 Database Free Space. DB20000I The SQL command completed successfully. Name = SYSCATSPACE Type = System managed space Total pages = 1745 Total pages = 1745 Used pages = 1745 Free pages = Not applicable Page size (bytes) = 4096 Name = USER1 Type = Database managed space Total pages = 12800 Used pages = 160 Free pages = 12608 Page size (bytes) = 4096 Name = INDX1 Type = Database managed space Total pages = 12800 Used pages = 96 Free pages = 12672 Free pages = 12672 Page size (bytes) = 4096 Name = TEMPORARY1 Type = System managed space Total pages = 1 Used pages = 1 Free pages = Not applicable Page size (bytes) = 4096
Veritas Storage Foundation for DB2 Administrator's Guide
Last updated: 4 Nov 2004
Copyright ©2009 Symantec Corporation
All rights reserved.