As the size of database and the volume of transactions increase, many of Db2 transactions tend to spend significant amount of wait time in database read and log write I/Os.
zHyperLink is introduced to help reduce b2 transaction latency.
Db2 11.5 is here and with it comes a bunch of new features and changed behaviors in the area of Availability & Recovery that should make your every day tasks easier. Check out the list that includes items like Advanced Log Space Management, Reduced Logging and better HADR Reads on Standby.
Thinking about your availability and recovery strategy shouldn't give you sleepless nights. Db2 understands the importance of keeping your database online 24x7 and with Db2 11.1 / 11.5 and its continuous delivery of new features and enhancements, you are on the right path of achieving such goals.
Este artículo provee conocimiento necesario y ofrece la base y al mismo tiempo el aspecto más importante sobre optimización de queries, es decir, estimar cardinalidad, o bien, estimar el número de registros que fluyen a través de las varias operaciones de la ejecución del plan de un query.
Diving a bit deeper into examples where an application design that used to be efficient can become overly expensive.