RE: Is anybody here using DB2 v8 ??

RE: Is anybody here using DB2 v8 ??

 

  

I believe that the IBM JVM is supplied by default but that comparable
products from other vendors can be used with beneficial consequences for
memory usage.

> -----Original Message-----
> From: Alejandro Daniel Toffetti [SMTP:[Email Address Removed] Sent: Wednesday, November 05, 2003 12:58 AM
> To: DB2 UDB LazyDBA
> Subject: Re: Is anybody here using DB2 v8 ??
>
> I'm sorry I've not been clear enough at explaining my problem.
> The server box runs OK, in fact, the server box has better hardware. The
> problem here is in the development boxe[s|n] (sp?). We would need to run
> MS VB, CA ErWin, DB2 Control Center, DB2 Command Center and DB2 Stored
> Procedure Builder at the same time, but doing this on 256 Mb RAM makes
> the box choke and cough.
> Looking at the Task Manager I've noticed that DB2 Control Center
> uses a great amount of RAM.
> In \sqllib\bin\db2cc.bat I saw this::
>
> -o:"-nojit -mx128m -ms32m"
>
> I was thinking (in fact hoping) if maybe there is some way to
> improve the performance of the JVM, other than installing more memory.
> In the long run, we will eventually be provided with better
> hardware, but we depend on a government agency and cannot tell when will
> it happen. not in the near future for sure. That's why I'm trying to
> find another solution, even though more memory is the correct one.
>
> Thanks you very much for your help !!
>
> Daniel
>
> Richard J Reppert wrote:
>
> >Never feel stupid asking questions.
> >
> >A 500 Mhz pc should be PLENTY to run Db2. (Assuming you are not trying
> to
> >do 200 transactions/second). There are several things you can do to
> greatly
> >improve the speed of DB2 on this box.
> >
> >1. Remove a great number of the services running under XP. There are
> MANY
> >services under NT/W2K/XP that are not needed on a server.
> >
> >2. Memory, Memory, Memory! Put a gig of ram in the machine and things
> will
> >really improve. You should change the DB2 config to tune the memory
> usage.
> >256M is what I would call a minimum.
> >
> >Richard
> >
> >On Tue, 04 Nov 2003 02:13:49 -0300, Alejandro Daniel Toffetti wrote:
> >
> >>Hi folks !
> >>
> >> This is my first post to this list. I've recently downloaded and
> >>tried DB2 v8 Express Edition. I've installed it on a P III 500 Mhz with
> >>256 RAM development box running Win XP and I've found that the admin
> >>tools, specially the Command Center, are now huge resource consumers
> >>(compared to DB2 v6.1).
> >> The installation notes just says this:
> >>
> >>Hardware requirements
> >> An Intel x86 compatible processor
> >>
> >> Does anybody knows what are the minimum required hardware to run
> >>it properly ? Is there any arcane way to make it run faster / using
> >>less resources ? I feel stupid asking this, It's just that we will not
> >>be able to upgrade all our hardware anytime soon.
> >>
> >>Kind regards and thanks in advance for any hint.
> >>
> >>Daniel
> >>
> >>
> >>
> >>---------------------------------------------------------------------
> >>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> >>Get today's cartoon: http://www.LazyDBA.com
> >>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] >>For additional commands, e-mail: db2udbdba-[Email Address Removed] >>
> >
> >
> >
>
>
>
Euler Hermes is the world's premier credit insurer, offering solutions for
the management of trade receivables, from credit insurance and factoring to
bonding and guarantees.
------------------------------------
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient or have received this e-mail in error, notify
the sender immediately and destroy this e-mail. Any unauthorised use,
copying, disclosure or distribution of the contents of this e-mail is
strictly forbidden and may be unlawful.
Read our full e-mail disclaimer statement and monitoring policy
(http://www.eulerhermes.com/disclaim/email.cfm) before taking any action
based on the contents of this e-mail.


DB2 & UDB email list listserv db2-l LazyDBA home page