Archives of the TeradataForum
Message Posted: Wed, 29 Aug 2007 @ 18:05:08 GMT
| Subj: | | Re: Finding Multiload locks |
| |
| From: | | nazy_gholizadeh |
You can see mload locks (when an mload fails and leaves a lock on the table) by running the checktable utility, with the "at level pendingop"
option.
check all tables at level pendingop; (or you can specify the table name, if you are checking on a specific table)
On the Remote Console (Teradata Manager) and Checktable option or On the node,using cnsterm6 / start checktable ......
Checktable should not run while tables are being loaded.
Nazy
| 
