Re: AW: db_online problem

2004-07-15 Thread Ertan Kucukoglu
Hi, I am going to replace current system. So, I backup data. I did not restore. Below is my backup history. I see several HISTLOST messages. dbmcli on ozler>backup_history_list OK END 4030AECE0002| |HISTLOST |2004-02-16 13:51:42| |2004-02-16 13:51:42|

AW: AW: DB Reindex

2004-07-15 Thread Zabach, Elke
[EMAIL PROTECTED] wrote: > > How to do it on linux dbmcli? Why didn't you have a look in the list of dbmcli-commands (as I did) http://dev.mysql.com/doc/maxdb/en/30/cc213e225f9a0be1000a114084/frameset.htm finding after less than a minute of scrolling sql_recreateindex Recreating a Damaged

AW: Always UTF-8

2004-07-15 Thread Zabach, Elke
[EMAIL PROTECTED] wrote: > > How to configure my MaxDB databases instances data to be always in UTF-8 > format, with JDBC > There is no chance to store data in the database in UTF-8 format. You can store it in either ASCII or UCS2. To store UCS2 you have to set configuration parameter _UNICODE t

Re: AMD Opteron - Any new developments?

2004-07-15 Thread Dmitry Melekhov
[EMAIL PROTECTED] wrote: 1) Can MaxDB 32-Bit be successfully installed and ran on a Opteron system? Yes, I tested this, it works :-) -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

unixODBC odbc connection pooling

2004-07-15 Thread Michael Bielicki
I am trying to setup connection pooling with maxdb under unixodbc. single connect works but my application requires pooling which th4e odbc driver seems to not recognise. Is there anything specfic I have to do for that ? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/

Always UTF-8

2004-07-15 Thread maxdb
How to configure my MaxDB databases instances data to be always in UTF-8 format, with JDBC -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Anybody got MaxDBProxy running?

2004-07-15 Thread Sascha-Matthias Kulawik
The Access denies occures during the login with mysql -u DBA -s localhost Or mysqlfront. > -Original Message- > From: Döhr, Markus ICC-H [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 15, 2004 5:12 PM > To: 'Sascha-Matthias Kulawik'; '[EMAIL PROTECTED]' > Subject: RE: Anybody got MaxD

RE: Anybody got MaxDBProxy running?

2004-07-15 Thread Sascha-Matthias Kulawik
No, it has written the conquestdev.pid, Ive created the directory and after that a # chmod -R 777 /rel Any other ideas maybe? Is the backup file compatible between the latest final and the actual alpha version? > -Original Message- > From: Döhr, Markus ICC-H [mailto:[EMAIL PROTECTED]

Re: AW: DB Reindex

2004-07-15 Thread maxdb
How to do it on linux dbmcli? Marcin P wrote: Now it's clear :-) The easiest way is to go to Database Manager -> Recovery -> Index and then select the indices that may be corrupted and press "Recreate". Hope this helps, Marcin Uzytkownik <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECT

AMD Opteron - Any new developments?

2004-07-15 Thread Kevin . Wilson
1) Can MaxDB 32-Bit be successfully installed and ran on a Opteron system? 2) Is there any concrete plans as to when a x86_64 port could be expected?

AW: ERROR: Row too long

2004-07-15 Thread Zabach, Elke
Fabio Pinotti wrote: > > The column C_TREE_PATH is used inside many tables, and many queries in the > application are sorted by this field. > Because ORDER BY accepts a max length of 1000 chars, I used so far a > rtrim(substr(c_tree_path,1,1000). But I think it's not useful to have a > length of 4

RE: Descriptor and memory leak in odbc driver (from 7.3 to 7.5 i ncludes)

2004-07-15 Thread Koetter, Thomas Theodor
Hi Pavel > -Original Message- > From: Pavel Konovalov [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 15. Juli 2004 12:08 > To: [EMAIL PROTECTED] > Subject: Re: Descriptor and memory leak in odbc driver (from > 7.3 to 7.5 includes) [snip] > As I understand one of more solves of this proble

Re: ERROR: Row too long

2004-07-15 Thread Fabio Pinotti
The column C_TREE_PATH is used inside many tables, and many queries in the application are sorted by this field. Because ORDER BY accepts a max length of 1000 chars, I used so far a rtrim(substr(c_tree_path,1,1000). But I think it's not useful to have a length of 4000 when I can use only 1000. So I

RE: Anybody got MaxDBProxy running?

2004-07-15 Thread Döhr, Markus ICC-H
> 040715 15:18:27 ./MaxDBProxy: Can't create/write to file > '/rel/mysql-4.0-bin-new/var/conquestdev.pid' (Errcode: 2) > ive created the directory - but no success, I'm getting > "Access denied" all the time. Maybe the user that is running the database or the proxy can't write to this directory

AW: Dropping a temporary table...

2004-07-15 Thread Anhaus, Thomas
Xavier Camier wrote : > >Hello, > >I attempt to create a stored proc which : > >1) SELECT some datas and put the to a cursor > >2) CREATES a temp table from the cursor >eg : CREATE TABLE TEMP.TOTO AS SELECT * FROM MYCURSOR > >3) Works on the TEMP.TOTO table. > > >My problems occurs when I try to l

