SybaseIQ裸設(shè)備創(chuàng)建數(shù)據(jù)庫(kù)

1、Sybase IQ 裸設(shè)備創(chuàng)建數(shù)據(jù)庫(kù)一、 創(chuàng)建裸設(shè)備1) 創(chuàng)建物理卷linux-ks8u:/dev # pvcreate /dev/sdc Physical volume "/dev/sdc" successfully createdlinux-ks8u:/dev # pvs PV VG Fmt Attr PSize PFree /dev/sdc lvm2 - 10.00G 10.00G2) 創(chuàng)建卷組linux-ks8u:/dev # vgcreate racvg /dev/sdc Volume group "racvg" successfully cr

2、eatedlinux-ks8u:/dev # vgs VG #PV #LV #SN Attr VSize VFree racvg 1 0 0 wz-n- 10.00G 10.00G3) 創(chuàng)建邏輯卷（裸設(shè)備）linux-ks8u: # lvcreate -n lv01 -L 7.99G racvg Rounding up size to full physical extent 7.99 GB Logical volume "lv01" createdlinux-ks8u: # lvcreate -n lv02 -L 1.99G racvg Rounding up size

3、to full physical extent 1.99 GB Logical volume "lv02" created linux-ks8u: # lvs LV VG Attr LSize Origin Snap% Move Log Copy% lv01 racvg -wi-a- 7.99G lv02 racvg -wi-a- 1.99G4) 掃描LVM和激活卷組linux-ks8u: # vgscan Reading all physical volumes. This may take a while. Found volume group "racvg&

4、quot; using metadata type lvm2linux-ks8u: # vgchange -ay 2 logical volume(s) in volume group "racvg" now active5) 編輯/etc/raw，創(chuàng)建裸設(shè)備linux-ks8u: # vi /etc/raw# /etc/raw# sample configuration to bind raw devices# to block devices# The format of this file is:# raw<N>:<blockdev># exa

5、mple:# -# raw1:hdb1# this means: bind /dev/raw/raw1 to /dev/hdb1# .raw1:mapper/racvg-lv01raw2:mapper/racvg-lv026) 啟動(dòng)raw服務(wù)linux-ks8u: # chkconfig raw on7) 執(zhí)行綁定linux-ks8u: # service raw startbind /dev/raw/raw1 to /dev/mapper/racvg-lv01. donebind /dev/raw/raw2 to /dev/mapper/racvg-lv02. done8) 查詢綁定關(guān)系li

6、nux-ks8u: # raw -qa/dev/raw/raw1: bound to major 253, minor 2/dev/raw/raw2: bound to major 253, minor 39) 修改權(quán)限linux-ks8u:/dev/mapper # chown -R sybiq:sybase racvg-lv01linux-ks8u:/dev/mapper # chown -R sybiq:sybase racvg-lv02linux-ks8u:/dev/raw # chown -R sybiq:Sybase raw1linux-ks8u:/dev/raw # chown

7、-R sybiq:Sybase raw2注意：Sybase IQ 在Suse Linux 10裸設(shè)備上創(chuàng)建數(shù)據(jù)庫(kù)的時(shí)候存在一個(gè)BUG。描述：Suse Linux 10把rawctl文件從/dev目錄移動(dòng)到/dev/raw目錄，導(dǎo)致IQ往raw partition上進(jìn)行寫操作的時(shí)候，由于在/dev目錄下找不到rawctl文件就會(huì)創(chuàng)建失敗。解決辦法：在/dev目錄下使用link命令建立到/dev/raw/rawctl/的soft link。命令如下： linux-ks8u:/dev # ln s /dev/raw/rawctl /dev/rawctl linux-ks8u:/dev # chown

8、 R sybiq:sybase /dev/rawctl10) 解決系統(tǒng)重啟后權(quán)限自動(dòng)還原的問(wèn)題問(wèn)題描述：裸設(shè)備權(quán)限修改之后，每次系統(tǒng)重新啟動(dòng)后又還原成原來(lái)的權(quán)限。解決辦法：編輯/etc/init.d/raw文件，將上面修改權(quán)限和創(chuàng)建soft link的命令添加到文檔結(jié)束前的倒數(shù)第二行。二、 創(chuàng)建數(shù)據(jù)庫(kù)1) 啟動(dòng)demo數(shù)據(jù)庫(kù)sybiqlinux-ks8u:/ASIQ-12_7/demo> start_asiq asiqdemo.cfg asiqdemo.dbsybiqlinux-ks8u:/ASIQ-12_7/demo>isql UDBA PSQL Sasiqdemo2) 創(chuàng)建cc

9、ibiq庫(kù)腳本>create database /home/sybiq/ccibiqdb/ccibiq.db>iq path /dev/raw/raw1>temporary path /dev/raw/raw2>log on /home/sybiq/ccibiqdb/ccibiq.log>iq size 1024>temporary size 256 -單位為M>iq page size 131072 -單位為M>collation 936ZHO -單位為2014，該值128k>go3) 啟動(dòng)創(chuàng)建的ccibiq庫(kù)sybiqlinux-ks8u:/ccibiqdb> start_asiq ccibiq.cfg ccibiq.db Jcp9364) 創(chuàng)建用戶和授權(quán)sybiqlinux-ks8u:/ccibiqdb> isql UDBA PSQL SCCIB_SERV Jcp936>sp_iqaddlogin ccib,ccib123>go>grant DBA to ccib>go5