Symptom
Create database with catalog page size 32k, but srvlog displayed warning below
Performance warning: Database "myiqdb" has a page size of 4096 that does not match maximum of 32768 set for server, causing inefficient use of cache
Create database command:
CREATE DATABASE '/opt/sybase/db/myiqdb.db'
TRANSACTION LOG ON 'imyiqdb.log'
MIRROR 'myiqdb.mlg'
CASE RESPECT
PAGE SIZE 32768
JAVA ON
JCONNECT ON
IQ PATH '/dev/raw/raw1'
IQ PAGE SIZE 262144
IQ RESERVE 20000
TEMPORARY PATH '/dev/raw/raw2'
TEMPORARY RESERVE 2000
Server is started with parameter -gp 32768
Read more...
Product
Keywords
Sybase, dbisql, interactive sql, nogui, no-gui, multiline, , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.