Dropping a temporary table...

2004-07-15 Thread Xavier CAMIER
Hello, I attempt to create a stored proc which : 1) SELECT some datas and put the to a cursor 2) CREATES a temp table from the cursor eg : CREATE TABLE TEMP.TOTO AS SELECT * FROM MYCURSOR 3) Works on the TEMP.TOTO table. My problems occurs when I try to launch the DBProc more than once. The TOTO

Anybody got MaxDBProxy running?

2004-07-15 Thread Sascha-Matthias Kulawik
Ive installed the Alpha2 and tried to use the maxdbproxy. The DB is running on a Debian GNU/Linux. Once ive tried to start the MaxDBProxy directly from my desktop with --console --dbserver="devserverip" --dbname="DEVDB" as well as starting it from the machoine directly with: --console --dbserver=

RE: Port configuration

2004-07-15 Thread Dittmar, Daniel
> I have one SAP DB 7.4.3 installation my computer. > Is it posible to configure 2 (or more) DB instances, to > listen on 2 (or > more) TCP/IP ports? > I'm using Windows OS and I'm connecting via ODBC. > > If there is no such possibility, how can I recognise which > TCP/IP packet > belongs t

AW: 24988 sql error using Database Manager GUI

2004-07-15 Thread Zabach, Elke
Rebecca E. Grenier wrote: > > Hi all, > > I am a new user trying to set up a MySQL database on my Windows XP > computer. I > have downloaded the Database Manager GUI and it *seems* to be working even > though it continually throws the -24988 sql error, unknown user > name/password > combo even t

AW: Call a Stored Procedure from another Stored Procedure

2004-07-15 Thread Zabach, Elke
news wrote: > > Hi All, > > How can I call a Stored Procedure from another Stored Procedure? > > Basic problem is that I have created a Stored Procedure with DECLARE CURSOR statement>, which forces a SELECT statement just after > the , but before returning I need > some more processing with the

AW: ERROR: Row too long

