Does it mean there is no support for moving from Bisam to some databases which was supported before, or new Quick guides are in prepartation or ...?

We want to make a migration, but at first I want to do comparative analysis of:

 supported versions of RDBMS
 price of license
 HW price (and sizing)
 What Baan people say
 Implementation cost
 Postimplementation cost and time frame
 API-s
 Disaster recovery i bussiness continuity ISO17799 / BS 7799
 performance
 skalability
 4GL support
 future Baan polocy...

Help me with some literature or if you can for DB2 / Oracle / support from Baan in this moment of time ...

My option is to stay on Bisam but, it is not my and I think SSA / DBMS vendor interest ...

D.

Are the Quick Guides being withdrawn or are you having difficulty downloading ? I have recently had trouble down loading word documents but I assumed it was a microsoft problem.

I have downloaded an enormous amount of LN6.1 stuff which is mostly pdf, without any problems recently.

As to the database. Why change?

If performance is a problem upgrade the hardware -- more / faster disks -- more memory and cpu cycles. I think it would be possible to get much greater performance improvement with hardware upgrade than with than with database software no matter what your scale of operations are. The improvement would certainly be at a much lower cost and the cost would be a one-time cost.

If you were to change RDBMS you would probably have to pay SSA more money (certainly if you went to Oracle which is best of breed) as well as paying for RDBMS licences and ongoing annual support/use fees.


Terry

I think he might want to change because
1) bisam doesn't support tables > 2GB
2) future baan porting sets may not have a tbase driver...

As far as I know, you don't have to pay SSA any more money
dependant on which DB driver you license, or even if you license all of them..

I'm a big fan of db2, it's small and fast, doesn't cost nearly as much as Oracle and doesn't come with all the extra un-needed crap. The only downside is that db2's Query Optimizer is "So Smart" that it doesn't accept hints, a bit of a sticky situation when baan's sending <blank> to <zzz> queries... (of course there are ways around that....)

Dave

Thank you people,

Terry,

it isn't MS problem - I listed QG-s by FTP - there is no DB2 migration guide (a saw it a couple of years ago on Baan KB...)

Maybe, IBM is getting Informix as a basement SUBP and ?
More I choose SUBP, I am more on the side to change only HW, but, when management is prepared for change, we have to make our situation so up to date and so better for IT.

++++++++++++++++++++++++++++++

Dave,

you are right too,

also, we have a global agreement with IBM and Oracle so beside DB2, there is Informix and Oracle in the game;

Do you know what is with custom reports we made last 5 years on bisam;
shall we have a problems migrating to DB2/Oracle/Informix because of SQL differences?

Can you give me more details (links ...) on situation you said about:
"Query Optimizer is "So Smart"... "


Thanks

In Baan you're not writing DB specific code.. so as far as that goes, bisam, oracle, db2, informix, mssql do not matter.. What matters is - you'll probably be migrating from Level 1 to Level 2 driver, that's where you may run into some problems.

If you saw the quick guide "years ago" then I can imagine why they removed it.. it was 2 lines of migration (bdbpre/bdbpost), and then the Driver Manual. DB2 did not have a level 2 driver then, so that was really all there was to it.. Even today, with the level 1 to level 2, its not much more difficult, but you have to make sure to test your custom programs to make sure they are returning the data you expect (they won't error, they'll just parse things differently) Why? level 1 was buggy, level 2 is fixed..

No links or anything on the DB2 optimizer.. just info that I received from Baan and DB2.. I can't find the syntax for the db_resource parameter to fix it otherwise I would post it here..

If you're really researching multiple DBs, i would suggest getting a copy of the latest driver manual for each, maybe even get the SSA ERP LN ones since they're more up to date (and a good chunk of the stuff was backported..)

Dave

I will continue searching ...

:o

As it turns out - they are still available.. there just seems to be a problem
with Baan's ftp server that's messing with all of the quick guides.

Dave

KBase said (when you search for DB2)

85 Quick Guide 1823 - Moving a Company From BISAM to DB2
160119 db2 Support N/A 25 Oct 2002

But, on a list of QGuides, there is not QG1823 (any more)

D.

(Maybe, newer ver. is expected)

Baan sent it to me, why not log a case and have them send it to you?

Dave

Not because I don't love Baan, but we as a company have read-only access to KBase.

Thanks
Bye

Ah, well, i'm sure they'll be back online eventually. But after reading the doc, I think with a little experimentation you could figure it out.

good luck!

Dave