vaishali
26th October 2004, 10:19
We have BaanIVc4 with database Informix 9.40FC2 and O/S HP-UX11i.
With porting set 6.1c.07.01

we observed that for idxdbs dbspace, onstat -d comand shows status flag as “N B”.
Earlier(i.e before we changed the database logging mode from ANSI to Buffered and tools and all company data was loaded thru bdbpost6.1 utility) the status was “N”. The chunks status is “PO—“ for all those chunks which were added in this dbspace when the dbspace flag was “N”.
Subsequently when new chnuk was added in the dbspace idxdbs, the chunk status shown is “PO-B”.
We logged a query on net and we got following explanation.
Big chunks/dbspaces are specified with a B in the onstat output. This B is put on the 'new' fourth position. The B on the third position is used for BLOB spaces.

Recently we added one chunk of 1 gb in the same dbspace idxdbs but this chunk also shows flag “B”. Probably since the dbspace flag has set to “B” all chunks newly added will get flag “B”.

We would like to know whether this will have any problem for Baan application and Data?

Regards,
Vaishali

triton45
26th October 2004, 22:59
Yes, the "B" status flag is set for the whole chunk.

Before version 9.4, Informix only allowed 2Gig chunks to be added to the database. Now with 9.4, you can have a chunk > Petabyte.

Baan knows nothing about how Informix stores your data, nor does it care. This will not cause a problem.

Andy