Here's a quick example
using onstat -d or oncheck -pe phylogs, find out the available FREE pages, then multiply by Page Size (2 or 4, depends on platform), use that value for the physical log size.
> oncheck -pe physdbs
DBspace Usage Report: physdbs Owner: informix Created: 04/28/2020
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
6 /u1/chunks/ol_test13/physdbs 2 51200 53 51147
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
physdbs:'informix'.TBLSpace 3 50
FREE 53 51147
Total Used: 53
Total Free: 51147
> onparams -p -d physdbs -s 102294
Do you really want to change the physical log? (y/n)y
> oncheck -pe physdbs
DBspace Usage Report: physdbs Owner: informix Created: 04/28/2020
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
6 /u1/chunks/ol_test13/physdbs 2 51200 51200 0
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
physdbs:'informix'.TBLSpace 3 50
PHYSICAL LOG 53 51147
Total Used: 51200
Total Free: 0
Casey
------------------------------
CASEYTAN
------------------------------
Original Message:
Sent: Mon May 18, 2020 10:38 PM
From: Saradhi Motamarri
Subject: IDS 11.50: Physical log size specified is too large
Hi,
I have created a test instance on IDS 11.50.
Then, I have created a new dbspace phylogs.
And added a raw chunk of 1024 MB to it.
When I execute:
$onparams -p -d phylogs -s 1048552
I am getting the following error:
Physical log size specified is too large.
Are there any specific limits on the size of the physical log?
Associated questions:
If you add more chunks to phylogs dbspace, does Informix use those other chunks?
Thank you in advance.
#Informix