Monday, 13 November 2017

SAP HANA 2.0 SP02 Features Access restrictions in Active/Active (read enabled) system setup

Tags


New feature in SAP HANA 2.0 SP 2 Replication state both side are ACTIVE and ACTIVE.

SAP HANA 2.0 SP02 Features Access restrictions in Active/Active (read enabled) system setup



Symptom:

With the SAP HANA 2.0 SPS00 release the secondary instance in an Active/Active (read enabled) system replication setup provides a read-only service. With SAP HANA 2.0 SPS00 and SAP HANA 2.0 SPS01, you will encounter "feature not supported" errors when you try to create/access the following table types on the secondary. Even if you directly connect to the secondary, these restrictions apply.

  • row store
  • row store tables
  • row store global temporary tables
  • row store no-logging tables
  • column store
  • column store global temporary tables
  • column store no-logging tablesaa
  • Since SAP HANA 2.0 SPS02 release most of these restrictions are gone. As of this version you can access all the above mentioned table type on the Active/Active (read enabled) secondary system, except:


column store no-logging tables

However, row store tables can only be accessed via direct connection to the secondary system; hint-based statement routing from the primary to access row store tables on the secondary will be possible in future releases.

Prerequisite:

Running SAP HANA 2.0 system with Active/Active (read enabled) system setup

Solution
Access to column store no-logging tables will be enabled in future SP.


More Details refer Snote:2391079






EmoticonEmoticon

Note: only a member of this blog may post a comment.