Re: maxdb 7.6.00.37

2007-09-28 Thread Simon Matter
> Hi > > > > I have a problem when try to install a version 7.6.00.37 of Maxdb for > linux > and Solaris (no sparc processor). > > > > The version of linux is Fedora 7. version of Solaris 10 > > > > In linux try to install , first whit tgz installer, nothing, the > installation abort this problem i

Re: Use of libSQLDBC with gcc 4.0.x

2007-07-01 Thread Simon Matter
> Hello *, > > I will give my problem directly to the list after I had searched in > the archive. But I did not find my problem in list. So I hope someone > can help. > > I have installed MaxDB 7.6 on Linux 10.0 with kernel 2.6.13-15, to start > with development in C++ I found in the tutorial an ex

RE: What's going on with websql in 7.6?

2006-11-23 Thread Simon Matter
alternative location (I'm running 7.6 installed via rpm) and on another port. That way I can still use the 7.6 webdbm and also update the maxdb-web rpm without conflicting with websql75. Regards, Simon > > regards, > > Markus > > -Original Message- > From:

What's going on with websql in 7.6?

2006-11-23 Thread Simon Matter
I'm still wondering what's going on with websql in 7.6? IIRC it was said that it will reappear in an upcoming 7.6 release, but I still can't find it in the current release. Thanks, Simon -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://li

RE: Pipe Question during Backup

2006-11-08 Thread Simon Matter
>> I am backing up via the DBM Gui to a pipe on HP-UX 11.11 (7.5 database >> release). The pipe is sending 8k chunks at a time. Is there a way to >> increase the chunks being sent to the pipe to help increase the backup >> speed. Currently 10g of data backed up via the pipe to a gigabyte line >> in

Re: Help! I want to shrink my MaxDB 7.6 backup

2006-10-05 Thread Simon Matter
> Hello MaxDB users, > > For a test environment I backup a MaxDB 7.6 database to a filesystem. I > use a Backup Medium of: > Backup Type: Complete Data > Device Type: File > Backup Tool: None > Device/File: > > The volume of the test database is now around 50 GB and growing. It > takes quite long

Re: incremental Backup

2006-08-30 Thread Simon Matter
> Outage of our application (jboss). > We do our backup in online mode. > But while backup is running, operation of jboss applications is hightly > restricted. > Sometimes it is not possible to create new connections. > An other restriction is, that our main table is locked too long time, so > we g

RE: maxdb 7.6.0.32 rpms depend on glibc 2.3.4

2006-07-28 Thread Simon Matter
n RHEL3 anymore. Thanks, Simon > > Best regards, > Daniel > > > -Original Message- > From: Simon Matter [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 20. Juli 2006 11:14 > To: maxdb@lists.mysql.com > Subject: maxdb 7.6.0.32 rpms depend on glibc 2.3.4 > > H

maxdb 7.6.0.32 rpms depend on glibc 2.3.4

2006-07-20 Thread Simon Matter
Hi, The latest maxdb rpms 7.6.0.32 depend on glibc-2.3.4, which makes them unusable on distributions like RedHat EL3, which uses glibc-2.3.2. Is there a reason why this specific glibc version is needed now? Thanks, Simon -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/

Re: New MaxDB software version 7.6.00.32 available now

2006-07-20 Thread Simon Matter
> > Hello, > > The new version 7.6.00.32 of MaxDB software and binaries is available > now. > You can download it at http://dev.mysql.com/downloads/maxdb/7.6.00.html. > For the new features in this version see > http://dev.mysql.com/doc/maxdb/changes/changes_7.6.00.32.html. Thanks for the new rele

Re: Hosts File

2006-07-17 Thread Simon Matter
> Hi, > > Is it really necessary to insert in the linux hosts file the ip adress of > each workstation to improve db response time? Of course not. Having properly configured DNS is the preferred solution to all name resolution problems. You only need a hosts file if you don't have DNS or it's not

Re: Please help with configuration

2006-07-13 Thread Simon Matter
and adjust to fit your needs. Simon > > Do you agree? > > > On 7/13/06, Simon Matter <[EMAIL PROTECTED]> wrote: >> >> > Simon, >> > >> > Memory usage: >> > total used free sharedbuffers >>

Re: Please help with configuration

2006-07-12 Thread Simon Matter
If some of the 294M is related to MaxDB, it's very clear that it may slow down things. I think reducing cache_size may help a bit then. Simon > > I changed the maxcpu parameter to 1. Lets see what happens. > Thank you very much for the help. > > Best regards >

Re: Please help with configuration

2006-07-12 Thread Simon Matter
>> MAXCPU is already with value 2. >> cat /proc/cpuinfo | grep "processor" | wc -l returns 2 processors. You get 2 processors but you also get that with 1 CPU and HT enabled. If you have only 1 single core CPU, set MAYCPU to 1, really. BTW, how is your real memory usage? It looks a bit high for

Re: shmmax

2006-06-09 Thread Simon Matter
> Hi Simon, > > Thank you for your script, but can you tell me what it does? It sets the kernels shmmax parameter to 104857600, but only if it is smaller than 104857600. I don't remember how I came to use 104857600, it's a long time ago... Simon > > best Regards &

Re: shmmax

2006-06-08 Thread Simon Matter
> Hi, > > Do you have any documentation about shmmax parameter? > I have a server with 2 Gb of Ram, 2 processors and it is slow. > I need to correct it.I need to find out what is happening. > I think it is this parameter. I have no docs but I've put this into my init scripts: SHMMAX=$(/sbin/sys

Missing file in the 7.6.0.16 rpms

2006-03-22 Thread Simon Matter
I have tried to restore a 7.5 backup to a new 7.6.0.16 server installed via rpms. All went well but load_systab failed because of a missing file. The file ist TRIGGER.py, which is installed in /opt/sdb/7600/env. Adding TRIGGER.py from the tarball made it for now but it would be nice if this could b

Re: Automate Database Backups

2006-03-01 Thread Simon Matter
> In our shop we use Veritas Netbackup. It talks about using the BACKINT > executable to run database backups for MaxDB. I am still sifting through > the rubble on this but would appreciate any tips from users who have > this in place. Or if not this any other software/suggestions to help out > wit

Re: Migration SAPDB 7.3.00.48 to MAXDB 7.6. with in Place-Migration // 2 problems

2006-02-06 Thread Simon Matter
> Hi Daniel, > this helped, but I still get an error when I try to switch to admin state: > > --- > -bash-3.00# /root/maxdb-all-linux-32bit-i386-7_6_00_16/SDBINST -main > SAPDB::Install::Instance::ChVolPerm::main -v -d ZIPDB3F > MSG >>> changing permissions of database files... > INFO>>> chperm 660

Re: Managing Time on MAX DB Systems

2006-01-03 Thread Simon Matter
> I was wondering if anyone else on the list has > experienced any issues with MAXDB while running > NTP to keep the time in sync. > > We were running SAP DB last summer and experienced > some strange issues while running NTP (missing > records being one). Right now we are stopping the > DB and upd

Re: Betr.: Re: Very poor performance of sapdb

2005-11-18 Thread Simon Matter
> Hello Simon, > > Both raid controllers are brand new and working with cache. Well, brand new doesn't mean the cache is working in write-back mode. If the battery voltage is too low, the controller puts the cache in write-trough mode until the capacity of the batteries is on the safe side. So, re

Re: Very poor performance of sapdb

2005-11-18 Thread Simon Matter
> Hello, > > We use sapdb 7.4.3.31-1 on two different servers. > One server is a Dell PowerEdge 6850 and the other is a HP Proliant DL580 > G3. > When checking both systems, the dell is a little bit faster when writing > to disk and reading from disk but this is normal because the Dell has 256M > c

Re: MaxDB on Linux: XFS or ReiserFS?

2005-11-12 Thread Simon Matter
> I would appreciate if some of you could post your opinions on which > filesystem is better (performance + stability) for MaxDB OLTP operations: > ReisferFS 3.x or XFS? We are using SAPDB/MaxDB on LVM/XFS for years now and never had any problems. I guess at least performance wise XFS is better th

RE: unable to create another db instance

2005-10-14 Thread Simon Matter
lt. Did you create the directory in which the data files are located first? And then you need write permissions for the user under which the instance runs. However, I have never used MaxDB on Windows, so there could be something specific I don't know. Simon > > Johan > > ---

Re: unable to create another db instance

2005-10-13 Thread Simon Matter
> Hi all > I very recently downloaded MaxDB and it installed fine on my Windows XP > Professional system. I created a db instance as part of the installation > process. Everything still fine. I even hooked up WebSphere to MaxDB > through > the XADataSource and everything was still great! Wow! Posti

Re: Performance problem MS Access <> SAP-DB

2005-09-26 Thread Simon Matter
> Hi all, > > I have a performance problem between SAP-DB 7.4.03.32 (SLES-7), Windows XP > MS Access 2002 (10.xx), ODBC-Driver MAX-DB 7.5. > > As far as I can see from the SQL-Trace of the ODBC-Driver the requests to > the SAP-DB will be answered in 1 second. The time between one SQL-Command > and

Re: -24994,ERR_RTE: runtime environment error

2005-08-29 Thread Simon Matter
> Hi, > > Maxdb 7.6 can't start. > [EMAIL PROTECTED] TEST]$ dbmcli -d test -u dbm,dbm db_online > ERR > -24994,ERR_RTE: runtime environment error > 1,Check knldiag! Kernel died before reaching ADMIN state > > knldiag.err: > > 2005-08-29 17:59:45 --- Starting GMT 2005-08-29

Re: Max amount of databases? Limits?

2005-08-24 Thread Simon Matter
> DB geeks, > > we reinstalled our experimental server with SuSE 9.1 and SAPDB 7.3.0.25. > We have several customer databases running, about 20 database instances > I guess. Each db is about 500 to 2000 MB in size in only one devspace. > The server is an old Athlon 900 with 768 MB RAM (ok, maybe th

RE: start/stop databases without manager-password

2005-08-24 Thread Simon Matter
> Hi Sven, > > the tools x_start and x_stop should be used in init-scripts. They will > allow root to start/stop instances without providing any passwords. This > should work starting with release 7.5. Unfortunately I can't find x_start or x_stop on my 7.5 and 7.6 installs, both rpm installs. Does

Re: SQL-Error 24988

2005-03-06 Thread Simon Matter
> Hello! > > I installed the MaxDB7.5 on Fedora Core 3_32 with the rpms. The > installation > went all well. but if I am trying to create a database with the webdbm, i > always get the SQL-Error 24988 during the last step. When i look in the > workpath, the directory for the database is created. Bu

Re: Problems with MaxDBProxy

2004-01-02 Thread Simon Matter
> Hello, > > I have some problems understanding how exactly MaxDB proxy works (or > should > work). I have a small MySQL database, which I would like to import into > MaxDB. I thought that I should just start MaxDBProxy, use mysqldump to > dump > the database to a file, and then use mysql client to

Re: a long time in conenct to databace

2003-12-30 Thread Simon Matter
> Hello I am federico of Argentinean > > I ask a question to have if to you it has passed them the same thing, > install the base in a windows 2k server with service pack 2, I created a > test base and all OK , but when the client installs in another machine > (with windows me) and I want to connec

RE: SAPDB/MaxDB on RedHat 9 ??

2003-12-16 Thread Simon Matter
--- HTH Simon > > Again, many thanks! > Jerry > > > -Original Message- > From: Simon Matter [mailto:[EMAIL PROTECTED] > Sent: Monday, December 15, 2003 2:09 AM > To: Jerry Apfelbaum > Cc: [EMAIL PROTECTED] > Subject: Re: SAPDB/MaxDB on RedHat 9

Re: SAPDB/MaxDB on RedHat 9 ??

2003-12-15 Thread Simon Matter
> Hello > > I have been trying for a few days to get SAPDB/MaxDB working under > RedHat 9 to evaluate it for a large upcoming project. > > The Installation seems to go well but I cannot get a real database to > really start running. I've tried 7.505, 7.508 tgz's as well as 7.4 tgz > and rpm. No l

Re: Members of the database administrators group

2003-11-20 Thread Simon Matter
> Hi, > > the group "sapdb" stands in /etc/group , and the user sapdb has the right > groupID . > > I'm sorry, but the command "usermod" is unknown for RedHat 8.0 :-( That's almost impossible. It's part of the shadow-utils package. Otherwise you could edit /etc/group and /etc/gshadow directly by h

Corrupt ini file in 7.4.3.30-1 rpm release

2003-11-12 Thread Simon Matter
Hi, I have upgraded one of my servers to sapdb-7.4.3.30-1 today. When I tried to access webdbm, I found out that it doesn't work anymore. The file /var/spool/sql/ini/WebAgent74.ini is corrupt, looks like a typo to me. The patch below corrects the problem. Regards, Simon --- WebAgent74.ini.orig F