DB2 Utility (1)

DB2 Utility learning experience (1) 1. DB2 Utility has a simple understanding that DB2 Utility is divided into Online Utility and Stand Alone Utility. In most cases, it is run in JCL mode, DB2 Online Utility requires a sysin dd statement for parameter input.
Online Utility requires that DB2 be in the running state. The running mode is similar to that of MVS Batch jobs or a stored procedure. Stand Alone Utility does not require DB2 to run. The running mode can only be run in mvs jcl mode, there are two types of Online Utility. The first category is auxiliary classes such as LISTDEF Utility and TEMPLATE Utility, which are used to assist other Utility for more convenient use. The second category is functional classes such as COPY, LOAD, UNLOAD, REBUILD, REORG, REPAIR, RUNSTATS. Www.2cto.com 2, there are 5 types of DB2 Online Utility Monitoring and Control Utility statuses. The status information is stored in the SYSUTILX tablespace ACTIVE (ACTIVE) being processed.
The STOP tool is paused, and the changed data cannot be used. The TERMINATING tool is terminated by the TERMINATE Utility command from the last state of PHASE execution (PHASE) re-start CURRENT re-start at the last internal commit point. The information of the submit POINT is saved in the SYSUTILX tablespace, which contains two tables: SYSUTILSYSUTILX saves overflow information when the CHECKPOINT/RESTART information exceeds the available space of the SYSUTIL table.
The SYSUTIL record is used to prevent other Utility from simultaneously processing the same DB2 object from being updated at the Utility commit point or stop point, in this way, when the Utility starts again, you can get the startup information. This table cannot be queried using SQL statements. You can only use the DISPLAY Utility command to delete rows using TERMINATE Utility and delete specific UtilityId rows.