Toad World® Forums

Re: No extract ddl on SYSCATSPACE tablespace


#1

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


#2

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