(Craig S. Mullins) Another pervasive problem permeating the DB2 development community — and indeed for most relational DBMSes — is the “flat file” development mentality. What I mean by this is, when a programmer tries to access data in a relational database the same way that he would access data f
Tag: IBM
Unix command of the day: watch
(Leons Petrazickis) The project I’m working on right now involve not just Dockerized Rails microservices, Meteor JS, and a data set measured in tens of terabytes, but also a big Bash code base.
Developing a plug-in connector for web service endpoints using WebSphere Cast Iron: Part 4: Implementing the DescribeObject orchestration
(Raghvendra Neelekani) This five-part tutorial series shows you how to use the WebSphere Cast Iron Connector Development Kit (CDK) to quickly and easily develop plug-in connectors for web service and ReST based applications. Part 4 shows you how to implement the DescribeObject orchestration for your
A Few Scripting Basics with DB2 and PowerShell
(Ember Crooks) Not long ago, I posted some of the details of using PowerShell as your command line for DB2 on Windows. I am definitely addicted to PowerShell as my command line when I have to work on Windows servers.
Fun with SQL
(Troy L Coleman) In writing about the upcoming IDUG DB2 tech conference last week, I noted that the event includes expanded content for developers. This is no isolated occurrence.
April 2015 ‘Fun with SQL’ third Challenge
(Kurt Struyf) This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
The DB2Night Show #155: All About IDUG & DB2’s GOT TALENT 2015 Winners!
(Scott) 100% of our studio audience learned something! IDUG Volunteers Terry Johnson, Conference Chair, and Steve Rosenberger, Thread Chair, shared with us great information about the upcoming IDUG Conference in Philadelphia!
Understanding IBM Enterprise Records
(Whei-Jen Chen, Serena S Chan, Jean-Marc Costecalde, Yolanda H Yates and Harry Yessayan) Records management helps users address evolving governance mandates to meet regulatory, legal, and fiduciary requirements. Proactive adherence to information retention policies and procedures is a critical facet
SQL Performance Basics: Part 5, Avoid Sorting
(Craig S. Mullins) Sorting is a very costly operation that you should strive to avoid if at all possible. Indexes are very useful for this purpose. DB2 can choose to use an available index to satisfy the sorting requirements of an ORDER BY, GROUP BY, or DISTINCT clause.
WebSphere eXtreme Scale – a better choice than Infinispan
(Cesar Saavedra) There are many commercial and open-source software offerings in the in-memory data grid (IMDG) market nowadays. An IMDG offers many benefits, some of which are:
