Hi Ondrej.Zizka,
**NO, **only have set DB2_COMPATIBILITY_VECTOR=ORA in our development environment.
Do you think this can help us ?? If so, how ??
We have two possibles options in mind:
1.- Alter table to PCTFREE
2.- Rebuilding table and change VARCHAR by CHAR
3.- Rebuild table very frequent is no possible because the applications is OLTP 7x24
The table suffers 450,000 Updates by day
PCTFREE = -1
**LOCKSIZE= **Row
Rows: 1072
The table length is: 700 bytes
The AVGROWSIZE is: 332
The tablespace of the table is 32K
==> OVERFLOW
SCHEMA TABLE_NAME PAGES OVERFLOWS
SW_APP ATMDEVICESTATE 12 1,827,658
What value of PCTFREE do you recommend ???