Simple tablespace, segmented tablespaces and "classic" partitioned tablespaces have all been deprecated. Once you get to Db2 v12 FL 504, UTS (either partition-by-range or partition-by-growth) is your only option for CREATE TABLESPACE (unless you set your CURRENT APPLICATION COMPATIBILITY to a lower function level).
Bill Gallagher | Senior Systems Engineer, DBA
For completeness: one place where UTS is discouraged is for workfile tablespaces (DSNDB07 or whatever). DSNTIJTM / DSNTWFG will set application compatibility back to V11R1 if it creates them.
One of the 'Apollo' presentations mentioned that there was work to 'do something' about this situation for Apollo.
Speaking of snap-crackle-pop, the news this morning is that the Kellogg's strike has been settled. The union has voted to accept and is officially pleased with the results. All of us union folks can buy our Pop-Tarts again!
Computer Systems Manager
5 Manhattan West
New York, NY 10001
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504