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

[ctoman]

Remember this is a test env with only those CLOB tables. ash:/md/db/data->sudo sh ./viewdbblock.sh carolina 72 4416 viewdbblock.sh Release V1.4 as of Jul 21, 2012 Database: carolina Area Info: "Lobs":72,64;64 Dbkey: 4416 (Block 69) Blocksize: 8 (KB) Extent: /md/db/data/ext/carolina_72.d1 Size: 2.02803e+06 (KB) Offset: 552 (KB) ./viewdbblock.sh[378]: 2.02803e+06: Syntax error Creating temp database... Please, wait. ----------- 0000 bk_dbkey: 0x00001140 4416 bk_type: 0x03 3 (Data Block) bk_frchn: 0x01 1 (RMCHN) bk_incr: 0x0001 1 bk_nextf: 0x00001180 4480 bk_updctr: 0x00000015 21 0010 bkCheckSum: 0x77ce 30670 bkHeaderSize: 0x0040 64 objectId: 0x0007 7 partitionId: 0x0000 0 objectType: 0x0003 3 bkObjDbkey: 0x0000000000006000 24576 0020 bkDbkey: 0x0000000000001140 4416 bkNextf: 0x0000000000001180 4480 0030 bkLastBiNote: 0x0000000000000000 0 partitionId: 0x0000 0 Reserved: 0x0000 0 Reserved: 0x00000000 0 0040 nextCluster: 0x093702d71cc0199b 664002592984013211 prevCluster: 0x1661132d0ffc0cce 1612591225837980878 RMBLK: numdir: 9 freedir: 55 free: 727 dir: [ 0] Offset: 0x1cc0 Size: 830 Table number: 0 0 0xec CLOB_RES_2 0x03 0x3b 0x7b 0x22 0x6a 0x6f 0x 0x63 0x74 0x69 0x6f 0x6e 0x49 0x64 0x22 0x3a 0x22 0x32 0x34 0x63 0x63 37 0x62 0x2d 0x35 0x36 0x65 0x36 0x2d 0x32 0x33 0x32 0x31 0x61 0x39 0 0x69 0x64 0x65 0x72 0x22 0x3a 0x22 0x68 0x79 0x62 0x72 0x69 0x73 0x2 x22 0x3a 0x22 0x32 0x34 0x37 0x35 0x37 0x30 0x22 0x2c 0x22 0x61 0x6c a 0x22 0x30 0x30 0x30 0x35 0x30 0x36 0x34 0x31 0x22 0x2c 0x22 0x6a 0x 0x4a 0x6f 0x62 0x49 0x64 0x22 0x3a 0x22 0x30 0x30 0x30 0x35 0x30 0x36 75 0x73 0x22 0x3a 0x22 0x64 0x65 0x66 0x61 0x75 0x6c 0x74 0x22 0x2c 0 0x41 0x56 0x45 0x53 0x20 0x43 0x4f 0x4e 0x53 0x54 0x52 0x55 0x43 0x5

Continue reading...