(Joe Pluta) If you know me, you know I love Common Table Expressions (or CTEs). In today’s article, we’re going to take advantage of CTEs and aggregate functions to learn how to find data that matches group conditions.

(Megha Kuchhal) This article describes how to quickly build and deploy JSR-compliant portlets in the cloud. My team developed tooling to build and test portlets using the IBM Portlet Container Tools for WebSphere® Application Server Liberty Profile.

(Willie Favero) Testing for RSU service package RSU1410 is now complete.

(Ramazan Polat) Truncating a table means deleting all rows and not logging the operation.

(Markus Winand) I’ve just completed IBM DB2 for Linux, Unix and Windows (LUW) coverage here on Use The Index, Luke as preparation for an upcoming training I’m giving.

(John Maenpaa) This month, we’re going to talk about security. Maintaining good security in our applications is extremely important. If you’ve read any of the recent reports of credit card theft, identify theft, or just plain data theft, then you have a glimmer of why it is so important.

(Jeff Berger and Lee LaFrese) The tight integration that IBM DB2 for z/OS has with the IBM System z architecture and the z/OS environment creates a synergy that allows DB2 to use advanced z/OS platform functions.

DBI Software has introduced pureFeat V6.1 Performance Management Suite for IBM DB2 LUW which adds two key new capabilities for Stored Procedure Visibility and insight into Current Activity Functions.

(Dan Burger) If you’ve seen IBM’s Redbook on modernization for i-centric customers, it’s clear the direction Big Blue recommends includes the DB2 for i database as an integral part of the modernization process. In application-first environments, which dominate in IBM i shops, database modernization

(Katherine J. Lamendola and Jeffrey T. Klier) This article shows you how to use IBM Endpoint Manager to deploy and configure IBM Tivoli Storage Manager backup agents on virtual machines that are running in an IBM PureApplication System cloud. Distributing backup agents to virtual machines is essenti