Re: Task State "RootShare"

2004-09-07 Thread Axel Busch
to add or remove another leaf to the btree. regards, Uwe -Original Message- From: Axel Busch [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: Task State "RootShare" Hi, I was dumping the task state of our database instance durin

Task State "RootShare"

2004-09-07 Thread Axel Busch
Hi, I was dumping the task state of our database instance during a sudden increase in database connections (from 2 to 150 in 10 seconds) with x_cons, and ran across the state "RootShare". This state is not documented, but since most of the tasks are in this state, I would be _very_ interested in wh

AW: Hot Standby with MAXDB documentation

2004-03-06 Thread Axel Busch
Hi Kevin, Yves Trudeau did and documented (http://sapdb.2scale.net/moin.cgi/SapDbHaHowto) a way to set up a standby solution (thanks, Yves). We will now try something like this with the hot standy feature, except that we prefer Heartbeat. 'Course we will gladly share our experiences. regards, A

AW: Problme while installing. 7.4.3.31.

2004-02-25 Thread Axel Busch
Hi Chris, this does most likely mean that the database is (somehow) already running. Check in the process list in the Taskmanager for "kernel.exe" Kill the Process kernel.exe and retry. regards, Axel > -Ursprüngliche Nachricht- > Von: Christoph Weser [mailto:[EMAIL PROTECTED] > Gesendet

Error starting sadb: -24988, sql error [db_warm -f]; 1,database not running

2004-02-18 Thread Axel Busch
Hi, this morning after reboot my sapdb instance is not coming up (Windows XP). The Error message is: -24988, sql error [db_warm -f]; 1,database not running Strange enough, the kernel.exe process is running. So I killed kernel.exe, shut down the service in the control manager and tried again. The

RE: sqlcreatetls -odbc related crashes

2004-02-17 Thread Axel Busch
however is utterly unimpressed. This happens with ODBC Driver 7.3 and 7.4. regards, Axel > -Ursprüngliche Nachricht- > Von: Axel Busch [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 17. Februar 2004 09:05 > An: 'Ajit Aranha'; [EMAIL PROTECTED] > Betreff: AW:

AW: sqlcreatetls -odbc related crashes

2004-02-17 Thread Axel Busch
Hi Ajit, > >>I checked the SAP DB sources and found the definition and > >>various references to the function, so its not a problem of > >>the ODBC Driver.=20 > > Alex, I encounter a problem with a program that just runs in a > loop creating connections and disconnecting them using > odbc(7.3 an

sqlcreatetls : Nicht genügend Speicher / Not enough memory. Could not write to event log

2004-02-16 Thread Axel Busch
hi, i have a rather nasty problem on a Windows 2000 Advanced Server running SAPD DB "KERNEL 7.4.3 BUILD 027-123-048-452": A NT Service runs under an administrative account and periodically connects to the SAP DB which is installed on the same machine. Sometimes ODBC::connect fails with an Applic

AW: more SAP DB / MaxDB Documentation available

2004-02-16 Thread Axel Busch
Hi, > the biggest advantage of Stefan Wichmann's book is that it is > available. Are there other books? > > Personally, I do not like this book (yet). I bought it late last year. > I find the structure unclear, chapters too long, convoluted > sequence of items. > What annoys me most is the large

AW: AW: MAXDB Success Story

2004-02-16 Thread Axel Busch
r windows version > of sapdb to > sapdb runing under Linux redhat 9 > > in sapdb documentation has never heard about that > > contrary to what I read in this document in this mailing list always > saying that backup are platform independent, please correct > me

more SAP DB / MaxDB Documentation available

2004-02-16 Thread Axel Busch
Hi, for all of you who are interested in some bedtime lecture on our beloved database: 1) the "Book SAP DB / MaxDB" from Stefan Wichmann If you speak german, get it. This book is very helpfull. It gets you started as a beginner and is also pretty good as a reference manual. Thanks, Stefa

AW: MAXDB Success Story

2004-02-16 Thread Axel Busch
Hi Markus, nice to read your success story. We are also very happy with our sapdb for two years now. About 30 installations, ranging from 4 to 2000 users. This thing is just awesome. We compiled a documentation dealing with Installation and Administration under Windows and Linux. The guys from SA

SAP DB on Mac OS X, OpenBSD?

2004-02-15 Thread Axel Busch
Hi, did anyone ever try to build SAP DB on OS X or OpenBSD from the sources? regards, Axel -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: AW: embedded SAP DB / unattended installation

2004-02-10 Thread Axel Busch
a bit longer. For updates, I have been doing: > > sdbinst -batch -profile all > sdbupd -batch -d XXX -u UUU,PPP -package all > > Good luck! > Mark > > Axel Busch wrote: > > >Hi Matthias, > > > >thank you for your comment. However, that was not what

AW: embedded SAP DB / unattended installation

2004-02-10 Thread Axel Busch
mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 10. Februar 2004 12:28 > An: [EMAIL PROTECTED] > Betreff: Re: embedded SAP DB / unattended installation > > Am Dienstag, 10. Februar 2004 09:17 schrieb Axel Busch: > > Hi, > > > > i would like to use SAP DB in a kind of

embedded SAP DB / unattended installation

2004-02-10 Thread Axel Busch
Hi, i would like to use SAP DB in a kind of embedded environment. Does SAP DB provide a method of unattended/automatic installation? I checked the installation log for windows. Is copying the files, setting the windows registry keys and adding the entries to the services file really enough? H

AW: AW: Unattended database

2004-02-07 Thread Axel Busch
Hi, > I have couple more questions, > > > set the Data cache to the maximum memory you can spare and > > increase the number of semaphores. Get back to me if you need > > more info on that. > Why would you do this? Data Cache: Your Database will grow eventually. Queries will return more resul

AW: Unattended database

2004-02-06 Thread Axel Busch
Hi, > -Ursprüngliche Nachricht- > Von: Zabach, Elke [mailto:[EMAIL PROTECTED] --cut-- > And UPDATE STATISTICS (as mentioned in another mail) will not recreate > anything, just count the number of rows/pages/different > values in indexes/columns, > which does not seem to be what you were

AW: Unattended database

2004-02-05 Thread Axel Busch
Hi Miro, > Let say I have 40GB HDD and I can spare 30GB. Do you have nay > suggestions as to how to structure it and potentially about > any special parameters to set? set the Data cache to the maximum memory you can spare and increase the number of semaphores. Get back to me if you need more

AW: sql scripts with SQL Studio ...

2004-01-28 Thread Axel Busch
Hi Chris, i changed your script to work with sapdb (attached sqpdb2.sql) replace "--" with "//--" replace "--//" with "--" replace ";" with "\n;" regards, Axel > -Ursprüngliche Nachricht- > Von: Chris Joelly [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 28. Januar 2004 18:28 > An:

AW: cannot create reply fifo ( SAPDB 7.3.00.34)

2003-12-11 Thread Axel Busch
Hi Markus, > > [EMAIL PROTECTED]:/usr/spool/sql/fifo> ls -l insgesamt 0 > > -rw-rw-rw-1 sapdbroot0 2003-12-11 08:43 > > ckeckdone_INTRANET > > Who's starting the DB - root? If not, change the permissions for no, "sapdb" is. btw, this was already printed in the email: > > [

AW: cannot create reply fifo ( SAPDB 7.3.00.34)

2003-12-11 Thread Axel Busch
intranet) is down and won't wake up. *cry*. Ideas? regards, Axel > -Ursprüngliche Nachricht- > Von: news [mailto:[EMAIL PROTECTED] Im Auftrag von Daniel Dittmar > Gesendet: Donnerstag, 11. Dezember 2003 01:07 > An: [EMAIL PROTECTED] > Betreff: Re: cannot create rep

AW: AW: Fedora Linux - Error 24875

2003-12-11 Thread Axel Busch
MD5 passwords. At least, > I don't think I am. Does Fedora turn this on by default? > Luckily this is only a development box, so I can do what > I want on it. Can you tell me how I can check? > > Funny thing is, I didn't have this problem on Redhat Linux 9 Weird! >

cannot create reply fifo ( SAPDB 7.3.00.34)

2003-12-10 Thread Axel Busch
Hi, strange things here: When I tried to connect to my SAP DB 7.3.00.34 instance on SuSE 8.2 (which was 5 minutes ago running just nicely) with DBMGUI to make a backup, I suddenly got --- Error --- -4 socket receive error [10053] -

AW: AW: ODBC connection string (Windows 2000) & dbmcli command

2003-12-09 Thread Axel Busch
Hi Ian, > Hi Alex - Axel ;) > I know about all the details you gave me - I was > trying a UDL file before I mailed the group, and used the DSN > entry created by the installation (MAXDB) to create a system DSN also. > > But no connection - constantly rejected with "-4008 Unkown > username/

AW: ODBC connection string (Windows 2000) & dbmcli command

2003-12-09 Thread Axel Busch
Hi Ian, first you have to create a DSN in the odbc manager control panel -> administration -> data sources (odbc) or just execute c:\winnt\system32\odbcad32.exe. - Choose , - select the MaxDB driver you installed from the MaxDB Server package (or SAP DB 7.4 ODBC driver, it works as well) - Cho

AW: good book for sap db (maxdb)

2003-12-08 Thread Axel Busch
> -Ursprüngliche Nachricht- > Von: Christoph Weser [mailto:[EMAIL PROTECTED] > > I've seen this morning, that it is now available with a > shipping time of 1-2 weeks. 3 days now ;) I just ordered it and will file a report as soon as I get it. Also I'm about to complete a Documentati

WebDBM / DBM GUI not working with MD5 passwords enabled

2003-12-08 Thread Axel Busch
Hi, looks like WebDBM, DBM GUI and DBMCLI have problems creating a database on a remote host when the host has MD5 passwords enabled. (WebDBM tells me that the user is not a DB Administrator and DBM GUI thinks it got the wrong username /password combination. haha.) The workaround after half