!! db crash !! cannot create semaphore ????

Hi, half an hour ago we had a db crash. After checking the diag files I found some hints that something's wrong with creating a communication semaphore. What does this mean ?? example from dbm.prt: 0x2c73 ERR -24988 DBM ERR_SQL: sql error 0x2c73 ERR -24988 DBM

SAP = Sybase

Hi, on the heise-newsticker I read the info that SAP wants to cooperate with Sybase (http://www.heise.de/newsticker/data/tol-17.11.03-004/). Will this possibly influence the free maxdb/sapdb product line now or in the future ? thanks ..:GERD:.. -- MaxDB Discussion Mailing List For list

remove primary key which is foreign key in diff. table

Hi, I want to remove a primary key (for creating a new one with one additional column). This column references (foreign key) a column in a different table, so I think I first have to remove this referential constraint and then drop the primary key, right ? My problem is that I don't know the

problem creating index

Hi, I've a problem creating an index in our database. The tool xsql tells me, that the index already exists, but this isn't the case. have a look: === linux:/opt/sapdb/depend/bin # xsql -d DBNAME -u

AW: problem creating index

Thanks alot Thomas, SQLStudio and dbmcli works (LoaderCli never used..) bye ..GERD.. -Ursprüngliche Nachricht- Von: Anhaus, Thomas [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 13. Januar 2004 09:10 An: 'Gerd König' Betreff: RE: problem creating index Hi Gerd, I remember a problem

Vsuspend, task limit, problems

Hi, today we have some problems concerning task limit. From time to time, the database isn't responding because task limit (current setting: 120) is reached. Is it possible to get more details from the log-files why the tasks are not being finished ? thanks in advance ...GERD... some

migrate from 7.4 to MaxDB = 903 I/O Error

Hi, we're going to migrate from SapDB 7.4.3.31 to MaxDB, but we're running in troubles. In 7.4 we created a backup via: backup_media_put mybackup $BACKUPFILE FILE DATA 0 8 YES util_connect dbm,0okmCDE3 backup_start mybackup MIGRATION DATA and restored this with: see attached file

param_rmfile ERROR

Hi, while restoring a 7.5.05 backup on a different machine (both SuSE9.0) we're running in troubles at the command param_rmfile. The error message is (from dbmsrv.prt): = ERR -24997 DBM ERR_FILE: file handling error

strange optimizer / index use ??

Hi, we're wondering about the heavy load our maxdb produces. After some time of investigation we found out that the database produces a lot of table scans. Why we are wondering is, that our currently running 7.3.0.46 doesn't produce table scans, furthermore this version uses the created indices

Re: strange optimizer / index use ??

:) Stephen Gutknecht On Tue, 6 Apr 2004 17:39 , Gerd König [EMAIL PROTECTED] sent: Hi, we're wondering about the heavy load our maxdb produces. After some time of investigation we found out that the database produces a lot of table scans. Why we are wondering is, that our currently running 7.3.0.46

SAPDB 7.3 on x64 Linux System

Hello, I an trying to set up a SAPDB 7.3 on a SuSE 9.1 with 64 Bit support (kernel version 2.6.5-7.155.29-smp). It works fine on a 32 bit version (SuSE 9.1, x32, kernel 2.6.4-52-smp) as soon as you set the environment variable LD_ASSUME_KERNEL to 2.2.5. As soon as I try this with the 64 bit

performance problems (avoid table locks) in 7.3

Hi, we're currently having strange performance problems with sapdb 7.3.0.48 on linux. The amount of vserver processes is about 100 and this leads to unacceptable response times to our application. During the lunch time (12.00-13.00) this number decreases to 20-30 (and then we have acceptable

7.5.0.34 invalid subtrans structure (update table with long column)

Hi, we recently upgraded from 7.3.0.48 to 7.5.0.34 and now we're having strange troubles. We have one table with a update trigger, and one long column. If we want to perform an update-statement on this table we get the error: -3102 POS(1) Invalid subtrans structure. The strange thing is,

set autolog_on after recovery

Hi, I wanted to know how to set autolog_on after recovery of a db instance. We have a script for recover a db-backup which works perfect for SapDB 7.3.xx After upgrade to MaxDB7.5.0.34 the script runs nice until setting autolog feature. MaxDB tells me to create a complete data backup first.

db_online fails after enabling HotStandby [ValidateOrCreateShare failed: ]

Hi, we're currently trying to test the HotStandby feature of MaxDB using 7.5.0.34 on SuSE linux. Our scenario looks like this (minimal hardware requirements): - server A: master instance with shared log-space via nfs - server B: standby instance with mounted log-space via nfs - data devspace

Re: [-3102]: Invalid subtrans structure / update / column of type LONG / JDBC

Hi, we also had this error after upgrading to MaxDB 7.5.0.34 We opened a ticket at Sap-Support and the result was a bug report for MaxDB. Have a look at the following document (and try the workaround ;-) ): http://www.sapdb.org/webpts?wptsdetail=yesErrorType=0ErrorID=1142714 bye-GERD-

run SQLStudio / DBM Gui with CrossoverOffice

Hi, does somebody know if the MaxDB-GUIs (SQL-Studio, DBMGui) can be started with CrossoverOffice under MacOS and/or Linux ? Be default not (as far as I know), but perhaps somebody tried this already and has some hints ? thanks in advance...GERD... -- MaxDB Discussion Mailing List For list

_UNICODE and DEFAULT_CODE

Hi, how do the parameters _UNICODE and DEFAULT_CODE influence each other ? The problem is, that we want to have _UNICODE=NO (otherwise we get OUTPUT column too long error), and the default code for character data = UNICODE (or at least in some tables we want to have unicode character data to be