MaxDB 7.5 alpha2 - Windows 2000 - privilege help

2004-03-01 Thread Ed Bagdonas
I have installed MaxDB 7.5 alpha 2 (7.5.01.00) on Windows 2000 with no errors; but, using the database manager, am unable to register an database instance as the name of the machine - the following error is given: -24965 logon to system failed [user_system ...] A required privilege is not he

Re: Can Not Activate New Database

2004-03-01 Thread BVW Home
Hello Everyone; Sorry for my ignorance, and thank you for all your assistance, I now have my MaxDB setup and running! Now I can learn even more. Are there any good books on SapDB/MaxDB ? I've acquired the .pdf manuals from the mysql website. Thank you for everything, Billy Willoughby

ANN: MaxDB Debian packages

2004-03-01 Thread Martin Kittel
Hi, I have prepared Debian packages of MaxDB release 7.5.00.08 that can be downloaded from ftp://ftp.charade-db.org/pub/charade-db/debian/unstable or via apt-get if you add the following line(s) to your sources.list: deb ftp://ftp.charade-db.org/pub/charade-db/debian unstable/ deb-src ftp://ft

Cant start DB, Kernel Environment issues.

2004-03-01 Thread rickb
Hi, I posted before, hopefully someone else has seen this. I have installed on three different redhat machine and get the same error on all of them. Below I have listed the error and other possible step to start or diagnose the problem but I am getting nowhere. any help is appreciated. PS. I a

RE: Problems using jdbc

2004-03-01 Thread Schroeder, Alexander
This is again a 'Trend Micro' problem. Someone (the admin of your machine) seems to have installed something like Trend Micro's InterScan AppletTrap(tm) and it seems to forbid you to open a socket ... Please look how to change the rules of this antivirus so that it permits you contacting a host

RE: MaxDB loadercli tableextract - lock tables? backup

2004-03-01 Thread iml-sapdb
On Mon, 1 Mar 2004 11:15 , 'Schildberg, Steffen' <[EMAIL PROTECTED]> sent: >> I found that using tableextract PAGES of all tables I get >> 4.7GB. Is this because the indexes are left behind? 12GB vs >> 4.7GB is pretty big difference. >> >Yep, could be. It depends of course on the indexes yo

loadercli 'use user' defaults to localhost

2004-03-01 Thread iml-sapdb
Hello Steffen, Any progress on this topic? It is DBEXTRACT that concerns me most and is partly responsible for misleading me :) DBEXTRACT creates a catalog script that will do things such as: USE USER a CREATE TABLE a1 USE USER B CREATE TABLE b1 instead of: CREATE TABLE a.a1 CR

Re: Problems using jdbc

