En este artículo, Daniel nos describe a mayor detalle algunos de los parámetros y conceptos que normalmente son ignorados al momento de crear tablespaces en Db2 para z/OS y por qué deberíamos de tomarlos en cuenta.
”. Overthinking and trying to predict Db2 performance is a slippery slope, and so rather than “thinking” about Db2 performance why not have the database tell you how it will perform. The key to this is the Db2 accounting trace, and subsequent Db2 accounting reports. The accounting reports are useful
From existing concepts that we were scared to test ourselves, to new technology that is finding its place into our daily jobs, we have you covered so you'll be able to learn about the Db2 in a consistent and smarter way. Check out our monthly content and stay tuned to our Premium Content updates.
Playing with cardinality and selectivity on predicates is not a common trick, though Joe Geller, David Simpson and Tony Andrews demystify it so that you can start playing with its intricacies and give a boost to the Optimizer.
Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.