The list_instances operator shows the instance configuration. Available only in the Enterprise Edition.

Synopsis

list_instances();

Library

The sync operator resides in the System library. Run the following query to load this library:

AFL% load_library('system');

Summary

The list_instances() operator returns information about the instances registered in your system. The output attributes are as follows:

instance_id : uint64,
membership : string,
member_since : date_time,
liveness : bool,
server_id : uint32,
server_instance_id : uint32,
host : string,
port : uint16,
base_path : string

Example

1. List instances:

   AFL% list_instances();
   

   The output may be:

   {No} instance_id,membership,member_since,liveness,server_id,server_instance_id,host,port,base_path
   {0} 0,'member','2016-01-22 20:47:48',true,0,0,'127.0.0.1',1239,'/devel/scidb/DB-mydb'
   {1} 1,'member','2016-01-22 20:47:48',true,0,1,'127.0.0.1',1240,'/devel/scidb/DB-mydb'
   {2} 2,'member','2016-01-22 20:47:48',true,0,2,'127.0.0.1',1241,'/devel/scidb/DB-mydb'
   {3} 3,'member','2016-01-22 20:47:48',true,0,3,'127.0.0.1',1242,'/devel/scidb/DB-mydb'

2. Show the list_instances() schema:

   AFL% show('list_instances()', 'afl');

   The output is:

   {i} schema
   {0} 'list<instance_id:uint64 NOT NULL,membership:string NOT NULL,member_since:datetime,liveness:bool NOT NULL,server_id:uint32 NOT NULL,server_instance_id:uint32 NOT NULL,host:string NOT NULL,port:uint16 NOT NULL,base_path:string NOT NULL> [No=0:*,1000000,0]'