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.