Re: No extract ddl on SYSCATSPACE tablespace

Version is DB2 V8.2 (we are running under special dispensation because of
websphere). Toad version is 4.6. What I do is go to tablespaces, order by
tablespaceid, right click the first tablespace (which happens to be SYSCATSPACE)
and select extract ddl. It does nothing. It works when I select a user
tablespace.

Jim Rutten

Senior Database Administrator

Staples Promotional Products

7500 W 110th St

Overland Park , KS 66210

p:(913) 319-4709

jim.rutten@StaplesPromoProducts.com

www.StaplesPromotionalProducts.com

Hi Jim,
We didn’t script sys tablespaces in 4.6 by using extract DLL.
I’ve just verified that we do that in 4.7 so you just need to start using 4.7 for that.
Vlas