versago:database_port_information

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
versago:database_port_information [2020/06/15 10:59]
runger created
versago:database_port_information [2020/07/28 14:16] (current)
Line 20: Line 20:
 SERVICE_NAME, PORT, SQL_PORT, (PORT+2) AS "HTTP_PORT" SERVICE_NAME, PORT, SQL_PORT, (PORT+2) AS "HTTP_PORT"
 FROM SYS.M_SERVICES FROM SYS.M_SERVICES
-WHERE ((SERVICE_NAME='indexserver' AND COORDINATOR_TYPE='MASTER') or (SERVICE__NAME='xsengine'))+WHERE ((SERVICE_NAME='indexserver' AND COORDINATOR_TYPE='MASTER') or (SERVICE_NAME='xsengine'))
 </code> </code>
  
 The "SQL_Port" value returned by the query is used by Versago.  In the following image, the tenant is DEVTenant.  The query returns port 30047. The connection in Versago is created using this port, rather than the single tenant 30015. The "SQL_Port" value returned by the query is used by Versago.  In the following image, the tenant is DEVTenant.  The query returns port 30047. The connection in Versago is created using this port, rather than the single tenant 30015.
  
 +{{:versago:multitenant_hana_port_determination.png?800|MultiTentant Determination}}
 +
 +<WRAP center round tip 80%>
 +The HANA Multi-Tenant information applies to Versago v2.4.  The next version of Versago (v3) will include additional connection parameters that will determine the port automatically
 +</WRAP>
  
versago/database_port_information.1592233152.txt.gz · Last modified: 2020/06/15 10:59 by runger