- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: dba needs sysadmin help on optimizing configur...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2000 03:46 PM
тАО08-11-2000 03:46 PM
I inherieted the current system:
HP 9000n800 11.0
HP 12H Raid fully populated with 12 9 gig drives
(No unallocated space on the 12H, so I believe it is operating at Raid 5 for EVERYTHING!)
4 LUNS
2 ctrlrs one active one spare
Informix 7.3 on raw dbspaces
vg01 has the app executables and data files
vg02 raw dbspace and tempdbs
vg03 has raw test environ
Goals:
-Modify the controllers: both active for 2 LUNS each and spare for the other 2
-Fragment the db into various dbspaces and map them to diff VG's, if that will improve perf (I don't think it will, since the 12H manages everything using it's own algorithyms)
-Drop one or more unused dbspaces (8 dbspaces allocated < 10% in actual use)
-Create additional tempdbs in diff VG
-Most important: drop and unallocate the excess dbspaces/raw disk and give it back to the 12H so it can re-build the Raid 01 capacity.
Q:
-am I off base in any of the assumptions or goals?
-will changing the active controller paths to LUNS do what I want for the raw spaces, and is there anything I need to do besides the vgreduce/extend for the raw files and links?
-what caveats are there besides be very careful when I kill off the excess dbspaces and...yikes...delete the logical drive.
tia to any who will respond!
Doug
p.s. what is the surest method to be sure I am correct in the assumption I have no unallocated disks/space in the 12H?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2000 11:25 PM
тАО08-12-2000 11:25 PM
SolutionFirst things first.
Make a recovery tape of your OS.
You can use ignite make_recovery for this.
Secondly shutdown you databases and do a cold backup of everything. If you do toast everything recovery should be easy from here.
Now comes the planning stage. You say you have two paths with each one having an alternative path. Try and plan your VG's around this so that your load will be balanced. Personally I like working with LVM rather than raw volumes it gives a bit more flexibility but of course there are instances where this is not possible.
If you are thinking about splitting dbspaces across VG's make sure the VG's are split across the controlers. Maybe even use physical VG's
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-13-2000 11:38 PM
тАО08-13-2000 11:38 PM
Re: dba needs sysadmin help on optimizing configuration of array/ctrlr for db usage
Make sure to have a good recovery plan before wiping out the array.
Just my 2 cents.
Rgds,
Philip
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-14-2000 12:15 AM
тАО08-14-2000 12:15 AM
Re: dba needs sysadmin help on optimizing configuration of array/ctrlr for db usage
The above comments about backup and recovery I would most certainly do.
We're using a 12H with Oracle but are not using raw devices. From what I know the performance gain is only about 2% and this is to little for us to give up the more convenient LVM-administration. As far as your questions are concerned.
4 LUN's is excellent. You can switch primary and alternate with the system online using vgreduce and vgextend.
If you can free up some diskspace for RAID 0/1 that would be good. However, the 12H will ALWAYS put data in RAID 0/1. Use the arraydsp -v
In Oracle, more tablespaces are good for performance. Using more VG's on the 12H does not make any difference in my experience since everything is striped over all disks. If you have redolog-file on the 12H, consider moving them off the 12H to another disk because they are written to constantly which will keep to internal SCSI-queue busy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-14-2000 12:18 AM
тАО08-14-2000 12:18 AM
Re: dba needs sysadmin help on optimizing configuration of array/ctrlr for db usage
Hi,
Backup up and also make recovery tapes of your system before performing these tasks.
Look at these:
http://www.hp.com/essd/model12H_writews.html
http://www.enterprisestorage.hp.com/pdfs/idc_autoraid.pdf.
There are full explanation for your AutoRAID
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2009 01:45 PM
тАО04-30-2009 01:45 PM