Ühel kenal päeval, K, 2006-07-26 kell 06:40, kirjutas Gregory S Stark: > The DB2 handbook says "Tables can now be reorganized online with almost full > acess to the table allowed" but their syntax does not use the word "online".
Does this reorganizing refer to what we do with CLUSTER ? I'd really love to be able to CLUSTER a table with ALLOW WRITE ACCESS. currently this requires quite a complicated dance with views,triggers, logfiles and changing access funtions. > They actually support three modes: > > ALLOW NO ACCESS > ALLOW READ ACCESS > ALLOW WRITE ACCESS > > I'm not sure where that leaves us. The word "online" seems deeply ingrained in > the database vocabulary for this feature but there's a certain amount of > SQLishness in the DB2 syntax too. > > DB2 also supports some other nice options like interrupting an index build and > then resuming it later. If there's demand that seems like something we > would be > able to support too. The same infrastructure might be useful for > suspending and > resuming vacuums on large tables too. > > -- > Gregory Stark > EnterpriseDB http://www.enterprisedb.com > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match