Recent content by bodom131286

  1. bodom131286

    Exponential Database Growth

    thank you All for your inputs &guide. This has been sorted. Process was trying to store file of 200+MB as some scanned file with different scan settings. So file was not getting loaded and DB space was increasing. As this process was running every hour, so DB space was increasing by 200MBper...
  2. bodom131286

    Exponential Database Growth

    Hi Cringer, below are the content of DB structure file: b /ext1/prod/mfgdata/medlblobs.b1 f 1048576 b /ext1/prod/mfgdata/medlblobs.b2 # d "Schema Area":6,64;1 /ext1/prod/mfgdata/medlblobs.d1 f 16384 d "Schema Area":6,64;1 /ext1/prod/mfgdata/medlblobs.d2 # a /ext1/prod/mfgdata/medlblobs.a1 # a...
  3. bodom131286

    Exponential Database Growth

    Hi Rob, Below are the required details : file system type XFS. klevprdqad17ap1-/ext1/prod/mfgdata $ ls -ltrh medlblobs* -rw-rw-r--. 1 mfgpro mfg 1.5K Oct 6 2019 medlblobs.st.old -rw-rw-r--. 1 mfgpro mfg 1.7K Dec 8 2019 medlblobs.st -rw-rw-r--. 1 mfgpro mfg 128K Jun 15 02:06 medlblobs.a2...
  4. bodom131286

    Exponential Database Growth

    /QUOTE] Thank you for looking in this and helping. I am trying to zero down to the root cause & checking if there is any change application: difference between dbalaysis of April & June 15: sdiff medlblobs.dbanalysis.15thJune medlblobs.dbanalys.24thMay | grep '|' Database...
  5. bodom131286

    Exponential Database Growth

    Hi Dimitri, Thank you for your response & suggestions. I am checking for scanner settings change meanwhile looking at other place aswell. Thanks! rahul
  6. bodom131286

    Exponential Database Growth

    Thank you for looking in this and helping. I am trying to zero down to the root cause & checking if there is any change application: difference between dbalaysis of April & June 15: sdiff medlblobs.dbanalysis.15thJune medlblobs.dbanalys.24thMay | grep '|' Database: /ext1/prod/mfgdata/medlblobs...
  7. bodom131286

    Exponential Database Growth

    Hi Tom, Thank you for going through this. I am measuring DB size from backup file size of database. d "BLOBS":10,64;8 /ext1/prod/mfgdata/medlblobs_10.d1 f 2097152 d "BLOBS_IDX":11,1;8 /ext1/prod/mfgdata/medlblobs_11.d1 f 65536 Storage area is holding scan PDF / documents. No we have not...
  8. bodom131286

    Exponential Database Growth

    Hi Cringer, From backup we are measuring DB size. Backup size is 75GB. 1. Openedge version : 11.6 . Service pack : 4 2. OS version : redhat 7.7 3. I am checking with application team an users if there is any changes in application / scan machine. 4. There is no error we are getting. I am...
  9. bodom131286

    Exponential Database Growth

    Thank you for your inputs. I am attaching more details herewith. There is only one table in database. xxblobs ()table for same is attached herewith. please find the Dbanalysis (on various days from 23rd May )& database structure file attached as well Database size from promon is 75GB & database...
  10. bodom131286

    Exponential Database Growth

    Hi All, In Openedge 11.6.4 DB, I have only one table which stores blobs (scanned PDF & documents). (maximum file size 90KB). This DB is used for now 10+ years and it grew to 44 GB tin 10 years, but we are seeing an exponential growth where it has grown by 30+GB to 75GB in last 17 days. I am in...
Top