db2维护手册（DB2 maintenance manual）.doc

db2维护手册（DB2 maintenance manual） DB2 maintenance manual Catalog DB2 Maintenance Manual 1 Daily maintenance day 3 DB2 operation 1, check whether the administration server starts 3 2, check that the DB2 instance has already started 3 3. See if the table space status is normal 3 4. Look at the status of the table 4 5. Check out disk space 4 6 check the storage management software is normal 4 7 check the database backup is normal 5 8. Check that the archived log is correctly filed 5 9, check the buffer pool hit rate of 5 10, check the current running the most frequent SQL, its hit rate is normal 5 11, check the current connection of the application, there is no illegal connection 5 12, check whether there is deadlock 6 13. RUNSTATS 6 for tables and indexes 14. Check whether the watch needs to be reorganized 6 15. Restructure the tables that need to be restructured 7 Two 、 DB2 daily maintenance monthly operation 7 1 check out the DB2 log 7 2. Check whether the backup and log are all saved. 7 Three 、 DB2 daily maintenance quarterly operation 7 1. See how the system works by snapshot monitor 7 2 database patch level 8 Four, notice 8 1, do not delete active log file 8 2, pay attention to the transaction log storage space 8 3, according to the actual workload of the system, configure the log space 8 4. Set the correct database code page 9 5. Check the installation of permit (LICENSE) 9 6, before you create a database, adjust the system time 9 7, do not arbitrarily execute CHOWN (CHMOD) - R (UNIX/LINUX) 9 8, in archive log mode, use LOAD and remember to add NONRECOVERABLE parameter 9 Five. Attached: restructuring Table 9 in offline mode Six, attached: index reorganization 10 Seven. Attachment: guidelines for the collection and updating of statistical information 11 Eight: attached: use CLP capture database running snapshot 13 Daily maintenance day operation of DB2 1, check that the management server is started Use the PS command to see if there is a dasusr1 daemon PS -ef dasus