1. Start database DB2Start2. Stop database db2stop3. Connect Database DB2 Connect To O_YD User DB2 Using PWD4. Read the database management program to configure DB2 GET DBM CFG5. Write Database Administrative Programs Configure DB2 Update DBM CFG Using Parameter Name Parameter Value 6. Configuration of Database DB2 Connect To O_YD User DB2 Using PWDB2 Get DB CFG for O_YD7. Configuration of Write Database DB2 Connect To O_YD User DB2 Using PWDDB2 Update DB CFG for O_YD Using Parameter Name Parameter Value 8. Turn off all applications to connect DB2 Force Application AllDB2 Force Application ID1, ID2,, IDN Mode Async (DB2 List Application for DB O_YD Show Detail). Backup Database DB2 FORCE Application AllDB2 Backup DB O_YD to D: (DB2 Initialize Tape On //./tape0) (DB2 Rewind Tape On //./tape0 )db2 Backup DB o_yd to //./tape010. Recovery Database DB2 Restore DB O_YD from D: To D: DB2 Restore DB O_YD from //./tape0 to D: 11. Binding Storage Procedure DB2 Connect To O_YD User DB2 Using PWDDB2 BIND C: /DFPLUS.BND copy stored procedure to the C: / SQLLIB / FUNCTION directory on the server 12. Standard Table DB2 Connect To O_YD User DB2 Using PWDB2 REORG TABLE YDDDB2 RUNSTATS ON TABLE YDD with DISTRIBUTION AND INDEXES ALL
