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?
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...
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...
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...
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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.