RE: Uninstalling SAPDB 7.4 (rpm)

2003-12-01 Thread Schmoger, Daniel
Hi Martin, sdbuninst is part of tgz package installation. to uninstall SAP DB rpm packages do this: rpm -e `rpm -qa | grep sapdb` bye, daniel > -Original Message- > From: Martin Cordova S. [mailto:[EMAIL PROTECTED] > Sent: Montag, 1. Dezember 2003 16:04 > To: [EMAIL PROTECTED] > Subje

SAPDB clustering / High availability

2003-12-01 Thread Ajit Aranha
Hi, Am looking for pointers to setting up sapdb 7.3/7.4/ (maybe maxdb???) for high availability/Clustering. Pls. Can u direct me to info about the same. Regards, Ajit -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMA

Query optimizer - join observation - MaxDB 7.5

2003-12-01 Thread Stephen Gutknecht (SAPDB)
I don't know how most DBMS systems behave, but MaxDB 7.5 Explain shows that the following SQL statement generates a ton of I/O: SELECT * FROM TableA, TableB, TableC WHERE TableA.A1 (+) = TableB.B1 AND TableA.A2 (+) = TableC.C1 AND 1=2 It seems to do the I/O for the joins, despite the

RE: sapdb

2003-12-01 Thread Dittmar, Daniel
> # rpm -Uhv sapdb-srv74-7.4.3.30-1.i386.rpm > error: failed dependencies: > sapdb-ind >= 7.4.3.30 is needed by sapdb-srv74-7.4.3.30-1 > sapdb-ind >= 7.4.3.30 is needed by sapdb-srv74-7.4.3.30-1 You must also download and install the package with the version independent software:

RE: sapdb

2003-12-01 Thread Kevin Wilson
this implies to me that you must have the x.30 installed prior installing the x.30-1 update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 10:42 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: sapdb Hi, Iam trying to install

RE: Setup SAPDB as DB for WebSphere

2003-12-01 Thread ilacosta
The result of the query is "INTERNAL", as I suposed. We don´t use DriverManager directly, because the url connection is defined in the JNDI space of WebSphere. This url contains "...?sqlmode=oracle", but may WebSphere cuts this piece of the url ?. I think, fixing this property in the url connecti

sapdb

2003-12-01 Thread Jay . R . Jayatissa
Hi, Iam trying to install the sapdb on my Linux Server (Linux hlwsalx001 2.4.9-e.27enterprise #1 SMP Tue Aug 5 15:39:21 EDT 2003 i686 unknown) but Iam getting the following dependency error when executing the installation command # rpm -Uhv sapdb-srv74-7.4.3.30-1.i386.rpm error: failed depende

Backup run-time Error -2147417851

2003-12-01 Thread Darius Cooper
Trying to make a complete backup of the database (for the first time). [Using version 7.4.2.6 on Windows 2000 1) I define my media as a file. 2) Choose 'next step and select 'Recovery (without checkpoint)' 3) Start the backup. I get the following message: Run-time Error -2147417851 (80010105)

MacOS X port of SAPDB / MaxDB

2003-12-01 Thread Yann Michel
Hi, is there any Mac OS X port of SAPDB or MaxDB availlable? Thanks in advance. Regards, Yann -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Setup SAPDB as DB for WebSphere

2003-12-01 Thread Schroeder, Alexander
If you use the JDBC 2.0 interfaces (DriverManager, with connect URL), this should work. Are you sure that the option comes through to the driver? You may do a SELECT A.SQLMODE AS SQLMODE FROM SHOW_CONNECT_PARAM A, SHOW_USER_CONNECTED B, SHOW_USER_CURRENT C WHERE A.SESSION=B.SESSIO

RE: websql cannot connect to database

2003-12-01 Thread Auer, Wolfgang
Hi Poorni, did you start the x_server of the database? http://www.sapdb.org/7.4/htmhelp/ba/e286de8c9b11d5993100508b6b8b11/content.htm Regards Wolfgang -Original Message- From: poornima ponnuswamy [mailto:[EMAIL PROTECTED] Sent: Montag, 1. Dezember 2003 16:01 To: [EMAIL PROTECTED] Subject

Uninstalling SAPDB 7.4 (rpm)

2003-12-01 Thread Martin Cordova S.
What's the proper way to uninstall an RPM based installation of SAPDB 7.4? rpm -e ?? I can't find the sdbuninst program. Regards, Martin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

websql cannot connect to database

2003-12-01 Thread poornima ponnuswamy
Hi everyone, I am using RH9.0 and sapdb 7.4. I created a database instance and I am able to use sql commands using dbmcli. But when I tried to use websql I am not able to connect to the database and I get the error ODBC-Error: [SAP AG][LIBSQLOD SO][SAP DB]Unable to connect to data source;-709 CON

SAPDB OLAP instance type

2003-12-01 Thread Martin Cordova S.
Where can I find more information about the OLAP instance type?. I already searched the SAPDB (7.4) online docs, but only found the OLAP instance type definition, nothing else. Regards, Martin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:h

Setup SAPDB as DB for WebSphere

2003-12-01 Thread ilacosta
Hello, we are building an web application for WebSphere and SAP DB. Our first version did not use connection pool. Now, we are triying to setup WebSphere for this. We defined the DB in WebSphere (i think correctly and in "custom properties" fro the DataSource we wrote some like this: "jdbc:sapdb:

RE:Re: dbproc and OUT parameter

2003-12-01 Thread Anhaus, Thomas
Jean-Michel OLTRA wrote : >> You are asking for dynamic sql having parameters inside a db-procedure ? >> Sorry, this is still not possible. >> But you may return a cursor created by a dynamic sql statement. Example : >I know, I "just" want to fetch such a cursor in an OUT parameter. >the resultset

Log Devspace

2003-12-01 Thread Pierre du Plessis
Hello MaxDB users My SAPDB 7.3.0.42 was doing a logbackup today and it ended with the error -902 Now, when I try to restart the database, I get these kernel error log messages (See below) and a -24988, sql error, -902. It looks like my log devspace file is currupt. The last time I had this probl

RE: Floating point issue

2003-12-01 Thread Zabach, Elke
Gerald Nowitzky wrote: > > Some time ago, I have been reporting a problem concerning accuracy of > operands of trigonometric operations, which introduced the > need to scale > operands - float(...,15) -. It seems to be what is described in PTS # > 1121198 and 1121197. > > Although it should be

Re: dbproc and OUT parameter

2003-12-01 Thread '[EMAIL PROTECTED]'
Le lundi 01 décembre 2003, Anhaus, Thomas a écrit... bonjour, > You are asking for dynamic sql having parameters inside a db-procedure ? > Sorry, this is still not possible. > But you may return a cursor created by a dynamic sql statement. Example : I know, I "just" want to fetch such a c

RE: Problems with Windows 2000 installation

2003-12-01 Thread Zabach, Elke
Hi, after some private communication it was found out, that 1. Data Volume and Log volume are named the same, which can't work. At least one name has to be changed by the user. 2. the errormessage does not tell this very exactly. This will be changed by MaxDB. Elke SAP Labs Berlin > >

Re: maxdb odbc for windows / sapdb odbc is limited to 3sign

2003-12-01 Thread Thomas Stegbauer
Koetter, Thomas Theodor wrote: Hi Thomas, Hi thomas, -Original Message- From: Thomas Stegbauer [mailto:[EMAIL PROTECTED] Sent: Dienstag, 25. November 2003 17:09 To: Dittmar, Daniel Cc: [EMAIL PROTECTED] Subject: Re: maxdb odbc for windows / sapdb odbc is limited to 3sign Dittmar, Daniel

Floating point issue

2003-12-01 Thread Gerald Nowitzky
Some time ago, I have been reporting a problem concerning accuracy of operands of trigonometric operations, which introduced the need to scale operands - float(...,15) -. It seems to be what is described in PTS # 1121198 and 1121197. Although it should be fixed, I still observe some strange behavi

RE: OLAP work

2003-12-01 Thread Zabach, Elke
Low Ee Mien wrote > > > Hi all, ... > - does MaxDB have materialized views like Oracle? (is it the > snapshots feature or am I wrong on this) No, MaxDB does not have materialized views. Snapshots are snapshots of the whole database. Elke SAP Labs Berlin > > Thanks. > > > Low Ee Mien > S

OLAP work

2003-12-01 Thread Low Ee Mien
Hi all, I'm in the process of evaluating MaxDB 7.5.0.8 for OLAP-related work. Specifically, trying to get it to work with the Mondrian server (http://mondrian.sourceforge.net), and to see if MaxDB has any features that can offer performance benefits to OLAP queries (aggregations and such). Can so

RE:dbproc and OUT parameter

2003-12-01 Thread Anhaus, Thomas
Jean-Michel OLTRA wrote : > bonjour, >I'm trying to get a one row resultset in a OUT parameter within a >DBPROC with dynamic sql inside. >Sapdb version 7.4.3.27 >I read the archives and saw that it wasn't possible. >Is this still true ? >My dbproc fails You are asking for dynamic sql h