Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Autolocate

  • 1.  Autolocate

    Posted Fri September 18, 2020 01:28 PM
    I have written a deep-dive blog post, which you may be interested in reading, on the relatively new AUTOLOCATE feature. It is a lot more far-reaching than it seems from just reading the manual. (With thanks to HCL Support for initially pointing out its use.)
    https://informixdba.wordpress.com/2020/09/18/autolocate/

    ------------------------------
    Benjamin Thompson
    ------------------------------


  • 2.  RE: Autolocate

    Posted Fri September 18, 2020 02:04 PM

    Very useful  - productive use of Plague Lockdown J

     






  • 3.  RE: Autolocate

    Posted Sat September 19, 2020 09:39 AM
    Thank you for sharing the great article.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 4.  RE: Autolocate

    Posted Mon September 21, 2020 02:09 AM
    Very interesting! What about index placement? Is the same logic applied to this? We tend to put indexes in dbspases with 16KB pages

    ------------------------------
    Øyvind Gjerstad
    Developer/Architect
    PostNord AS
    ------------------------------



  • 5.  RE: Autolocate

    Posted Mon September 21, 2020 04:58 AM
    It is a good question and I haven't looked into it yet. 16 kB for all indices would not be a bad strategy, if that is what it does.

    ------------------------------
    Benjamin Thompson
    ------------------------------