IDUG Content Committee

 View Only

Latest Discussion Posts

Please login to see all eligible discussion postings

Either the content you're seeking doesn't exist or it requires proper authentication before viewing.

Latest Shared Files

Log in to see this information

Either the content you're seeking doesn't exist or it requires proper authentication before viewing.

Community Blogs

  • Written By: Mark Gillis . Posted By: Tony Andrews New, Final and Old tables are features that have been around in Db2 for several versions, at least back to v9.7, but they don’t seem to get a lot of use. I’m not sure why unless it’s just because ...

    1 person recommends this.
  • Case Study #1: The Query: SELECT ... FROM T1 JOIN T2 ON T1.C1 = T2.C1 AND T1.C2 = T2.C2 WHERE T1.C4 = ‘Something’ AND T1.C6 > 27 The Environment: The only available interesting index on T2 is a single column index on C1. Table T2 ...

    1 person recommends this.
  • Written By: Joe Geller Posted By: Tony Andrews SQL Pagination – New Syntax Problem Statement One of the oldest problems in Db2 performance was the efficient processing of pagination. Pagination is a programming paradigm in which an online ...

  • Posted By Tony Andrews: Written By Tony Andrews: With every Db2 version since V8, there has been great improvements in Db2 for z/OS. Many of the improvements affect developers specifically, especially in the SQL programming language and optimization. ...

    3 people recommend this.
  • September 2022 has a content committee primary focus on indexes . Indexes are those critical Db2 objects that define uniqueness and/or importantly help us quickly find our data. There have been some great IDUG blogs via the content committee ...

    1 person recommends this.