DB2 Utility (2)

DB2 Utility (2) 3. DB2 Online Utility 3.1, LISTDEF Utility can define multiple objects in a LIST and define a name for the set. Generally, we use LISTDEF to define a LIST before a Utility control statement, and use this LIST in the following Utility Control statement. At www.2cto.com 3.2, the TEMPLATE Utility Control statement can be used to allocate files without using the JCL statement when LISTDEF is used. The control statement can contain parameters used to allocate files: file size, location, and file attributes. A template with the specified name is dynamically generated and can be referenced later. 3.3, COPY Utility performs image copy on any OBJECT. There are two types: full image copy and incremetal image copyfull image copy for TABLESPACE, PARTION, all pageincremetal image copies of index space only copy pages modified since the last full image copy. in daily work, full image copy is used. In theory, more than 50% of PAGES are modified, it is more appropriate to use full image copy 3.4. LOAD Utility is used to LOAD data to TABLESPACE and rebuild index www.2cto.com 3.5, UNLOAD Utility is used to UNLOAD data from several tables space or image copy dataset to several B SAM sequential data set. 3.6. REBUILD Utility is used to reconstruct INDEX3.7 Based on the TABLE content. reorg tablespace Utility is used to reorganize TABLESPACE to Improve the Performance of accessing TABLESPACE and reclaim fragments. 3.8. REPAIR Utility can help users REPAIR data, especially data that users cannot access normally. You must use it with caution. Otherwise, data or DB2 subsystem exceptions may occur. It is generally used for the following purposes: TEST and repair dbdsreset tablespace and INDEX some PENDING statuses verify that the content of the data area of TABLESPACE and INDEX replaces the content of the data area of TABLESPACE and INDEX to delete the content of a row in TABLESPACE and INDEX 16-bit DUMP information 3.9 is generated in the data area, RUNSTATS Utility is used to collect information about TABLESPACE, INDEX, PARTION, TABLE, and TABLE and store it in the DB2 catalog table. It can be divided into runstats tablespace and runstats index.