K
Kai Lahtinen
Guest
Hi! One of our customers have a a following problem . One big table "printouts" is placed alone on a type II area. The area is in one variable size file, that currently is almost 160 GB. The block size is 8k and the server is Windows server. If they try add records to the area, the database crashes with errors: [2017/07/04@00:47:10.667+0300] P-162768 T-162772 I ABL 135: (9450) bkioWrite:Insufficient disk space during write, fd 2864, len 16384, offset 19902184, file E:\db\datas\database_11.d1 [2017/07/04@00:47:10.698+0300] P-162768 T-162772 F ABL 135: (8897) SYSTEM ERROR: Unable to extend database within area printouts. [17/07/04@00:47:10.698+0300] P-162768 T-162772 1 4GL -- (Procedure: 'programX.p' Line:84) SYSTEM ERROR: Unable to extend database within area printouts. (8897) Area settings in st file: "printouts":11,64;512 E:\db\datas\database_11.d1 Statistics for Area: printouts Files in Area: printouts E:\db\datas\database_11.d1 163038707712 Database Block Usage for Area: printouts Active blocks: 19901951 Data blocks: 19901446 Free blocks: 505 Empty blocks: 235 Total blocks: 19902186 Extent blocks: 1 Records/Block: 64 A couple of months old tabanalys for the area (when it worked) : AREA "printouts" : 11 BLOCK ANALYSIS ------------------------------------------------- 19470847 block(s) found in the area. Current high water mark: 19470847 505 free block(s) found in the area 19470332 record block(s) found in the area 0 index block(s) found in the area 0 empty block(s) found in the area 2 object block(s) found in the area 2 cluster list block(s) found in the area 1 object list block(s) found in the area 2 cluster map block(s) found in the area RECORD BLOCK SUMMARY FOR AREA "printouts" : 11 ------------------------------------------------------- -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean Count Factor Factor PUB.printouts 912754005 123.4G 68 12382 145 917107791 1.0 1.0 We have studied this with co-workers and couldn't find solution. The customer has moved some old records from the area to an other place so we have managed so far, but we should solve this soon. Any ideas what might be the problem? Thanks Kai
Continue reading...
Continue reading...