Cannot Create Queue On AIX System Larger Then 400 Mb (Doc ID 956160.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Tuxedo - Version: 10.0 to 10.0
Information in this document applies to any platform.

Goal

You are unable to create a queue on AIX system larger then 400 MB using the script below:

echo
crdl <CONFIG_DIR><SLASH>QUE 0 4100000
qspacecreate
QSPACE
<QUE_IPC>
4000000
40
2000
2000
500000
errque
y
16
q

The error message is:

Q_CAT:1352: ERROR: Create queue space - failed to write block 262129 of table

QSPACE.00 on ../../test5/abc/QUE
Q_CAT:1295: ERROR: Queue space creation failed

You also noticed that the script that creates a 2 GB queue file in Windows environment creates 16 GB queue on AIX environment.

Why is the same script creating two different values for the queue?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms