(Ember Crooks) I haven’t generally been known for my SQL tips. I can find my way around SQL decently enough, but for years, I didn’t do much of it. I’ve used it more and more as the years have gone by as I have moved out of a stictly physical/system DBA role and into a more mixed role where I […]

(Jack Vamvas) UDF in DB2 . How can I view details on user defined functions?

(Jeff Hoy, Bill O’Donnell, Shane B. Weeden and Chunlong Liang) OAuth 2.0 service provider support was added to the IBM WebSphere Application Server Liberty profile as part of WebSphere Application Server V8.5.0.2. This article provides an overview of OAuth support highlighting architecture, new feat

(Troy Coleman) DB2 10 for z/OS introduced support for reading and writing LOB and/or XML data to files using file reference variables. File reference variables allow large LOB or XML values to be inserted from or selected into files rather than host variables. This saves memory because applications

(Philip) So you want to add compression to your house you need to get a tradesman in to give you an estimate, then carry out the work, DB2 can do all of this. Just like building an extension you need to make sure that you need all the appropriate permissions from the “council” (IBM) in place, you ei

(Vincent Corvinelli and Samir Kapoor) Statistical views provide the necessary sophisticated statistics to the optimizer to more accurately model complex relationships. In this article, you learn through examples how to identify these complex relationships and create statistical views to allow the op

(Jack Vamvas) How can I list the DB2 table columns and unique constraints?

(Kent Milligan) As the utilization of SQL triggers continues to rise, some developers are being challenged by the fact that they must define a separate SQL trigger for each database event they want to associate with a trigger.

(Benjamin Leonhardi, Piotr Pruski and Andre Albuquerque) PureData System for Analytics is IBM’s core warehousing platform. This article explains how to integrate it with InfoSphere BigInsights, IBM’s enterprise-ready Hadoop distribution. We’ll discuss the integration concepts, as well as a primary u

(Jonathan Lidaka and David Nixon) Using responsive web design has become a popular approach for creating a single web site that optimizes content and layout automatically by relying on the use of CSS media queries. This article discusses how to leverage the device class mechanism in WebSphere Portal