Synchronization Questions

2006-09-13 Thread Andres Rebolledo
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 th

RE: sql help needed

2006-09-13 Thread Zabach, Elke
Luca Calderano wrote: > > I have the two tables below: > > Table A > --- > Date| Value > 2006-09-01 | 100 > 2006-10-01 | 200 > 2006-07-01 | 50 > > Table B > --- > Date| Value > 2006-09-13 | 100 > 2006-07-25 | 50 > > I need to do a dbproc showing

sql help needed

2006-09-13 Thread Luca Calderano
I have the two tables below: Table A --- Date| Value 2006-09-01 | 100 2006-10-01 | 200 2006-07-01 | 50 Table B --- Date| Value 2006-09-13 | 100 2006-07-25 | 50 I need to do a dbproc showing the following result: RESULT -- PROGR | A.Da

-24998 error

2006-09-13 Thread Cappellano, John J
I am running Gui version 7.5.00.12 with Kernel version 7.6.00 of the MaxDB database on HP-UX 11.23 server. The install is part of an APO/SCM SAP setup. I am consistently getting -24998 upon logging into the DBM Gui, selecting SQL User tab and a few others. I can hit okay and things seem to work ok.

RE: -24998 error

2006-09-13 Thread Cappellano, John J
This is the error I am getting from my database manager log file. ERR -24950 DBMSrv ERR_USRFAIL: User authorization failed DBMSrv DBM Server client disconnect: PID 11889 on computer sapd014.amp.com Thanks From: Cappellano, John J Sent: Wednesday, Septemb

Re: Moving from version 7.5 to 7.6

2006-09-13 Thread Ranadave Mukherji
Hi, Tried that on a few tables, all i get is "0 rows affected" and a time. Maybe it is the way I upgraded the database? Rana On Monday 11 September 2006 14:20, Jey Razack wrote: > try to perform 'UPDATE STAT ' on each table. > on huge tables use the 'ESTIMATE SAMPLE nn PERCENT' option. >

RE: Another autosave question

2006-09-13 Thread I.Molenbuur
Hi Michael, Using the dbmcli commands in a script and periodically running the script will do the job for you. In the script you must perform the following steps: - switch off autosave - perform a manual logbackup - switch on autosave Regards, Imko -Oorspronkelijk bericht- Van: Michael

ADO.NET provider for MaxDB 0.8.5

2006-09-13 Thread Dmitry Key
Hi, all. The version 0.8.5 of ADO.NET provider for MaxDB is released, binaries and source code can be downloaded from http://www.sf.net/projects/maxdbprovider. New features: 1. Connection pool support. 2. GUI installer for the Windows platform. Besides stress tests are optimized and some mino