Tag: IBM

Community

A Quick Intro to DB2 SQL Functions

(Craig Mullins) The last post I made to this blog used functions to translate data from one form to another. Functions frequently can be used to overcome issues when you are reading data from your DB2 tables. With that in mind, I thought it might make sense to go over DB2 SQL functions at a basic le

Community

db2pd to monitor bufferpools

(Chris Eaton) One nice feature of db2pd that you can’t easily get from any other monitoring tool is the contents of your bufferpools. You can see bufferpool hit ratios with just snapshots but if the hit ratio is lower then you expect it may be difficult to find out what is in the bufferpool that is

Community

DB2 security: The starting point

(Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong and Yuk-Kuen Henry Chan) When thinking about organizational information security, your mind might jump to the technical details such as firewalls, access control lists, certificates, auditing, cryption, and all those wellknown electronic trappi

Community

Sorting Out a Solution in DB2

(Craig Mullins) Sometimes an application can require different, perhaps even somewhat “odd” data sorting. These needs may cause developers to sit and scratch their head for hours trying to make DB2 do something that seems “unnatural.” But often you can conjure up an answer by properly understanding