为什么有时我们在SYSTEMDB模式下无法通过M_DATABASE看到租户数据库项

2020-08-15 03:58发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


a)停止租户BK2后,m_database的此输出正常:

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>更改系统停止数据库BK2;

受影响的0行(总时间16.255817秒;服务器时间16.248228秒)

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB => SELECT * from m_databases; DATABASE_NAME,DESCRIPTION,ACTIVE_STATUS,ACTIVE_STATUS_DETAILS,OS_USER,OS_GROUP,RESTART_MODE,FALLBACK_SNAPSHOT_CREATE_TIME

" SYSTEMDB"," SystemDB-BK2-20"," YES","","",""," DEFAULT",?

" BK2"," BK2-20"," NO","用户通过ALTER SYSTEM STOP DATABASE停止","","","默认",?

已选择2行(总时间为2016.008毫秒;服务器时间为1163微秒)

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

b)停止租户BK2后,m_databases的输出异常:

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB => alter system stop数据库BK2;

受影响的0行(总时间15.252442秒;服务器时间15.247724秒)

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB => SELECT * FROM SYS.M_DATABASE; SYSTEM_ID,DATABASE_NAME,HOST,START_TIME,VERSION,用法" BK2"," SYSTEMDB"," hanabktest2"," 2020-07-02 04:19:55.163000000"," 2.00.041.00.1560320256"," TEST"已选择1行 (总时间为1792.450毫秒;服务器时间为1657微秒)

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


a)停止租户BK2后,m_database的此输出正常:

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>更改系统停止数据库BK2;

受影响的0行(总时间16.255817秒;服务器时间16.248228秒)

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB => SELECT * from m_databases; DATABASE_NAME,DESCRIPTION,ACTIVE_STATUS,ACTIVE_STATUS_DETAILS,OS_USER,OS_GROUP,RESTART_MODE,FALLBACK_SNAPSHOT_CREATE_TIME

" SYSTEMDB"," SystemDB-BK2-20"," YES","","",""," DEFAULT",?

" BK2"," BK2-20"," NO","用户通过ALTER SYSTEM STOP DATABASE停止","","","默认",?

已选择2行(总时间为2016.008毫秒;服务器时间为1163微秒)

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

b)停止租户BK2后,m_databases的输出异常:

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB => alter system stop数据库BK2;

受影响的0行(总时间15.252442秒;服务器时间15.247724秒)

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB => SELECT * FROM SYS.M_DATABASE; SYSTEM_ID,DATABASE_NAME,HOST,START_TIME,VERSION,用法" BK2"," SYSTEMDB"," hanabktest2"," 2020-07-02 04:19:55.163000000"," 2.00.041.00.1560320256"," TEST"已选择1行 (总时间为1792.450毫秒;服务器时间为1657微秒)

hdbsql SYSTEMDB =>

hdbsql SYSTEMDB =>

付费偷看设置
发送
1条回答
蓋茨
1楼 · 2020-08-15 04:49.采纳回答

在第一个查询中,您从系统视图中选择 M_DATABASES 列出所有数据库。 在第二个查询中,您从系统视图中选择 M_DATABASE ,它仅提供有关您登录的数据库的信息。登录到SYSTEMDB时,您仅会获得有关系统数据库的信息。

我没发现任何问题,您只需从 不同的来源,因此获得不同的结果。

一周热门 更多>