Archives of the TeradataForum
Message Posted: Wed, 17 Sep 2003 @ 10:26:42 GMT
| Subj: | | Re: Internal session problem |
| |
| From: | | Chris Coffing |
You may want to do a show locks from the remote console to determine what is blocking your other queries...
The internal session may still be up and running but you can do a "release lock [databasename], override" from SQL Assistant.
This will work for table locks as well. This will release the lock that the internal session has on the database and release it from all
the AMPS... You may want to do a "release mload databasename.tablename" if this is an mload issue...
Make sure you are not in the application phase of your mload or you will corrupt your table and will have to rebuild it...
Chris Coffing
Coffing Data Warehousing
www.coffingdw.com
| 
