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
- 1
- 2