Update the PICOLLECTIVE and PISERVER tables on the primary server

Use piconfig to create one record in the PICOLLECTIVE table for the collective and to create a record for each server in the collective in the PISERVER table. You need to specify identifying fields for both tables. We recommend that you create a command file and use piconfig to run the commands in that file.

1. Create a text file, such as collective_create_uc.txt, in the ..\PI\adm directory.

2. Copy the following text into the file:

   * Collective information
   *
   @tabl picollective
   @mode create,t
   @istr name, Description, CollectiveID
   uc-s1,UC 2012 Demo Collective,08675309-0007-0007-0007-
   000000001001
   *
   * Individual server member information
   *
   * valid values for Role include:
   * 0 NotReplicated
   * 1 Primary
   * 2 Secondary
   *
   @tabl piserver
   @mode create,t
   @istr name,Description,Collective,FQDN,Role,ServerID
   uc-s1,UC 2012 Demo Server 1,uc-s1,uc-s1.osisoft.int,1,08675309-
   0007-0007-0007-000000001001
   uc-s2,UC 2012 Demo Server 2,uc-s1,uc-s2.osisoft.int,2,08675309-
   0007-0007-0007-000000001002
   

3. Edit the text to specify the information for your collective and servers. If necessary, add additional lines for additional servers in your collective.

4. Open a command window.

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

6. Enter:

   piconfig < collective_create_uc.txt