- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: informix 7.3 and nfs mount issue
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
тАО02-09-2008 04:01 AM
тАО02-09-2008 04:01 AM
L2000, quad 440mhz cpu, 3gb ram, gigabit nic card, hpux11i v2 and informix 7.3
Storagetek s500 nas.
I'm not a dba so bear with me.
We have an issue where our db keeps hanging ( starts up fine but when we run a big query it hangs), the dbspaces are in a directory on a nfs mount.
When i try to list the contents of that directory it just hangs as well (after the query has been run), allthough i can list the contents of other directories on that mount ok.
I've check the logs and there is nothing obvious there, no packet loss on the lan etc.
Any ideas?
Cheers
George
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2008 07:23 AM
тАО02-09-2008 07:23 AM
Re: informix 7.3 and nfs mount issue
dd if=
for
On the NAS side see if you can run the same read test if it is available.
Finally you probablyhave heard this before, running a database environment over NFS (even if it is NAS based NFS) it is not a good idea.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2008 07:39 AM
тАО02-09-2008 07:39 AM
SolutionBill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2008 09:17 AM
тАО02-09-2008 09:17 AM
Re: informix 7.3 and nfs mount issue
But this server just doesnt want to play when we run this big query.
NFS wasnt my choice, we migrated from a xp256 when we moved dc :-(
We have old netapps nas, i'm going to copy the data over to that and see if we have the same problem.
But the servers do need to be patched anyway so that may help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-11-2008 04:37 AM
тАО02-11-2008 04:37 AM
Re: informix 7.3 and nfs mount issue
I don't know how the Informix database works but I don't think puting the tablespaces/datafiles on a NFS is a good idea. Is it a certified/recomended storage by Informix?
Does the Informix database have the concept of redologs? If it has, at least, move them (the redologs) to a local storage...
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-16-2008 11:13 AM
тАО06-16-2008 11:13 AM
Re: informix 7.3 and nfs mount issue
An nfs patch update did the trick in the end.