SAP Knowledge Base Article - Preview

2443433 - SAP IQ. Database created with catalog page size 32k but servlog displayed 4k.

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

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.