Recent content by Vito

  1. V

    Question Deleted 90% of huge table, but Storage Area is still full, why?

    Yes, guys, indexes are in separate area. I was going to use "tablemove" to move all tiny tables to another area and keep only that large table inside.
  2. V

    Question Deleted 90% of huge table, but Storage Area is still full, why?

    Yes, you are right, PROUTIL did it already :) There are some tiny one-record tables, which I will also easily dump--drop-truncate_the_area-load
  3. V

    Question Deleted 90% of huge table, but Storage Area is still full, why?

    Thank you again, Tom and Rob! Last night truncated BI, later will work with dumping the table, Storage Area truncate, and loading table back
  4. V

    Question Deleted 90% of huge table, but Storage Area is still full, why?

    Thank Thank you Tom, I just executed "proutil -C truncate bi" and it worked. I did it on test DB. Real database participates in replication. Can we run "proutil -C truncate bi" on Replicated database?
  5. V

    Question Deleted 90% of huge table, but Storage Area is still full, why?

    Thank you guys, thanks a lot! You clarified this to me. And yes, very interesting thing about Before Image files. When I was deleting the records from that huge table, my BI grew up a lot. I got two fixed size BI files with default size 512M, and one dynamic file, and he grew up till 20G. I...
  6. V

    Question Deleted 90% of huge table, but Storage Area is still full, why?

    Recently one huge table grew up and over-filled entire storage area (called AppData). I spoke with developers and App-Support, all decided that we can safely purge 90+% of this table, so I did it. But when I run "prostrct statistics" or query <select * from PUB."_AreaStatus">, it still shows...
  7. V

    Question Which Db Parameters To Change On New More Powerful Server?

    Thank you, Rob! That part about PROBKUP -Bp I've read last night and already modified my nightly backup scripts
  8. V

    Question Which Db Parameters To Change On New More Powerful Server?

    Hi Cringer, could you please explain me quickly, how do you put some objects (tables, indexes) into the secondary buffer pool using Data Admin tool? Is it in "Data dictionary" -> "Admin" -> "Alternate Buffer Pool" -> "Alternate Buffer Pool Maintenance", right? You just assign objects and...
  9. V

    Question Which Db Parameters To Change On New More Powerful Server?

    By the way, guys, anybody knows what's the "full parameter name" of -lruskips and -lru2skips ? Examples: beforeimageclusterage for -G, maxusers for -n, etc I'm asking that because when you start DB with proserve -servergroup dbname.servergroup -m5 it ignores everything wht's in otherargs= section
  10. V

    Question Which Db Parameters To Change On New More Powerful Server?

    Thank you, guys! Let me analyze all the metrics one by one :) 1) blocksindatabasebuffers (-B) echo -e "R&D\n1\n7" | promon /mydb 2>/dev/null 06/16/17 Status: Buffer Cache 10:01:31 Total buffers: 13,000,002 Hash table size: 3985057 Used...
  11. V

    Question Which Db Parameters To Change On New More Powerful Server?

    Here are my all DB startup params from promon (DB log was purged and archived, so it's faster to get them from PROMON) After-image Management Archival Directory List (-aiarcdir): /somedir Create After-image Management Archival Directory(s) (-aiarcdircreate): Not Enabled After-image...
  12. V

    Question Which Db Parameters To Change On New More Powerful Server?

    Looks like it makes sense to increase spinlockretries from 40000 to what Progress recommends 10,000 * # of CPUs, so to 480,000 in my case
  13. V

    Question Which Db Parameters To Change On New More Powerful Server?

    And here is her performance indicators
  14. V

    Question Which Db Parameters To Change On New More Powerful Server?

    Here is params for one of them, which is bigger and more busy than other ones [configuration.somedb.main] afterimagebuffers=300 afterimageprocess=true archivaldir=/somearchivedir archivalinterval=3600 asynchronouspagewriters=4 beforeimagebuffers=300 beforeimageprocess=true...
  15. V

    Question Which Db Parameters To Change On New More Powerful Server?

    Sorry guys, I will give you move input. Now we have Progress 11.5, migrating to 11.7 Total size of all databases ~ 400GB Current Hardware: some old IBM Blade, 2 CPUs * 8 cores, RAM 128GB, local HDD: Mirrored 140GB It has couple 1Gbs NICs, theu couldn't be bonded because of IBM chassis...
See more
Top