 |
 |
Archives of the TeradataForum
Message Posted: Tue, 15 Mar 2005 @ 14:14:48 GMT
| Subj: | | Re: TPump Update |
| |
| From: | | Victor Sokovin |
| | You are using a pack factor of 50, which means that an MSR will include 50 update statements. | |
| | Remember that row level locking is not, it is row hash locking and therefore it is possible 2 updates may require the same lock even with
different PI values. | |
I am trying hard to understand the last sentence but am not quite there yet. However, it seems to correlate with another recent thread on the
maximum number of locks. If the number of row hash locks exceeds some limit (on R3 it might be rather low), TD may opt for escalating the locks to
table level. I assume TPUMP is treated in the same way as other processes as far as locking is concerned, and TPUMP does not get any extra quota
on the number of such locks. I wonder whether Bill has seen any table level locks while monitoring the process. Just a speculation.
Regards,
Victor
| |
