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.
SAP Knowledge Base Article - Preview