Db2 SQL for the DBA - Using Modern SQL for DBA Tasks 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. ...
Nota del editor: Este artículo fue publicado originalmente en inglés. Con la aprobación del autor, el equipo de IDUG ha creado la traducción que a continuación se presenta. Con las funciones SQL OLAP RANK y DENSE RANK disponibles en programación SQL desde hace un tiempo, resulta bastante...
Advanced Query Tuning with IBM Data Studio by Tony Andrews Do you make any New Year's resolutions? In case you don't have any Db2 related, we have a suggestion for you. What if you start the New Year with improving the performance of your SQL queries? Learn more about the advanced query tuning...
After a discussion with a friend, I came across an interesting article about the modern SQL in PostgreSQL (sorry the article is in czech). What raised my attention was a mention about the Lateral join . I work mostly on Db2 for z/OS and haven't heard the term in this context. What about you? ...
Temporal Support of Db2 for z/OS – Part I Temporal Auditing Enhancements in Db2 12 Continuous Delivery Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Abstract This article series discuss the major Db2 temporal enhancements delivered in Db2 12 for z/OS...
With the SQL OLAP RANK and DENSE RANK functions being around for a while in SQL programming, it is quite easy to query for the TOP XX from data. Take for example the following query that will return the TOP 5 employees out of the EMP table based on the column SALARY. DENSE RANK will be used...
SQL statement for DB2 on Z; identify and create DROP statements for all aliases whose tables (or views) do not currently exist. (Uses Common Table Expression and UNION to create multi-line output)
2 attachments
Leveraging your Db2 Skills with Big Data Jim Wankowski, IBM The Challenge The idea of the traditional data center being centered on relational database technology is quickly evolving. Many new data sources exist today that did not exist as little as 5 years ago. Devices such...
Catalog query identifying several data events for tablespaces, within the past n (31, in the example) days. Results are verbose.
Nota del editor: Este artículo fue publicado originalmente en inglés. Con la aprobación del autor, el equipo de IDUG ha creado la traducción que a continuación se presenta. por: Meg Bernal, Chris Crone, IBM SVL Lab DB2 12 trae una serie de nuevas mejoras relacionadas con SQL y SQL PL....