Filip Sergeys wrote :
>Hello,
>2 questions again:
>1) Are nested while loops possible or not?
>I have followed the recommendation in this mail
>(http://archives.neohapsis.com/archives/dev/sapdb/2003-q3/0743.html) and
>named each select (see 'code snipped' below) but I have the same problem
>as t
Le mercredi 18 février 2004, Andy Chan a écrit...
bonjour,
> During the process, I also wonder why the Log volume LOG_001 never get created for
> the new instance, while the Data volume gets created when we do "recover_start".
> Then I though it gets created when I can kick-in "recove
Hi,
I have a weird problem where a sapdb 7.3.0.30 instance (on windows2000
) goes down at 1:01 AM every day. I havent been able to track any
scheduled tasks/ client programs running at this time. (this is a very
low load time).The error log does not contain any information about the
crash. Would
Anyone can give me a pointer?
If on the other hand, I keep updating the slave instance (sdb2) by asserting
incremental data backup from master (sdb1) ? Would I need to restore log backup at all
- of course expecting data loss ?
-Original Message-
From: Andy Chan
Sent: 2004?2?18? 17:14
Hello, all.
I just encountered a strange error when trying to drop a table (7.5.0.8).
The message I received is:
ERR 51080 SYSERROR -9404 AK System error: VAK19 2
Does anyone know what might cause such an error? Is it serious?
Thanks.
--
Mark Thomas
United Drugs
--
MaxDB Discussion Mailing L
Jean-Michel OLTRA wrote:
No. We're slowly removing features to make it easier for MySQL to
implement a replacment.
A little bit more details ?
Please don't make me elaborate on this joke too much.
Daniel Dittmar
--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]
--
MaxDB Discussion Mailing
[EMAIL PROTECTED] wrote:
I tired that and the error is
./dbmgetf -d mydb -u user,pass -k KNLDIAG
Did you actually install a database named mydb? 'dbmcli db_enum' should
show it.
The documentation also discusses User Kernel thread subset of tasks which
include a Log Writer, so if the application
I tired that and the error is
./dbmgetf -d mydb -u user,pass -k KNLDIAG
Error while receiving data! Operation aborted!
-24994, ERR_RTE: runtime environment error
1,OS error: 'No such file or directory'
** EOF **
0 Bytes of 0 Bytes received!
>From the documentation I understood
Le mercredi 18 février 2004, Daniel Dittmar a écrit...
bonjour,
> No. We're slowly removing features to make it easier for MySQL to
> implement a replacment.
A little bit more details ?
Some features totaly removed ? Replacement of pieces of code for same
features ? For new tools ? ...
DL wrote:
I have noticed that on SAP ftp server there an alpha version of maxdb 7.0.1
with extension rpm
The release 7.5.01 alpha 2
(http://www.mysql.com/downloads/maxdb-7.5.01.html) contains feature
required for the MaxDB Proxy. The proxy allows MySQL clients to
communicate with MaxDB. It's goi
Le mercredi 18 février 2004, Filip Sergeys a écrit...
bonjour,
> SET GUARANTEETXT = GUARANTEETXT & GUARANTEE;
> but also not correct.
> What is the correct way to obtain a concatenated string in a dbproc?
string1 || string2
--
jm
--
MaxDB Discussion Mailing List
For list archives: h
[EMAIL PROTECTED] wrote:
I get this error when starting up the database. It says to look knldiag,
but no file is written. There is the appldiag which states the same
knldiag is described here: http://sapdb.2scale.net/moin.cgi/knldiag
Daniel Dittmar
--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTE
I get this error when starting up the database. It says to look knldiag,
but no file is written. There is the appldiag which states the same
error. I couldnt find any info in the docs and when I googled it I came
across several suggestions to set LD_ASSUME_KERNEL which still doesnt seem
to work
HERE IS THE SYNTAX THAT DOES WORK. SEEMS LIKE SAPDB DOESN'T LIKE YOU TO USE
PSUEDO TABLE NAMES:
UPDATE USERDB.RMA SET ITEM_TOTAL = (SELECT (SUM(WARRANTY_CHARGE) +
SUM(LABOR_CHARGE) + SUM(PARTS_CHARGE)) FROM USERDB.RMA_ITEM WHERE RMA_ID =
2045001 AND ACTIVE='Y') WHERE RMA_ID = 2045001
UPDATE USERD
Hello,
2 questions again:
1) Are nested while loops possible or not?
I have followed the recommendation in this mail
(http://archives.neohapsis.com/archives/dev/sapdb/2003-q3/0743.html) and
named each select (see 'code snipped' below) but I have the same problem
as the poster it iterates once (1
This one doesn't work either:
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-5016 POS(27) Missing delimiter: =.
UPDATE USERDB.RMA R SET R.RMA_TOTAL = (SUM(R.ITEM_TOTAL) +
SUM(R.MISC_CHARGE) + SUM(R.FREIGHT_CHARGE)) WHERE R.RMA_ID = 2045001 AND
R.ACTIVE='Y';
-Or
Just out of curiocity:
Is the debugger going to be like the debugger in the ABAP workbench? I
found it pretty usefull and writing dbproc's has a lot in common with
writing abap programs.
Regards,
Filip Sergeys
On Wed, 2004-02-18 at 15:58, Anhaus, Thomas wrote:
> Filip Sergeys wrote :
>
> >Hell
Well this isn't necessarily true because if it were then this statement
would work:
UPDATE USERDB.RMA A SET A.ITEM_TOTAL = (SELECT (SUM(B.WARRANTY_CHARGE) +
SUM(B.LABOR_CHARGE) + SUM(B.PARTS_CHARGE)) FROM USERDB.RMA_ITEM B WHERE
B.RMA_ID = 2045001 AND B.ACTIVE='Y') WHERE A.RMA_ID = 2045001;
error
Filip Sergeys wrote :
>Hello,
>What is the correct sequence of commands to use vtrace
>I used the methods described on
>www.mysql.com/products/maxdb/pdf/opensupport_eng.pdf page 24
>and
>http://sapdb.2scale.net/moin.cgi/VTrace
>and
>http://lists.mysql.com/maxdb/18645
>but neither gave me luck
Filip Sergeys wrote :
>Hello,
>Except for vtrace (for which I opened another thread because I can't get
>it to work) are there any other ways of printing debug information.
>I 'd like see if the loop gets executed.
>Regards,
>Filip Sergeys
You may write trace information into a table using no
Hi Aleksey,
the names of your source and targetusers differ ( test,test1)
the name is internally used for a qualified update.
this causes the Row not found error.
you can avoid this error, that will be fixed in one of the
next releases if you replace 'test' by 'test1' in the file
'test_tbl.dat00
> > > Using ODBC the connection time to this database is about
> 2 minuts
> some
> > > parts of software are frequently open and close database
> connection
> because
> > > those parts are independent EXE's.
You should also test connection times with other MaxDB clients. I think that ODBC
r
Hello,
I have some problem with loadercli (MAXDB vertion is
7.5.00.08 for Linux). Im using following command in
loadercli command file to export and then to import
all tables of the user test to export:
use user test initial
//
catalogextract USER OUTSTREAM FILE 'test_cat.dat'
//
tableextract US
Running SAP DB 7.3.0.32, I have an ESQL/C application that establishes a
connection to a database, does a SQL 'select *' to get one row in a
table x, does an SQL update on the row and then again does a SQL
'select *' on the row. Table x has 23 columns, 12 being LONG columns.
For some database recor
Hello,
Except for vtrace (for which I opened another thread because I can't get
it to work) are there any other ways of printing debug information.
I 'd like see if the loop gets executed.
Regards,
Filip Sergeys
On Wed, 2004-02-18 at 08:14, Anhaus, Thomas wrote:
> Filip Sergeys wrote :
>
> >H
Hello,
What is the correct sequence of commands to use vtrace
I used the methods described on
www.mysql.com/products/maxdb/pdf/opensupport_eng.pdf page 24
and
http://sapdb.2scale.net/moin.cgi/VTrace
and
http://lists.mysql.com/maxdb/18645
but neither gave me luck
dbmcli -d -u util_execute diag
I have some upgrading questions:
I have noticed that on SAP ftp server there an alpha version of maxdb 7.0.1
with extension rpm
Are you intended to make the next release under rpm too?
Would the release be more stable than the proposed now ?
I have not yet upgraded my server to Max db due to many
Hy all,
We are using:
sapdb-7.4.3.31 on linux (rpm-installation)
a question:
how do I have to interprete this "SELECT * FROM LOCKSTATISTICS"
(we sometimes run into deadlocks.)
Is the whole Table locked?
(ROWID columns seem to be NULL)
(In the attachment is same snapshot)
SESSION
Hi,
this morning after reboot my sapdb instance is not coming up (Windows XP).
The Error message is:
-24988, sql error [db_warm -f]; 1,database not running
Strange enough, the kernel.exe process is running.
So I killed kernel.exe, shut down the service in the control
manager and tried again. The
Hi
> -Original Message-
> From: Axel Busch [mailto:[EMAIL PROTECTED]
> Sent: Montag, 16. Februar 2004 18:40
> To: [EMAIL PROTECTED]
> Subject: sqlcreatetls : Nicht genügend Speicher / Not enough memory.
> Could not write to event log
>
>
> hi,
>
> i have a rather nasty problem on a Win
Backups are platform dependent? That's quite new to me also - we did our
R/3-Migration from Windows to Linux like this. I always thought they were
"endianess"-dependent...
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 91
Hello,
I've got a sapdb 7.3.0.34 running. Recently I have problems with the
SELECT FROM DUAL statement.
The command: "SELECT seq_tislot_feature.nextval FROM dual" leads to:
Base table not found;-4004 POS(40) Unknown table name:DUAL.
I can work around the problem by executing instead:
SELECT seq
More information after trying that out... still not getting the expected result though
:_*
What I did was simply to copy the log volume from primary instance (db_state = ONLINE)
to second instance. (Conceptually I don't think it's right, but I've no other option
to proceed.) In addition, I d
33 matches
Mail list logo
