(David Adler) This series of tutorials takes you through common tasks that work with spatial data in the DB2 Spatial Extender. These tasks include importing and creating spatial data, constructing and executing spatial queries, working with IBM spatial tools, working with third-party and open source

(Ember Crooks) One of the awesome things about running scripts locally on a DB2 server is that if they’re run as a privileged user, you do not have to specify the password. This makes for easier scripting without storing or encrypting passwords.

(Lockwood Lyon) Distributed applications are just that: distributed across one or more hardware platforms across the enterprise. These environments are usually separate from that of the database server.

(Nick Maynard) The Ionic Framework speeds hybrid application development by providing an aesthetic and easy-to-use development framework. This tutorial will show you how to use the Ionic JavaScript and CSS components with the IBM MobileFirst Platform to create a hybrid application.

(Scott) No doubt, IDUG NA Philadelphia offers a plethora of DB2 education and networking opportunities! It can be hard to decide which sessions to go to, especially if you don’t know the speakers or if you are new to IDUG. This blog contains my technical session picks, plus links to Twitter accounts

(Troy L Coleman) Last week I discussed the factors that cause a package to be marked invalid and go through AUTOREBIND. My recommendation was to always REBIND the package manually once the changes have been implemented.

(Lockwood Lyon) When it’s time to recover multiple databases, every second counts. This is why processes, scripts, and job control language (JCL) for all the various combinations of database recoveries should already exist.

(Somu Chakrabarty) When DB2 BLU columnar architecture was introduced in DB2 10.5 GA, it was not possible to create a columnar table in a database which is the primary database in an actively connected HADR pair. This prevented a true DR solution.

(Dave Beulke) With the all the hacking stories getting a lot of news coverage, security of your DB2 system is paramount. Doing a DB2 SQL security audit periodically or before your DB2 migration has been a standard security best practice of many for countless years and many DB2 Version upgrades.

(Abhik Roy) The previous article, DB2 Workload Manager (WLM) as a Monitoring Solution – Understanding WLM (Part1 of 3), defined what the DB2 Workload Manager is and described the various database objects that make up the DB2 Workload Management ecosystem.