HP-UX 11.0 and Informix 7.3 - Data Missing ??

[Laurie_2]

Hi All,

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

[A. Clay Stephenson]

Hi Laurie:

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.

[S.K. Chan]

To add to Clay's response.
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.

[Steve Lewis]

Assuming you only have one instance running, log in as an informix user, check that you have the INFORMIXDIR, PATH and INFORMIXSERVER env vars set, then execute the command
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.

[Tim D Fulford · Accepted solution]

Laurie

I 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

[Tim D Fulford]

OOPS, pressed the wrong button!!