Search

1 to 10 of 64
Sort by

Blog Entry
Db2 SQL for the DBA

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. ...

Brian Laube's profile image

Blog Entry
Usar los percentiles con SQL

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...

Tony Andrews's profile image

Blog Entry
Advanced Query Tuning with IBM Data Studio

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...

Tony Andrews's profile image

Blog Entry
Lateral join

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? ...

Emil Kotrc's profile image


Blog Entry
SQL Percentiles

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...

Tony Andrews's profile image

Library Entry
FIND ALIASES WITHOUT EXISTING TABLES

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


Blog Entry
Leveraging your Db2 Skills with Big Data

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...

Jim Wankowski's profile image

Library Entry
SQL: Recent Util History for Tablespaces, including lack of backup

Catalog query identifying several data events for tablespaces, within the past n (31, in the example) days. Results are verbose.


Blog Entry
DB2 12 para z/OS: Dos mejoras SQL altamente requeridas

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....

Chris Crone's profile image