Informix

 View Only
  • 1.  IDS 11.50: Physical log size specified is too large

    Posted Mon May 18, 2020 10:39 PM
    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


  • 2.  RE: IDS 11.50: Physical log size specified is too large

    IBM Champion
    Posted Mon May 18, 2020 10:55 PM
    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





  • 3.  RE: IDS 11.50: Physical log size specified is too large

    IBM Champion
    Posted Mon May 18, 2020 10:56 PM
    And no to additional chunks

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 4.  RE: IDS 11.50: Physical log size specified is too large

    Posted Mon May 18, 2020 11:06 PM
    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
    ------------------------------



  • 5.  RE: IDS 11.50: Physical log size specified is too large

    Posted Tue May 19, 2020 12:34 AM
    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





  • 6.  RE: IDS 11.50: Physical log size specified is too large

    IBM Champion
    Posted Tue May 19, 2020 07:54 AM
    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


    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.








  • 7.  RE: IDS 11.50: Physical log size specified is too large

    Posted Tue May 19, 2020 09:16 AM
    Thank you Art for the insights.