where do the logical logs reside?

[argoo]

How do you determine the dbspace that the logical logs reside in?

Thanks,

 

[mberni]

select a.number, a.size, c.name
from syslogfil a, syschunks b, sysdbspaces c
where a.chunk=b.chknum and b.dbsnum=c.dbsnum;

should do the trick

 

[argoo]

Unfortunately, the chunk field does not exist in syslogfil. I am using informix v9.30.HC2.

 

[mberni]

we have 9.40 here, so i cannot look on a running 9.30 system

have a look at the columns of your syslogfil, maybe you can guess a link to the chunks/dbspaces

Maybe this is of help too: if you do not explicitly move the logs somewhere else, they go into the root dbspace.

 

[argoo]

I am assuming the logs are not in the rootdbs. There doesn't seem to be a relationship between the syslogfil and syschunks tables. Onstat reports an address that may be used to relate chunks to logical logs. However, I am not 100% sure.

 

[mberni]

ok, then try the onmonitor-tool

The logs-status can be found at :

status / logs

at least in my env there is a column "dbspace" for each log. you can scroll the list with the cursor.

 

[argoo]

Don't know why I didn't see it before?!? Thanks.