Skip to Content
0
Jul 20, 2020 at 10:56 AM

The doubt about the HANA data_volume

120 Views

1) Why only the hdb00001/datavolume_0000.dat cannot be viewed from M_DATA_VOLUMES ?

2) What the meanings of <n> within the datavolume hdb<m>.<n> should be ?

3) What the meanings of nameserver.lck for /hana/data/BK1/mnt00001 should be ?

hanabktest1:/hana/data/BK1/mnt00001 #

hanabktest1:/hana/data/BK1/mnt00001 #

hanabktest1:/hana/data/BK1/mnt00001 # ls -ltr

total 4 drwxr-x--- 1 bk1adm sapsys 142 Jun 15 14:25 hdb00001

drwxr-xr-- 1 bk1adm sapsys 118 Jun 15 14:26 hdb00003.00003

drwxr-xr-- 1 bk1adm sapsys 118 Jun 15 14:26 hdb00002.00003

-rw-r--r-- 1 bk1adm sapsys 22 Jul 12 04:44 nameserver.lck

hanabktest1:/hana/data/BK1/mnt00001 #

hanabktest1:/hana/data/BK1/mnt00001 #

hanabktest1:/hana/data/BK1/mnt00001 # cat nameserver.lck

hanabktest1:1381585128

hanabktest1:/hana/data/BK1/mnt00001 #

hanabktest1:/hana/data/BK1/mnt00001 #

hanabktest1:/hana/data/BK1/mnt00001 #

hanabktest1:/hana/data/BK1/mnt00001 # ls -ltr hdb00001

total 3413420

-rw-r----- 1 bk1adm sapsys 0 Jun 15 14:24 __DO_NOT_TOUCH_FILES_IN_THIS_DIRECTORY__

-rw-r----- 1 bk1adm sapsys 36 Jun 15 14:25 landscape.id

-rw-r----- 1 bk1adm sapsys 3758096384 Jul 12 04:46 datavolume_0000.dat hanabktest1:/hana/data/BK1/mnt00001 #

hanabktest1:/hana/data/BK1/mnt00001 #

>select * from M_DATA_VOLUMES ; HOST,PORT,PARTITION_ID,VOLUME_ID,FILE_NAME,FILE_ID,STATE,SIZE,MAX_SIZE "hanabktest1",31003,0,3,"/hana/data/BK1/mnt00001/hdb00003.00003/datavolume_0000.dat",1,"ACTIVE",3422552064,0 "hanabktest1",31007,0,2,"/hana/data/BK1/mnt00001/hdb00002.00003/datavolume_0000.dat",1,"ACTIVE",201441280,0 2 rows selected (overall time 8409.726 msec; server time 4542 usec)