Search results

No, Lee. You can configure a single-volume db on V9 as well. Don't know why anyone will doing this...but I have seen DBA configure it on a single-volume... As long as your last mydb.bn is not a fixed extent...then your db should be fine...

Totally agree with Macery. Maintenance indexes should be a part of DBA weekly work. Just in case, DBA is not already doing indexes maintenance... Basically there are two problems with indexes: corruption and underutilization. There are a couple of tools that allow you to analyze, fix, compact...

Tunning -B parameter alone will give you a little bit of gain on your db performance. First of all, you have to know the % of database buffer hit. Here is the little formular that you can use: % DB buffer hit = [(db_requested - db_read)]/db_requested x 100 Where, db_requested and...

Thanks Darrell! Once I thought more about it, you are absolutely right. When the db failover to a standby node, it will mount the file systems on the shared drives...then start the db. Since the db is crashed on the previous node, the standby system will do an automatic crash...

Check out QAD solution ID: 1.0.34802754.2695015 on "How to dump large conversion files". The 'gig2dump.p' script works like a charm on my system. Good Luck! Bob

Can Progress installation directory (DLC), all production db (.db files), parameter file (.pf), db start and stop scripts and all database extents installed on the shared drives in HACMP cluster? This is my dilemma. We have two HACMP nodes and all our production dbs including Progress...

Hello All, I am wondering anyone out there has run HACMP without Fathom Cluster? Or with Fathom Cluster installation directory and Progress $DLC on the shared volume file system? Thanks, Bob.

Great! Thank you very much! I will try it on my DR server. Cheers, Bob.

Hi, I am working on DR and need to move all Progress Installation from one machine to another. We are running AIX 5.2. I am wondering if I can backup all Progress DLC directories using AIX native commands (backup/restore) and restore it on a different server...or do I have to re-install the...