I would like to get the number of entries of an EVI symbol table.
View qsys2.syspartitionindexes is a good starting point:
SELECT table_schema, table_name, system_table_name, number_keys, index_name, system_index_name, column_names, substr(unique_partial_key_values, 1, 24), overflow_values, evi_code_size
WHERE table_schema in ('MyLib') and accpth_type = 'EVI'
- number_keys contains the number of lines of the table not the number of keys.
- overflow_values contains the number of symbols that are in overflow area.
- unique_partial_key_values (96 char) seems contain that information but in a way I am not used to. For example : '8 -1 -1 -1'
By the way a modified version of this select could help to know which EVI's should be recreated because their overflow areas are almost full.