If a table is locked and no processes are running, you've got a serious DB2 issue that should be reported to IBM. They'll want to know exactly what happened to get into this state because
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400. Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level. I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence)
A growing number of database queries lend themselves to recursive solutions. It's not always easy to spot when recursion is called for, especially for people una…