Still using SMS Tablespaces for user data? They have been deprecated for quite sometime…

There are a couple methods that can be used to move data to new Automatic Storage Tablespaces. The ADMIN_MOVE_TABLE supplied stored procedure can be used and offers lots of options. It is best used with tables with small to medium amounts of data. LOAD FROM CURSOR is another method and can be used to move large amounts of data. To enable a database for automatic storage, add a stogroup and specify multiple paths. Db2 will then balance the table data over the available paths which can help to provide balanced IO. To restore a database that uses both automatic storage and SMS for system data to another non-automatic storage database, generate a redirected restore script and specify the correct STOGROUP.