[FSID] How to drop a public function?

2005-09-19 Thread Andreas Goldstein
Hi Listmembers, I defined a public function on my 7.6.00.12-Windows MaxDB. Now I would lik to change the function, but I can not drop the old version :( Here is what I did in more detail: Logged into the DB-instance as DBAdmin CREATE PUBLIC FUNCTION KDSUMME ... Worked well Now I would like to

DBA Password Change (Resend)

2005-09-19 Thread Rob See
(this is a resend of a question I asked last week. There is indication in the archives that this condition is due to a bug, but that was at least a year ago. Please let me know if anyone has any workarounds, or if it is a bug when it will be fixed. Thanks.) Hi, I need to change my DBA p

Re: How to track DB usage of user

2005-09-19 Thread Ralf Schneider
Am Montag, 19. September 2005 17:28 schrieb Robert Klemme: > You could do reports like > > select user, count(*) > from your_table > > to see which user takes up how much space of the table. If you > combine this with information about the whole table's size you can > even calculate MB a certain u

Re: How to track DB usage of user

2005-09-19 Thread Robert Klemme
With Oracle you can set limits to users. I don't think this is possible with MaxDB. You could do reports like select user, count(*) from your_table to see which user takes up how much space of the table. If you combine this with information about the whole table's size you can even calculate M

RE: ORIGINAL_RUNDIRECTORY parameter

2005-09-19 Thread Heinrich, Tilo
Hello David, it will not look into that directory directly, but it will restore files dbm.knl and dbm.ebf of database D1 temporarily when they are needed (e.g. for function "dbmcli -d D2 ... backup_ext_ids_get D1"). Best regards, Tilo Heinrich SAP Labs Berlin -Original Message- From: Da

How to track DB usage of user

2005-09-19 Thread Ralf Schneider
Hi, I've a Java application on top of MaxDB. This application provides accounts for different users. All my tables have the userID as column to distinguish the data of the users. I want to track how much DB space is used by each user for checking the current usage against a defined limit. How

ORIGINAL_RUNDIRECTORY parameter

2005-09-19 Thread David Lane
What is the usage of the ORIGINAL_RUNDIRECTORY parameter? The documentation says 'use this only for a migration'. I'm creating a database (D2) by recovering a backup of another database (D1). I specify ORIGINAL_RUNDIRECTORY in the BSI_ENV file of database D2. Does that mean that the recovery will

ireport in 7.6 releases

2005-09-19 Thread Jean-Michel OLTRA
bonjour, I was used to ireport, for sql queries, with the 7.5 maxdb releases. Is ireport deprecated in 7.6 release (7.6.00.12) ? -- jm -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]