In ArcGIS Data Store 10.9, the relational data store uses Transport Layer Security (TLS) protocol connections to communicate with the hosting server, and a new data store type—object store—is available to store cached query responses for hosted feature layers.
See the 10.9 issues addressed list for information on fixes in the software.
Beginning with ArcGIS Data Store 10.9, the relational data store uses TLS protocol connections to communicate with the hosting server. If you do not want to use TLS communication between the relational data store and hosting server, you can use the changedbproperties command to disable it. To determine whether TLS communication is enabled on the relational data store, use the describedatastore command.
To simplify the changedbproperties command, the options for disabling or enabling TLS communication for the tile cache data store have been combined with the options for relational data store.
New data store type to cache query responses for hosted feature layers
If the ArcGIS Enterprise deployment includes hosted feature layers that are viewed frequently by many users but are not edited often, the ArcGIS Server administrator of the hosting server can enable caching on individual layers in hosted feature layers. Once enabled, query responses will be cached for the layer and the number of queries sent to the relational data store will decrease, thereby improving drawing performance for those layers. However, before the ArcGIS Server administrator can enable feature query response caching on feature layers, the ArcGIS Data Store administrator must create an object store.
The object store is created using the configuredatastore utility. The listobjectstorage utility has been added to allow you to determine the current size of the cache for each layer as well as the cache expiration policy.