oracle dba wrote: > > Jim, > > How do you know? Yes, he wants separate tablespaces for every schema. > I wonder if he knows he can still put tables into separate tablespaces > without using separate schemas. :) > > And maybe for fun. I am going to recommend back that we use a schema > per table! > > Rich
The reason for his advice (I share the general opinion on the list) may be a blue background? I have not touched DB2 for 10 years now and it may (hopefully) have totally changed now, but 'one table per tablespace' used to be something reasonable with DB2 which used to escalate locks in such a way that if many pages were locked in a table the page locks were released and the lock taken AT THE TABLESPACE LEVEL !!! -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
