Why do you tidy your room sometimes? How do you know when it’s the time to do it? Do you do it on a weekly basis or when it’s too cluttered? This is how I do it (in the Db2 LUW world).
Meet the DMS storage model, alternative for SMS tablespaces. In case of DMS we allocate a big chunk of contiguous disk space as a container and give the control over it to Db2...
Here is everything you need to know about storage systems in Db2 LUW, System Managed Space in particular.
What if you put your Db2 LUW database under a microscope? What would you see? What’s the smallest identifiable unit, into which the database can be divided? Let's check the anatomy of Db2 LUW.
What would you say if your grandmother asked you what is your job? How would you explain what is "database" and what does "Db2" mean?
