The list_array_residency operator shows the physical instances on which arrays reside. Available only in the Enterprise Edition.

Synopsis

list_array_residency();

Library

The list_array_residency() operator resides in the System library. Run the following query to load this library:

AFL% load_library('system');

Summary

The list_array_residency operator shows the physical instances on which arrays reside. The output attribute value indicates the array redundancy, i.e. one less than the number of copies that the system maintains for every chunk in a given array. The redundancy value is a system-wide configuration setting maintained in config.ini.

Example

Create an array:
```
AFL% create array A<v:double>[i];
```
List array residency:
```
AFL% list_array_residency();
```
The exact output can vary. The sample output below shows an array with ID 271 resides on instances 0-3 and has redundancy 3.
```
{array_id,instance_id} redundancy
{271,0} 3
{271,1} 3
{271,2} 3
{271,3} 3
```
Remove the array:
```
AFL% remove(A);
```