[ ESO ]  

Sybase Survival Guide in La Silla



 
          Is there anything wrong with the Sybase SQL Server? 
          • Login on wg5arc with the sybase account  password sybaze .
          • Check that the SQL Server OLASLS is up and running by executing the shell script: /opt/sybase/install/check_OLASLS
          • If the server is not available then look at the bottom of the error log to find out what happened. 
              • tail -100 /opt/sybase/install /OLASLS.log
          • If the server is available, start db-monitor:
                • db-monitor
            which should generate an output like this:
            DB Monitor -- type CTRL-C to poll, CTRL-\ to quit

            DB Monitor on SYBASE Fri Jul 17 12:59:52 1998 

            spid ? who(from):database what phys_io mem blk 

            ---- - ------------------------------ -------------------- -------- --- --- 

            7 R LSRS1rssd_prim(wg5arc):LSRS1rs awaiting command 0 1 

            15 R LSRS1rssd_prim(ac0):LSRS1rssd awaiting command 0 1 

            10 R sa(ac0):master awaiting command 209 1 

            1 R p2pp(wg5ops):obrep awaiting command 1 1 

            Load: 2.4

          • In case db-monitor does not manage to connect to the server then stop and then start all related sybase processes up again.
            • /opt/sybase/install /stop
              /opt/sybase/install/start
          • If the server cannot be killed as previosly advised, then perform the following: # kill -15 "process_id"
      FYI: The most important server that must be running is OLASLS which is the SQL Server and holds the databases.
      Brief description of the other processes:
      OLASLS_BACKUP is the Backup Server to perform dumps and loads.
      OLASLS_LSRS1rssd_ltm is the log transfer manager used for replication server.
      LSRS1 is the actual replication server.

Send comments to <famores@eso.org>
Last update: July 17, 1998 
[Observing Facilities and Operations][ESO][Index]See my CV[Help][News]