Our current install is BaaN IV on AIX 4.3.3 using Oracle 7.3.4.3
This has been a very stable configuration for the last 7 years.

We are planning to upgrade the hardware and therefore also the OS to AIX 5.3

Monitoring the various threads on this user group I get the feeling that the Oracle 9i and Oracle 10g have some performance problems in the BaaN IV environment. Does anyone have any experience with the DB2 database?

According to the vendor this database is utilizing a much smaller footprint and memory requirements are not as severe as the Oracle database system.

Our current install is BaaN IV on AIX 4.3.3 using Oracle 7.3.4.3
This has been a very stable configuration for the last 7 years.

We are planning to upgrade the hardware and therefore also the OS to AIX 5.3

Monitoring the various threads on this user group I get the feeling that the Oracle 9i and Oracle 10g have some performance problems in the BaaN IV environment. Does anyone have any experience with the DB2 database?

According to the vendor this database is utilizing a much smaller footprint and memory requirements are not as severe as the Oracle database system.

Hello,

in january we've moved our database to Oracle 10G. Together we've split application and database server.
Based on SSA/BaaN sizing we have no performance problems.

Regards

I love DB2. What your vendor told you is true, it's a no-nonsense small footprint, small memory usage database with very little configuration needed. and the nice thing is that it's really fast.

The only downside to DB2 is that the optimizer doesn't accept hints,
so it's possible to get really bad performance on large queries. But SSA usually has a workaround for that for their code - Your custom code though could be a problem though.

Also you have to set LIBPATH everywhere with DB2.. so it gets a little tricky if you have crystal or other 3rd party apps. not impossible, but just something to be consious of.

Now for Oracle... 9i and 10g both work fine if tuned correctly, but each new version take more memory then the last, and it's just so bloated. So it's usually good practice to upgrade your box with the DB.

Hope that helps!

Dave

I agree completely with Dave: Oracle is just too bloated.

But on the other side, the initial problems with Baan IV and Oracle 9/10 are well known by know and with the proper configuration performance is ok. Compared to oracle 7, just consider two things:

a) Oracle will need more RAM (add 20%)
b) Oracle did not become any faster (so add some CPU power, but this will come automatically with the new box)

If you know Oracle, you paid your support and your whole environment is Oracle minded, then I would stick with it.

Markus

What are the minimum porting set requirements/service packs for DB2, Oracle 9i and Oracle 10g

We might want to do a test on these to get comparative results.

Our BaaN IV system has the multi dimension extention installed (proloq) and is currently i/o bound!

Solution: 163684 - Minimum Portingset Requirements for Oracle 9i / 10g

Solution: 15219 - Porting set header solution. Read the release notes for
the various portingsets to determine OS and DB compatbility.

Good luck!

Dave

Hello,

in january we've moved our database to Oracle 10G. Together we've split application and database server.
Based on SSA/BaaN sizing we have no performance problems.

Regards


Dear Bernd,

u have mentioned that u have seperated the Application Server & database server, we are also planning to do the same, could u pls help me out how u have performed the I/O between 2 Servers (thru the normal Ethernet via a network switch or thru FIBRE Channel ??)

i am not able to find out the solution to increase the I/O between two servers.

pls help

Deepak

Dear Bernd,

u have mentioned that u have seperated the Application Server & database server, we are also planning to do the same, could u pls help me out how u have performed the I/O between 2 Servers (thru the normal Ethernet via a network switch or thru FIBRE Channel ??)

i am not able to find out the solution to increase the I/O between two servers.

pls help

Deepak

Hello Deepak,

we do the I/O from HP-UX application Server to W2K3 DB Server thru Gigabit Ethernet, handled by network switch.

Environment is 130 users in 5 live companys.

Regards

Hi Albert,

Why also not compare with MySQL 5.0?
Today I got the information that MySQL 5.0 in combination with BAAN IV will be certified and supported by SSA Global in August 2006.
If you are interested in testing this sooner I can arrange for contacts with SSA BAAN Development in The Netherlands and MySQL AB.
As per June 2006 MySQL 5.0 will already be certified and supported for LN 6.1 and b50_c.
You can use the MySQL database for already EUR 500 per year and pay no license fee at all.
MySQL is not only cheaper but also scalable, uses very few to no resources on your server and has a very high performance.

Please let me know if you are interested in MySQL.

Regards,

Edwin

Hi Deepak,

If you have dual ethernet cards to your servers.You can connect both the servers through cross-cable. It will be strong enough. This will bypass your switches, so that, if the switch goes down there will no impact of connectivity between App and DB. Also packet switching will be fast. We have applied this recently.

Gigabit ethernet is one of the solution.

regards,

-Suhas

Thanks Suhas,

actually i was also thinking this idea, but IBM partners were not showing the correct way. they were about to make money by addiing up some additional fiber channels and costlier equipments.

thanks any way for your reply.

Best Regards
Deepak

The postings in this group convinced me to try the DB2 database and this after 8 years of BaaN Oracle experience.

We procured a used RS/6000 system and populated this with a copy of the BaaN application from development and a DB2 database. Exported the 000 and test company vi the bdbpre6.1 procedure and imported this data into the DB2 database via the bdbpost6.1 executable. Yes, we had problems. This was mainly due to licensing problems. Did not want to license the box until we have made a decision which database is appropriate for our environment. The system runs in demo mode.
The ASCII client seems to work. The GUI client does not seem to function. The log.bshell displays the following errors (have reduced the un-necessary lines):

2006-05-12[07:25:25]:E:root: Errno 1 (Not owner) bdb_errno 0
2006-05-12[07:25:25]:E:root: Log_mesg: Can't change process group
2006-05-12[07:25:25]:E:bsp:
2006-05-12[07:25:25]:E:bsp: Errno 0 bdb_errno 0
2006-05-12[07:25:25]:E:bsp: Log_mesg: No servers listed in /apps/bse/lib/licence6.1
2006-05-12[07:25:26]:E:bsp:
2006-05-12[07:25:26]:E:bsp: Errno 0 bdb_errno 0
2006-05-12[07:25:26]:E:bsp: Log_mesg: No servers listed in /apps/bse/lib/licence6.1
2006-05-12[07:25:26]:E:bsp:
2006-05-12[07:25:26]:E:bsp: Errno 0 bdb_errno 0
2006-05-12[07:25:26]:E:bsp: Log_mesg: Detected database server termination

Any suggestions?

Please check the server name in the licence6.1 file, if it is empty, then try to add the local server ip address or host name in the same.

it should work after it in Demo mode.

Deepak

Thanks for your reply.

Tried first to enter a licensed server as we do for development. Did not work.

Tried this with an empty file; did not work!

Tried this with the hostname of the testserver itself; did not work!

Any other suggestions?

Hi,

enusr that there is a Blank line after u have specified the host name in licence61. file, in case it is missing.

Regards

Learner

Thanks for your reply.

Tried first to enter a licensed server as we do for development. Did not work.

Tried this with an empty file; did not work!

Tried this with the hostname of the testserver itself; did not work!

Any other suggestions?

did you try the ip address of the server that is licensed?

it's important that you pre/post ttiex300 and ttiex301 from the environment that IS licensed before you do anything..

Dave