how to diable table in Db2

[suresh4ind]

Im working on DB2 database and i want to know how to disable tables in DB2

[sakumar9]

You can quiesce the table to make to not usable for users. You need to put it back in unquiesced to let the users access the table.

QUIESCE TABLESPACES FOR TABLE TEMP_TABLE  SHARE;

You can find more information at this link:
http://publib.boulder. ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw .admin.cmd.doc/doc/r0008635.html

Regards
-- Sanjay

[sakumar9]

Following link is more relevant to your case:

http://publib.boulder. ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw .admin.cmd.doc/doc/r0002003.html