Skip to end of metadata
Go to start of metadata

HANA_Tables_ColumnStore_TableHostMapping_Fallback

If the 'HANA_Tables_ColumnStore_TableHostMapping_Fallback' script fails use this one

Input Parameters

SCHEMA_NAME
TABLE_NAME          
MIN_SIZE_MB
RESULT_ROWS

Output Parameters

SCHEMA:      Schema name
TABLE_NAME:  Table name
TOTAL_GB:    Total table size (GB)
PART:        Number of partitions
HOST_1_GB:   Table size on host 1 (host name found in line 1 of output, role found in line 2 of output)
HOST_2_GB:   Table size on host 2
HOST_3_GB:   Table size on host 3
HOST_4_GB:   Table size on host 4
HOST_5_GB:   Table size on host 5
HOST_6_GB:   Table size on host 6
HOST_7_GB:   Table size on host 7
HOST_8_GB:   Table size on host 8
HOST_9_GB:   Table size on host 9
HOST_10_GB:  Table size on host 10
HOST_11_GB:  Table size on host 11
HOST_12_GB:  Table size on host 12
HOST_13_GB:  Table size on host 13
HOST_14_GB:  Table size on host 14
HOST_15_GB:  Table size on host 15
HOST_16_GB:  Table size on host 16

 

  • No labels