DB2

DB2 is IBM's offering to the highend database market. The latest version of DB2 (Universal Database) is ideal for OLTP, Data Warehousing, Decision Support and everything in between. It's well priced, extremely scalable and runs on virtually every platform out there from handhelds to mainframes.

Identify specific rows that have overflowed


Does anyone know how to identify the specfic rows that are overflowed in a DB2 LUW table? My application team wants to know the specific rows to help them figure out in what business situations it is happening (when a VARCHAR column is updated with a larger text string than originally inserted).
Maybe db2dart can do this。
But if your table is large ,that means a lot of work......
When a VARCHAR column is updated such that it no longer fits on the original page, db2 will leave a tombstone record on the original page pointing to an overflow record on the new page. db2dart /dd (possibly some other db2dart options as well) will dump info. Look for something similar to:
Record Type = Pointer Record (tombstoned)
I think DB2 Support can help you interpret db2dart output.
I asked another person this question and here's the reply:
"There isn't really an official way, but you can use the RID() function with the lockname to select the row (or dump the page with dart and read it). Someone wrote a technote on how to do this, or perhaps an article. try a google search, because I think it was actually an article"

Related Links

Creating a new database with the existing database with same structure
load error SQL0302N
load error SQL0302N
Db2 Udb Unix Aix
Dropping and recreating a primary key which has already unique index
Strange installation problem - please help!
DB2 Varchar characters truncated
ZRC=0x805C012D
How to pivot dates into columns?
Task center problem
can i use the list tablespaces command in a procedure
stored proc problem
Forgot db2admin password
Help !!!!
Problem in Installation of DB2 UDB 8.1
DB2 OLE DB Driver

Categories

DataBase Dev
MongoDB
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
Crystal Reports
Delphi, C etc
JAVA
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
Brilliant Database
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
New Members & Introduc...
Applications & Tools
Database Concepts & De...
Chit Chat
Marketplace
Job Opportunities
Suggestions & Feedback

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App