UDB 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