SAP 租户HANA端口查询以及创建数据库指定端口
SAP MDC HANA 租户端口查询SQLSELECT DATABASE_NAME,SERVICE_NAME,PORT,SQL_PORT,(PORT + 2) HTTP_PORTFROM SYS_DATABASES.M_SERVICES WHERE((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or (SERVICE_NA
·
SAP MDC HANA 租户端口查询SQL
SELECT DATABASE_NAME,SERVICE_NAME,PORT,SQL_PORT,(PORT + 2) HTTP_PORT
FROM SYS_DATABASES.M_SERVICES WHERE
((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or (SERVICE_NAME='xsengine'))
利用上述查询到的端口,可以在创建新的租户数据库时,直接指定端口
CREATE DATABASE <DATABASE_NAME> AT LOCATION '<HOST_NAME>:3XX03' SYSTEM USER PASSWORD <PASSWORD>;
更多推荐
所有评论(0)