2004-03-01 Thread Victor Medina
Hi! On Mon, 2004-03-01 at 09:58, [EMAIL PROTECTED] wrote: > Hello! > > I recently downloaded the actual version of the jdbc-driver and installed > it. > Then I compiled the Example program from the documents but with some > changes: > > i. database_server ="VIF3711"; (this is my local computer

RE: 24965 logon to system failed

2004-03-01 Thread Zabach, Elke
Silke wrote: > > Hi all, > we've got a > - Windows XP system and > - Sapdb 7.5.0.08 > running. > > param_startsession > param_init > param_put MAXUSERTASKS 100 > param_put MAXDATAVOLUMES 2000 Really MAXDATAVOLUMES, i.e. the number of data volumes/disks you want to store data on? Oops, that see

RE: problems with python modules after build from sources while l oading systabs

2004-03-01 Thread Dittmar, Daniel
> Up to now i succeed until the point where i try to load the > systabs into > a new database instance. Now i seem to have a problem with the python > modules. > > The exact problem is: > When I do a > load_systab -ud init [...] > The python version that was used during the build time is

Re: Problems using jdbc

2004-03-01 Thread Victor Medina
Hi! The security model of the Java Platform won't let you access any resource outside the browser environment. Supposing that you code is just right, testing the applet in a different machine should give no problem. Best Regards! On Mon, 2004-03-01 at 09:58, [EMAIL PROTECTED] wrote: > Hello!

Problems using jdbc

2004-03-01 Thread stefan . dallwig
Hello! I recently downloaded the actual version of the jdbc-driver and installed it. Then I compiled the Example program from the documents but with some changes: i. database_server ="VIF3711"; (this is my local computer!) ii. instance name ="TST74"; (<= there is still a 7.4 instance on my mach

ERR: 24965 logon to system failed

2004-03-01 Thread Silke
Hi all, we've got a - Windows XP system and - Sapdb 7.5.0.08 running. param_startsession param_init param_put MAXUSERTASKS 100 param_put MAXDATAVOLUMES 2000 param_put LOG_SEGMENT_SIZE 1000 param_checkall param_commitsession db_admin db_activate DBA,DBA after creation of a database with the s

Re: reg oracle to maxdb migration

2004-03-01 Thread Filip Sergeys
Hi, I have a perl script that connects to oracle and sapdb at the same time and move data from one database to the other based on a list of tablenames in a plain text file. Performance is however an issue because it does plain select - insert statements I' m stil trying to get perl to work with th

RE: Update statistics

2004-03-01 Thread Zabach, Elke
Ajit Aranha wrote: > > Hi, > Where in the documentation can I find info on update statistics (for > 7.3 / 7.4). http://www.sapdb.org/7.4/htmhelp/3b/86f067458411d3a98200a0c9449261/frameset.htm > > Is there a guide on using the optimizer in the dbmgui and what doing > this actually does 'under

RE: MaxDB loadercli tableextract - lock tables? backup

2004-03-01 Thread Schildberg, Steffen
Hi Stephen, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > I am feeling like loadercli is not getting attention it > needs. I've posted several topics related to it and wasted a > lot of time due to design > problems I have reported. Is no one at SAP / MySQL actively > taking this t

RE: user-defined-function in insert-select (was:CHR(NUM()) )

2004-03-01 Thread Zabach, Elke
'Jean-Michel OLTRA' wrote: > > Le mardi 17 février 2004, Zabach, Elke a écrit... > > bonjour, > > > > http://lists.mysql.com/maxdb/19753 > > They are implemented, but not tested and containing many bugs. > > 7.5.1 is recommended. > > Hmmm ! instance crashes at early tries... > > For now

Update statistics

2004-03-01 Thread Ajit Aranha
Hi, Where in the documentation can I find info on update statistics (for 7.3 / 7.4). Is there a guide on using the optimizer in the dbmgui and what doing this actually does ‘under the hood’ ?? Regards, Ajit

RE: Deadlock and LOCKSTATISTICS

2004-03-01 Thread Zabach, Elke
Andre Reitz wrote: > > Hy all, > > We are using: > sapdb-7.4.3.31 on linux (rpm-installation) > > > a question: > how do I have to interprete this "SELECT * FROM LOCKSTATISTICS" > (we sometimes run into deadlocks.) > > Is the whole Table locked? > (ROWID columns seem to be NULL) >

Re: DEADLOCKS Caused by SELECTS

2004-03-01 Thread Andre Reitz
On Mon, 23 Feb 2004 15:58:03 +0100 "Schroeder, Alexander" <[EMAIL PROTECTED]> wrote: > > > i dont think, that you are right. > > are you really sure that you do not mean isolationlevel > > 'serializable'. > > > > Uhm, err, yes - it is only such strict for 'serializable'. I messed it up :-) >

RE: Any way to control Temporary Table performance?

2004-03-01 Thread Zabach, Elke
[EMAIL PROTECTED] wrote: > > > Hi, > > We are working with our newly aquired 8GB Sun Solaris Sparc > system. We figured once the DATA_CACHE was populated that > most of our > SELECT statements would scream... as we are only working with > 10GB of data... > > Solaris shows that disk writes

RE: Sum(amount) query

2004-03-01 Thread Zabach, Elke
Yusuf Gangat wrote: > > Hi guys > > I am having a bit of a problem. I have the following query to sum the > amounts in a table : > select sum(amount) from transactionfile where sub_account = '6000' and > transactiondate >= '2004-02-1 00:00:00' and transactiondate <= > '2004-02-29 00:00:00' and a

RE: ORDER BY number/char ??

2004-03-01 Thread Zabach, Elke
Ajit Aranha wrote: > > Hi, > I need to order by the numeric value of a char column. > (to get a an order like 1,2,3,4,...10,11 (numeric) instead of > 1,10,11,2,3 (char) ) > > Here is a query which does'nt work which hopefully > demonstrates what I'm > trying to do. > > SELECT * FROM SOME_

RE: MaxDB UPDATE STATISTICS on clones / replication partners

2004-03-01 Thread Becker, Holger
[EMAIL PROTECTED] wrote: > As I have mentioned on the list on the past... UPDATE > STATISTICS requires lots of slow disk I/O and it locks the > tables. Some of our tables > are large and the lock can last for long periods (30 minutes > or longer for a single table). Yes, this is on professio

RE: Can Not Activate New Database

2004-03-01 Thread Strahl, Torsten
Hi Billy, I assume that your log area is full! You have to activate the autosave log feature! Scan the archive for detailed informations. Regards, Torsten SAP DB, SAP Labs Berlin -Original Message- From: Billy Willoughby [mailto:[EMAIL PROTECTED] Sent: Montag, 1. März 2004 03:14 To: '[E