[progress Communities] [progress Openedge Abl] Forum Post: Re: Excessive Clob Growth

[ctoman]

ash:/md/db/data->sudo sh ./viewdbblock.sh carolina 72 viewdbblock.sh Release V1.4 as of Jul 21, 2012 Database: carolina Area Info: "Lobs":72,64;64 Dbkey: 128 (Block 2) Blocksize: 8 (KB) Extent: /md/db/data/ext/carolina_72.d1 Size: 2.02803e+06 (KB) Offset: 16 (KB) ./viewdbblock.sh[378]: 2.02803e+06: Syntax error Creating temp database... Please, wait. ----------- 0000 bk_dbkey: 0x00000080 128 bk_type: 0x0c 12 (Object Block) bk_frchn: 0x7f 127 (NOCHN) bk_incr: 0x0001 1 bk_nextf: 0x00000000 0 bk_updctr: 0x00006191 24977 0010 bkCheckSum: 0xccdc -13092 bkHeaderSize: 0x0040 64 objectId: 0x0000 0 partitionId: 0x0000 0 objectType: 0x0008 8 bkObjDbkey: 0x0000000000000080 128 0020 bkDbkey: 0x0000000000000080 128 bkNextf: 0x0000000000000000 0 0030 bkLastBiNote: 0x0000000000000000 0 partitionId: 0x0000 0 Reserved: 0x0000 0 Reserved: 0x00000000 0 0040 nextCluster: 0x0000000000000000 0 prevCluster: 0x00000000000001c0 448 OBJBLK: 0040 totalBlocksOld: 0x0000000000000000 0 hiWaterBlockOld: 0x0000000000000000 0 chainFirst[FREECHN]: 0x00000000000001c0 448 0050 chainFirst[RMCHN]: 0x0000000000000000 0 chainFirst[LOCKCHN]: 0x0000000000000000 0 0060 numBlocksOnChainOld[FREECHN]: 0x0000000000000000 0 numBlocksOnChainOld[RMCHN]: 0x0000000000000000 0 numBlocksOnChainOld[LOCKCHN]: 0x0000000000000000 0 0070 chainLast[FREECHN]: 0x0000000000000fc0 4032 chainLast[RMCHN]: 0x0000000000000000 0 0080 chainLast[LOCKCHN]: 0x0000000000000000 0 objectId: 0x0000 0 objectType: 0x0008 8 0090 serialNumber: 0x0000000000000000 0 firstFreeCluster: 0x0000000000000000 0 00A0 lastFreeCluster: 0x0000000000000000 0 totalBlocks: 0x00000000000748be 477374 00B0 hiWaterBlock: 0x00000000000668bf 420031 numBlocksOnChain[FREECHN]: 0x0000000000000039 57 00C0 numBlocksOnChain[RMCHN]: 0x0000000000000000 0 numBlocksOnChain[LOCKCHN]: 0x0000000000000000 0 00D0 partitionId: 0x0000 0 Block Info: carolina.area.72.dbkey.128.160429_152026.txt

Continue reading...