ASE 11.9.2 Install for RedHatLinux6.2
〜その10 tempdbを拡張する〜
０．更新履歴
- 2002.04.15 新規作成
１．はじめに
このドキュメントでは，Linux版のSybase ASE11.9.2開発版をインストールする手順を説明する．
２．現在のtempdbの大きさを確認する．
- isqlでASEに接続する．
bash$ isql -Usa -P -Spoweredge
Msg 2401, Level 11, State 2:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
1> sp_helpdb tempdb
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
-----------------------------------------------------------------------
tempdb 2.0 MB sa 2
Apr 15, 2002
select into/bulkcopy/pllsort
(1 row affected)
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
master 2.0 MB data and log 1056
(return status = 0)
1> quit
bash$
|
- 2MBだと，あまりにも少ないので，次のようなスクリプトを作成する．
bash$ cat tempdb.sql print 'Create tempdb_dat01 512MB' declare @vdevno int select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1 from master.dbo.sysdevices d, master.dbo.spt_values v where v.type = 'E' and v.number = 3 disk init name='tempdb_dat01', physname='/opt/sybase-11.9.2/database/tmpdevice/tempdb_dat01.dat', vdevno = @vdevno , size=262144 go print 'Create tempdb_dat02 512MB' declare @vdevno int select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1 from master.dbo.sysdevices d, master.dbo.spt_values v where v.type = 'E' and v.number = 3 disk init name='tempdb_dat02', physname='/opt/sybase-11.9.2/database/tmpdevice/tempdb_dat02.dat', vdevno = @vdevno , size=262144 go alter database tempdb on tempdb_dat01 = 512, tempdb_dat02 = 512 go bash$ |
- isqlでそのDDLを実行する．
bash$ isql -Usa -P -Spoweredge -itempdb.sql -o/opt/sybase-11.9.2/database/log/CreateTempdb.log bash$ |
- ログファイルを確認してみる．
bash$ cat /opt/sybase-11.9.2/database/log/CreateTempdb.log 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. Create tempdb_dat01 512MB (1 row affected) Create tempdb_dat02 512MB (1 row affected) Extending database by 262144 pages on disk tempdb_dat01 Extending database by 262144 pages on disk tempdb_dat02 bash$ |
- isqlで接続して，tempdbのサイズを確認してみる．
bash$ isql -Usa -P -Spoweredge
Msg 2401, Level 11, State 2:
Line 2:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
1> sp_helpdb tempdb
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------
tempdb 1026.0 MB sa 2
Apr 15, 2002
select into/bulkcopy/pllsort
(1 row affected)
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
master 2.0 MB data and log 1040
tempdb_dat01 512.0 MB data and log 524288
tempdb_dat02 512.0 MB data and log 524272
(return status = 0)
1>
|
- 拡張できた事が確認できる．
