Hi, I understand that the Level1 database driver in Baan uses Hash columns for each Index in a table, while the Level2 database driver does not use Hash columns.

Now I would first like to test certain tables in our test server, for which I would like to convert them from Level1 to Level2.

I mean, Is it possible to have one or two tables on Level2 driver while all the rest remain in Level1 ?

like....
I use ttaad4110m000 Maintain Database Definations : to define one more database defination for Level2. (say 003)

Then take seq. dump of the table and delete the table.

suppose tdinv700.

next.. using ttaad4111m000 asign table tdinv700 to the database 003.

again create the table using ttaad4230m000...


Is this logical and possible ?? Am I missing something ?

I tried it and get following error :

"bdb_errno 1502"...

Am I supposed to create a new database instance ??

What parameter should be used in ttaad4110m000 ?

The parameter for Level 1 is as follows :
INF_LEVEL1=1,INFORMIXDIR=F:\informix,INFORMIXSERVER=ol_testbaan,INFORMIXSQLHOSTS=\\TESTSERVER

I tried the following two options :

1)
INF_LEVEL2=1,INFORMIXDIR=F:\informix,INFORMIXSERVER=ol_testbaan,INFORMIXSQLHOSTS=\\TESTSERVER

2)INF_LEVEL1=0,INFORMIXDIR=F:\informix,INFORMIXSERVER=ol_testbaan,INFORMIXSQLHOSTS=\\TESTSERVER

In order to convert from level1 to level2 you have to export all of your data and then re-import it using the bdbpre/bdbpost utils. Before posting the data in you will have to update your BSE/lib files to reflect the level two driver.

But, be aware that you can create problems by setting up a driver for some tables to behave different. It will generate a different driver and thus 2 phase commit is not guaranteed. Beside this, performance can drop significant as joins between some tables can not be done in the driver anymore.