Below is a collection of code snippets and details related to a Sybase IQ server build. In the below example, the server/database is called HELENA.
##-------------------------------------------------------------##
## Create DB and rename the IQ Server
##-------------------------------------------------------------##
pwd
start_asiq -n util @util.cfg
echo "Start Create DB: " `date`
dbisqlc -q -c "uid=DBA;pwd=SQL;dbn=utility_db;eng=util;links=tcpip" ./admin/sql/create_db_HELENA.sql
echo "Create DB Completed: " `date`
dblog -t ./HELENA.log HELENA.db
# -- 12.X syntax - contents of create_db_HELENA.sql
CREATE DATABASE './HELENA.db'
TRANSACTION LOG ON './HELENA.log'
BLANK PADDING ON
-- CASE IGNORE
IQ PATH './Main/main001'
TEMPORARY PATH './Temp/temp001'
IQ PAGE SIZE 262144
BLOCK SIZE 16384
MESSAGE PATH 'HELENA.iqmsg';
# -- 15.X .. use iqinit .. # Note: no dev sizes, for raw devices
./iqinit -iqpath './Main/main001' -iqpgsize 262144 -iqblksize 16384 -p 4096 -iqsize 200G -iqtmppath './Temp/temp001' -iqtmpsize 50G -dba iqadmin,dragonfly './HELENA.db'
# -- Adding DB Spaces (Raw devices are used here)
CREATE DBSPACE main002 AS './Main/main002' IQ STORE
go
CREATE DBSPACE main003 AS './Main/main003' IQ STORE
go
CREATE DBSPACE main004 AS './Main/main004' IQ STORE
go
CREATE DBSPACE main005 AS './Main/main005' IQ STORE
go
CREATE DBSPACE main006 AS './Main/main006' IQ STORE
go
CREATE DBSPACE main007 AS './Main/main007' IQ STORE
go
CREATE DBSPACE main008 AS './Main/main008' IQ STORE
go
CREATE DBSPACE TEMP02 AS './Temp/temp002' IQ TEMPORARY STORE
go
CREATE DBSPACE TEMP03 AS './Temp/temp003' IQ TEMPORARY STORE
go
CREATE DBSPACE TEMP04 AS './Temp/temp004' IQ TEMPORARY STORE
go
CREATE DBSPACE TEMP05 AS './Temp/temp005' IQ TEMPORARY STORE
go
CREATE DBSPACE TEMP06 AS './Temp/temp006' IQ TEMPORARY STORE
go
CREATE DBSPACE TEMP07 AS './Temp/temp007' IQ TEMPORARY STORE
go
CREATE DBSPACE TEMP08 AS './Temp/temp008' IQ TEMPORARY STORE
go
What are typical page size / block size settings, for Sybase IQ?
catalog page size ........... 4 k
iq page size ................ 128 k
block size .................. 8 k
To view these settings later, run sp_iqstatus from dbisql.
|
|
