Update statistics

2005-05-04 Thread Michael Andrewes
n question. regs Michael Andrewes -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Row locking problem. - Vtrace (new driver)

2005-04-12 Thread Michael Andrewes
Hi, Perfect, I'll upgrade in the next few weeks. Regards Michael Andrewes -Original Message- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: Tuesday, 12 April 2005 12:21 AM To: Michael Andrewes; maxdb@lists.mysql.com Subject: AW: Row locking problem. - Vtrace (new driver) Mi

RE: [-602]: System error: Move error

2005-04-10 Thread Michael Andrewes
nown issue with this/older releases? This problem has only JUST started happening, with a query I've been using for quite a while. Regards Michael Andrewes -Original Message- From: Becker, Holger [mailto:[EMAIL PROTECTED] Sent: Friday, 8 April 2005 7:11 PM To: Michael Andrewe

RE: [-602]: System error: Move error

2005-04-07 Thread Michael Andrewes
ithin the in() clause. Regards Michael Andrewes -Original Message- From: Michael Andrewes [mailto:[EMAIL PROTECTED] Sent: Friday, 8 April 2005 9:24 AM To: 'SAP DB mailing list' Subject: [-602]: System error: Move error Hi, I got this error this morning with a statement s

[-602]: System error: Move error

2005-04-07 Thread Michael Andrewes
make sure that that duplicates are removed from here on in. My question is, what is -602? This error is pretty hard to reproduce, I am trying to get a vtrace. regards Michael Andrewes COMMUNICATOR INTERACTIVE www.communicator.com.au P +612 9256 0912 F +612 9256 0922 M +61 410 677 458 PAGE

RE: Row locking problem.

2005-01-22 Thread Michael Andrewes
ude any, as that’s not what this thread is for. I will get a vtrace and send it in. Thankyou Michael Andrewes -Original Message- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: Saturday, 22 January 2005 2:18 AM To: Michael Andrewes; Schroeder, Alexander; SAP DB mailing list Subj

RE: Row locking problem.

2005-01-19 Thread Michael Andrewes
ings going on will be useful, and I'll put it in. Regards Michael Andrewes -Original Message- From: Schroeder, Alexander [mailto:[EMAIL PROTECTED] Sent: Wednesday, 19 January 2005 6:21 PM To: Michael Andrewes Subject: RE: Row locking problem. Hello Michael, getting back to you

Row locking problem, row sometimes seems to not exist.

2005-01-18 Thread Michael Andrewes
am hoping that there may be an extra lock suffix I can append to the query, or perhaps I database parameter. Is there any information I can provide that will help in resolving the problem? Regards Michael Andrewes *** As I said in my email, I went through and noticed that exceptions

RE: Row locking problem.

2005-01-16 Thread Michael Andrewes
not be the application as far as I can tell, as any database errors would now be being passed to the top level, but instead Still the exception I generate if the property value is null is being thrown, which is of course just after getting the result from the DB. *** Regards Michae

RE: Row locking problem.

2005-01-12 Thread Michael Andrewes
Sorry, Step 2 is this select " + fieldNames() + " FROM " + TABLE_NAME + " WHERE property_name = ? and promotion_id = ? FOR UPDATE OF property_value -Original Message- From: Michael Andrewes [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 January 2005 2:22 PM To:

Row locking problem.

2005-01-12 Thread Michael Andrewes
so am at a loss, but it happens in our Production environment between 0 and 2-300 times per day. I currently work around it by initialising the property somewhere else, then if the property is null, I reprocess the SMS message (works, but sometimes has a few goes). Michael Andrewes - Software

RE: MIN() and MAX() on primary key column very slow

2004-09-06 Thread Michael Andrewes
Hi, I'm currently still using 7.4 in production (7.5 in test and development). I assume it's also a known bug with 7.4? Regards Michael Andrewes -Original Message- From: Becker, Holger [mailto:[EMAIL PROTECTED] Sent: Monday, 6 September 2004 6:34 PM To: 'Michael And

MIN() and MAX() on primary key column very slow

2004-09-06 Thread Michael Andrewes
ng the min() and max() values of the primary key column? regards Michael Andrewes - Software Director C O M M U N I C A T O R Interactive Marketing P +612 9719 1469 F +612 9719 1796 M +61 410 677 458 PAGER +612 9214 8752 W www.communicator.com.au Copyright Communicator Interactive Marketing P

Backup file size

2004-06-17 Thread Michael Andrewes
am running redhat linux 7.3. Is the backup file size limited to 2 GB? And if so, how am I supposed to do a complete backup? Regards Michael Andrewes - Software Director C O M M U N I C A T O R Interactive Marketing P +612 9719 1469 F +612 9719 1796 M +61 410 677 458 PAGER +612 9214 875

RE: Database link in Oracle

2004-06-10 Thread Michael Andrewes
our database. Is this not what archive instances are for/capable of? Regards Michael Andrewes -Original Message- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 June 2004 5:07 PM To: 'Dusan Kolesar'; SAP DB mailing list Subject: AW: Database link in Ora

Backup procedures.

2004-06-03 Thread Michael Andrewes
d way to do my backups, or would it be better if I also backed up the logs each night along with the migration data backup? regards Michael Andrewes - Software Director C O M M U N I C A T O R Interactive Marketing P +612 9719 1469 F +612 9719 1796 M +61 410 677 458 PAGER +612 9214 8

RE: SapDB 7.4 regular crash on backup

2004-06-03 Thread Michael Andrewes
how it goes. However after reading this page http://developer.postgresql.org/docs/postgres/kernel-resources.html I am confident this will fix my problem. Thanks everyone for your help. Hopefully I will have no more crashes. Regards Michael Andrewes -Original Message- From: Michael

RE: JDBC error: restart required

2004-06-03 Thread Michael Andrewes
Hi, Does this happen after a backup? -Original Message- From: Donatas Ciuksys [mailto:[EMAIL PROTECTED] Sent: Friday, 4 June 2004 12:46 AM To: [EMAIL PROTECTED] Subject: JDBC error: restart required Hi, I'm using MaxDB 7.5.00.12, JDBC driver 7.5.01.00, Apache jakarta DBCP (database

RE: SapDB 7.4 regular crash on backup

2004-06-03 Thread Michael Andrewes
Hi, Thanks, your backup settings are similar to mine. I will keep this in mind. What prompted you to increase the settings in sysctl.conf? Was it problems similar to mine? Or prior knowledge/documents? Regards Michael Andrewes -Original Message- From: Döhr, Markus ICC-H [mailto

RE: SapDB 7.4 regular crash on backup

2004-06-03 Thread Michael Andrewes
I will adjust the values tomorrow and post my results. Thankyou Michael Andrewes -Original Message- From: Filip Sergeys [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 June 2004 6:39 PM To: Michael Andrewes Cc: 'Brunzema Martin'; [EMAIL PROTECTED] Subject: RE: SapDB 7.4

RE: SapDB 7.4 regular crash on backup

2004-06-03 Thread Michael Andrewes
server during that hour), which by the last backup tend to be around 3-400 mb. Is the amount of memory for semaphores (as I assume this setting is) the general consensus on why this is happening? Regards Michael Andrewes -Original Message- From: Filip Sergeys [mailto:[EMAIL PROTECTED

RE: SapDB 7.4 regular crash on backup

2004-06-03 Thread Michael Andrewes
Could you please provide some more information? Regards Michael Andrewes -Original Message- From: Brunzema, Martin [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 June 2004 4:41 PM To: 'Michael Andrewes'; [EMAIL PROTECTED] Subject: AW: SapDB 7.4 regular crash on backup > -

SapDB 7.4 regular crash on backup

2004-06-02 Thread Michael Andrewes
while ago where sap/the OS just DELTED it's log volume, half its config files, and some of it's data volume (ie, we lost everything up until our previous montly full backup), However I also cannot have the database shutting itself down all the time. regards Michael Andrewes - Software