Sample QUIESCE control statements

Use the sample control statements as models for developing your own QUIESCE control statements.

Example 1: Establishing a quiesce point for three table spaces

The following control statement specifies that the QUIESCE utility is to establish a quiesce point for table spaces DSN8D81A.DSN8S81D, DSN8D81A.DSN8S81E, and DSN8D81A.DSN8S81P.

//STEP1    EXEC DSNUPROC,UID='IUIQU2UD.QUIESC2',
//            UTPROC='',SYSTEM='DSN'
//SYSIN    DD *
QUIESCE TABLESPACE DSN8D11A.DSN8S11D
        TABLESPACE DSN8D11A.DSN8S11E
        TABLESPACE DSN8D11A.DSN8S11P
//*

The following example shows the output that the preceding command produces.

DSNU000I    DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TEMP      
DSNU1044I   DSNUGTIS - PROCESSING SYSIN AS EBCDIC 
DSNU050I    DSNUGUTC -  QUIESCE TABLESPACE DSN8D81A.DSN8S81D 
                            TABLESPACE DSN8D81A.DSN8S81E 
                            TABLESPACE DSN8D81A.DSN8S81P 
DSNU477I  = DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D81A.DSN8S81D   
DSNU477I  = DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D81A.DSN8S81E   
DSNU477I  = DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D81A.DSN8S81P   
DSNU474I  = DSNUQUIA - QUIESCE AT RBA 000004E43B78 AND AT LRSN 000004E43B78  
DSNU475I    DSNUQUIB - QUIESCE UTILITY COMPLETE, ELAPSED TIME= 00:00:02      
DSNU010I    DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

Example 2: Establishing a quiesce point for a list of objects

In the following example, the QUIESCE control statement uses a list to specify that the QUIESCE utility is to establish a quiesce point for the same table spaces as in example 1. The list is defined in the LISTDEF utility control statement.

//STEP1    EXEC DSNUPROC,UID='IUIQU2UD.QUIESC2',
//            UTPROC='',SYSTEM='DSN'
//SYSIN    DD *
//DSNUPROC.SYSIN    DD  *                                 
LISTDEF QUIESCELIST INCLUDE TABLESPACE DSN8D81A.DSN8S81D
                    INCLUDE TABLESPACE DSN8D81A.DSN8S81E    
                    INCLUDE TABLESPACE DSN8D81A.DSN8S81P    
QUIESCE LIST QUIESCELIST                                    
//*

The following example shows the output that the preceding command produces.

DSNU000I    DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TEMP      
DSNU1044I   DSNUGTIS - PROCESSING SYSIN AS EBCDIC                               
DSNU050I    DSNUGUTC -  LISTDEF QUIESCELIST INCLUDE TABLESPACE DSN8D81A.DSN8S81D
INCLUDE TABLESPACE DSN8D81A.DSN8S81E 
INCLUDE TABLESPACE DSN8D81A.DSN8S81P
DSNU1035I   DSNUILDR - LISTDEF STATEMENT PROCESSED SUCCESSFULLY             
0DSNU050I    DSNUGUTC -  QUIESCE LIST QUIESCELIST                            
DSNU477I  = DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D81A.DSN8S81D  
DSNU477I  = DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D81A.DSN8S81E  
DSNU477I  = DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D81A.DSN8S81P  
DSNU474I  = DSNUQUIA - QUIESCE AT RBA 000004E56419 AND AT LRSN 000004E56419 
DSNU475I    DSNUQUIB - QUIESCE UTILITY COMPLETE, ELAPSED TIME= 00:00:00     
DSNU010I    DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0  

Example 3: Establishing a quiesce point for a table space set.

The following control statement specifies that QUIESCE is to establish a quiesce point for the indicated table space set. In this example, the table space set includes table space DSN8D81A.DSN8S81D and all table spaces that are referentially related to it. Run REPORT TABLESPACESET to obtain a list of table spaces that are referentially related.

QUIESCE TABLESPACESET TABLESPACE DSN8D11A.DSN8S11D

The following example shows the output that the preceding command produces.

DSNU000I   DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TSLQ.STEP1
DSNU050I   DSNUGUTC - QUIESCE TABLESPACESET TABLESPACE DSN8D11A.DSN8S11D
DSNU477I - DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACESET DSN8D11A.DSN8S11D
DSNU477I - DSNUQUIA -    QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D11A.DSN8S11D
DSNU477I - DSNUQUIA -    QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D11A.DSN8S11E
DSNU477I - DSNUQUIA -    QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D11A.PROJ
DSNU477I - DSNUQUIA -    QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D11A.ACT
DSNU477I - DSNUQUIA -    QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D11A.PROJACT
DSNU477I - DSNUQUIA -    QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D11A.EMPPROJA
DSNU477I - DSNUQUIA -    QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D11A.DSN8S1D
DSNU474I - DSNUQUIA - QUIESCE AT RBA 000000052708 AND AT LRSN 000000052708
DSNU475I   DSNUQUIB - QUIESCE UTILITY COMPLETE, ELAPSED TIME= 00:00:25
DSNU010I   DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

Example 4: Establishing a quiesce point without writing the changed pages to disk

In the following example, the control statement specifies that the QUIESCE utility is to establish a quiesce point for table space DSN8D81A.DSN8S81D, without writing the changed pages to disk. (The default is to write the changed pages to disk.) In this example, a quiesce point is established for COPY YES indexes, but not for COPY NO indexes. Note that QUIESCE jobs with the WRITE YES option, which is the default, process both COPY YES indexes and COPY NO indexes. For both QUIESCE WRITE YES jobs and QUIESCE WRITE NO jobs, the utility inserts a row in SYSIBM.SYSCOPY for each COPY YES index.

//STEP1    EXEC DSNUPROC,UID='IUIQU2UD.QUIESC2',
//            UTPROC='',SYSTEM='DSN'
//SYSIN    DD *
//DSNUPROC.SYSIN    DD  *                                  
QUIESCE TABLESPACE DSN8D81A.DSN8S81D WRITE NO                                   
//*

The preceding command produces the output that is shown in the following example. Notice that the COPY YES index EMPNOI is placed in informational COPY-pending (ICOPY) status:

DSNU000I    DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TEMP              
DSNU1044I   DSNUGTIS - PROCESSING SYSIN AS EBCDIC                           
DSNU050I    DSNUGUTC -  QUIESCE TABLESPACE DSN8D81A.DSN8S81D WRITE NO       
DSNU477I  = DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE DSN8D81A.DSN8S81D
DSNU477I  = DSNUQUIA -    QUIESCE SUCCESSFUL FOR INDEXSPACE DSN8D81A.EMPNOI  
DSNU474I  = DSNUQUIA - QUIESCE AT RBA 000004E892A3 AND AT LRSN 000004E892A3   
DSNU568I  = DSNUGSRX - INDEX ADMF001.EMPNOI IS IN INFORMATIONAL COPY PENDING  
DSNU475I    DSNUQUIB - QUIESCE UTILITY COMPLETE, ELAPSED TIME= 00:00:00       
DSNU010I    DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0     

Example 5: Establishing a quiesce point for a clone table space

The following control statement specifies that the QUIESCE utility is to establish a quiesce point for the specified clone table space and its indexes, and write the changes to disk.

QUIESCE TABLESPACE DBJM0901.TPJM0901 WRITE YES CLONE