Step 4: Creating and configuring the desktop ObjectServer

Proceed as follows:

1. On the desktop ObjectServer computer (ncdesk), enter the following command:

   $NCHOME/omnibus/bin/nco_dbinit -desktopserver -dsddualwrite -dsdprimary AGG_V -server DIS_1 -customconfigfile $NCHOME/omnibus/extensions/multitier/objectserver/display.sql

   The desktop ObjectServer DIS_1 is created.

2. On the primary ObjectServer, use the following nco_confpack command to extract the definition of alerts.status from AGG_P:

   $NCHOME/omnibus/bin/nco_confpack -list -server AGG_P -user root | grep alerts.status | $NCHOME/omnibus/bin/nco_confpack -export -user root -package alerts_status.jar

3. Copy alerts_status.jar to nchost02.
4. Start the desktop ObjectServer:

   $NCHOME/omnibus/bin/nco_objserv -name DIS_1 &

5. Import the custom alerts.status columns into DIS_1:

   $NCHOME/omnibus/bin/nco_confpack -import -package alerts_status.jar -from AGG_P -server DIS_1 -user root

6. Use the SQL interactive interface to log into DIS_1:

   $NCHOME/omnibus/bin/nco_sql -user root -server DIS_1

7. Use the SQL interactive interface to verify that the three new columns are at the end of the table definition:

   1> select ColumnName from catalog.columns where DatabaseName = 'alerts' and TableName = 'status' order by OrdinalPosition;
   2> go

The desktop ObjectServer DIS_1 is now configured and running.