2004-07-15 Thread Zabach, Elke
Fabio Pinotti wrote: > > Hi, > I have the "Row too long" error with the following query: > > SELECT > b.K_SUBJECT_TYPE, > b.N_SUBJECT_TYPE, > to_char(GET_HRC_LEVEL(rtrim(substr(b.C_TREE_PATH,1,1000)),null)-1) > FROM > (SELECT rtrim(substr(C_TREE_PATH,1,1000)) C_TREE_PATH > FROM SUBJECT_TYPE

Port configuration

2004-07-15 Thread Dusan Kolesar
Hello, I have one SAP DB 7.4.3 installation my computer. Is it posible to configure 2 (or more) DB instances, to listen on 2 (or more) TCP/IP ports? I'm using Windows OS and I'm connecting via ODBC. If there is no such possibility, how can I recognise which TCP/IP packet belongs to which DB in

AW: db_online problem

2004-07-15 Thread Brunzema, Martin
Hi, what do you mean by "I tried to have full backup": Did you backup data or did you restore data? If you restored data it may be the case that your LogVolume does not match the restored state of your Datavolume. Have a look into your backup-history and see which logbackups you have to recover.

Call a Stored Procedure from another Stored Procedure

2004-07-15 Thread QA
Hi All, How can I call a Stored Procedure from another Stored Procedure? Basic problem is that I have created a Stored Procedure with , which forces a SELECT statement just after the , but before returning I need some more processing with the result of . I would like to call the another stored p

Re: AW: renaming column name -> error 28534 SOLVED

2004-07-15 Thread Filip Sergeys
thank you!! Regards Filip On Thu, 2004-07-15 at 12:28, Anhaus, Thomas wrote: > Filip Sergeys wrote : > > > > >Hi, > > > >When trying to rename a column name, I receive error 28534. THe > >strangest part is the string following "recreated". This is exactly how > >it appears in the error message.

AW: renaming column name -> error 28534

2004-07-15 Thread Anhaus, Thomas
Filip Sergeys wrote : > >Hi, > >When trying to rename a column name, I receive error 28534. THe >strangest part is the string following "recreated". This is exactly how >it appears in the error message. Doesn't seem to be normal. Is my >database on its way to the "eternal fields" because of catalo

renaming column name -> error 28534

2004-07-15 Thread Filip Sergeys
Hi, When trying to rename a column name, I receive error 28534. THe strangest part is the string following "recreated". This is exactly how it appears in the error message. Doesn't seem to be normal. Is my database on its way to the "eternal fields" because of catalog corruptions or something? Ge

Re: Descriptor and memory leak in odbc driver (from 7.3 to 7.5 includes)

2004-07-15 Thread Pavel Konovalov
- Original Message - From: "Koetter, Thomas Theodor" <[EMAIL PROTECTED]> To: "'Pavel Konovalov'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, July 15, 2004 4:22 PM Subject: RE: Descriptor and memory leak in odbc driver (from 7.3 to 7.5 includes) Thanks, Thomas, for operative an

AW: Problem with rownum

2004-07-15 Thread Zabach, Elke
Fabio Pinotti wrote: > > Hi, > is it possible to run a query like this (Oracle mode)? > > "Select rownum+1 from table" > > > SqlStudio gives me the following error: > > General error;-7036 POS(17) ROWNO specification not allowed in this > context. > As the kernel tells you with its erro

AW: Recursive DECLARE CURSOR statement

2004-07-15 Thread Zabach, Elke
QA wrote: > > Hi Elke, > > I just upgraded to 7.5.00.15 and still getting the same error. Bug is fixed with the next version. Workaround is available: In the dbproc: Create a temp-table looking like the view-result would look like. Insert into temp-table select * from Then do the recursive sel

AW: Recursive DECLARE CURSOR statement

2004-07-15 Thread Zabach, Elke
news wrote: > > Hi Thomas, > > It does not work. > That is a very short info. May we ask what is going on, which error occurs or if there are not the results expected or what do you mean with 'It does not work'? Maybe it is this we found out in the meantime: error Owner must be specified com

RE: Descriptor and memory leak in odbc driver (from 7.3 to 7.5 i ncludes)

2004-07-15 Thread Koetter, Thomas Theodor
Hi Pavel, > -Original Message- > From: Pavel Konovalov [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 15. Juli 2004 10:49 > To: [EMAIL PROTECTED] > Subject: Descriptor and memory leak in odbc driver (from 7.3 > to 7.5 includes) > > > > > It is likely that a descriptor and memory leak i

RE: ODBC bugs/ crashes

2004-07-15 Thread Koetter, Thomas Theodor
Hi Ajit > -Original Message- > From: Ajit Aranha [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 15. Juli 2004 09:13 > To: [EMAIL PROTECTED] > Subject: ODBC bugs/ crashes > > > Hi, > I am attempting to reuse ODBC connections (pooling) > I'm encountering some problems: > 1.The exe cras

Descriptor and memory leak in odbc driver (from 7.3 to 7.5 includes)

2004-07-15 Thread Pavel Konovalov
It is likely that a descriptor and memory leak in the MaxDB ODBC driver on Wondows 2000 . So, the number of descriptors and allocate memory in test process in Windows system monitor before performing and after that get the increase first once in 82 but then in 4 descriptors on every Open/Close o

db_online problem

2004-07-15 Thread Ertan Kucukoglu
Dear All, I have a db on FreeBSD system. SapDB version is 7.4.3.27. Recently I tried to have full backup. I do not understand what I did wrong but at the moment my db can not go inline. ozlerplastik# /usr/local/sapdb/depend/bin/dbmcli -d OZLER -u dbm,dbm db_admin OK ozlerplastik# /usr/local/sap

ODBC bugs/ crashes

2004-07-15 Thread Ajit Aranha
Hi, I am attempting to reuse ODBC connections (pooling) I’m encountering some problems: 1. The exe crashes if I allocate a connection from one thread and disconnect it from different thread 2. Also a variation of this earlier bug still exists in the latest 7.4 driver The old bug: PTS: 11

AW: Backup Online-Logs

2004-07-15 Thread Brunzema, Martin
Hi Hans-Joachim, in releases prior to 7.5.00 Build 8 it is not possible to save the last written logpage, because it is in access by the LogWriter. So any comits, which will be on this Logpage will not be saved. And if only this one page needs to be saved you will get -123 as returncode, because n