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.