For applgrp data tables, CMOD will specify the STOGROUP associated with the database for its CREATE TABLESPACE/INDEX. If there’s a database associated with a given applgrp, it will use the STOGROUP for THAT database when creating the tablespaces/indexes for that applgrp. Create a STOGROUP CMOD, GRANT USE, ALTER DATABASE db STOGROUP CMOD.
ARSUTBL can put a “restrict on drop” in the DDL. Perhaps “restrict on drop” is going to cause problems? Not something we've ever used or thought out.
I'm curious as to what the business reason for using "restrict on drop" is.
Ed