RE: AW: string function

2005-06-22 Thread 王 旭
Thanks! elke From: "Zabach, Elke" <[EMAIL PROTECTED]> To: "? ?" <[EMAIL PROTECTED]>, Subject: AW: string function Date: Wed, 22 Jun 2005 11:07:29 +0200 [EMAIL PROTECTED] wrote > > How can i get the start-position of string "s1" in string "s2". > e.g. S1 = name > S2 = myname. > start-

how about load_balance

2005-06-22 Thread liu xiaotao
Hi! when I run maxdb on RedHat9.0,I used top to monitor the process and thread.I found cpu always be occupied by maxdb's one kernel thread and the thread id don't change. This thread occuped 23-30% of cpu time, othre kernel thread or vserver thread only occupied 0.1%-0.2%。At that time the ca

RE: 32 bit -> 64 bit migration

2005-06-22 Thread Döhr, Markus ICC-H
> We're going to be upgrading from a 32-bit linux -> 64-bit > (opteron) system. We did this on Itanium-2, install the fresh system including the database and then backup and restore the database. This is the fastest way IMHO. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP

RE: JDBC driver sees Users not Schemas

2005-06-22 Thread Schroeder, Alexander
Hello Jaime, which version of the jdbc driver do you use (java -jar sapdbc.jar -V), and which version does the database have. Take care also that each user has at least one schema having the same name as the user. So, in which way your output differs from the result of SELECT * FROM SCHEMAS Rega

RE: 32 bit -> 64 bit migration

2005-06-22 Thread Kevin Wilson
You will be best off doing a clean installation of the 64-bit version of maxdb then doing a import. The complete backup pops in quite nicely between platforms. -Original Message- From: Ken Snider [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 9:45 AM To: maxdb@lists.mysql.com Sub

JDBC driver sees Users not Schemas

2005-06-22 Thread Jaime Thomson
I am connecting to an instance of MaxDB, but instead of the schemas I am getting a list of the users. Has anyone run into this problem before -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

32 bit -> 64 bit migration

2005-06-22 Thread Ken Snider
Greetings! We're going to be upgrading from a 32-bit linux -> 64-bit (opteron) system. When we migrated mysql, the on-disk format was bit-agnostic, and we were able to copy the physical on-disk database files across without issue. Will we be able to do this with MaxDB, or will we be forced to

Re: instance in strange state

2005-06-22 Thread Robert Klemme
Unfortunately not an answer to your question but another strange issue: the db seems to be running but doing nothing for 2 days. You cannot connect to it from other hosts but locally using dbmcli - if the user is root: Remote: 14:38:19 [pgm]: ./dbmcli -u dba,*** -d cr -n crdb Error! Connecti

AW: string function

2005-06-22 Thread Zabach, Elke
[EMAIL PROTECTED] wrote > > How can i get the start-position of string "s1" in string "s2". > e.g. S1 = name > S2 = myname. > start-position is 2.(Begin position is zero) > As the reference-manual tells us: http://dev.mysql.com/doc/maxdb/en/cd/c300ebb9b011d2a97100a0c9449261/frameset.htm

string function

2005-06-22 Thread 王 旭
How can i get the start-position of string "s1" in string "s2". e.g. S1 = name S2 = myname. start-position is 2.(Begin position is zero) _ 与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn -- MaxDB Discussion Ma