> >I was backing up the log every hour too, however as I don't
> >need the log to
> >get my data back from a migration backup, and it created so
> many files
> >I decided I would just leave it autolog backup.
>
> If you backup log every hour you should get at maximum 24 log
> backups more, as i
Hi:
When a data base convert row locks into a table lock (lock
escalation)?
How I can prevent the lock escalations?
Thanks.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
After using SDBINST to upgrade my 7.3.0.46 server and its instances
(production and a test one (the test one isn't ever used)) I can enter Admin
mode but any attempt to enter online causes shutdown. Also other select
operations in Admin mode causes a shutdown to occur as well. Below is a
snippet of
Erick,
Well, there are several different ways to go about this, depending on
what you want. The easiest way (similar to MS Access's auto increment)
is to do something like:
CREATE TABLE auto_inctable (foo int DEFAULT SERIAL, bar varchar(20))
This will create a table with an auto incrementing col
I use studio and DBM gui, i just wanted to try that tool because is
supposed to be more easy to use.
I now have to setup an odbc connector and let a MS Access frontend app and
an ENVOX voice app to talk to the mysql. If you happen to have code to setup
a mysql function similar to the "autonumber"
Here is the doc link I am referring to:
http://dev.mysql.com/doc/maxdb/en/88/c290d224d9e140a9c70480c233/content.
htm
If sdbinst can do the migration then why not use the very same logic to
allow the dbmgui to migrate 7.3 images to a 7.5 server?
-Original Message-
From: Kevin Wilson
Erick,
I didn't know you could use MySQL administrator with MaxDB. I may be
wrong, but I don't know of a way to do that. You might want to try DBM
GUI and SQL Studio. Both are available here:
http://dev.mysql.com/downloads/maxdb/7.5.00.html
Cheers,
JLS
Erick Perez wrote:
indeed is 7210 tcp (im u
You have GOT to be joking! Everything in the docs state that an image newer
than 7.3.0.25 can be migrated.
2004-06-07 09:20:36 7930 ERR 52000 RESTORE Kernel 7.3.0 Build
046-000-094-452
2004-06-07 09:20:36 7930 ERR 52000 RESTORE Restore not possible. Hostfile
too old!
2004-06-07 09:20:36 7929 ER
indeed is 7210 tcp (im using windows).
i wanted to try mysql administrator but the program does not seem to work. I
enter dba/pass and port 7210 and it never connects
anyways..thanks
erick
-Original Message-
From: John Singleton [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 0
Hello Shesh,
do you mind sending the file dbm.ebp or if existent dbm.ebl to the list? Most probably
the backup tool needed more time to finish the backup, then the DBM Server would grant
it.
Best Regards,
Tilo Heinrich
SAP Labs Berlin
>-Original Message-
>From: H.K, SHESHACHALA (STSD)
Hello Michael,
>Currently we are backing up every hour.
>Due to a type of failure we had recently where memory in our db server
>failed and DELETED some database config files and some data
>files I do all
>backups for MIGRATION.
If your database version is 7.4 or above, there is no difference be
Hello all,
So I think I've pretty much got MaxDB's name resolution system down. But
I just wanted to post to the list to make sure :)
So, from what I've been able to determine, it works like this:
1) Say I have three users. DBA, DBA2, and DBA2USER. DBA creates DBA2
then DBA2 creates the resource
Hello Timo,
in most cases you are right, however, if log backups were created in parallel to the
incremental backup log backups before LOGSAVE 10 could be needed. You can have a look
into your backup history columns 8 and 9. They contain numbers (log page number or log
IO sequence number) order
Hello John,
Ouch. I forgot that it is possible to create a synonym
graphically, and assumed you typed the CREATE SYNONYM
in an SQL window omitting the user qualification.
Lets call that 'limitation' a bug.
It will be corrected in the next version.
Sorry for the inconvenience and thanks for report
Hi Markus,
Do you know if this will be corrected in the future? I'm trying to
figure out how to document it. If this won't be corrected in the future,
SQL Studio is limited to creating synonyms for objects the current user
owns. In theory, however, SQL Studio could create a synonym for any
obje
Hi Kevin,
you send me the knldiag of the failed recovery attempt?
Regards,
Torsten
SAP DB, SAP Labs Berlin
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 7. Juni 2004 16:49
An: [EMAIL PROTECTED]
Betreff: DBMGUI v7.5.00.11 & 7.4.3.30 fail
Using the older DBMGUI 1st edition you cannot do the migration to a 7.5
server as the bug link suggests. You get the error:
-24988 sql error [util_execute INIT CONFIG]; -3008, Invalid keyword or
missing delimiter.
-Original Message-
From: Kevin Wilson
Sent: Monday, June 07, 2004 9:49 AM
Thanks, I'll check it out
Gustav Brock <[EMAIL PROTECTED]>
06/07/2004 09:45 AM
Please respond to Gustav Brock
To: [EMAIL PROTECTED]
cc:
Subject:Re: MaxDB, ODBC, and ADO question
Hi James
OK. Within the current session you probably need to:
First, rel
migrate a 7.3.0.46 migration backup to a clean install MaxDB 7.5.0.14 server
installation. I have migrated instances before using the dbmgui so I do know
the process. The error given is:
-24988 sql error [db_activate RECOVER DATA]; -111, incompatible
incremental backup
Here is the link which sta
Hello,
Is it possible theoretically or rather is it SQL compliant that a single
select in one unit of work to give a result set that duplicates a row
with the same PK? The select would be issued using READ_COMMITED
isolation level and looks like this: "select col1, pk from table where
col1=1 or
Hi @all,
i need some advice with an trigger statement. When i execute this statement
in the SQL Studio, i became this error.
Error ---
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Syntax error or access violation;-3005 POS(1) Invalid SQL statemen
Thanks Elke,
The first problem is sorted out. I am minimised the value of
SESSION_TIMEOUT value to 100, it worked. But I am getting the second
error.
Error: SAPDB responded with:
-24920,ERR_BACKUPOP: backup operation was unsuccessful
The backup tool was killed with -1 as sum of e
> -Ursprüngliche Nachricht-
> Von: Gianluca Sensidoni [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 3. Juni 2004 11:33
> An: [EMAIL PROTECTED]
> Betreff: to_date function - Oracle to MaxDB
>
> Hi to all
> We are working for a porting from Oracle to MaxDB. Inside our project
> there a
Hi James
OK. Within the current session you probably need to:
First, relink the TableDefs using the new User ID/Password.
Then, either use CurrentDB or use DBEngine with a refresh of the
TableDefs collection:
DBEngine(0)(0).TableDefs.Refresh
For a developer Access list visit:
AccessD mailin
That is correct, I am trying to use access only as an application (no
security at all within Access), then I want to connect to the linked
tables using the MaxDB security.What I have currently is one user who
has read only rights and aother that has update, and I want to be able to
log on w
Hi Alex,
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Sonntag, 6. Juni 2004 22:15
> To: [EMAIL PROTECTED]
> Subject: Re: Webtools/ODBC problem: libsqlod.so not found...?
[snip]
> (1) Segmentation fault
[...]
IIRC, unixODBC offers a small sql-query tool
H.K, SHESHACHALA wrote:
>
> Hi,
>
> Can anyone help on this:
>
> Error: SAPDB responded with:
> -24988,ERR_SQL: sql error
> 1,task limit
>
There are two possible reasons:
1. you specified the database-parameter (during installation) MAXUSERTASKS with the
value x, meaning that in ma
Le dimanche 06 juin 2004, [EMAIL PROTECTED] a écrit...
> I have no indep_prog in my MaxDB installation directory, and as far as I
> understand the official documentation (which is *hard* to understand, so I
> may be wrong...) this directory has to be used only in case there's
> already an insta
Hi,
Can anyone help on this:
Error: SAPDB responded with:
-24988,ERR_SQL: sql error
1,task limit
Rgds
Shesh
I mean something like this:
CREATE FUNCTION TEST(VAL INT) RETURNS NUMBER AS
BEGIN
IF VAL < 5 THEN RETURN TEST(VAL+1)
ELSE RETURN VAL;
END;
it's just an example of course...
thanks in advance
joannes
- Original Message -
From: "Zabach, Elke" <[EMAIL PROTECTED]>
To: "'Joannes Ca
Joannes Capitanio wrote:
>
> Is it possible to create recursive function inside maxdb?
>
What do you mean with 'recursive function' ?
Are we talking about recursive selects as described here?
http://dev.mysql.com/doc/maxdb/en/a7/41ee26605911d3a98800a0c9449261/frameset.htm
Elke
SAP Labs Berlin
Is it possible to create recursive function inside maxdb?
thanks in advance
joannes
> -Ursprüngliche Nachricht-
> Von: Billy Willoughby [mailto:[EMAIL PROTECTED]
> Gesendet: Samstag, 5. Juni 2004 16:36
> An: [EMAIL PROTECTED]
> Betreff: Foreign Key Question
>
> Hello Everyone;
>
>I have a foreign key I'm trying to create to cascade a delete and I
> keep getting
Hello John,
you wrote :
> I have two users, DBA, and DBA2. I also have 2 tables FOO and
> BAR. FOO
> belongs to DBA and BAR belongs to DBA2. DBA has all
> privileges on DBA2's
> tables and vice-a-versa.
>
> Now: In sqlcli I can use the create synonym statement to create a
> synonym like this
I've a database into which I use triggers to compute some fields values when
inserting or updating a record.
Until version 7.5.00.11, everything works fine. But in 7.5.00.14, the
trigger crashes the database instance. It crashes when executing the update
statement.
CREATE TRIGGER TABLE1_UPDATE FO
35 matches
Mail list logo
