Search results

  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...
  16. V

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

    Hello all, Thanks God, we've got more powerful than what I have now Dell PowerEdge R720 with 256GB of RAM, 8 SSDs and 48 cores (2 CPUs * 12 cores each * 2 virtual) with 10Gbs NICs :) Created RAID-10, tuned XFS, created LACP with two NICs, also tuned together with switch, so got 18-19Gbs...
  17. V

    Resolved "transition Failover" Fails With "segmentation Fault"

    Shortly, you are right: we should be very careful with Progress, right place and right angle. Initially it was a little bit wrong combination of parameters and maybe ways of creating a target DB. Later after I changed them to the proper ones, but I've made a type (databass-role instead of...
  18. V

    Resolved "transition Failover" Fails With "segmentation Fault"

    Hi guys, I finally found a perfectly working configuration, exactly what's needed. Here it is: addai.sta . a . a . clean.sh proshut db1 -by proshut db2 -by echo y | prodel db1 echo y | prodel db2 rm *.recovery;rm *.lg;rm *.log rm *.bak;rm *.sav;rm *.sav.inc rm *.stdout;rm db?.st...
  19. V

    Resolved "transition Failover" Fails With "segmentation Fault"

    Yeap, I've called them. We went through and reproduced it. Case 00397291 is created
  20. V

    Resolved "transition Failover" Fails With "segmentation Fault"

    Changed all AI extents to variable size. Same result...
Top