Configure the PICOLLECTIVE and PISERVER tables on the primary server

The PICOLLECTIVE and PISERVER tables contain configuration and status information for each server in a Data Archive collective. New collectives and members must be added to these tables to allow client applications to connect to servers in the collective. This topic explains how to create a script that adds details about a new collective to these tables.

Note: The following identifying fields and values must be referenced in the script: 1) PICOLLECTIVE table: Name, Description, and CollectiveID; and 2) PISERVER table: Name, Description, Collective, FQDN, Role, and Server ID. For more information, see Collective table (PICOLLECTIVE) and Server table (PISERVER).

Follow these steps to create a script that adds records to the PICOLLECTIVE and PISERVER tables for a new Data Archive collective.

1. Create a text file that will contain the script in the ..\PI\adm directory.

2. Copy the following lines of code into your new text file.

   Important: Make sure to replace all fictitious values in the sample script with your actual information. Add lines for more servers if needed.

   Script example

   * ============================

   * PICOLLECTIVE + PISERVER (piconfig command file)

   * Replace the placeholder text in the sample script with actual values.

   * ============================

   * --- Collective (must exist once) ---

   @tabl picollective

   @mode create,t

   @istr name,Description,CollectiveID

   uc-s1,UC 2006 Demo Collective,{COLLECTIVE_GUID}; 08675309-0007-0007-0007-000000001001

   * --- Server members (one row per server) ---

   @tabl piserver

   @mode create,t

   @istr name,Description,Collective,FQDN,Role,ServerID

   uc-s1,UC 2006 Demo Server 1,uc-s1,uc-s1.osisoft.int,1,{SERVER1_ID}; Role 1 = Primary

   uc-s2,UC 2006 Demo Server 2,uc-s1,uc-s2.osisoft.int,2,{SERVER2_ID}; Role 2 = Secondary

3. Open a terminal or command prompt window.

4. Navigate to the ..\PI\adm directory.

5. Enter the following commands to run the script and add the records to the PICOLLECTIVE and PISERVER tables : piconfig < collective_create_uc.txt

   New records are added to the PICOLLECTIVE and PISERVER tables.

6. Verify that the new records have been added to the PICOLLECTIVE and PISERVER tables.