Search results

Thanks for the replies - it's always very helpful getting multiple opinions, especially in the domain of DBA, because "the World is on your shoulders". I don't see any real variation in opinion. It seems that the consensus is: * Writing probkup files to disc is so reliable (especially with a...

I appreciate the reliability issues with tape and I'd never write a probkup to tape without including redundancy with -red - although even then I wouldn't choose a value as low as 9 for -red; maybe 50 to 100. If a backup goes to disc - and then to tape, I wonder whether adding redundancy to the...

OE 10.1C (moving to 11.6 next March.) Solaris 10 We have multiple production DBs, totaling about 2.3 TB. At present they are backed-up using probkup online - to disc files - and later those files are copied to tape. The existing scripts specify "-red 9". I understand what the "-red" does...

OE 10.1C0407 on Solaris. (Soon migrating to OE 11.6.) I am new to this site. I wrote this short piece of code to show me info about _IndexStat: DEF VAR naym AS CHAR. DEF VAR i AS INT. DEF STREAM xx. OUTPUT STREAM xx TO /tmp/ronz. FOR EACH _indexstat NO-LOCK BY _indexstat-id: FIND...

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