Saturday, January 7, 2012

Find out in which phase Db2 Load utility is executing



Lets say you are executing a DB2 load utility job and the job is running for a long time. As you know load utility operates in following phases.

UTILINIT, RELOAD, SORT, BUILD, SORTBLD, INDEXVAL, ENFORCE, DISCARD, REPORT and UTILTERM

If you want to know in which phase LOAD job is executing, you can issue the command as shown in the following DB2 commands screen. In this example load utility id is LD12.

                               DB2 COMMANDS                    SSID: DB1X      
 ===>                                                                           
                                                                               
 Position cursor on the command line you want to execute and press ENTER       
                                                                                
 Cmd 1 ===> -DISPLAY UTIL(LD12)                                                
 Cmd 2 ===> 
 Cmd 3 ===> 
       ...>                                                                    
 Cmd 4 ===> 
       ...>                                                                    
 Cmd 5 ===> 
       ...>                                                                    
       ...>                                                                    
 Cmd 6 ===> 
       ...>                                                                    
       ...>                                                                    
 Cmd 7 ===> 
       ...>                                                                     
       ...>                                                                    
       ...>                                                                    
                                                                               
 PRESS:  ENTER to process    END to save and exit     HELP for more information

The below output shows that Load utility is executing in IDEXVAL phase.                                                                               

 DSNU105I  #DB1X DSNUGDIS - USERID = TSUXXXX                                   
                 MEMBER = DB1X                                                 
                 UTILID = LD12                                                 
                 PROCESSING UTILITY STATEMENT 1                                
                 UTILITY = LOAD                                                
                 PHASE = INDEXVAL   COUNT = 481690                             
                 NUMBER OF OBJECTS IN LIST = 1                                  
                 LAST OBJECT STARTED = 1                                       
                 STATUS = ACTIVE                                               
 DSN9022I  #DB1X DSNUGCCC '-DISPLAY UTIL' NORMAL COMPLETION                     
 *** 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.