DB2 Internals: Simple Query Processing

You may also like...

15 Responses

  1. Raul Baron says:

    Thank you very much for sharing, Ember. Best regards from Spain.

  2. Chris Aldrich says:

    Like it! It might also not be a bad idea to list which registry, DBM, and DB CFG parms may affect differing processes or points. Again, not necessarily going into detail, but just pointing it out may help others to make the connection between them.

  3. Peter Schuetze says:

    Best blog I have seen so far on how to get data. I like the visuals as well.

  4. Suvradeep Sensarma says:

    Once again great to see a very lucid and crisp write up from you. We usually don’t find these kind of materials in IBM websites.Your article is equally good as of Matt Huras’s DB2 internals presented in IDUG.
    However, i always have a doubt regarding the prefetching part. How DB2 predicts which page is needed? Isnt it more difficult in case of an OLTP environment where the page access is very random? Can you please shed some light on it?

    • Ember Crooks says:

      It’s true that prefetching cannot help us with the singleton row query. However, there’s much more going on in most e-commerce/OLTP databases that either sequential or list prefetching can help with. I’ll put a blog entry about prefetching high on my to-write list.

  5. Koteswararao says:

    Its very simple and very nice . I am expecting this kind of blogs more.

  6. Shubhrojyoti De says:

    Nice blog. Thank you.

  7. kidug says:

    Hi Ember, Will you please kindly share your blogs in https://www.facebook.com/groups/kidug/ . This will help many people who loves DB2 for sure. Thanks in advance.
    Regards,KIDUG

  8. JF Renard says:

    Your blog is really fantastic! The best I ever saw! You use a powerfull teaching method to make us understand how db2 is working and how we can extract the best from it.
    Thank you so much.
    And about this type of blog entry, let’s go! 🙂

  9. WW_DB2 says:

    Really enjoyed reading your blog, you explain everything very clearly. Loved the graphs too. Can’t wait for your next blog!

  10. Kovthe says:

    Thanks for this blog. Do you have something similar for DML statements, which also tells the statement workflow, and also what happens in case of database crash.

  11. Balaji says:

    Great work, Ember.

    The way you have written about each topic, particularly the one above has more than enough details, with a good flow and explanatory pictures, takes us into a db2 world.
    Enjoyed learning and looking forward to more articles.

    Thanks & Regards.

  12. Chris says:

    Looking forward to this series!

Leave a Reply

Your email address will not be published. Required fields are marked *