ASE 11.9.2 Install for RedHatLinux6.2 〜その9 sybaseのシャットダウンと終了〜
ASE 11.9.2 Install for RedHatLinux6.2
〜その9 sybaseのシャットダウンと終了〜
0.更新履歴
1.はじめに
このドキュメントでは,Linux版のSybase ASE11.9.2開発版をインストールする手順を説明する.
2.ASEのシャットダウン
bash$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 872 0.0 0.1 1648 752 pts/0 S 18:06 0:00 sh -c /
opt/sybase-11.9.2/bin/backupserver -Spoweredge_back -e/opt/sybase-11.9
.2/database/log/backup.log -N25 -C20 > /dev/null 2>&1
sybase 873 0.0 0.7 7376 4608 pts/0 S 18:06 0:00 /opt/sy
base-11.9.2/bin/backupserver -Spoweredge_back -e/opt/sybase-11.9.2/dat
abase/log/backup.log -N25 -C20
sybase 880 0.0 0.1 1648 752 pts/0 S 18:11 0:00 sh -c /
opt/sybase-11.9.2/bin/dataserver -spoweredge -d/opt/sybase-11.9.2/data
base/sysdevice/master.dat -e/opt/sybase-11.9.2/database/log/sqlserver.
log -M/opt/sybase-11.9.2 > /dev/null 2>&1
sybase 881 2.0 2.6 30500 17236 ? S 18:11 1:26 /opt/sy
base-11.9.2/bin/dataserver -spoweredge -d/opt/sybase-11.9.2/database/s
ysdevice/master.dat -e/opt/sybase-11.9.2/database/log/sqlserver.log -M
/opt/sybase-11.9.2
bash$
|
bash$ isql -Usa -P -Spoweredge
Msg 2401, Level 11, State 2:
Line 1:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
1> shutdown SYB_BACKUP
2> go
Backup Server: 3.48.1.1: The Backup Server will go down immediately.
Terminating sessions.
1> shutdown
2> go
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 op
eration terminated due to disconnect
CT-LIBRARY error:
ct_cancel(): network packet layer: internal net library error: Net-Lib protoco
l driver call to read data failed
bash$
|
- showserverコマンドで,落ちたかどうか確認する.
bash$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
bash$
|
3.ASEの起動
bash$ pwd
/opt/sybase-11.9.2
bash$ cd $SYBASE/install
bash$ ls -la
total 1140
drwxrwxr-x 3 sybase sybase 4096 Apr 15 18:06 .
drwxrwxr-x 20 sybase sybase 4096 Apr 15 19:28 ..
-rwx------ 1 sybase sybase 416 Apr 15 17:52 RUN_poweredge
-rwx------ 1 sybase sybase 318 Apr 15 18:06 RUN_poweredge_back
drwxrwxr-x 2 sybase sybase 4096 Apr 15 17:38 SPR
-r-xr-xr-x 1 sybase sybase 1112392 Jun 8 1999 auditinit
-r-xr-xr-x 1 sybase sybase 471 Jun 17 1999 cshrc
-r-xr-xr-x 1 sybase sybase 1867 Jun 18 1999 profile
-r-xr-xr-x 1 sybase sybase 1436 Jun 15 1999 rc.sybase
-r-xr-xr-x 1 sybase sybase 674 Jul 13 1999 showserver
-r-xr-xr-x 1 sybase sybase 7989 Jul 13 1999 startserver
-r-xr-xr-x 1 sybase sybase 2405 Jun 17 1999 sybinstall.sh
bash$
|
bash$ ./startserver -f ./RUN_poweredge -f ./RUN_poweredge_back
〜略〜
00:00000:00001:2002/04/15 19:48:19.99 server Database 'sybsystemprocs' is now online.
00:00000:00001:2002/04/15 19:48:20.02 server Recovery complete.
00:00000:00001:2002/04/15 19:48:20.02 server SQL Server's default sort order is:
00:00000:00001:2002/04/15 19:48:20.02 server 'bin_sjis' (ID = 50)
00:00000:00001:2002/04/15 19:48:20.02 server on top of default character set:
00:00000:00001:2002/04/15 19:48:20.02 server 'sjis' (ID = 141).
00:00000:00001:2002/04/15 19:48:20.02 server Loaded default Unilib conversion handle.
bash$
|
- showserverコマンドを使って,起動しているか確認する.
bash$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 946 0.2 1.8 30500 12024 ? S 19:48 0:00 /opt/sybase-11.9.2/bin/dat
aserver -spoweredge -d/opt/sybase-11.9.2/database/sysdevice/master.dat -e/opt/sybase-11.9.
2/database/log/sqlserver.log -M/opt/sybase-11.9.2
sybase 947 0.0 0.6 7340 4480 pts/0 S 19:48 0:00 /opt/sybase-11.9.2/bin/back
upserver -Spoweredge_back -e/opt/sybase-11.9.2/database/log/backup.log -N25 -C20
bash$
|