When A table or database is being backed up, it put a HUT
lock on the object, which is released when it finishes backup successfully. But
sometime when backup fails or aborted HUT lock be there and query on those
objects goes into blocking. One way of
find and release lock on object is to login into one of the node and use show
lock utility.
Here is the steps we can follow...
1. start CNSTERM 6 by typing "cnsterm 6"
UAT2_1-9:/var/opt/teradata/DEV_108 # cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Started 'dip' in window 1
at Tue Oct 16
04:03:29 2012
Input Supervisor Command:
start updatedbc
Started 'updatedbc' in window 1
at Tue Oct 16
04:18:18 2012
Input Supervisor Command:
enable all logons
12/10/16 05:11:03 Logons enabled.
Enable Logons of screen debug in ctl have been updated to
All.
Input Supervisor Command:
start dip
Started 'dip' in window 1
at Tue Oct 16
05:19:50 2012
2. Start "showlock utility" by typing "start showlocks" on CNSTERM 6 terminal.
Input Supervisor Command:
> start showlocks
start showlocks
Started 'showlocks' in window 1
at Wed Oct 17
09:22:22 2012
Input Supervisor Command:
>
3. Start CNSTERM 1 in different putty session to see the hut
lock..
UAT2_1-9:/var/opt/teradata/DEV_108 # cnsterm 1
Attempting to connect to CNS...Completed.
Hello
USER arcuser4 MODE Excl
AMP All Amps
GL_TB.TRUNK_GS_SUMMARY
USER arcuser4 MODE Excl
AMP All Amps
GL_TB.VERTICAL
USER arcuser4 MODE Excl
AMP All Amps
GL_TB.ZZZ_GL_PARAMETER
USER arcuser4 MODE Excl
AMP All Amps
GL_TB.ZZZ_TB_BI_DIM_STORE
USER arcuser4 MODE Excl
AMP All Amps
GL_TB.ZZZ_TB_BI_DIM_STORE_OPER_HRS
USER arcuser4 MODE Excl
AMP All Amps
GL_TB.base64
USER arcuser4 MODE Excl
AMP All Amps
--ShowLocks Processing Complete--
Now, once we get the list of object having HUT lock, we can
login into the "arcmain" session and put release lock command on
those object.
4. type "arcmain" and enter
5. type “Logon
10.12.88.120/arcuser4,password;”
6. type “Release lock (GL_TB.TRUNK_GS_SUMMARY);”
7. Logoff;
No comments:
Post a Comment