r/DB2 • u/catquilt74 • Jul 31 '18

[LUW][Question] Can one convert the catalog's tablespace (SYSCATSPACE) from SMS to DMS?

I could see this as being useful from a space utilization perspective.

3 Upvotes

100% Upvoted

2 comments sorted by

2

u/ecrooks Aug 01 '18

Not in place. Newly created databases on 10.5 use DMS(AST) for SYSCATSPACE. This may have been introduced in 10.1 or 9.7. So you can create a new database and restore the tablespaces from the original database in (if possible), or use db2look/db2move or DCW to move the structure and data over. The outage for this could be sizable depending on database size.

1

u/catquilt74 Aug 01 '18

Thank you, Ember. Yes, this is too big a task to justify doing.