Dear Sir,

what's advantage for level 2 ? if level 2 is better level 1 , Can I change all table to level 2 ?

Thanks for your share.
Nopadon

the last time I checked with Baan Support (Sept, 2003) there was no level 2 driver available for Baan IV.

Hello,

I am not sure for baan iv, but now I already convert to level 2 for a few table (Customization Table) on BaaN ERP.it's seem it's faster then use VB or BaaN read data.


Note. BaaN ERP
Database SQL 2k En.
OS: Win 2K advance Server.

I am facing similar problem, hope you people help me in this regards.

I would like to update data into BaaN Tables through one VB program, as we are using BaaN 4, Ms-Sql on win 2k. When I enter 100 records through VB only 4-5 records displyed in BaaN
after reorganise I can see 100 records.
As per BGS it is related to driver level problem because level 2 is not supported by baan iv/ms-sql and level 1 can't support 3rd party app.

Can anybody suggest how to solve this issue? or Can anybody give me docs on BaaN connectivity kit or logic behind algorithm of hash column updation?

Thanks in advance.

-Suhas

Apparently level 2 driver for sql is now available for Baan IV. I was told that the upgrade would get rid of the ugly hash columns and potentially cut the db size in half...

Yes you're right - the latest porting set (6.1c.07.04) for Baan 4 supports SQL 2000 in level 2 mode. There is a conversion program to run.

I haven't been brave enough to try it yet though!

Advice - test, test, test!

Just curious, how much testing have you done and whether you have started running with the level 2 driver yet? Any advice on what to look out for would be great. My company is considering the jump...

Hej,

we changed our testsystem to the second level driver. The performance improvement is great, also the size of the database was reduced by 40%.

:D

Hej igen,

i found a specific documentation that we created ourself and works just fine. If there is any intrest please let me know. Than i'll translate it into english,

We have migrated to level 2 in 2002 (probably the first company in india).
I can site following advantages
1.) Hash column is removed,hence reducing database size and in turn backup time
2.) More complex queries handled by database,hence if your database server is separate then it's utilisation can help along with application server.
3.) Now sisnce column indexes are created , applications which are directly running on odbc protocols will run phenomanally faster.

We have now no speed issues inspite of exponential increse in database.

I've just migrated Sql Server from level 1 to level 2 in Test environment. Install portingset 6.1c.07.06 and run conversion session ottcomsql. Since the server is not licensed yet , i've ommited the maintain system configuration. Now i tried to create tables for new co. Go to query analizer and saw tables still hash columns. Is there aditional steps i must run to put SQL in level 2?

Thanks in advance

Did you change to level 2 driver in the tabledef6.2 file?

Malutz : I have my problem solved. I followed the following steps

1) Create 3 databases on ttaad4110m000
a) 001 . For Tools Only (without Audit)
b) 002 .All Others tables (without Audit)
c) 003 .MAndadotry Tables For Audit (With Audit)
2) In all databases Fill the field parameter with this value
MSQL_LEVEL1 = 0
3) Dump ALL companies (including 000).
4) Convert RDD in ttaad4110m000 in order to re-create tabledef6.1
5) Exit Baan
6) from command line use bdbpost -k -n -m -f -I <path/file> -Cxxx, for every co. dumped.
7) Login Baan and then reorganize tables for all companies

Afterwards all co ar in level 2

hi guys,


we have plan to upgrade our database level too
from 1 to level 2.

we are using baan IVc4 sp14

is there a requirement before we upgrade to database level 2.

please advice


regards,
-wei

I believe the requirement was that you had to be on 4c4 and maybe the latest sql server service pak.