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 1048552I 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

Don't forget the chunk header size so a 1024000 will take not a 1024000 physlog Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC

And no to additional chunks Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC

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 physdbsDBspace 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 102294Do you really want to change the physical log? (y/n)y > oncheck -pe physdbsDBspace 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 ------------------------------

Hi Casey and Paul, Thank you. It works now, after adjusting the size to free pages. With the best regards and thanks, Saradhi Motamarri +61430022130 Sent from Yahoo Mail for iPhone

Saradhi: The physical log must be a contiguous single extent log, so it can only have a single chunk. If you need a larger physical log, then you will have to create a new dbspace that is larger out of a single device or file then use onparams to move the physical log to the new space then drop the old one. In v12.10 they added a new dbspace type, created with onspaces -c -P, for the physical log that is extendable (if it is created in a cooked file) so that you can grow the single chunk in place if needed. Unfortunately in v11.xx you have to move it to a new larger chunk instead. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Thank you Art for the insights.