Hi,
are you aware of this? Just curious:
www.atstake.com/research/advisories/2003/a111703-1.txt
www.atstake.com/research/advisories/2003/a111703-2.txt
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
E-
Hi Tilo,
I am using 7.4.3.28 from 7/31/2003
Actually what I have noticed is that the user is there under Owned User
node, but none of his tables, indexes or stored procedures are in the
catalgue manager. And then it hit me, the user didn't grandet access to
DBA, thats why I cannot see them. On
Hello Glen,
have a look onto "dbmcli -d ... -u ...,... -uSQL -c info data" and "dbmcli -d ... -u
...,... -uSQL -c info log".
Best regards,
Tilo Heinrich
SAP Labs Berlin
-Original Message-
From: Case, Glen [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 5:03 PM
To: [EMAIL PROTE
Please ignore my previous e-mail. Should have RTFM but wish I had one
command I could have used consistently which could be very helpful when
you are using scripts to automate.
-Original Message-
From: Bandireddy, Madhu
Sent: Monday, November 17, 2003 12:16 PM
To: [EMAIL PROTECTED]
Subjec
Here is my environment:
SAPDB version 7.30.17 on Windows 2000.
I am using the following dbmcli command to list the backup history list
to extract the list of archive logs that are generated and copy them to
a standby server.
dbmcli -u / -d SDB -uUTL -c backup_history_list
The script with this
Hi,
I'm running sapdb 7.3.30
the db crashed with the following in the error log.
2003-11-08 07:51:12 0x674 ERR 18431 MESSAGES Could not write to event
log, rc = 31
2003-11-08 08:14:22 --- Starting ---
2003-11-17 19:11:04 0x7BC ERR 52000 LOG Pos: Log: 2318
I am looking for a dbmcli command that will show me the percent full of the
data and log volumes. I am writing a script that will capture the values
and page me is the percent full is greater than the threshold value. Is
anybody aware of one ?
Thanks
Glen Case
_
i need to create a count to acces to SAPDB but always tells me that the "password /
user id does not match" what can i do
Filip Sergeys wrote:
> In a table with a few milion records there is 1 column with only a 100
> different values. I like to build an index on that column. In
> oracle you
> can choose a bitmap type of index that is optimized for such
> situation.
> Does sapdb have something similar?
>
> Secondl
Hi,
In a table with a few milion records there is 1 column with only a 100
different values. I like to build an index on that column. In oracle you
can choose a bitmap type of index that is optimized for such situation.
Does sapdb have something similar?
Secondly, how can i force a query to use a
[EMAIL PROTECTED] wrote:
> Hi!
>
> I need to execute a query that returns all debts of a client
> over 180 days.
>
> I'm trying something like
>
> select * from MYTABLE
> where clientid = 1
>and dueDate > addDate(select DATE from DUAL, 180)
>
> but I always get an error:
>
> General erro
Mark Thomas wrote:
>
> Hello, all.
>
> Yesterday, I discovered that my SYSDBA account has lost its ability to
> change passwords--any password but its own. It was working
> on Monday. Now,
> I execute: "alter password fakeuser somepass" and I get:
> "[-5001] (at 16)
> Missing privilege:OWN
I don't prefer any of those methods because I didn't tried one of them
:o) yet. I think I've missunderstood something in your last mail.
If the rollback works I would prefer this.
Zabach, Elke wrote:
Georg Thome wrote:
Uups
I didn't know the missing because I did not need them on SapDB/MaxDB.
Bu
Leo Kirch wrote:
>
> hi,
> i've got a strange problem with a dbproc definition while
> using variables
> within. attached is the source (don't ask what i'm trying to do :)
>
> thanks a lot
> yours
> sebastian
This is a bug, we will try to fix as soon as possible.
The subquery in your last sel
Hi all,
as a bird told me another workaround for the db_activate bug in the current DBMGUI
should be the following:
To avoid this error you can install the new instance with the installation wizard and
cancel the installation wizard after the installation and before you call the recovery
wizar
Georg Thome wrote:
>
> Uups
> I didn't know the missing because I did not need them on SapDB/MaxDB.
> But I did not understand why the after update trigger does not work.
If you CHECK the old value and then return an error, the trigger fails,
the update itself fails, leaving the values as they w
Uups
I didn't know the missing because I did not need them on SapDB/MaxDB.
But I did not understand why the after update trigger does not work.
Isn't there an access to the old values?
What about inserting the values again which are deleted?
Greetings
Georg
Zabach, Elke wrote:
Georg Thome wrote:
Hello Francesco,
you can not download old versions of the Database Manager. You have to apply the
workaround until a newer version comes out, that fixes the bug.
Best regards,
Tilo Heinrich
SAP Labs Berlin
-Original Message-
From: Francesco Pagano [mailto:[EMAIL PROTECTED]
Sent: Friday,
Georg Thome wrote:
>
> If I understand you right, you want to preserve the data of one row
> being changed after insertion.
> I think the only way for doing this is via triggers.
> You have to implement a BEFORE UPDATE and a BEFORE DELETE trigger on
> that table.
Nice idea, but MaxDB does not
Hi Miro,
what version of SQL-Studio are you running? Please follow mailing list thread
http://lists.mysql.com/maxdb/17395 .
Best regards,
Tilo Heinrich
SAP Labs Berlin
-Original Message-
From: Miroslav Halas [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 5:26 PM
To: Heinrich,
hi,
i've got a strange problem with a dbproc definition while using variables
within. attached is the source (don't ask what i'm trying to do :)
thanks a lot
yours
sebastian
//-snip---
CREATE TABLE "DBA"."ELEMENT_ATTRIBUTES"
(
"ELEMENT_UID" Char (10) ASC
Hi
Thank you for your time. I am currently resourcing a SAP DB for a
maintenance and monitoring DBA position for a client in Australia. Whilst I
have several years experience recruiting Open Source applications, I have
not come across SAP DB. Can you tell me/which companies uses this in Sydney?
W
22 matches
Mail list logo
