Search results

Rob - thank you for such a detailed and informative reply! I will go through all of that carefully to make sure I understand if anything creates any problems for me. The existing DB is 10.1C on Solaris - and we plan to migrate to 11.6 over the next few months. (The time will depend on...

Hi .... I've known about -B2 for a while - and now I'm about to get my hands dirty. I'd be grateful for a bit of help from those who have experience with this feature. I understand the proutil enableB2 and disableB2 commands. Once an area is "enabled" - does that attribute stick? I mean...

Thanks Rob. Overflowing the int counter being the cause was what I understood - what "intrigued" me was that promon was able to display the value correctly. I suppose that's because the actual internal counter Progress uses is "big" (and what promon displays) - but it is when the data is moved...

Hi, I'm collecting VST details, mainly to see before/after statistics for a soon-to-be change from 10.1C to 11.6. In the _Latch VST I see a value of 2349332849 for the TXT latch (with promon) - but when I look with the VST I get -1945571795. (The figures were taken a few seconds apart, so...

Thank you! It "looked wrong" - but from what you say .... I guess it's correct!

10.2B on RH Linux. I was looking at some statistics collected from VSTs and noticed: _AiLog-RecWriten = 276390419 _BiLog-RecWriten = 276390419 _AiLog-TotWrites = 2018820 _BiLog-TotalWrts = 2709130 I am surprised that both AI recs-written and BI recs-written are identical. Is that...

OE 10.2 - RH Linux I've dumped/reloaded many DBs before - but this is my first try with an OE DB that only contains SQL tables. I had many problems, but got through all except one. My final DB (in testing) is missing some SQL privileges. In the original DB, when I display sequence privileges...

Thank you very much for that. I'm a little bit surprised that the code page (UTF-8) is not an attribute of the database. I expected that if I back-up a DB that is UTF-8, it would remain UTF-8 when I restore it. But clearly that is not the case. I am also surprised that if I restore a backup...

I have made some "progress" .... By adding -cpinternal UTF-8 to the idxbuild I can get idxbuild to function. But I am left with the problem that when I start-up the testdb database with proserve, it shows: (4264) Character Set (-cpinternal): ISO8859-1. What have I missed in backing-up and...

OE 10.2B, RH I have rather little experience working with UTF-8 databases - and I've hit some trouble. I am working in a test environment and I've done this: 1. Taken a probkup online of a running DB that uses UTF-8. 2. Created a new structure file testdb.st. 3. Done prorest testdb...

I'm not keen to change anything just yet - because I want to be able to quantify any effect of what any change might cause. I can move the client tmp files into tmpfs (being the only "available" file system I have) - but I'd still like to see what the I/O metrics are. Iostat shows me details...

Thank you very much for the replies; you have confirmed what I thought was the case. I will probably make the temp files visible with -t. But unless I put them in their own file system I can't get I/O statistics. And iostat doesn't normally show i/o for tmpfs. But if I run iostat -p ALL 3 3...

OE 10.2 on RH Linux I have used VSTs to get a variety of database disk I/O statistics - but how about client I/O (ie, temp files). Is there a way to get this information too?

-spin is 50000 promon shows "Buffer Hits" to be fairly constant at about 98.2% - which is a hit ration of about 50:1 I'll do an analysis of memory usage next week - but my initial feeling is that there is quite enough memory to allow -B to go up by a factor of about 8.

The figures ... -aibufs = 600 -bibufs = 600 BI block size = 16K cluster size = 16 MB APWs = 6 -directio = no AIW and BIW = yes/yes Checkpoints about every 2 to 4 minutes BI buffers flushed each day at checkpoint = 820,000 (roughly) Empty buffer waits = 0 DB block size = 8K DB size = 160 GB -B...

RH - OE10.2B I have started looking at a very busy s l o w system. I am sure that most of the slowness is caused by the disk config ... which has everything in one big RAID set (0+1). And by "everything" I mean "everything" - including ai and bi. My question is - are there any particular...

"D" like this ... Record Locking Table: Usr Name Chain # Rowid Table Lock Flags Tran State Tran ID 279 hzv7fz REC 1692 464967448 1271 SHR D None 1698744435 381 w66f391a REC 2658 464416137 1271 SHR D...

Most of what promon displays is pretty obvious, but there are certain things that I have to admit to being rather hazy about - even though I've worked with Progress quite a while. Maybe someone can help me to understand the following: D = "downgrade" As I understand it - when a transaction...

RH, OE 10.2B and 11.3.3 I have done a few database migrations from Type 1 storage areas to Type 2 - using mean record size to separate tables into different areas accordingly (ie, "by the book"). I now have a different situation - numerous DBs using the same application, but very different...

It was my understanding that when a transaction completes - any exclusive locks are downgraded to shared locks - and those locks will persist until the records go out of scope. If a program does nothing further with records for that (or those) record(s) but instead waits for an event of some...