Re: several transactions on various threads within one application

2003-10-27 Thread Daniel Dittmar
Mark Johnson wrote: Does the same constraints (???) apply to the ODBC driver? i.e., - what we want to do is share a single connection with multiple threads. Each thread creates its own statement handles, etc. from the shared connection. Is the ODBC driver (with a shared connection handle) th

Re: SAPDB Database Creation problem

2003-10-27 Thread Daniel Dittmar
Sjoerd van Leent wrote: When I want to create a database I have a problem. Since there is as far as I know no specific user list for database creation, I think that the Active Directory is used. However, when creating a database, remote or local using either the GUI or WebDBM I constantly get an er

Re: Build error. ... SapdbOwner not found: Open Registry:No such file or directory

2003-10-27 Thread Daniel Dittmar
andy wrote: > Hi, > I want to build from source on Redhat 8.0, everything is ok till I met this problem: Sorry for not answering earlier, but some work was required to the cvs depot. Short answer: - please checkout sapdb-743 instead of sapdb-74 (it's quite a bit more because tests are now inclu

Re: problem with max user tasks on SAPDB 7.4

2003-10-27 Thread Daniel Dittmar
Marcel Toma wrote: When I try to set the "max users task" greater than 180 I get a error during the database initialization Does anyone know why? Some resource is probably missing. Try knldiag (http://sapdb.2scale.net/moin.cgi/knldiag), perhaps some error message is more specific. Daniel Dittm

Re: several transactions on various threads within one application

2003-10-27 Thread Mark Johnson
Does the same constraints (???) apply to the ODBC driver? i.e., - what we want to do is share a single connection with multiple threads. Each thread creates its own statement handles, etc. from the shared connection. Is the ODBC driver (with a shared connection handle) thread safe? Or is th

Re: several transactions on various threads within one application

2003-10-27 Thread Daniel Dittmar
Tom Skalik wrote: Is it possible to run the several database transactions on various threads within one application created using sapdb embedded C++ precompiler under Linux system? Yes, you have to CONNECT (http://www.sapdb.org/7.4/htmhelp/f0/a283fdee4c487a813240a2f5f1c5fc/frameset.htm) for eac

SAPDB Database Creation problem

2003-10-27 Thread Sjoerd van Leent
Hello all, This is the first time I use SAPDB, I formerly used MYSQL and lots of others but I am new to SAPDB. I managed to install it together with the Web tools and GUI Client on a Win32 2003 system. When I want to create a database I have a problem. Since there is as far as I know no spe

ANN: 7.4.03/develop and tests now available via CVS

2003-10-27 Thread Dittmar, Daniel
The development tree for release 7.4.03 is now available via CVS: cvs -z5 -d :pserver:[EMAIL PROTECTED]:/cvsroots/sapdb checkout -P sapdb-743 Regression tests are now included, see sapdb-743/tests.readme for details Any releases using the product name SAP DB will come from this branch. It will

Re: problem with max user tasks on SAPDB 7.4

2003-10-27 Thread Marcel Toma
sorry, I meant 100 I got a error when to initialize the database with "max users task" greater than 100 On Mon, 27 Oct 2003 15:06:43 -0200, "Marcel Toma" <[EMAIL PROTECTED]> escreveu: > De: "Marcel Toma" <[EMAIL PROTECTED]> > Data: Mon, 27 Oct 2003 15:06:43 -0200 > Para: [EMAIL PROTECTED] > Assun

problem with max user tasks on SAPDB 7.4

2003-10-27 Thread Marcel Toma
When I try to set the "max users task" greater than 180 I get a error during the database initialization Does anyone know why? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: AW: SapDB/ E-Catalog - DBM GUI Errors !

2003-10-27 Thread whiskyworld.de
>> - how much >> would a SAPDB with this search feature cost ? - >There are no plans to create a 'product' out of this feature. A product would require end user >documentation, better integration with SAP DB, support for arbitrary applications etc. so, what solutions are existing to give the sa

RE: SAPDB with SuSE9.0 sapdb74

2003-10-27 Thread Dittmar, Daniel
> I've installed the rpms of SAP DB 7.4.3.27 on SuSE Linux 9.0. > > When I try with yast to start sapdb74 in the specified runlevels, the > links are not created. When I create the links myself, > sapdb74 doesn't > start. You have to edit the file because it must contain the names of the datab

RE: AW: SapDB/ E-Catalog - DBM GUI Errors !

2003-10-27 Thread Dittmar, Daniel
> Emm, isn't this sth. that should be listed in the manual ??? I think the next version of the documentation no longer mentions this instance type. > - how much > would a SAPDB with this search feature cost ? - There are no plans to create a 'product' out of this feature. A product would requir

RE: what parameter controls how many kernel processes start up

2003-10-27 Thread Dittmar, Daniel
> The settings I had before I updgrade to 7.4 got wiped out, > and I don't see > a parameter to control how many kernel processes start when > the database > goes online. I have about twice as many as I need and they > are just chewing > up memory. Anyone know the answer? The parameter is c

RE: Index Specification

2003-10-27 Thread Becker, Holger
Renato Cramer wrote: > Is possible force the SAP DB to use an index specified in a SELECT > statement? With version 7.4 we introduce some optimizer hints but only for testing purpose. So there is no documentation about it. The SAP DB optimizer is a cost based one and should choose the index if

Re: Performance on DUAL processor

2003-10-27 Thread Yves Trudeau
Hi, I noticed the same. It seems that a single connection cannot use more than one CPU. I don't really bother with that since we have 30 users... Yves Marcel Toma wrote: I used slmon On Mon, 27 Oct 2003 12:17:23 +0100, "Döhr, Markus ICC-H" <[EMAIL PROTECTED]> escreveu: De: "Döhr, Markus IC

Re: select count(*) from (select * from tab)

2003-10-27 Thread Thomas Markus
Hi, I got this, when I order by a too long unicode column. In an non unicode db the order by with a varchar(1000) col works. After creating a unicode db that order by fails with this message. I had to resize the col. Now it works with varchar(500). bye [EMAIL PROTECTED] wrote: Hello If I execu

Re: AW: Performance on DUAL processor

2003-10-27 Thread Marcel Toma
you mean accessing the database? yes, we are using a system running on a hotel with lots of people accessing SAP throw resin-ee server On Mon, 27 Oct 2003 14:57:32 +0100, Thomas Cataldo <[EMAIL PROTECTED]> escreveu: > De: Thomas Cataldo <[EMAIL PROTECTED]> > Data: Mon, 27 Oct 2003 14:57:32 +0100

RE: Performance on DUAL processor

2003-10-27 Thread Marcel Toma
I used slmon On Mon, 27 Oct 2003 12:17:23 +0100, "Döhr, Markus ICC-H" <[EMAIL PROTECTED]> escreveu: > De: "Döhr, Markus ICC-H" <[EMAIL PROTECTED]> > Data: Mon, 27 Oct 2003 12:17:23 +0100 > Para: "'Marcel Toma'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Assunto: RE: Performance on D

Re: AW: Performance on DUAL processor

2003-10-27 Thread Thomas Cataldo
On Mon, 2003-10-27 at 11:57, Marcel Toma wrote: > yes, I set de amount of CPUs to 2 Just a stupid question, but do you have more than one user at a time during your tests ? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.c

Index Specification

2003-10-27 Thread Renato Cramer
Hi all, Is possible force the SAP DB to use an index specified in a SELECT statement? Thanks in advance. Renato Cramer Analista de Sistemas Depto. de Desenvolvimento Domínio Sistemas Ltda. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http:/

Duplicating db instances with Python

2003-10-27 Thread Oliver Walczak
Dear List, I had some short advances on a script that duplicates a database from a windows backup file to a linux host, but now i'm running into strange memory access violation errors when it comes to opening two database sessions one after another. For simplicity i send a shortened version of my s

RE: Performance on DUAL processor

2003-10-27 Thread "Döhr, Markus ICC-H"
> watching the performance of each processor I notice that sap > doesnt use both processor but 1 at time if one of the > processors reach 100% the it start using the other How do you notice that? What tool do you use? Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC,

Re: AW: Performance on DUAL processor

2003-10-27 Thread Marcel Toma
yes, I set de amount of CPUs to 2 On Mon, 27 Oct 2003 12:01:55 +0100, "whiskyworld.de" <[EMAIL PROTECTED]> escreveu: > De: "whiskyworld.de" <[EMAIL PROTECTED]> > Data: Mon, 27 Oct 2003 12:01:55 +0100 > Para: "Marcel Toma" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Assunto: AW: Performance

AW: Performance on DUAL processor

2003-10-27 Thread whiskyworld.de
Hmm, have you told SAPDB to use 2 Processors ?? - when you create a new DB instance you are asked to specify many vars - one of it is amount of CPUs, standard is 1 and unless this is set to 2 it will only use 1 at a time to spare the other one for different apps for example Korbinian -Ursprü

Performance on DUAL processor

2003-10-27 Thread Marcel Toma
I installed SAP on a xeon dual processor usig linux (debian 3.0r1) watching the performance of each processor I notice that sap doesnt use both processor but 1 at time if one of the processors reach 100% the it start using the other why does this happen? -- MaxDB Discussion Mailing List For li

SAPDB with SuSE9.0 sapdb74

2003-10-27 Thread Henning Marwede
Hello, I've installed the rpms of SAP DB 7.4.3.27 on SuSE Linux 9.0. When I try with yast to start sapdb74 in the specified runlevels, the links are not created. When I create the links myself, sapdb74 doesn't start. What is the problem. TIA Henning -- MaxDB Discussion Mailing List For li

AW: AW: SapDB/ E-Catalog - DBM GUI Errors !

2003-10-27 Thread whiskyworld.de
Emm, isn't this sth. that should be listed in the manual ??? - how much would a SAPDB with this search feature cost ? - Korbinian Bachl www.whiskyworld.de PS: if the SAPDB E-Catalog dosnt work, why is it listed in the wizard ? -Ursprüngliche Nachricht- Von: news [mailto:[EMAIL PROTECTED]

RE: Some Warning when I run Java app?

2003-10-27 Thread Schroeder, Alexander
Hi, I doubt that this warning is emitted from MaxDB, but instead of your application server (Servlet etc.). So please look there. Alexander Schröder SAP DB, SAP Labs Berlin > -Original Message- > From: dinh thanh [mailto:[EMAIL PROTECTED] > Sent: Sunday, August 17, 2003 4:09 AM > To: [E

several transactions on various threads within one application

2003-10-27 Thread Tom Skalik
Hallo, Is it possible to run the several database transactions on various threads within one application created using sapdb embedded C++ precompiler under Linux system? Best Regards, Tom T.Skalik KUCERA IPC +49 69 7171 3580

RE: Open sql

2003-10-27 Thread Zabach, Elke
De Luna Gomez, Miguel wrote (unfortunately only directly to one guy, not to the list): > > HI I was checking the news and I found you answering a > question related to opensql. We are changing some portal > stuff to open sql and one problem came up. > > When doing a join there is an error s

unexpected termination of SAPDB service

2003-10-27 Thread Gerd König
Hi, a few weeks ago we had a stand-still of our SapDB and we wondered why, because the status we checked before was O.K. Unfortunately this happens regularly now, and we don't know what to do. After checking the event log we found "Error 7031: The SAPDB:DBNAME service terminated unexpectedly."

loadercli Trouble once again

2003-10-27 Thread Carsten Tolkmit
.4.3Build 027-121-048-452 // * // M Loaderinstance started at khorne // * // MStarting protocol at 2003102700083315 // * // * // * // MSTART 2003102700083315 // * SET // * // MSTART 2003102700083315 // * USE USER "OIKOTEST" * SERVERDB "TN