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 for Me (Login required).

Search for additional results

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