you can hardly call 10 bucks a commercial application. it will cover my
hosting fees at best.
- Original Message -
From: "Andris Spruds" <[EMAIL PROTECTED]>
To: "Vitaly Veksler" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 2:19 PM
Subject: Re: sapdb data e
Hi list
is the version 7_4_3_31 of SAPDB capable to be installed on windowsNT 4
Server/Service Pack 6.
Cheers
Dimitris
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes I can, just last week I created data volume 20GB and Log volume
15GB. Thats why I asked in other post if that is something I should even
attempt to do (because I can doesn't mean that it is the best thing to
do, or is it ;-)?
This is straight FC1 without any updates and patches.
Miro
Don G
Sven Köhler wrote:
can we expect MaxDB to support NPTL soon?
Probably not 'soon'. Not even 'real soon now'.
There are plans to support Linux AMD64 which seems to require this. What
isn't clear is when this will be made available and whether there will
be binary 32bit releases supporting that pla
Stephen Gutknecht (SAPDB) wrote:
If I am using a Windows 2000 i386 system, can I use DBMCLI and the
command-line data loader utilities to interact with a Sun Solaris install of
MaxDB?
Sure, both tools work across the network and across platforms.
I would be installing the same version of SAPDB on
Thanks for the response.
I have a couple of follow up questions:
Is the undo log only written to if in the middle of a transaction?
Can you think of any other reason why deactivating redo logging would
cause temp table writes to run faster if they have no effect?
Thanks.
>
> >Hello,
> >
> >I
Hi,
It looks like we are going to establish a large-RAM Solaris system for data
study. Our goal is to extract our MaxDB database from Windows 2000 and
import it each day into our Solaris system.
If I am using a Windows 2000 i386 system, can I use DBMCLI and the
command-line data loader utilities
Hello,
Sounds great... But it seems You forgot to mention that this is a commercial
application. :(
Best regards,
Andris Spruds
- Original Message -
From: "Vitaly Veksler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 10:00 PM
Subject: sapdb data extrac/l
Guys,
I have put together a great utility that will allow you easily to extract all contents
of your schema (table defs, constraints, foreign keys, sequences) into a flat xml file
format and then load it into a target database.
I have been using SapDB's built in capability and not very excited
Don Gray wrote:
Out of curioisty can you create db files > 2Gb on your Fedora Core 1
installation?
The underlying *OS* has no such limitation, neither does ext3. However, sapdb
as compiled on Linux_x86 may have a limitation. If that's true it's a
limitation of sapdb, NOT the OS.
This has been tr
Out of curioisty can you create db files > 2Gb on your Fedora Core 1
installation?
Don Gray
CTO, VigilantMinds Inc.
-Original Message-
From: Miroslav Halas [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 11:36 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: How to i
Hi,
Are these kind of queries possible in maxdb? (see below)
The problem seems to be in the "subquery": "select c.value from
t_riskobject "
What I'm basically trying to get is the result of a query as part a
return value of another query. Look at the example, you'll see what I
mean.
In oracle
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
ftp://ftp.sap.com/pub/maxdb/tmp/changes_7_5_00_08.txt (104 KB)
we haven't quite figured out how to integrater the change infos into mysql.com.
Daniel Dittmar
--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To
I created this function:
CREATE DBFUNCTION RISORSA_OPZIONATA(CODRISORSA FIXED(10,0), CODESIGENZA
FIXED(10,0)) RETURNS fixed
AS
VAR TMPVAR FIXED; TMPVAR1 FIXED; PARAM FIXED; RISULTATO VARCHAR;
SET TMPVAR = 0; TMPVAR1 = 100; PARAM = 0;
IF CODESIGENZA IS NOT NULL THEN
BEGIN
Guys,
I have following problem and I am looking for a suggestion. I need to
create a database on Linux which will run mostly unattended and should
have as much space as possible.
Let say I have 40GB HDD and I can spare 30GB. Do you have nay
suggestions as to how to structure it and potentially
Guys,
I have seen repeated emails about this on the newsgroup and I have also
seen and suggested some solutions but these emails come again and again.
I have put together step by step process how to install 7.4.3.30 on
Fedora Core 1. It uses the LS_ASSUME_KERNEL hack in my own way, since
the s
On Mon, 2 Feb 2004 16:33:18 +0100, Rick F. van der Lans <[EMAIL PROTECTED]>
wrote:
Hi Dusan,
If you want to get the first 5 (or whatever), this will work:
select * from table1 as t1 where 5 > (select count(*) from table1 as t2
where s2.primarykey < s1.primarykey)
Is this generic enough?
regard
Hello Chris,
>when recovery start we become the following error (-24977 unknown command
>"db-activate" [db_activate RECOVER "Filename" DATA])
This is a bug in DBMGUI Second Edition. Until a patch is available, you could try
using DDBMGUI (first edition).
Best Regards,
Tilo Heinrich
SAP Labs Ber
Resuming the problem: any function (or CASE) I put in the query make the
subqueries not being executed (always returns null).
Thanks,
Edson Richter
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Rele
More info:
Upgrade to 7.4.3.30 doesn't solve the problem.
The sum problem can be solved putting in from of subquery a "1.0*" (this
guarantees datatype). I think it's a bug!
After upgrading to 7.4.3.30 not only DATEDIFF affect the subquery results,
but VALUE function too (in 7.4.3.27 VALUE worked f
> 32512,/opt/sapdb/depend74/bin/x_python
> /opt/sapdb/depend74/env/lsystab.py -d
> TST74 -u dba,* -dompwd domain en ENG
Please run the command above from the command line and check if anything suspicious
appears, like a Python traceback or a core. The latter seems likely as the 32512 is
the r
> http://www.komadev.de/e171/e79/index_ger.html had develop for SABDB on
> FreeBSD 5.x
> Has MySQL AB plan to support MaxDB on FreeBSD 5.x ?
We will try to incorporate the patches into the sources so that building MaxDB for
FreeBSD should be easy. There are currently no plans to add FreeBSD to th
> Witch are the dependences between Python and MaxDB ? or what
> can't I do
> without Python ? Create database ? loading system tables ?
Loading of the system tables is done through Python scripts
(/env/*.py), which access MaxDb through the Loader. Several tools will
not work correctly if the
Can someone link the right pages at MaxDB web site to latest version?
Edson Richter
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/1/2004
Hi!
Since as we can see in the MaxDB list, the MaxDB package isn't so stable as
is 7.3 and 7.4 releases. So, I think we (the user community) should ask you
to extend the open support by some months, until MaxDB (7.5) be stable as
7.4 and 7.3.
It this possible?
Thanks in advantage,
Edson Richter
Hi Christian,
the error with "db_activate" command is a problem of the current
DBMGui version. The responsible developer told me that a bug fix
will be available soon.
Error code -111 "Incompatible incremental backup" means that the hostfile
used for the recovery is not the right one! Did you sta
Hi!
Database version: 7.4.3.027 on Win2K.
Error message: none.
Problem: The following query executes fine, but with DATEDIFF (line 4), the
sum always returns NULL (if DATEDIFF is removed, sum return rounded values -
the CB.v is a decimal(18,6) field, and should not return rounded values):
SELECT
> Is MaxDB 7.5.00.08 ready for corporate
> installation or a developer release?
MaxDB 7.5.00.08 is the current stable release, see:
http://www.mysql.com/downloads/maxdb-7.5.00.html
The development version is available here:
http://www.mysql.com/downloads/maxdb-7.5.01.html
Robert Völkel
-Original Message-
From: Mark Fisher [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 12:24 PM
To: [EMAIL PROTECTED]
Subject: Temp tables and logging
>Hello,
>
>I noticed that when I try deactivating "redo" logging (as a test),
>writing data to temp tables seems to happen fast
Le jeudi 05 février 2004, GUITARD Damien a écrit...
bonjour,
> Witch are the dependences between Python and MaxDB ? or what can't I do
> without Python ? Create database ? loading system tables ?
sql module for sql commands
dbm module for dbm commands
loader module for
"Python, c'es
two rows with DATEMB '20040204' and '20040205'
And used sqlcli to verify...
SELECT * FROM MISESBAS WHERE YEAR(DATEMB)=2004
oups, one row, should be two
reinserted the missing row, with my gui, and manualy. Same result. (I
did not forget to commit)
Tried:
SELECT * FROM MISESBAS W
Dirk Vleugels wrote:
> On Wed, Feb 04, 2004 at 03:49:00PM +0100, Becker, Holger wrote:
> > Sorry, my fault next time I will test the commands I post here.
> > You have to use util_execute command within dbmcli.
> > Example:
> > dbmcli -d -u util_execute diagnose
> optimize join outer off
>
>
Hi,
we want to migrate our production DB (7.3.0.24 / gui first edition) to
another W2K-Server running sapdb 7.4.3.31 & sapdb gui second edition.
Before this step we tried to test the migration procedure but without any
luck.
Following steps were be done:
-installation of sapdb 7.4.3.31 on a WinX
Hello,
I noticed that when I try deactivating "redo" logging (as a test),
writing data to temp tables seems to happen faster. Is it correct to
assume that even temp table writes are logged in SAP-DB?
If that is the case, are there any plans to not do that (like with other
databases, have the op
http://www.komadev.de/e171/e79/index_ger.html had develop for SABDB on
FreeBSD 5.x
Has MySQL AB plan to support MaxDB on FreeBSD 5.x ?
and does MaxDB support locale like MySQL does?
(character set for sorting)
Somsak Lim
IT Consultant
[EMAIL PROTECTED]
Hello,
Witch are the dependences between Python and MaxDB ? or what can't I do
without Python ? Create database ? loading system tables ?
Thanks.
Damien.
On Wed, Feb 04, 2004 at 03:49:00PM +0100, Becker, Holger wrote:
> Sorry, my fault next time I will test the commands I post here.
> You have to use util_execute command within dbmcli.
> Example:
> dbmcli -d -u util_execute diagnose optimize join outer off
This works!
One more question: any wa
> -Original Message-
> From: Denis Minnikhanov [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 04, 2004 4:31 PM
> To: [EMAIL PROTECTED]
> Subject: SAP DB 7.4 backup and restore
>
>
> Hi SAP DB developers!
>
> History:
> SAP DB v. 7.4.3.31(but the same issue with v.v.
> 7.4.3.10
Dear All,
Is MaxDB 7.5.00.08 ready for corporate
installation or a developer release?
This question came into my mind due to an article
published on Newsforge.com. For more information
kindly visit
http://www.newsforge.com/programming/04/01/26/187210.shtml
Thanking you.
What about fixing this bug in SAP DB? Are there plans to do this
before end of March where version 7.3 is only further supported
for SAP customers? Does version 7.4 have this bug?
Regards,
CTB
Bernard Clement schrieb:
Hi CTB,
Well the example you were providing was ASCII only and that is why I s
Hi Stephen.
Just wanted to drop you a line -
when it comes to SAP DB (not MaxDB),
Linux RH 7.2, kernel 2.4.20-20
When it comes to machines -
for two years my production server
was Compaq 2xPIII 800 MHz,
512 MB of RAM, RAID.
Recently I have upgraded to:
2 x PentiumXeon 2GHz,
RAM - 2GB,
RAID etc.
Wo
42 matches
Mail list logo
