- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- HP-UX 11.0 and Informix 7.3 - Data Missing ??
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-05-2002 01:17 PM
тАО02-05-2002 01:17 PM
I'm back, I changed jobs last week.
Could somebody explain to me where the data
from informix goes?
When I do a bdf, I am only using vg00 and vg01.
However, when I go to SAM I see I have vg02
with stuff on it.
However I cannot look at the informix data?
How do a verify. I do use dbspace, but that
doesn't tell me where it is...
When I go to SAM Logical Vol. I see vg02
with lvol1-lvol4 and it says "UNUSED".
Where is my data?
Thanks,
Laurie
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2002 01:26 PM
тАО02-05-2002 01:26 PM
Re: HP-UX 11.0 and Informix 7.3 - Data Missing ??
I strongly suspect that your Informix data is in vg02 but that you are using raw volumes. That's why you can vgdisplay vg02 but these lvol's do not have filesystems mounted on them. You will need to get with you DBA and do some queries to find where the data actually resides.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2002 01:32 PM
тАО02-05-2002 01:32 PM
Re: HP-UX 11.0 and Informix 7.3 - Data Missing ??
You can confirm these raw lvols by looking in to /dev/vgXX.
The raw lvols which Informix uses have to be owned by Informix user (eg : informix:informix) because if it's owned by root Informix will not be able to write to it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 07:07 AM
тАО02-06-2002 07:07 AM
Re: HP-UX 11.0 and Informix 7.3 - Data Missing ??
onstat -d
The right hand side will list the chunk paths.
Normally these will be symbolic links to the actual paths so 'll' each one to see where the actual data is held.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-08-2002 08:07 AM
тАО02-08-2002 08:07 AM
SolutionI suspect that you are using raw chunks for your database. This is fine & reccomended by IBM (Informix as was). if, as informix, you do
% onstat -d
You will see something like
Informix Dynamic Server Version 7.30.UC7A -- On-Line -- Up 2 days 03:58:08 -- 496456 Kbytes
: Stuff in here about DBspaces :
Chunks
address chk/dbs offset size free bpages flags pathname
dd30c218 1 1 0 131072 129993 PO- /home/informix/databaselinks/rootdbs
dd30caf8 2 2 0 393216 8139 PO- /home/informix/databaselinks/logicallogs
dd30cbd8 3 3 0 131072 0 PO- /home/informix/databaselinks/physicallog
: More stuff here :
basically the /home/informix/databaselinks/??? is the chunk informix is using. If you then do an
% ls -lL /home/informix/databaselinks/???
it will show you the device (majour & minor number
eg
crw-rw---- 1 informix informix 64 0x050003 Jan 7 16:05 /home/informix/databaselinks/???
So here the volume group is the one with the minor number 0x050000
So that answers the first part of your question (where does the data live)
I suspect you want to know which dbspaces are filling up, well the onstat -d gives you all this info, or you can use my script, freespace.ksh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-08-2002 08:08 AM
тАО02-08-2002 08:08 AM