If you're running at V7.x then you can get this info from the history file. I don't know the command from the top of my head but: list history for <dbname> tablespace <tblspacename> all or something close to it should give you the when, I think the whom and maybe the how. HTH, Pierre.
Sinha, Amit wrote: >That did it thanks a lot Ajith. I wonder though how may it would have >happened we were just called by the application people >that they were not able to access the tables ? Any way to see in the catalog >tables or log to see when and what caused it ? > >Thanks, > >Amit > >-----Original Message----- >From: Vilas, Ajith (USPC.PCT.Hopewell) [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 20, 2002 7:47 PM >To: Sinha, Amit; '[EMAIL PROTECTED]' >Subject: RE: [DB2EUG] Quiesced Exclusive State > > >Amit, > If you have more than one tables in this tablespace, you are probably >resetting the state for the wrong one !. Try the following steps >1. If you are not sure about which table, run the reset command for all of >them. >2. make sure you are connected as the user who got this into quiesce state. >Regards, >Ajith > >-----Original Message----- >From: Sinha, Amit [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 20, 2002 2:49 PM >To: '[EMAIL PROTECTED]' >Subject: [DB2EUG] Quiesced Exclusive State > > >Hi all, > >The USERSPACE1 has gone into quiesced exclusive state and using list >talespaces show detail identified the object id >and did quiesce tablespaces for table xx reset. >Even after executing the command the tablepspace is still in Quiesced state. > >What I am doing wrong ? I have encountered this for the first time. > >Any help will be greatly appreciated. > >Thanks. > >Amit >- >::: When replying to the list, please use 'Reply-All' and make sure >::: a copy goes to the list ([EMAIL PROTECTED]). >*** You are subscribed to [EMAIL PROTECTED] >*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] >- >::: When replying to the list, please use 'Reply-All' and make sure >::: a copy goes to the list ([EMAIL PROTECTED]). >*** You are subscribed to [EMAIL PROTECTED] >*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > -- Pierre Saint-Jacques 514-737-4515 Off. IBM Certified Solutions Expert - Administration President 514-737-1268 Fax. 233 Simcoe Cr. SES Consultants Inc. [EMAIL PROTECTED] Mount-Royal, QC Canada H3P 1X1 - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
