Skip to Content
author's profile photo SMEPC SH
0
SMEPC SH
Jul 16, 2020 at 10:23 AM

​Why sometimes we cannot see the tenant database item via M_DATABASE under the SYSTEMDB mode

171 Views

a) This output of the m_databases was normal after stop the tenant BK2:

hdbsql SYSTEMDB=>

hdbsql SYSTEMDB=>

hdbsql SYSTEMDB=> alter system stop database BK2;

0 rows affected (overall time 16.255817 sec; server time 16.248228 sec)

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","Stopped by user via ALTER SYSTEM STOP DATABASE","","","DEFAULT",?

2 rows selected (overall time 2016.008 msec; server time 1163 usec)

hdbsql SYSTEMDB=>

hdbsql SYSTEMDB=>

b) This output of the m_databases was abnormal after stop the tenant BK2:

hdbsql SYSTEMDB=>

hdbsql SYSTEMDB=>

hdbsql SYSTEMDB=> alter system stop database BK2;

0 rows affected (overall time 15.252442 sec; server time 15.247724 sec)

hdbsql SYSTEMDB=>

hdbsql SYSTEMDB=>

hdbsql SYSTEMDB=> SELECT * FROM SYS.M_DATABASE; SYSTEM_ID,DATABASE_NAME,HOST,START_TIME,VERSION,USAGE "BK2","SYSTEMDB","hanabktest2","2020-07-02 04:19:55.163000000","2.00.041.00.1560320256","TEST" 1 row selected (overall time 1792.450 msec; server time 1657 usec)

hdbsql SYSTEMDB=>

hdbsql SYSTEMDB=>