On Tue, Dec 16, 2003 at 12:01:55PM +0700, David Garamond wrote:
> Sven K?hler wrote:
> >I was very disappointed by Interbase/Firebird. It seemed to me like a
> >MS-Access: a database-engine that works on regular files
>
> Firebird seems simple, but it doesn't mean it's inferior or
> [intentional
Sven Köhler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's inferior or
[intentionally] crippled like MS-Access. SQL server also works on
"regular files" (db is s
James
If you are also looking at non-Open Source DB's, I'd recommend you look at
Oracle. I've used it on Linux for e-commerce and it is solid as a rock.
Jerry
-
Jerry,
I too am evaluating databases for an Open Source project of mine and I have
MySQL, MaxDB and PostgreSQL on my system (the
Hi All,
Can anyone tell me, where I can find auto backup tools for SAPDB that
running on Windows...
Thanks,
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you very much, Simon. Your scripts did the trick and now SAPDB/MaxDB
works just fine on RedHat 9!!
(I had to rename your sapdb.sysconfig-1.0.7 script to sapdb.init-1.0.7 when
copying it to /etc/sysconfig.)
Because I was trying to use LD_ASSUME_KERNEL before without success, I
looked at you
On Tue, Dec 16, 2003 at 01:11:21AM +1100, Chris Nolan wrote:
>
> To backup those funky sleek MyISAM tables, you could just issue a
> LOCK TABLE statement or two (LOCK DATABASE?), do a FLUSH and copy
> the files. If I recall correctly, (and I'm sure sirs DuBois and
> Zawodny will find out where I
Salviski, Michael wrote:
Has anyone gotten the error "An error occurs by installing database 'CPD'!
-24988 sql error [util_execute INIT CONFIG]; -2008,Message not available"
when trying to create the first instance after installing SAP DB?
This happens quite often if you choose too small a data vo
frengo wrote:
What do you mean about dropped LGPL licence ?
If I understood well, on the website, MaxDb is STILL under GPL. Isn't it
With SAP DB, the kernel was licenced under the GPL and the client
libraries under the LGPL. With MaxDB, everything is licenced under the
GPL (or the MySQL ccommerc
Thorsten Mauch wrote:
Hi
I want to build the SAP-ODBC driver for windows. Unfortunatly is part of the
entire server src.
I read the sources readme but it seems it basicly refer to linux. Does
anyone build the SAPDB udner windows ?
or is a howto availble ? e.g. what compiler or tools (beside pytho
Thorsten Mauch wrote:
Hi all
I use sapdb 7.4.30 with the current ODBC driver.
I transferred a MSSQL database to SQLDB using the MS Transfer manger. I
found that all table names are created in lowercase.
Following ODBC queries seek for the uppercase tables, so a table not found
exception is
thrown.
Has anyone gotten the error "An error occurs by installing database 'CPD'!
-24988 sql error [util_execute INIT CONFIG]; -2008,Message not available"
when trying to create the first instance after installing SAP DB?
Thanks in Advance,
Mike
--
MaxDB Discussion Mailing List
For list archives: http:
Curtis Maurand wrote:
Matthew Stanfield said:
Hi,
Usually, i'll use "enum('0','1')" in place of a boolean type.
Curtis
[snip]
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the B
Hi,
Regarding backups, mysqlhotcopy locks all MyISAM tables named for backup
before copying the files. As a result, they are in a consistant state.
InnoDB and BDB tables need to be handled differently though, so you're
looking at 1 of 4 methods:
1. Shut the database down and copy the table spa
I thought that too. It definitely says that its distributed under the GPL on
the web site. This was one the reasons I downloaded it!
Best Regards,
James Bannon
(When in doubt, try honesty!)
-Original Message-
From: frengo [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 22:33
To: [EMAI
Hi
I want to build the SAP-ODBC driver for windows. Unfortunatly is part of the
entire server src.
I read the sources readme but it seems it basicly refer to linux. Does
anyone build the SAPDB udner windows ?
or is a howto availble ? e.g. what compiler or tools (beside python and
perl) are needed
Hi all
I use sapdb 7.4.30 with the current ODBC driver.
I transferred a MSSQL database to SQLDB using the MS Transfer manger. I
found that all table names are created in lowercase.
Following ODBC queries seek for the uppercase tables, so a table not found
exception is
thrown.
Can i adjust the ODBC
What do you mean about dropped LGPL licence ?
If I understood well, on the website, MaxDb is STILL under GPL. Isn't it
?
frengo
-Original Message-
From: Juergen Sauer [mailto:[EMAIL PROTECTED]
Sent: lunedì 15 dicembre 2003 15.45
To: Jerry Apfelbaum; [EMAIL PROTECTED]; [EMAIL PROTECTED]
S
Here's the latest - still no luck..
---
dbmcli on nms2>db_state
OK
State
ADMIN
---
dbmcli on nms2>param_startsession
OK
---
dbmcli on nms2>db_addvolume DATA c:\netvoyant\db\nms2\datadev02 F 64
ERR
-24974,ERR_XPSESSION: param session active
dbmcli on nms2>db_stop
ERR
-24994,ERR_RTE: runtime env
Hi,
I have attempted to install the SAP DB v7.4 drivers on one of our systems,
but encountered errors in the sqltypes.h file.
System:
Red Hat Linux 7.3 2.96-110
gcc 2.96
Perl v5.6.1
Other components installed:
DBI-1.38
DBD-ODBC-1.06
unixODBC-2.2.7
The errors were encountered with both of the
Hi,
I've used both PostgreSQL and MySQL on a Linux server and found both
setting up (using RPM) and maintaining them very easy (MySQL was slightly
easier to set up but I set it up after I was already proficient on
PostgreSQL, so perhaps comparing the ease of setup is unfair). Both are
well doc
Hello Alexander,
The JDK version is 1.4.1_02 but the same thing occurs with 1.4.2_02.
The results of getBigDecimal().doubleValue() is 5.225.
I created a test with gets String, Double and BigDecimal from that
field, and generated two traces from JDBC driver, the first is with my
old driver the la
Hi,
i think this will work,
DATALOAD TABLE s_entitytype
ETTID 1 NULL IF POS 1 =''
INFILE 'dat\entitytype.dat'
DELIMITER ''
NULL ''
but make shure that the value of the field is '' and not ' '.
rgds.
Albert
Jean-Michel OLTRA schrieb:
Le lundi 15 décembre
Hi Alexander,
all our Applications are web-based, so there is no other application
that could feed the cache.
But I think when dropping table and indexes, the cache for data that
belongs to that table is deleted too.
So did it makes any scence to delete only the data of the table and not
the
Firebird 1.5 definitely should be one of your options. It has a very
strong history, great support, and very lightweight hardware-wise while
having features that match any out there.
David
To: "'Jerry Apfelbaum'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject:RE: MySQL or M
Le lundi 15 décembre 2003, Christoph Weser a écrit...
bonjour,
> DATALOAD TABLE s_entitytype
> ETTID 1 DEFAULT NULL
> INFILE 'dat\entitytype.dat'
> DELIMITER ''
> NULL ''
> Missing data for specified column ETTID"
> Is this a bug or a feature? If it is a
Hello Clóvis,
Could you manage to make a vtrace from that situation, and
could you specify which platform (JDK and version) you use?
(see http://sapdb.2scale.net/moin.cgi/TroubleShooting)
Could you also try a getBigDecimal(), on this a 'doubleValue()'
and check the result? (This is basically wha
Hello,
it looks to me like the 1st query did not hit the data cache, and was punished
with lots of data I/O. All following queries possibly then feed from the cache
to a certain extend and need not to access the hard disk too often.
As dropping, loading, and backup already takes some time, and i
hi list,
the named odbc on http://www.mysql.com/maxdb is the version 7.05.00.00
with the following bugs. (named earlier in the list. now i made one list :)
- doesn't work on windows nt4
- in software under control it is named odbc 7.5 (instead of maxdb odbc
7.5) (btw: this happened also to sqls
Hello everyone.
I'm using the following statement to load data into a table using the
repmcli:
DATALOAD TABLE s_entitytype
ETTID 1 DEFAULT NULL
INFILE 'dat\entitytype.dat'
DELIMITER ''
NULL ''
The table is:
create table s_entitytype (
ETTID FIXED(3
Hi folks,
of course somebody could give me a hint for my questions.
We are running some applications with tables up to 5GB with SAPDB 7.4 on
Linux.
Each day we are getting the whole data again in partial steps (with size
from 0,1 GB to 1,5 GB) at different times.
At the Moment we are dropping
Hello Mario,
could you manage to get a JDBC trace? Is the database instance
for the working case running on W2K too, and for the errornous
case on Linux? If yes, could you manage to create a vtrace?
(see http://sapdb.2scale.net/moin.cgi/TroubleShooting on how
to create the various traces.)
Re
Hi, MaxDB Team
I'm using SapDB 7.3 with latest JDBC driver and I found the follow issue:
In one table I have a column of type FIXED(12,3), in one record I have
the value 5.225 for this column then checking this value with:
WebSQL returns 5.225
ResultSet.getString() returns 5.225
ResultSet.getDo
Already exists a project to maintain the forge of all LGPL libraries, a some
development are
being done creating a rebranded new SQL Studio: http://sapforge.sourceforge.net. We
will
start maintenance when no more LGPL libraries be avaliable.
Also, we are translating messages on JDBC driver to se
Dear,
I could not find that anyone have similar error. I am using SAPDB 7.3.0.40 on Red Hat
Linux 8.0.
My application uses last version of a JDBC driver sapdb-jdbc-bin-7.4.04.03a, I have
this error:
com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Column index 1
was not
> Sven Köhler wrote:
>
> >> I set the isolation level to READ_REPEATABLE and use mysqldump |
> >> bzip2 to get the result. I've tested the restore and it's fine!
> >
> >
> > So how does mysqldump handle binary data?
> >
> > If it does embed the data into the SQL-statement somehow, that's crap,
> >
Tobias Asplund wrote:
Sven Köhler wrote:
I set the isolation level to READ_REPEATABLE and use mysqldump |
bzip2 to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am Sonntag, 14. Dezember 2003 20:59 schrieb Jerry Apfelbaum:
> Hello.
>
> I have been tasked with evaluating open source databases for a large
> upcoming project: e-commerce, B2B, high availability.
So, you should choose SapDB 7.3 or 7.4 due Licens
> ok, but what about a tool for Sapdb ?
You can use sqlcli together with SAP DB also.
Thomas Simenec
SAP DB, SAP Labs Berlin
-Original Message-
From: Jean-Michel OLTRA [mailto:[EMAIL PROTECTED]
Sent: Montag, 15. Dezember 2003 15:24
To: MaxDb
Subject: Re: xsql date format
Le lundi 15 dé
Huh? Not know how to backup a MySQL database? *sigh*
Every night, I do a backup of our MySQL database server that's holding
all of our mail and various other things (20GB+).
I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2
to get the result. I've tested the restore and it'
Are they? Shoving in rows that are several meg in size didn't pose any
problems. The restore procedure looked like this:
bunzip2 dumpfile | mysql -u db_grunt -p projectdb
May I ask where the limitation you mentioned is documented? Maybe the
situations we were using it in didn't come close to th
Le lundi 15 décembre 2003, Simenec, Thomas a écrit...
bonjour,
> you can find the sqlcli in the Standard Installation package for MaxDB on the mysql
> homepage.
> After installing, sqlcli can be found in /bin.
ok, but what about a tool for Sapdb ?
dbmcli displays correct date format but
I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2
to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
since SQL-Statements are limited in length.
--
MaxDB
> It is a mystery to me how the PostGreSQL work. I cannot recomm to use
> any feature discovered in PostGreSQL since some of the more uncommon
> feature are broken.
Would you care to elaborate? I've used both PostgreSQL and mySQL, but
certainly not all features, and I'm curious about what issues
PostgreSQL I rejected because I can't find a version that runs under Windows
without a lot of recompiling and, presumably, a lot of hacking, but it does
run well under Linux. Judging by some of the posts I've seen on the list
regarding the stability of MaxDB under various versions of RedHat, it wou
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird are
possible candidates.
Does anyone know why we should or should not use any of these? Does anyone
know of other possibilities?
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-eng
Hi,
you can find the sqlcli in the Standard Installation package for MaxDB on the mysql
homepage.
After installing, sqlcli can be found in /bin.
Thomas Simenec
SAP DB, SAP Labs Berlin
-Original Message-
From: 'Jean-Michel OLTRA' [mailto:[EMAIL PROTECTED]
Sent: Montag, 15. Dezember 2003
Le lundi 15 décembre 2003, Simenec, Thomas a écrit...
bonjour,
> the xsql tool does not really support the different date/time formats listed
> in the xsql help message.
so you need to remove these useless help message.
> For an ISO formatted date string (-MM-DD) please use our tool
> C:\>D:\sapdb\DBM\DBMCli.exe help db_warn
> OK
The OK says: dbmcli ran without errors. The not existing help output "says": There is
no help entry for "db_warn".
You might consider "dbmcli help db_warm" instead.
Regards
Christian
--
#include
/* The opinions stated above are my own and not
Hi there,
at first, i am using SAPDB 7.4.3 Build 014-000-037-95 on different Linux
platforms.
First question:
Can u please give me an example on how to create a mirrored logfile. I know
to set log_mirrored to yes,
but both param_addvolume(database creation) and db_addvolume (afterwards)
always fa
Thank you Christian,
I possibly found better solution to this problem in SAP DB user list
archive.
Put additional regesty entry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run with the
value "DBMCli.exe -d -u DBM, autolog_on "
Thanks for your advice, I appreciate that!
Hello,
Possibly, the DBMCli.exe functionality is broken in SAP DB 7.4.3.30:
C:\>D:\sapdb\DBM\DBMCli.exe help db_warn
OK
Expected result: Output of command help
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
>> I turned on autolog, but every time I restart the DB services, it is
>> turned off again. That happens now for several times. I can turn on
>> autolog manually with no problem.
> Start the database using dbmcli, not using the services applet or 'net start'.
> Currently,
> only the database
Hello!
I'm using SapDB database v.7.4.3 Build 030-121-056-274 under Red Hat Linux
release 7.3 (Valhalla). I shut it down and after that it reports me error
-24961 "Getting Kernel state failed: No such file or directory" (message
reported from dbmcli utility). Please help me with this issue. What c
Hi again,
I found somethink related to my problem.
From which verstion Bug is fixed/will be fixed?
That are really practical work arounds conserning
this bug?
Thanks ,
RE: Autolog turned off after restart
From: Dittmar, Daniel
(daniel.dittmarsap.com)Date: Wed Jul 16 2003 - 05:31:16 CD
Hi,
is there a way to have the client get an SQL error instead of beeing
suspended when the database is full?
For a specific application I need to continue even in case the database
is full. But at the moment the database suspends the task serving the
connection so that the SQL command blocks.
Hi Jean-Michel,
the xsql tool does not really support the different date/time formats listed
in the xsql help message.
For an ISO formatted date string (-MM-DD) please use our tool sqlcli.
But be aware that this tool comes fresh from development and so it's an
alpha version.
Regards,
Thomas
> I have only recently started these evaluations. BTW, my own background is
> from the Oracle DBA world.
>
> MySQL is certainly popular and seems to have very good performance, but I am
> concerned that the lack of Triggers, Stored Procedures, User-Defined
> Functions, and Views (to a lesser deg
Hello,
Has some one capable to configure AutoLog ON option with SAP DB 7.4 on Windows 2003
Server?
I am not able to get Autolog ON after server restart :-(!
Should I create some additional windows service to set autolog on with configured
dependences?
Did somebody solve such problem?
Ho
Hello José,
see a previous message at
http://listserv.sap.com/pipermail/sapdb.general/2002-October/008942.html,
especially regarding the setting of some kernel parameters for shared
resources.
Regards
Alexander Schröder
SAP DB, SAP Labs Berlin
> -Original Message-
> From: José Rómulo
Hello José,
you cannot change a volume's size, once it is created.
You may want to add an additional volume, instead.
Regards
Alexander Schröder
SAP DB, SAP Labs Berlin
> -Original Message-
> From: José Rómulo Elías Contreras [mailto:[EMAIL PROTECTED]
> Sent: Sunday, December 14, 200
Hi There,
I have a SAP database ver 7.3.0.25 called P01 running on NT4 server. The
server does full nightly backups. This is the main database server that
all
our users connect to.
I have recently setup another computer running SAPDB ver 7.3.0.25 called
P01
on Win2003 server, this server is to
> Hello
>
> I have been trying for a few days to get SAPDB/MaxDB working under
> RedHat 9 to evaluate it for a large upcoming project.
>
> The Installation seems to go well but I cannot get a real database to
> really start running. I've tried 7.505, 7.508 tgz's as well as 7.4 tgz
> and rpm. No l
62 matches
Mail list logo
