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

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