- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - HP-UX
- >
- System Administration
- >
- dba needs sysadmin help on optimizing configuratio...
-
-
Categories
- Topics
- Hybrid IT with Cloud
- Mobile & IoT
- IT for Data & Analytics
- Transformation
- Strategy and Technology
- Products
- Cloud
- Integrated Systems
- Networking
- Servers and Operating Systems
- Services
- Storage
- Company
- Events
- Partner Solutions and Certifications
- Welcome
- Welcome
- Announcements
- Tips and Tricks
- Feedback
-
Blogs
- Alliances
- Around the Storage Block
- Behind the scenes @ Labs
- Converged Data Center Infrastructure
- Digital Transformation
- Grounded in the Cloud
- HPE Careers
- HPE Storage Tech Insiders
- Infrastructure Insights
- Inspiring Progress
- Internet of Things (IoT)
- My Learning Certification
- Networking
- OEM Solutions
- Servers: The Right Compute
- Telecom IQ
- Transforming IT
-
Quick Links
- Community
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Contact
- Email us
- Tell us what you think
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Enterprise.nxt
- Marketplace
- Aruba Airheads Community
-
Categories
-
Forums
-
Blogs
-
InformationEnglish
dba needs sysadmin help on optimizing configuration of array/ctrlr for db usage
SOLVED- 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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- 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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- 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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- 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
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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- 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
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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- 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
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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-30-2009 01:45 PM
04-30-2009 01:45 PM
Re: dba needs sysadmin help on optimizing configuration of array/ctrlr for db usage
Re: dba needs sysadmin help on optimizing configuration of array/ctrlr for db usage
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2018 Hewlett Packard Enterprise Development LP