ASE 12.5 for Linux Install 〜Step 13 ASEの起動と終了用スクリプトを作成する〜
ASE 12.5 for Linux Install
〜Step 13 ASEの起動と終了用スクリプトを作成する〜
0.更新履歴
1.はじめに
このドキュメントでは,RedHat Linux 7.2に,Sybase Adaptive Server Enterprisee 12.5 for Linuxをインストールしたあと,起動と終了を簡単に行うためのスクリプトの作成手順を説明する.
2.終了用スクリプトを作成する
bash-2.05$ cd $SYBASE/$SYBASE_ASE
bash-2.05$ pwd
/opt/sybase-12.5/ASE
bash-2.05$ ls
ASE.csh lib poweredge.009 poweredge.018 poweredge.027 poweredge.bak
ASE.sh poweredge.001 poweredge.010 poweredge.019 poweredge.028 poweredge.cfg
bin poweredge.002 poweredge.011 poweredge.020 poweredge.029 poweredge.krg
certificates poweredge.003 poweredge.012 poweredge.021 poweredge.030 sample
debugger poweredge.004 poweredge.013 poweredge.022 poweredge.031 scripts
diag poweredge.005 poweredge.014 poweredge.023 poweredge.032 sybhelp
include poweredge.006 poweredge.015 poweredge.024 poweredge.033 symlib
init poweredge.007 poweredge.016 poweredge.025 poweredge.034 upgrade
install poweredge.008 poweredge.017 poweredge.026 poweredge.035 xappdefaults
bash-2.05$
|
bash-2.05$ cd install
bash-2.05$ ls -la
total 1664
drwxrwxr-x 3 sybase sybase 4096 Sep 22 17:17 .
drwxrwxr-x 16 sybase sybase 4096 Sep 22 17:34 ..
-rwx------ 1 sybase sybase 540 Sep 22 17:15 RUN_poweredge
-rwx------ 1 sybase sybase 485 Sep 22 17:17 RUN_poweredge_back
-rwx------ 1 sybase sybase 530 Sep 22 17:17 RUN_poweredge_mon
drwxrwxr-x 2 sybase sybase 4096 Sep 22 16:41 SPR
-r-xr-xr-x 1 sybase sybase 1647847 Jun 3 2001 auditinit
-r-xr-xr-x 1 sybase sybase 670 Jun 3 2001 showserver
-r-xr-xr-x 1 sybase sybase 17628 Jun 3 2001 startserver
bash-2.05$
|
bash-2.05$ echo shutdown SYB_BACKUP >> shutdown.sql
bash-2.05$ echo go >> shutdown.sql
bash-2.05$ echo shutdown >> shutdown.sql
bash-2.05$ echo go >> shutdown.sql
bash-2.05$
|
bash-2.05$ cat shutdown.sql
shutdown SYB_BACKUP
go
shutdown
go
bash-2.05$
|
bash-2.05$ echo $SYBASE/OCS/bin/isql -Usa -Psybase -Spoweredge -i`pwd`/shutdown.sql >> syb_shutdown.sh
bash-2.05$
|
bash-2.05$ cat syb_shutdown.sh
/opt/sybase-12.5/OCS/bin/isql -Usa -Psybase -Spoweredge -i/opt/sybase-12.5/ASE/install/shutdown.sql
bash-2.05$
|
bash-2.05$ chmod ogu+x syb_shutdown.sh
bash-2.05$
|
bash-2.05$ syb_shutdown.sh
Msg 2401, Level 11, State 2:
Server 'poweredge':
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
Due to previous errors, the language for this session is being forced to
'us_english'.
Backup Server: 3.48.1.1: The Backup Server will go down immediately.
Terminating sessions.
Server SHUTDOWN by request.
The SQL Server is terminating this process.
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminat
ed due to disconnect
bash-2.05$
|
bash-2.05$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
bash-2.05$
|
3.起動用スクリプトを作成する
bash-2.05$ echo `pwd`/startserver -f `pwd`/RUN_poweredge -f `pwd`/RUN_poweredge_back > syb_start.sh
bash-2.05$
|
bash-2.05$ cat syb_start.sh
/opt/sybase-12.5/ASE/install/startserver -f /opt/sybase-12.5/ASE/install/RUN_poweredge -f /opt/sybase
-12.5/ASE/install/RUN_poweredge_back
bash-2.05$
|
bash-2.05$ chmod ogu+x syb_start.sh
bash-2.05$
|
bash-2.05$ syb_start.sh
bash-2.05$ Backup Server/12.5/SWR 9617 GA/P/Linux Intel/Linux 2.2.14-5.0smp i686/main/2127/32-bit/OPT/
Thu May 24 01:34:30 2001
Confidential property of Sybase, Inc.
Copyright 1987, 2001
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.
This software contains confidential and trade secret information of Sybase,
Inc. Use, duplication or disclosure of the software and documentation by
the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and Sybase, Inc. or other written
agreement specifying the Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2002/09/22 18:45:32.44 kernel Warning: There is no valid license for ASE server produc
t. Server is booting with all the option features disabled.
00:00000:00000:2002/09/22 18:45:32.48 kernel Using config area from primary master device.
00:00000:00000:2002/09/22 18:45:32.50 kernel Internal run-time model set for Linux - Native
〜略〜
00:00000:00001:2002/09/22 18:45:34.85 server Database 'sybsystemprocs' is now online.
00:00000:00002:2002/09/22 18:45:34.85 kernel network name poweredge, type ether, port 5000, filter NO
NE
00:00000:00001:2002/09/22 18:45:34.87 server Recovery complete.
00:00000:00001:2002/09/22 18:45:34.87 server SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2002/09/22 18:45:34.87 server SQL Server's default sort order is:
00:00000:00001:2002/09/22 18:45:34.87 server 'bin_sjis' (ID = 50)
00:00000:00001:2002/09/22 18:45:34.87 server on top of default character set:
00:00000:00001:2002/09/22 18:45:34.87 server 'sjis' (ID = 141).
00:00000:00001:2002/09/22 18:45:34.87 server Master device size: 128 megabytes, or 65536 virtual page
s. (A virtual page is 2048 bytes.)
bash-2.05$
|
bash-2.05$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 32073 0.3 3.5 50996 36752 ? S 18:45 0:00 /opt/sybase-12.5/ASE/bin/dataserver -spow
eredge -d/opt/sybase-12.5/database/sysdevice/master.dat -e/opt/sybase-12.5/database/log/sqlserver.log -c
/opt/sybase-12.5/ASE/poweredge.cfg -M/opt/sybase-12.5/ASE
sybase 32075 0.0 0.5 8856 5500 pts/0 S 18:45 0:00 /opt/sybase-12.5/ASE/bin/backupserver -Sp
oweredge_back -e/opt/sybase-12.5/database/log/backup.log -Ljapanese -Jsjis -N25 -C20 -M/opt/sybase-12.5/
ASE/bin/sybmultbuf
bash-2.05$
|