Restrictions and Limitations

There are a number of restrictions and limitations to be aware of when using Native Cloud Object Storage.

  • Remote table spaces include a set of default table spaces that are provisioned with the instance: OBJSTORESPACE1 for user data and OBJSTORESPACEUTMP1 for user temporary tables. While these default remote table spaces cannot be dropped, customers can create additional NCOS remote table spaces by using supported commands.

Note: A maximum of 16 remote object storage table spaces (including defaults and user-created NCOS spaces) is allowed per instance.
  • Row organized tables cannot be created in remote table spaces.
  • User created indexes for column-organized tables cannot be defined in remote table spaces (use the INDEX IN clause to define a non-remote table space in order to create an index).
  • The remote storage access alias IBMDEFAULTREMALIAS defined for remote table spaces should not be modified, dropped or used for any other purpose.