Alter Table lock mode

Hi all, I am trying to change a couple of tables's lock mode from Page to Row by using the following statment: alter table hy_client lock mode (row); Is there anything i have to watch out by using this statment??, Shutdown & Restart?? or how can I ensure no user is using that table?? Thanks Franklin

Franklin The session will attempt to get exclusive access to the table while performing this command, if it can not then the command will simply fail. Try it a few times in rapid succession to see if you can get the required access (the actual command will take less than a second to run). If you can not get hold of the table you will have to wait until the users have all released it/logged out. The engine does not need to be shutdown for this to take effect, however you may need to increase the number of locks available especially if the row size is very much smaller than page size and many rows are locked at once by the application. Keith -> -----Original Message----- -> From: FRANKLIN TANG [mailto:franklin@macauslot.com] -> Sent: Thursday, January 30, 2003 3:57 AM -> To: ids@iiug.org -> Subject: Alter Table lock mode [172] -> -> -> Hi all, -> I am trying to change a couple of tables's lock mode -> from Page to Row by using the following statment: -> alter table hy_client lock mode (row); -> -> Is there anything i have to watch out by using this -> statment??, Shutdown & Restart?? or how can I ensure no user -> is using that table?? -> -> -> Thanks -> Franklin -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **