Hi All,
I have a query from a user who is asking if we can identify what
fields are causing records in a table to become overflow records. The
table in question has more than 25% of the records which are overflow.
The table structure is as follows

UC_POD_EXT VARCHAR 50
/BIC/UCATFKWH DECIMAL 17
/BIC/UCADKWH DECIMAL 17
/BIC/UCANKWH DECIMAL 17
/BIC/UCMAXKVA DECIMAL 17
UCINSTALLA VARCHAR 10
UCPREMISE VARCHAR 10
/BIC/ARBILLCLA VARCHAR 4
/BIC/UCOPC_MPS CHARACTER 1
/BIC/UCOPK_MIC DECIMAL 17
/BIC/ARSUBNO VARCHAR 9
RECORDMODE CHARACTER 1
/BIC/AROUTLET VARCHAR 2
/BIC/ARAREANO VARCHAR 3
/BIC/UCNUMMPRN INTEGER 4

The tablespace has a pagesize of 16384 bytes. Can anyone tell me if
there is a way to identify why 25% are going into overflow.

Regards,

Jean


* ** *** ** * ** *** ** * ** *** ** *
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed.
Any views or opinions presented are solely those of the author, and do not necessarily represent those of ESB.
If you have received this email in error please notify the sender.

Although ESB scans e-mail and attachments for viruses, it does not guarantee
that either are virus-free and accepts no liability for any damage sustained
as a result of viruses.

* ** *** ** * ** *** ** * ** *** ** *


DB2 & UDB email list listserv db2-l LazyDBA home page