Toad World® Forums

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

Jim Rutten

Senior Database Administrator

Staples Promotional Products

7500 W 110th St

Overland Park , KS 66210

p:(913) 319-4709


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.