Re: OpenLDAP and DB2 backend....scaling for performance???

[Trevor Warren <trevorwarren@yahoo.com>]

Hello Fellas,

 Do we have any numbers wrt performance of Openldap
and  back-sql. Since i am performing some
performance/stress tests on back-bdb i would like to
continue the same with back-sql.

 Is there any metrics available on
scalability/performance of the same??. Will it perform
worse/better???. Given the round-trip time for the
sql' connections i assume that this should be far
*worse*.

 Any reasonsoning on the same??.

Trevor

--- Roman Scherer <roman.scherer@gmx.de> wrote:
> 
> On Tue, 2004-06-08 at 16:31, Colin Ewart wrote:
> > Roman,
> > 
> > I've never configured OpenLDAP to use db2 or any
> other ODBC as a backend.
> > I'll also note back-sql is considered
> experimental. However...
> > 
> > Debug db2 first. First things to check are:
> > 
> > * Does the user "db2inst1" exist on the server?
> > * Does the user "db2inst1" have access to the
> database called "GOYALDAP"?
> > 
> > Test the above questions with the following in
> sequence:
> > 
> > #> su - db2inst1
> > #> db2 "connect to GOYALDAP user db2inst1 using
> dub13+"
> >                          <or>
> > #> db2 "connect to GOYALDAP user db2inst1 using
> secret"
> > #> db2 "list tablespaces"
> 
> DB2 connection works fine with the user db2inst1 and
> I can play with the
> tables in my database. I also created the test
> database from the
> "../lapd/back-sql/rdbms_depend/ibmdb2" directory
> without problems. Even
> the isql program from the unixODBC package connects
> me to the database
> and lets me view the tables...
> 
> 
> > If the su - fails... well... enough said. If one
> the above connect commands
> > works, there are possible inconsistencies
> regarding passwords in your
> > slapd.conf and odbc.ini which you need to
> investigate:
> 
> Ooops, the 2 different passwords is a copy & paste
> mistake. In reality
> they are the same. :)
> 
> >      dbname GOYALDAP
> >      dbuser db2inst1
> > >> dbpasswd dub13+ <<
> > 
> >      Database        = goyaldap
> >      Servername      = localhost
> >      UserName        = db2inst1
> > >> Password        = secret <<
> > 
> > If neither of the above db2 connect commands work,
> your db2 instance/db is
> > misconfigured or does not exist... and that's
> definitely off topic for this
> > list.
> > 
> > Regards,
> > 
> > Colin
> > 
> 
> 
> 
> 
> 
> 


=====
( >-                                           -< )
/~\    ______________________________________   /~\
|  \) /    Scaling FLOSS in the Enterprise   \ (/ |
|_|_  \        trevorwarren@yahoo.com        / _|_|
       \____________________________________/


	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/