hi all,
we are using Informix 7.31 FD5 under Baan IV and HP-UX and i wonder if our Informix db is using a L1 or L2 index structure for locating to rows.

how can we learn it in our current system?(the level of it; L1 or L2)

Regards,

There are several ways:
- On Baan level: check the settings. If Level 1/2 has been specified you run in that particular mode, else you run in Level 1 (as you use Informix)
- On database level: check the tables. If they have a hash column, it is Level1, else it is Level 2.

Hope this helps,
Dick

Or...


Take a look at the tabledef6.x file ( $BSE/lib). Look for the entry INF_LEVEL1. If INF_LEVEL1 is set to 1 then you are on L1 and on L2 otherwise.

Easier, is to turn dbslog on ( DBSLOG=1570) and connect to the Baan application server. You should be able to see the file dbs.log in your home directory as soon as you make a succesfull connection. dbs.log should contain all information about the settings you are using.

Rgds,
$.$.