Error 'log files cannot be created on dbspaces of big page' adding logical logs to another dbspace. The dbspace must be created with the default page size the same as the root dbspace

Technote (troubleshooting)


Problem(Abstract)

When creating logical logs starting in V10 of Informix Dynamic Server in another dbspace, The dbspace must be created with the default page size which is the same as the root dbspace they cannot be created in big page size if the default page size is 2K, then they cannot be created in a 4K, 8K, 16K dbspace. On windows/AIX the default is 4K so therefore it will fail on 8K, 16K page sizes..

Resolving the problem

Example

Solaris

IBM Informix Dynamic Server Version 10.00.UC3 -- On-Line -- Up 00:10:57 -- 29696 Kbytes

Dbspaces
address number flags fchunk nchunks pgsize flags owner name
a5227e0 1 0x60001 1 1 2048 N B informix rootdbs
ae55c18 2 0x60001 2 2 4096 N B informix dbs1
b2cc1f8 3 0x60001 3 2 8192 N B informix dbs2
b3181f8 4 0x42001 4 1 2048 N TB informix tmpdbs
b32a1f8 5 0x60001 5 1 2048 N B informix logdbs
b33c518 6 0x68001 8 1 2048 N SB informix sbspace

Default page size for rootdbs is 2048.

command to create logdbs with default page size

onspaces -c -d logdbs -p path -o 0 -s size

Take server down to quiescent mode
onmode -s

Error

$ onparams -a -d dbs1 -s 1000
log files cannot be created on dbspaces of big page

$ onparams -a -d dbs2 -s 1000
log files cannot be created on dbspaces of big page

Success
$onparams -a -d logdbs -s 1000
Logical log successfully added.

Example

AIX

IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:02:53 -- 54368 Kbytes

Dbspaces
address number flags fchunk nchunks pgsize flags owner name
401247e0 1 0x60001 1 1 4096 N B informix rootdbs
50097148 2 0x60001 2 1 8192 N B informix dbs1
502d51f8 3 0x60001 3 1 16384 N B informix dbs2
5032a1f8 4 0x60001 4 1 4096 N B informix logdbs
4 active, 2047 maximum

Default page size for rootdbs is 4096

Take server down to quiescent mode
onmode -s

Error

$onparams -a -d dbs1 -s 1000
log files cannot be created on dbspaces of big page

$onparams -a -d dbs2 -s 1000
log files cannot be created on dbspaces of big page

Success

$onparams -a -d logdbs -s 1000
Logical log successfully added.


Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Servers

Software version:

9.4, 10.0, 11.1, 11.5, 11.7, 11.70, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Software edition:

Enterprise, Growth, Ultimate

Reference #:

1211202

Modified date:

2013-08-10

Translate my page

Machine Translation

Content navigation