Recent content by Jimbro

On this particular server there are multiple databases 14 or 15, the largest being ~ 25GB. Thanks again

Will look into the MSA P2000 recommane Thanks Tom. Yes P2000 was a bad choice for sure. Nothing but problems with this thing. The 10GbE iSCSI segment is dedicated only to iSCSI traffic. From that perspective we are OK. P2000 is like any basic SAN where you can create "VDISKS" of different...

OK thank you again. My queue deoth size is set to 32 for my 4 sd devices sd[a-d] cat /sys/block/sd[a-d]/device/queue_depth 32 32 32 32 What should I look out for in the avgqu-sz column as a WARNING when I run iostat during the full backup? I should know already and I will do some reading as...

Hi more great advice, thanks. So the proquiet thing. I am using the "ST" file to gather the necessary DB extents that need to be backed up. Talking with the DBA she said that it's best to use prostrc list [DB] to make sure the "ST" file is up to date before we do the actual Quiet Point and make...

Thanks, these are excellent pointers. Option 2 is the direction I am going to push towards. Quiet point with rsync to another set of disk to avoid I/O contention at the disk layer. I think this is an excellent option. I did some test simply copying database extents and the impact was much much...

The issue is the production impact, we have slow scans and line disconnects. If the backup took 3 hours and caused no impact that would be just fine. Unfortunately it is killing production.

Hi, AI to local disk, then copied to remote storage via NFS. This is a unique situation, we were writing backups direct to NFS storage and we moved it local to improve performance. It did not help and so my feeling is that the disk read is the issue meaning the SAN may be underpowered. I...

Hi Rob, Thanks for the feedback. We do AI to a remote box so it's not on the same set of disk as the DB extents. We do use RAID 10 here in this situation. We are using SAS 10k disks, we do not have SSD. We have this spread across maybe 12 10k SAS drives. We are using an HP MSA p2000G3 10GbE...

HI All, We are experiencing extreme performance impact during the incremental online backups of our databases. We are in the process of upgrading the SAN however this will not be immediate. I want to set noatime on the EXT3 filesystems that hold the Progress Database extents, however I am not...

Hello Tom and Really Heavy Dude, I have another question. I understand the proquiet command creates a quiet point to allow the database extents to be copied to disk or tape. What I am unsure of is how do we ensure that the in use AI extent is committed so we can backup the AI files properly? In...

Sorry Tom, I wasn't sure but thanks for confirming. Appreciate it. James

Thank you Tom Would you mind confirming from the output that I have an Enterprise license? Product Name: OE Application Svr Ent Product Name: 4GL Development System Product Name: OE Enterprise RDBMS Product Name: Client Networking Thanks again James

Ahh now you guys did it, now I am feeling like I can make this proquiet thing happen. So I ran showcfg, thanks for the tip Really Heavy Dude. Looks like we are Enterpise licensed on this server right? showcfg | grep -i product Product Name: OE Application Svr Ent Product...

Hey thanks again man, In regards to the way we spread the I/O amongst the disks, this is a topic of great debate internally in our company. We had a strict policy when setting up servers going back to the Redhat 4 and AIX 4 days that we use only RAID 10 on 15k disks for the DB extents. In...

Dude....That's Heavy.. I like the pic, Clint is the man. Quit point have been arond in Progess - IIRC - almost forever. Quit points do block updates to the databsae until you disable them. Therefore one can use them to take snaphots of the database with OS tools. Nevertheless this is not the...