Synchronize and shutdown multiplex query nodes

Start SQL Remote on all nodes in the multiplex, if not already started. These are normally started by Sybase Central when starting servers.

Give the multiplex time to propagate any changes throughout the multiplex. To do this, look at the write server console log file and check that the events starting with 'ev_iqmpx' have successfully executed. Note: the server console log file, by default, is created in $ASDIR/logfiles.

For example:

Now accepting requestsOS Available: 933096K, Working Set: 83988K, Cache Target: 11483K
OS Available: 860680K, Working Set: 83996K, Cache Target: 11483K
Next time for 'ev_iqmpxq2w' is 2008/11/23 22:03:00.000
Next time for 'ev_iqmpxstatus' is 2008/11/23 22:03:00.000
OS Available: 859232K, Working Set: 84112K, Cache Target: 11489K
OS Available: 861052K, Working Set: 84424K, Cache Target: 11489K
OS Available: 860972K, Working Set: 84428K, Cache Target: 11489K
OS Available: 850248K, Working Set: 85540K, Cache Target: 11579K
OS Available: 850104K, Working Set: 85568K, Cache Target: 11579K
Next time for 'ev_iqmpxq2w' is 2008/11/23 22:04:00.000
Next time for 'ev_iqmpxstatus' is 2008/11/23 22:04:00.000
OS Available: 850120K, Working Set: 85600K, Cache Target: 11579K
Next time for 'ev_iqmpxq2w' is 2008/11/23 22:05:00.000
Next time for 'ev_iqmpxstatus' is 2008/11/23 22:05:00.000
OS Available: 852668K, Working Set: 85604K, Cache Target: 11579K

Wait for SQL Remote to scan its log files a few times and view the logs. To view these log files from Sybase Central, right-click the multiplex server and select SQL Remote | View SQL Remote Log.

The console indicates that SQL Remote is hovering at the end of the active log. Wait for the sleeping to stop to give SQL Remote a chance to process any messages. SQL Remote will go back to sleep once it finishes processing. For example:

I. 11/23 22:06:10. Scanning logs starting at offset 0001787252
I. 11/23 22:06:10. Hovering at end of active log

Please shut down SQL Remote and multiplex servers. If you simply shut down the multiplex servers, the SQL Remote servers will hover, then detect that the multiplex servers are no longer running and shut themselves down. By default, the SQL Remote servers should shut themselves down within 60 seconds.

Shut down query servers in the multiplex. They are no longer required.