B
bremmeyr
Guest
Thanks to all for your input. Tom No clob, no blob Good point that the objects need to be moved. Steve: About SQL, what if they use any ODBC connection for any SQL client? I know they use ODBC connections. Rob: Yes the schema area contained objects. They were moved, perhaps months ago. That could account for the current size. Yet with example customer B the area has grown after the objects have moved. Example database.d1 file sizes: Customer A, 300 MB; block size 4096, area hiwater 69,336; area total blocks 75,022 Customer B, 1.38 GB; block size 4096, area hiwater 362,991; area total block size 491,005 From DBanalysis 362991 block(s) found in the area. Current high water mark: 362991 361921 free block(s) found in the area 753 record block(s) found in the area 314 index block(s) found in the area 0 empty block(s) found in the area 1 object block(s) found in the area Customer C, 69 MB; block size 4096, area hiwater 17,382; area total block size 17,391
Continue reading...
Continue reading...