RE: SAPDB Standby database setup.

Hello Alexei, after recover_cancel (for log recovery) should a savepoint be written. This savepoint makes it possible to start log recovery again at this point. But there was an error in some versions which prevented such savepoint. Could you give me your used release and build please? It seems t

RE: SAPDB Standby database setup.

Hi Tilo, Thanks for your response. > >1) Are there alternatives to load log backups on > >standby instance other then do > >recover_start-recover_replace in one utility > session? > > End your log recovery with a recover_cancel (DBM > Server should do that by default, when ending with a > still

sapdb serviceguard extended package

Hello experts, could someone please let me know if there is exclusive service guard extended package for sapdb. i am setting up cluster on Linux Redhat AS 2.1. If so, from where can i download it? please let me know. I certainly hope to recieve an answer at the earl

Re: Data/Log Size via SQL Query

bonjour, Le mercredi 16 juin 2004, Adam Wendt a écrit... > Is it possible to get the Data and Log used % of a DB Instance from an > SQL query via ODBC rather than from dbmcli (info state)? You may look at system tables definitions, especially SYSINFO System Tables. (datavolumes/logvo

Data/Log Size via SQL Query

Hi, Is it possible to get the Data and Log used % of a DB Instance from an SQL query via ODBC rather than from dbmcli (info state)? Thanks, Adam Wendt IPCoast, Inc. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PR

Insert statement - "KB Stack" or "Move Error"

Hi, I get an error with the following statement on 7.5.01.00 (in SqlStudio): insert into table1 (col1, col2) select 1,2 from dual where not exists (select 1 from table where col1=1) The error is: General error;-602 POS(1) System error: Move error. or System error: KB Stack type illegal. d

Calling a function the db crashes (more details)

Using the same function, in a more complex sql statement, I receive the error General error;-602 System error: Move error. The query is the following. The function is used only in first subquery SELECT (SELECT pportaL.TO_CHAR2(Max(TO_NUMBER(K_KEY) +1)) FROM REGISTRY_TREE), 'appoin57',

RE: Error 530, Part II

Hi Christoph, for further analysis you could send me the files: dbm.utl,dbm.prt,knldiag,knldiag.err and knltrace. Then you should recover your last data backup and if necessary recover log as well to reach your last point in time. regards, Uwe >-Original Message- >From: Christoph Weser [

Calling a function the db crashes

Hello, I'm using MaxDb version 7.5.01.00. I have a function TO_CHAR2 owned by user PPORTAL that receives a float and give me back a char value. The function is created like this in Oracle mode (the grant in Internal mode because they don't work in oracle mode) DROP FUNCTION TO_CHAR2 // CREATE

Error 530, Part II

Sorry, I forgot knldiag output: ... ... ... 2004-06-16 15:12:55 17235 54003 dynpool LOCK SupplyPoolSize: 801424 2004-06-16 15:12:55 17235 54003 dynpool LOCK ObjColl_list size : 11776 2004-06-16 15:12:55 17235 54003 dynpool LOCK ObjReq_list size : 5888 2004-06-16 15:12:55 17

Error 530.

Hello. I'm using 7.4.3.32 on a SuSE 9.1 system. After a crash the DB won't warmup again. In the knldiag.err I got the following: Date Time TID Typ MsgID LabelMessage-Text ---

maxdb-76: compile issue(s) SAPDB/MemoryDebugger/MemDbg_Header.hpp

I'm trying to get maxdb-76 to compile on Solaris/x86 but the compile is throwing errors: !irconf -r -p $INSTROOT > /dev/null !$TOOLSHELL -S ifaconf.pl $INSTRUNTIME /home/sapdb/maxdb-76/usr/runtime/7600 -> 7.6.0.0,/home/sapdb/maxdb-76/us\ r registered. MemDbg_Config.cpp fast "/home/sapdb/maxdb-76/

RE: SAPDB Standby database setup.

Hello Alexei, >1) Are there alternatives to load log backups on >standby instance other then do >recover_start-recover_replace in one utility session? End your log recovery with a recover_cancel (DBM Server should do that by default, when ending with a still open utility session.) And restore th

AW: timestamp processing in Oracle mode

Heiko Giesselmann wrote: > Hi, > > I have an application that works in Oracle mode. There is a table with a >timestamp field and I am looking for a way to add an integer > representing seconds to that timestamp field with a value of type > timestamp as a result. The following is a working exp

RE: odbc SQL_NO_DATA_FOUND on update ?

Hi Tom, > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 15. Juni 2004 16:56 > To: [EMAIL PROTECTED] > Subject: odbc SQL_NO_DATA_FOUND on update ? > > > Hi, > > I've got a general odbc-problem with maxdb. > > what return-code should be thrown