Configure key range partition to partition Db2 Warehouse on Cloud data based on field values. Key range is supported for only the numeric and date/time data types.
You can configure key ranges for the following data types:
String
Numeric
Date/Time. Use the following format:YYYY-MM-DD HH24:MI:SS.MS
Perform the following steps to configure a key range partition: