dear fans,

we are planning to migrate to level2 driver on our Baan B40c4/MSSQL2000.

in the board, I checked thru the discussions for the past 4 years on the subject; its confusing; is level2 driver stable or not; is it good or bad; is it released or not etc.

any latest information can you please update, it will help us.
(we ami to go for level2 driver from a new installation to have reduced database size which is currently 140GB and for a better performance)

can you also give any docs explaining the steps and pre-requisites for level2 installation of Baan.

thanks

VISH

At Baan Support Site is available the documentation to do this proccess in B50c, and the procedure is the same for B40c (U7940B US).

bdbpre -> changes at tabledef6.1 and db_resource files -> bdbpost

Don't forget to upgrade before your Baan installlation with lastest porting-set and tools Service Pack.
At the porting-set documentation you can find the previous steps to re-licensing Baan software for SQL Server Level2.

Following this steps, I recomed you to go to Level2, the performance is much much better.

Good luck,
Sonia.

It's very simple....

set MSQL_LEVEL1 = 1
bdbpre -p <PACCCOMB> -I<LISTOFTABLES> -E<LOGFILE> -O<DUMPFILE> -C<COMPANY>

set MSQL_LEVEL1 = 0
bdbpost -k <PACCOMB> -n -E<LOGFILE> -I<DUMPFILE> -C<COMPANY>

repeat for each company. Then set MSQL_LEVEL1 in the standard resource files and re-organise the tables to rebuild the reference counters.

This will export and import from level 1 and import into level II. The -k option for bdbpost will delete the existing table, and re-create without the hash columns before importing.

Get the list of tables by using the "Count number of records" session in tools.

We saved 35% on our DB size! Performance for non-index queries is much better, which makes the "Query by Form" tool much more usable.

Of course - you have to license your system for SQL Level 2 (it's free but you have to do it) and make some other changes to the db_resource. but other than that, it's pretty simple for a small data set.

Dave

dr all,

tks for your good inputs

sonia : the document number takes me to some other topic.

New Server Level 2 Driver:
====================
it seems, if I install a New Baan IV c4 Master CD with default Porting set 6.1c.07.03 or higher then, automatically It is a level II Installation I believe.
Then I can just take the Seq.Dump from any Level 1 Server and put it on Level2 New server.

So we got the CD with default latest porting set; we had problem with this CD in installing; Once we sort out I will know;

Existing Server Level 1 to Level 2 Migration:
=================================
cole:
the idea of set MSQL_LEVEL1=1 and bddpre followed by
set MSSQL_LEVEL2 and bdbpost :
just some questions :

1)how the basic tools tables data like dba, aad, adv, txt, iex are converted.
is it going to be the same way as the application data with coy 000.
BGS says they have developed Utility set to do the L1 to L2 conversion...??

2)with L2 can we freely insert / delete / update from Query Analyser

dave can u pls tell me:
1) what changes needs done in table def, db_resource
2) why it needs re-licensing, does it mean if I convert to Level-2, then automatically it will go to demo mode; OR I need to run Patch objects after System Crash and take it to 14 days count down.

Thanks for your co-operation and patience dear all.

VISH

I think that the minimum porting set for MS SQL2000 level2 driver is 6.1c.07.04.

You need to relicense because otherwise baan keeps creating the tables in level1 unless you install asolution that appends the option "MS SQL Server level II" option to session ttiex3501m000.
After that you have to choose the refered option and to make it efective it must be relicensed.
At this moment i don´t remember what was the number of the solution that appends the option.

hi

we managed to install Level 2 from a baan CD with default porting set 6.1c.07.06. (after this we got some error as Failed to connect we noticed in event viewer that too got resolved by upgrading the PS to 6.1c.07.08 and BW 079.

yeah you are right; we need to apply a patch so that the Requested System Configuration is enabled with Level 2 driver check box option.

thanks