DB2 Archive

Purging lots of data in UDB

Problem: Need to delete 2-3 million rows from a table in UDB. Attempting to use one statement causes table locks and heavy log usage.

UDB Escape Characters

select oprid, oprdefndesc from psoprdefn where oprid like '%\_%' {escape '\'} and acctlock = 0

Recommendations for Dbflags parameter for DB2

Document 758657.1. We are currently one of the many environments that utilize UDB DB2 environment as our back-end. While browsing MOS I discovered this article about App. Server DBFlag Settings. I hope you find

Task Manager, System Monitor – best thing for DB2

One of my colleagues have introduced me to this utility and we had our DBAs install it on the system, and voila – you can see DB2 in works: it’s running snapshots online, you

DB2 Escape characters in queries

Recently I had to use escape characters in DB2 queries and after looking through documentation here is a simple way to do this. You can define you escape character using {escape '\'}   right