Hello Linos,
> If i not manually deactivate the units but i have a power failure and i
> have to reboot a server involved in the replication, do i have to
> manually activate the sync or it will be activated on reboot if i launch
> the messageserver and syncservice automatically, i can lost many
Hello Wolfgang,
> 2) If i deactivate the units and later activate them the changes made in
> this time are lost? (i refer to all the changes, client and master in a
> IN/OUT, if i only have out i know i can "send content to client")
>
> => Yes. You have to do your changes while the application is
Hello Linos,
> 1) when i have to do any structure change (add a column with alter table
> for example), it is replicated? or have i to do with replication units
> deactivated and make the structure change in all the clients?
=> Structure changes are not replicated. You have to deactivate the unit
Hello all,
i am developing a new app that and i want to use maxdb replication
with it, i have any questions, i hope you can help me.
1) when i have to do any structure change (add a column with alter table
for example), it is replicated? or have i to do with replication units
deactivated and
Dear Madam/Sir,
I'm new to MaxDB. I want to ask some questions for using MaxDB.
1. As we know, in Microsoft SQL Server, it has a type
"uniqueidentifier". With this type data, we can use the function
"newid()" to generate a globe user identifier.So
ECTED]
Sent: Wednesday, September 13, 2006 6:54 PM
To: maxdb@lists.mysql.com
Subject: Synchronization Questions
Hello all,
I have a few questions regarding MaxDB replication:
1) I am currently testing a simple MaxDB replication scenario. We have
one Master unit and two clients units, all of whi
Hello all,
I have a few questions regarding MaxDB replication:
1) I am currently testing a simple MaxDB replication scenario. We have
one Master unit and two clients units, all of which are in/out units.
Synchronization works fine when empty client tables are populated with
content from
Hello Alexander.
Thank You for the response I removed
CLOB suffix from the parameter type
and it fixed the problem. Besides Ive found in the PTS the solution of my
trouble with trace file its sufficient to add quotation marks for file
name.
At the time I faced with strange behavior of
pieces. This
is obviously not in your example the case.
Regards
Alexander Schröder
SAP DB, SAP Labs Berlin
-Original Message-
From: Dmitry Key [mailto:[EMAIL PROTECTED]
Sent: Freitag, 19. Mai 2006 06:04
To: maxdb@lists.mysql.com
Subject: The couple of questions on SQLDBC_C
The C code
The C code below connects to the database and adds one row to the simple
table with CLOB field. The following problems took place:
1) If I try to set the trace file name like C:\Temp\LogFile.txt library
creates the text file with name c in the working directory of MaxDB
(although change hist
Hi,
Fixed the problem by increasing the DATA_CACHE size from 1 (80 MB) to
32000 (256 MB).
The documentation says that DATA_CACHE >= MAXUSERTASKS*10, which is
satisfied by 1 for MAXUSERTASKS=800.
What are the other considerations for the size of the DATA_CACHE ??
(Looking at the stack trac
Hi Ingo,
> in which conditions will the event dispatcher terminated? i
> got still the problem, that the event dispatcher terminates
> in certain conditions (bring server to ONLINE or OFFLINE).
The Event Dispatcher should not terminate when the database state is
changed. The Event Dispatcher i
>
> > to the event dispatcher (first i changed the defaultvalue
> > from _MAXEVENTTASKS (2) up to 10.)
> Why did you do this? Do you want to run more than one Event Dispatcher
> in parallel?
i thought we need a higher value for every event to catch. next time, i will
read the manual more closel
Hi Ingo,
> to the event dispatcher (first i changed the defaultvalue
> from _MAXEVENTTASKS (2) up to 10.)
Why did you do this? Do you want to run more than one Event Dispatcher
in parallel?
> event with name OUTOFSESSIONS not dispatched (count 1)
> event with name OUTOFSESSIONS not dispatched (
Did somebody already has experiences with the event dispatcher of maxdb?
I`m running into some problems:
I want to catch the event OUTOFSESSIONS, so i add this event to the event
dispatcher (first i changed the defaultvalue from _MAXEVENTTASKS (2) up to 10.)
dbmevtdisp add Name == OUTOFSESSIONS
Hi,
I attempted to migrate my web application to the SQLDBC interface
and ran into a few problems... I'd like to be able to use parameterized
queries without having to bind variables to the parameters (I'd like to
be able to pass an array of values to execute and have them replaced on
the
mailto:[EMAIL PROTECTED]
Sent: Dienstag, 24. Mai 2005 10:46
To: maxdb@lists.mysql.com
Subject: Questions about Webdav
Good morning,
In a previous post I was wondering if MaxDB would be able to support
external
files locks the way IBM DB2 does. I was replied I should use Webdav to
manage
those fil
ere stored into the database.
My questions are :
- Are the files really stored into the database ?
- Excepted on the right management system what are the differences between
storing the files into the database through Webdav and storing the files into
the database by myself thanks to a long ? Is it
ipe backup
abilities.
Best regards,
Tilo Heinrich
SAP Labs Berlin
-Original Message-
From: Grisel Alarcon [mailto:[EMAIL PROTECTED]
Sent: Friday, March 18, 2005 2:51 PM
To: maxdb@lists.mysql.com
Subject: other questions...
Sorry but I have more question, Any help will be appreciated
1.- Someo
Grisel Alarcon wrote:
>
> Sorry but I have more question, Any help will be appreciated
...
>
> 3.- For owner aplications, How is the use of Store Procedure Language
and
> Triggers??? For example we read MaxDB has as limitation of tree
triggers
> on
> the same table; Are there samething else?
>
.
Sorry but I have more question, Any help will be appreciated
1.- Someone know if MaxDB can installed on Raw devices and what kind of I/O
accept?, for example. Paralel I/O???
2.- Does somebody use NetVault as external system backup; Are there any
agent for it?
3.- For owner aplications, How is th
I am a DB2 (UDB 8.2 on AIX) webapp developer by day and I have also used
Oracle and Postgres a lot in the past. Oracle has something called
"parameterized views" and UDB has a similar feature called "table UDFs (user
defined functions)" that I've grown to use quite a bit. Does MaxDB provide
any f
Hello Thomas,
> - Ease of Administration
>
> Is there a general rule that says MaxDB is easy to
> administrate or MaxDB
> needs an full-time DBA employee?
This depends on the size and needed availability of the database,
it is generally easy to administrate, but aside from easyness
there are
Hi all,
first of all, thanks for the very useful answers in my previous thread.
I do have some more questions though.
- Ease of Administration
Is there a general rule that says MaxDB is easy to administrate or MaxDB
needs an full-time DBA employee?
How easy it is to administrate MaxDB in an
Thomas Steinmaurer wrote:
>
> Hi,
>
> thanks a lot for your valueable comments!
>
> Do you also know whether MaxDB supports distributed transactions
across
> multiple databases (aka 2PC)?
No, this is not supported by MaxDB
Elke
SAP Labs Berlin
> If yes, is it XA compliant?
>
>
> Thanks,
>
Hi,
thanks a lot for your valueable comments!
Do you also know whether MaxDB supports distributed transactions across
multiple databases (aka 2PC)? If yes, is it XA compliant?
Thanks,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http:/
Am Donnerstag, 27. Januar 2005 10:46 schrieb Thomas Steinmaurer:
> 1) Full-Text search
>
> Does MaxDB have a built-in full-text search facility?
No.
> 2) Clustering, Load-Balancing
>
> I've read that MaxDB supports clustering for fail-over (hot-standby).
> Does that also support load-balancing i
Hi all,
I do have some technical related questions I haven't found an answer in
the Online documentation so far.
1) Full-Text search
Does MaxDB have a built-in full-text search facility?
2) Clustering, Load-Balancing
I've read that MaxDB supports clustering for fail-over (hot-stand
maxdb067.phpt on http://cvs.php.net/pecl/maxdb/tests.
Regards,
Thomas Simenec
SAP Labs Berlin
-Original Message-
From: Hawk [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 19. Januar 2005 18:28
To: maxdb@lists.mysql.com
Subject: A couple PHP questions
First one is why does maxdb_num_rows
First one is why does maxdb_num_rows always return -1?
If it's a bug in the api any ideas when it will be fixed?
Second one is about the functionality of maxdb_query and MaxDB's stored
procs. If a stored proc is called and returns out vars can we not just have
mysql_query return an array (or objec
I did not exactly find the answers for my questions in the manual. I did
find what "Wait for log writer" means for example, but I did not find
how to tune it.
Thanx in advance for any useful tip,
Regards,
Filip Sergeys
(Oh, and a Merry Christmas and happy New Year)
--
*-*-*-*-*-
"Filip Sergeys" <[EMAIL PROTECTED]> schrieb am 25.11.2004
16:10:28:
> I'am seeking the answer on three hypothetical situation where I need to
> recover a database (needed to write out a DRP)
>
> 1) suppose somebody updates a table with wrong values and that query is
> committed. After a few h
Hello,
I'am seeking the answer on three hypothetical situation where I need to
recover a database (needed to write out a DRP)
1) suppose somebody updates a table with wrong values and that query is
committed. After a few hours the error is spotted. Is it possible to
recover that individual table
Up until recently we have been able to leave an application running that
makes atleast 50 connect/query/disconnect sets a second for HOURS on end
without a problem, this had been run on the same exact system
configuration that is now failing VERY QUICKLY after an upgrade to
7.5.00.18. The stra
I still don't believe it's a MaxDB issue but more a W2K specific one...
I have found a document how to "tune" the TCPIP on Windows 2000:
http://www.microsoft.com/technet/itsolutions/network/deploy/depovg/tcpip2k.m
spx#EAAA
Maybe this registry parameters can help to keep the application running.
We have now tested the example code I posted between 2 W2K Server
machines and it fails near 1900 iterations. We hope this can be
confirmed by SAP as soon as possible and hopefully get a fix.
Thanks,
Adam Wendt
IPCoast, Inc.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.
Döhr, Markus ICC-H wrote:
Just for the sake of heart - did you try the other way around?
You might be right after all, with a DB on the W2K server loop
connection running both on localhost and from the XP box, the XP box
errors out around the same number of connects as before but the connect
Hello,
I'm trying to extract a user catalog and table...
To extract the catalog I do the following action
./loadercli -d TEST -u DBA,DBA
USE USER PSF PSF
CATALOGEXTRACT USER OUTSTREAM FILE '/tmp/cataPSF'
1) But when I try to extract the data with the istruction
./loadercli>TABLEEXTRACT USER D
Filip Sergeys wrote:
> Two questions I did not find straight answers for:
>
> Is there an easy way to retrieve/query the size of a table in bytes or
> blocks
>
> Does adding columns to a table, when it already contains a few millions
> records, have a negative performance
Two questions I did not find straight answers for:
Is there an easy way to retrieve/query the size of a table in bytes or
blocks
Does adding columns to a table, when it already contains a few millions
records, have a negative performance impact. And how much worse does it
get if you add yet
update the application, and the DB hasent complained.
Sumit Agarwal.
-Original Message-
From: Alex Castillo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 16:15 PM
To: [EMAIL PROTECTED]
Subject: BLOB and other questions about MaxDB
Hi!
I'm looking for a powerful open s
Hi!
I'm looking for a powerful open source database and I'm interesting in MaxDB. But I
have a little questions:
Are the BLOB fields supported in MaxDB??
It is a really 27/7 database server??
It is fast??
Thanks for your answers.
Best Regards.
---
I'm free, I use Linux.
Clo
> I finally managed to get 7.4.03-B31 "ported" so Solaris/x86,
Great.
> executed all
> the regression tests successfully. The process has been mainly
[...]
> The same has been done for 7.5.01-BETA.
>
>
> My questions are:
>
> - How to submit the patches
efined (SVR4)
-ldl
- some source modifications to include
- deleting comments behind assembler instructions
For the TOOLSRC there has been
- adding SVR4 to conditions
- deleting "-Xt" and "-Xa" as compile options since they are not supported
on Forte6U2/Intel
The same has b
Hello,
> we have some application, which is originaly written with
> Oracle DB, and we
> would like to port it to some smaller db for smaller customers :)
That's fine! Perhaps the Oracle SQL Mode of MaxDB may help you a little
in porting the application.
> So, I am looking for some possible RDB
Hallo,
we have some application, which is originaly written with Oracle DB, and we
would like to port it to some smaller db for smaller customers :)
So, I am looking for some possible RDBMS.
I would like to know, how the MaxDB works with binary large objects. It is
efficient for it, when, for smal
Filip Sergeys wrote:
Hello,
Are cursors unique to a session? I have some stored procedures that
returns a cursors, The cursor has a fixed name. If the same procedure
get executed twice (or more) times at the same time will it get mixed
up?
Cursors are unique, so you can use fixed names in stored
Hello,
Are cursors unique to a session? I have some stored procedures that
returns a cursors, The cursor has a fixed name. If the same procedure
get executed twice (or more) times at the same time will it get mixed
up?
Second question:
Is there a way to declare an empty cursor and populate it wi
In an application implemented in java, that open 100 of this SAPDB
connections :
DriverManager.getConnection(databaseUrl + databaseName + "?user=" +
databaseUser + "&password=" + databasePassword + "&isolation=" +
java.sql.Connection.TRANSACTION_READ_COMMITTED);
If I have an transanction T1 th
Rick van der Lans wrote :
>For a book that I am writing on MaxDB I want to create a few self-made views
>on the
>system tables. But certain things I do not understand or I can not find
>them;
>1) Where in the system tables does MaxDB store the fact that a view was
>created
>with the with-check-op
missing a system table.
4) If I would like to create a timestamp value out of the createdate and the
createtime used in the domain.tables table. How do I do that efficiently?
Hopefully, some one can help me with these questions.
Thanks,
Rick van der Lans
--
MaxDB Discussion Mailing List
For
[EMAIL PROTECTED] wrote:
Runtime error '-2147467259(80004005)':
Unknown MySQL Server Host
- if you want to connect to MySQL, you should use the MySQL general
mailing list (http://lists.mysql.com/#mysql)
- if you want to connect to MaxDB using a MySQL client, you have to use
the MaxDB proxy (http:
Le vendredi 09 janvier 2004, Jeroen Baten a écrit...
bonjour,
> -where can I see what grant rights a user or usergroup has on which table
> (just some directions is enough)
SELECT PRIVILEGE FROM DOMAIN.TABLEPRIVILEGES WHERE TABLENAME = 'MATABLE'
look at system tables in MaxDB documentat
Jeroen Baten wrote:
>
> Hi all,
>
> -Okay, so dbm and dba users are very different.
> -and sqlcli must have user and password in uppercase in 7.5.0.5
>
> Now I can make users, usergroups. I even have a set of
> scripts to transfer a
> mysql database to maxdb.
>
> Actually I am beginning to li
Hi all,
-Okay, so dbm and dba users are very different.
-and sqlcli must have user and password in uppercase in 7.5.0.5
Now I can make users, usergroups. I even have a set of scripts to transfer a
mysql database to maxdb.
Actually I am beginning to like this thing called maxdb. Very cool stuff
I encounter an error :-
Runtime error '-2147467259(80004005)':
Unknown MySQL Server Host
Please help me to solved.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
> 1-I want to use sqlcli but can't get in.
> I am using 7.5.0.5 on SuSE Linux prof 8.2
>
> dell3:/opt/sdb # programs/bin/sqlcli -d test6 -u jeroen,geheim
>
> Welcome to the SAP DB interactive terminal.
>
> Type: \h for help with commands
>\q to quit
> test6 => \s
> * -4008: Unkno
Hello,
We are building a potentially large product (both in data as in software size)
Since this is the only list I found, I guess I can bother you all with some
newbie questions :-)
0-is this the list for questions like to ones following?
1-I want to use sqlcli but can't get in.
I am
> i am trying to understand the performance of the following
> ABAP Sequence:
>
>
>while ..
>fetch next cursor %dbcursor
>...
>
>endwhile.
>
> I would like to compare it with ABAP statements as SELECT
> ... ENDSELECT
> or SELECT INTO TABLE.
You might want to
> -Original Message-
> From: Mischa Orlowski [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 05, 2004 1:48 PM
> To: [EMAIL PROTECTED]
> Subject: several log questions #2
>
>
> Hi there,
>
> unfortunately nobody answered my last question. I hope t
Hello Mischa,
[...]
>Second question:
>What is it good for having more than one "normal-not mirrored" logfile when
>u use automatic backup?
The automatic log backup starts to work if log_segment_size log pages were written to
the log. In the default case this is after 1/3 used logsize and then o
Hi there,
unfortunately nobody answered my last question. I hope this try is more
successfull. Thank u.
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_m
Hello,
i am trying to understand the performance of the following ABAP Sequence:
while ..
fetch next cursor %dbcursor
...
endwhile.
I would like to compare it with ABAP statements as SELECT ... ENDSELECT
or SELECT INTO TABLE.
What i do see is a WHILE loop, in which an
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
-Original Message-
From: Loc Truong
Sent: Thursday, October 23, 2003 3:39 PM
To: [EMAIL PROTECTED]
Subject: SAPDB migration questions..
Hi,
I did a SAPDB (Kernel 7.3 build 37) migration from a Window 2000 server to a Window
Microsoft Cluster(Window 2000 Proliant DL580 G2) using the
> I try the dependency setting, but my application still fail
> in an ODBC call
> (quite sure in the SapDB ODBC driver).
> Looking in the event viewer I did not see any log of SapDB
> stopping. but
> maybe event viewer service has already stopped !!!
To test if the dependencies are set, you coul
"Daniel Dittmar" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Sap DB wrote:
>
>>...
> >
> > 3) My service is running on same server than SapDB kernel, there is no
> > dependance between those services. when I shutdown my server, all my
> > ODBC/Sql command run an exception. Th
Kevin Wilson wrote:
Dan,
So in reference to your comment below, just how bad of an impact are we
talking here?
It adds a lot of I/O because every commit writes to disk. And
connections are synchronizing on the log writer. Think about a chain gang.
And if it is really bad then why would that b
Dan,
So in reference to your comment below, just how bad of an impact are we
talking here? And if it is really bad then why would that be the default
mode? (something to do with the jdbc spec I suppose)
"> 2) I saw in DBMGui a number named "waits for logwritter", this number is
> very high for
Sap DB wrote:
I'm writting an application NT service that query and update data from SapDB
odbc source.
1) My application use only one connection to datasource but many request
(statement) may be run in a same time (multiple threads).
Does anybody know if I should use a connection per thread, or i
I'm writting an application NT service that query and update data from SapDB
odbc source.
1) My application use only one connection to datasource but many request
(statement) may be run in a same time (multiple threads).
Does anybody know if I should use a connection per thread, or if nothing
will
71 matches
Mail list logo
