watching the performance of each processor I notice that sap
doesnt use both processor but 1 at time if one of the
processors reach 100% the it start using the other
How do you notice that? What tool do you use?
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC,
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.
Is this Linux?
How many semaphores do you have? On our DB-Server:
# sysctl -a | grep sem
kernel.sem = 4096 512000 16002048
Hi again,
the command tells me:
sysctl -a | grep sem
kernel.sem = 25032000 32 128
seems you have a lot more ;-)
What exactly does this mean (in combination with sapdb), and
how can I increase this value ?kernel.sem=4096 512000 1600 2048
The definition is
kernel.sem:
2003-11-12 03:21:35 1 ERR 11282 IPC create_shm: shmget error,
Invalid argument
2003-11-12 03:21:35 1 ERR 11247 COMMUNIC ABEND: cannot
create shared
memory (BIG_COMSEG): Invalid argument
It seems that your shared memory segment is not big enough. It seems you're
on 64bit, so
Hi,
are you aware of this? Just curious:
www.atstake.com/research/advisories/2003/a111703-1.txt
www.atstake.com/research/advisories/2003/a111703-2.txt
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
After a while (about 2000-5000 data entries) the DB crashes
and we dont know why, because it is everytime different. Even
after a restart the javaprograms (JDBC) wont connect. Even
the SQL Studio is not running the way it should be. So
everytime the DB crashed this way we deletet SAP DB
i have made a sapdb 7.4.03 standard installation on Red Hat
9.0 with 2GB
memory and 2 80GB hard disks and i run java swing clients
which connect by JDBC to the DB server.
after a time i observed that the memory expand till no more
is available (50 maxusertasks). furthermore each sapdb
For example SELECT from Table EBAN with index use, runs
sometimes about 20 seconds.
If the database is in the cache, the result set is within 500
milliseconds on my client.
What do you mean with if the database is in the cache? The problem is not
only which strategy is used but also how
Your comments suggests some things I have not considered with
SAPDB / MaxDB.
With a single drive for data, logs on a second drive. Questions:
1. Is there a difference to have 4 x 4GB devspaces, or a
single 16GB devspace?
Sure there's a difference. If you have only ONE devspace then there
com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC:
Cannot connect to jdbc:sapdb://dbserver/ISDB [Task limit].
[...]
2003-12-04 13:20:55 3207 WNG 11837 COMMUNIC ALL are busy (in all UKTs)
2003-12-04 13:20:55 3207 11580 COMMUNIC e84_find: UKT3 T5
[...]
How's the size of the
# /opt/netvoyant/sapdb/indep_prog/bin/dbmcli -d nms2 -u
control,control
db_addvolume DATA /opt/netvoyant/db/NMS2/datadev02 F 12
ERR
-24915,ERR_NOADDD: configuration update not allowed (param
file is inactive)
Try this:
# dbmcli -u control,control -d nms2
param_startsession
We'd like to re-initialize our database (Install Instance for Recover) to
import a production database. The second generation gui does not allow to
use current parameters, I have to either delete the DB to use the
parameters or write them down and create them from scratch. Older versions
did allow
I refer to What type of isolation level does SAP business
application use (by example: mySAP Business Suite
http://www.sap.com/solutions/, mySAP ERP
http://www.sap.com/solutions/erp/)?
Though that you asked this three times I assume it's urgent :-)
Isolation Level 0 is used (AFAIK), I
Backups are platform dependent? That's quite new to me also - we did our
R/3-Migration from Windows to Linux like this. I always thought they were
endianess-dependent...
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503
Hi Ralf,
we have a running SADB 7.4 on Win2KServer After we installed
the antivirus software Trend Server Protect (Trend Micro),
the database services were stopped. A normal start and stop
of the database does not help. The only solution is to do a
util_release and after that a db_warm.
[...]
They said our antivirus is not intended to run in database
servers (may be this politics is not applyable anymore).
[...]
It's a matter of choice but
- 95 % of virii/worms spread through mail (Outlook|Outlook Express)
on the _frontend_, not backend-/database systems
- the other
[...]
Please advise, and let me know if any logs / other
information would be
helpful
[...]
Have a look in the knldiag/knldiag.err file and see if you can figure out
what's going wrong (or post it here).
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
2004-03-01 16:36:11 --- Starting GMT
2004-03-01 16:36:11 7.4.3Build 031-123-060-910
2004-03-01 20:00:02 0xA6C ERR 18008 TASKING Could not
create thread:
'ASYNCi', rc = 8
my first guess would be that you've reached a system imposed limit of
Hey,
I hope someone from SAP can (and would like to) help me. I have decided to
give Solaris/Intel another try, I'm quite far by now but I'm stuck in
en/ven38a.s. The Solaris assembler does not like some statements and
assembler in general is greek to me...
That's my build log:
!$TOOLSHELL -S
I finally managed to get 7.4.03-B31 ported so Solaris/x86, executed all
the regression tests successfully. The process has been mainly
- adding conditions in the source files
(predominantly adding || defined(SVR4) )
- adding conditions for SVR4 to the desc files
|| defined (SVR4)
-ldl
-
Hi , in my company we are thinking install SAP, but I need
compare different databases options , for example DB2 ,
Oracle and MaxDB , I Would like to know what is the best
Operating System , and hardware to run MaxDB database .
There is no best OS - simply. It heavily depends on what
Hi,
are there some experiences regarding the performance of
MAX-DB / SAP-DB in a SAP R/3 environment (release 4.7) with
more than 150 Users?
We're running a ~ 280 GB SAPDB on Linux with about 800 created users and ~
500 concurrent with no performance problems. Avg. response time is between
I have done patches against the maxdb-75 tree as of yesterday. The cvs diffs
are here:
ftp://ftp.aubi.de/pub/sapdb/MaxDB/diff_maxdb75_140404.diff
and
ftp://ftp.aubi.de/pub/sapdb/MaxDB/diff_toolsrc_140404.diff
The build was done using SunOS 5.8/x86 and Forte 6U2. There's one
The problem is, we are not quite happy with the
performance of our
setup yet. When a not-too-high number of users tries to
access the
application, the database comes under load pretty quickly (as
measured by the Unix top command), and normally fast
queries start
to take
I'm trying to build SDBINST packages out of the tree. I copied over the perl
modules and installed XML::Expat.
Now the createPackage target does the following:
[...]
16-04-04 15:57:16 endofwaresources.mac fast
!cat $OWN/usr/etc/waresources.lst
As we are SAP customer I can tell you only about my experiences under SAP.
2. Can you share your experiences with the database
(problems, limitations)?
If you read the mailing list archive you'll find a lot of information.
Our DB: ~ 400 GB
~ 500 - 600 users concurrent
System
: http://www.siegenia-aubi.com
-Original Message-
From: Dittmar, Daniel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 6:25 PM
To: 'Döhr, Markus ICC-H'; '[EMAIL PROTECTED]'
Subject: RE: Building packages - ftp'ing?
Done this, now it get's further but it's trying
I'm trying to refresh my tree but suddenly I'm getting all kinds of
cvs checkout: move away maxdb-75/sys/src/in/vin25; it is in the way
C maxdb-75/sys/src/in/vin25
cvs checkout: move away maxdb-75/sys/src/in/vin26; it is in the way
C maxdb-75/sys/src/in/vin26
cvs checkout: move away
I have solved the first problem by connecting to admin, but
the second one still there.
As I stated in my private mail - you cannot use gcc to compile your
appliation - you need Forte 6U2.
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49
ucbcc: Warning: Option
-YP,:/usr/ucblib/sparcv9:/opt/SUNWspro/WS6U2/bin/../lib/sparcv
9:/opt/SUNWspro/WS6U2/bin/sparcv9:/usr/ccs/lib/sparcv9:/usr/li
b/sparcv9
passed to ld, if ld is invoked, ignored otherwise
ucbcc: Cannot find /opt/SUNWspro/WS6U2/lib/wordalignI8.o
and I found
We're running also 8 GB DB Server (SAP) with the following settings in
/etc/sysctl.conf
# Kernel settings (for SAP R/3)
#
kernel.shmmax=4113682943
kernel.sem=4096 512000 1600 2048
kernel.msgmax=16384
kernel.shmall=4113682943
kernel.msgmni=1024
vm.heap-stack-gap=256
Shared memory and IPC
What prompted you to increase the settings in sysctl.conf?
Was it problems similar to mine? Or prior knowledge/documents?
Since we have many sessions connecting to the database (5 application
servers) we also ran in a similiar problem. Decreasing the number of work
processes connecting helped
I know there is the LD_ASSUME_KERNEL workaround for use MaxDB
with nptl-enabled systems, and I have been using it successfully.
But is there some plan to allow it to run in nptl systems
without this workaround? I know there is some methods to
detect in runtime if the system have or not
sapddb02:/usr/sap/put/maxdb/indep_prog/web/pgm ./wahttp
exec(): 0509-036 Cannot load program wahttp because of the
following errors:
rtld: 0712-001 Symbol wd21SetContentChunked was referenced
from module wahttp(), but a runtime definition
of the symbol was not found.
rtld:
Hi,
trying again to create a new unified diff against the actual tree (maxdb-75)
but I have big trouble compiling
sys/src/SAPDB/Runtime/System/RTESys_AsmSpinlock.s
There were some recent changes in this file which do not compile anymore.
The Solaris assembler is somewhat different from the gnu
Just for curiosity:
i am sorry, but there is no such ifdef. The code has been
changed to automatically detect (via CPUID) if it is possible
to use 'sfence' (store fence AKA write memory barrier)
instead of 'lock cmpxchg' for unlocking. This result is
[...]
Is this executed on kernel
Hey Jörg,
this does unfortunately not work either...
vmake 10.02.18 05-01-2004
VMAKE_PATH =/home/sapdb/maxdb-75,
10-06-04 13:02:57 start ofcollection phase
10-06-04 13:02:59 endofcollection phase
10-06-04 13:03:00 start ofdbmcli.lnk fast
RTESys_AsmSpinlock.s fast
Silly me, it's not
.movl
or
.xorl
but movl
xorl
It's working finally - thanks VERY VERY much :-)
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
E-Mail: [EMAIL PROTECTED]
But when I call x_server stop and then x_server start I
cannot restart my database instance. When I execute db_online
I get the following error
Starting the x_server as root will also try to start the database as root
which is not possible. You should create a user for the database system
I have tried to putting in my .bash_profile, in /etc/profile.
I have checked my environment to make sure that the
LD_ASSUME_KERNEL environment variable has been set before
running dbmcli db_start, and it has been set.
Please be careful when setting this systemwide in /etc/profile - this
I'm trying to get maxdb-76 to compile on Solaris/x86 but the compile is
throwing errors:
!irconf -r -p $INSTROOT /dev/null
!$TOOLSHELL -S ifaconf.pl $INSTRUNTIME
/home/sapdb/maxdb-76/usr/runtime/7600 - 7.6.0.0,/home/sapdb/maxdb-76/us\
r registered.
MemDbg_Config.cpp fast
could someone please let me know if there is
exclusive service guard extended package for sapdb. i am
setting up cluster on Linux Redhat AS 2.1. If so, from where
can i download it? please let me know. I certainly hope to
recieve an answer at the earliest.
As far as I
Hey Daniel,
/home/sapdb/maxdb-76/sys/wrk/incl/SAPDB/MemoryDebugger/MemDbg
_Header.hp\
p, line 51: Error: MemDbg_Header::enum is not within the
range of a lon\
g or unsigned long.
[...]
[...]
Replace all the expressions in the enum with constants. Then
add the original expressions
Of course it depends on your data traffic.
We have for example a 120 GByte database which mostly has an
increase of 2-4 GByte/month.
We have a 1GByte Log volumne which is sufficient enough if
your are doing daily log backups. I think 50% (60GByte) of
Log space would be a little bit
Hi Florian,
I think you have hardware issues - can you check the evenlog for possible
errors?
Bad data pages don't occure in 99 % of cases due to wrong coding but due to
hardware problems. We had similar problems some time ago and it indeed was
the hardware.
Do you use dynamic discs under W2K?
we use 'standard' sata Disks under Linux without dynamic mechanisms.
I tried to recreate some faulty Indizes with the DMGui, but
it gave me a
9041 BD Index not accessible.
I droped the faulty Indizes and do a DB-Check again.
Afterwards, i'll try to do a reiserfsck now and check the disks.
Hi,
after a cvs update I have link errors pointing to the assembler coding Jörg
provided me.
RTESys_MemoryBarrier.s fast
enalib.lib fast
dbmcli.lnk fast
Undefiniertes erstmals referenziert
Symbol in Datei
RTESys_MemoryBarrier
I did it... simplies
set on /etc/profile
export LD_ASSUME_KERNEL=2.2.5
This is dangerous setting it systemwide since then ALL software will use old
threading implementation (and maybe will not expect so).
Better set it in the .profile of the user starting the db.
Greetz,
SIEGENIA-AUBI KG
I'm now trying to rebuild with Forte 5.6 instead of 5.3 and getting this
errors now:
SAPDB_RangeCodeClient.cpp fast
/home/doehrm/maxdb/maxdb-75/sys/wrk/incl/SAPDB/SAPDBCommon/SAPDB_RangeC\
ode.hpp, line 180: Error: Different types for ?: (SAPDB_ToStringClass\
and const char*).
ERR
-24964,ERR_EXECUTE: error in program execution
768,/opt/oltp/sdb/7500/bin/x_python
/opt/oltp/sdb/7500/env/lsystab.py -R
/opt/oltp/sdb/7500 -d GWDB -u dba,*
which build is this? did you try a newer one?
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC,
Hey Brad,
is there any note in knldiag or knldiag.err?
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
E-Mail: [EMAIL PROTECTED]
Internet: http://www.siegenia-aubi.com
--
MaxDB Discussion Mailing
2004-07-01 15:39:4916 ERR 11865 DCOM dlapi(dlopen)
Error:ld.so.1:
/opt/o
ltp/sdb/7500/pgm/kernel: fatal: dbpinstall.so: open failed:
No such file or dire ctory
2004-07-01 15:39:4916 ERR 11258 DCOM-DMP LVC_LoadLibrary - File:
dbpinstall
is the file there? should be in
2004-07-03 12:17:0211 ERR 51361 RESTART CONTROL USER
ALR. EXISTS; 0
it seems that you have created the database with a different dba user than
your recoverd database. Is that possible?
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503
I'm trying to build packages for over one week now but I still don't get the
point what's going on behind the scene. I finally got the installation that
far, that I now have a tgz-package (yippie!) but it's unfortunately not
installable.
# ldd SDBRUN
libperl.so =(Datei nicht
'::install56/perl/redist/linux24ia32/redist.mac', version 'f'
it seems that you have to create the target because it's (for whatever
reason) no there.
Go do
sys/desc/install56/perl/redist
and copy one target to the stated one and try again (that's how I did it).
Greetz,
SIEGENIA-AUBI KG
i think parts of sdbrun are built with your perl.
the key is to pass the perl make completly before sdbrun
starts from scratch.
Perl itself works but apparently the wxwin does not:
Hunk #2 failed--Couldn't find anywhere to put hunk.
2 out of 2 hunks ignored--saving rejects to
I'm sorry but I still don't get the point:
srvinst.mac:
srvinst58.mac
srvinst56.mac
srvinst56.mac calls install56/perl/sapdbinstperl.mac
which tries to copy perl executables and libraries (which are not there
since they are built for perl 5.8).
Since there are no other perl binaries in the
I finally managed to move my built TGZ to another system and installed it.
When trying to create a database it always fails at this point:
Date Time TID Typ MsgID LabelMessage-Text
srvinst56 is the current installer in 7.5 and it contains a
precompiled perl 5.6.1 or 5.005 (not in cvs).
but it should be possible to use your installed perl.
srvinst58 is a parallel development branch without any
precompiled binaries. this is used to develop an installation
gui and
Hi,
I finally managed to get 7.6 compile under Solaris/x86 - here's the first
bunch of patches:
ftp://ftp.aubi.de/pub/sapdb/MaxDB/76/diff_20040716.diff
This is against the maxdb-76 tree of today.
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
With the release of Suns Studio 9 I tried to built the current tree. This
error is through different sources the same - everything else built fine.
This happens on SPARC too so it's no compiler specific issue.
/home/sapdb/maxdb-76/sys/wrk/incl/SAPDB/SAPDBCommon/SAPDB_RangeCode.hpp\
, line 180:
I finally got 7.6 to compile :-) The new diff with the added casts is at
ftp://ftp.aubi.de/pub/sapdb/MaxDB/diff_maxdb76_20040803.diff
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
E-Mail: [EMAIL
Everytime I reboot my computer maxdb service start very slow. Any
Idea?
Do you shutdown the database (bring it to offline mode) before you reboot?
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
software in package Base is not runnable on your systemMAKE
SYSTEM: architecture = SPARCMAKE SYSTEM: cpp_runtime =
108434-12MAKE SYSTEM: cpp_runtime64 = 108435-12MAKE SYSTEM:
system = SolarisMAKE SYSTEM: version = 8YOUR SYSTEM:
architecture = SPARCYOUR SYSTEM: cpp_runtime = 106327-08YOUR
!
- Original Message -
From: Döhr, Markus ICC-H [EMAIL PROTECTED]
To: 'Matteo Gattoni' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 3:01 PM
Subject: RE: Solaris 7 compatibility
software in package Base is not runnable on your systemMAKE
SYSTEM: architecture
Using a database Oracle 9.2 instead of Oracle 8.1, I've received the
following error:
So.. what are you exactly trying here? Using the SAPDB ODBC driver to
connect to an Oracle database? This won't work and is expected to do not...
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus
ORA-28500: connection from ORACLE to a non-Oracle system
returned this message:
[Generic Connectivity Using ODBC][SAP AG][LIBSQLOD
SO][SAP DB]Unable to connect
to data source;-709 CONNECT: (unknown host (see
/etc/hosts)). (SQL State:
08001; SQL Code: -709)
ORA-02063:
You mean the parameter CACHE_SIZE - right?
Yes - in 7.5 the name is CACHE_SIZE - in older Versions it was called
DATA_CACHE
What about the parameters MAXSERVERTAKS and _IOPROCS_PER_DEV ?
MAXSERVERTASKS are the tasks for the server for example writes the changed
out of DATA_CACHE data to the
Please send me the link.
ftp://ftp.aubi.de/pub/sapdb/SAPDB/sapdb-server-win-32bit-i386-7_4_3_35.tar.b
z2
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
E-Mail: [EMAIL PROTECTED]
Internet:
I get an error when issueing a recover_start arch log 091 ERR
-24988,ERR_SQL: sql error
-903,Host file I/O error
IMHO you can't start with LOG recovery.
Restore the DATA with recover_start ... data and then continue with
recover_replace arch log
Greetz,
SIEGENIA-AUBI KG
We are trying to configure the backup/restore utility backint
using HP Data Protector and we are getting an error related
to the pipe we have created.
I don't know if HP DP does support backing up from pipes directly. I think
you have to use backint to create files of a certain size and
Connecting to the database failed Connection failed
(RTE:could not connect to socket [10048])
I think you're hitting a system imposed limit of open file descriptors. What
OS are you using?
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49
Windows XP SP2
Oh...
Now why would this leave open file descriptors? Is there
something I can do in the code to make sure they are closed properly?
No, I thought you were using a *nix'ish OS.
In case of Windows XP you have to take into account, that SP2 limits the
number of half open
is this a bug? i dont see any problem with adam source code.
the code connect and disconnect. if u use other DATABASE in
XP this will not be happening. any idea?
Can you prove this? If you use M$ SQL server connecting via TCP/IP (not
NamedPipes) you'll see exactly the same behaviour - and
I confirmed that this is NOT the TCP/IP half connect issue,
there are NO alerts in my Event Viewer regarding it and I
even upped the limit to 50 and still have the connection
issue at around 1700 connects,
Do you have any messages in knldiag or knldiag.err?
SIEGENIA-AUBI KG
2004-09-27 12:32:53 0x2F0 19651 CONNECT Connection
released, T22
2004-09-27 12:32:53 0x2F0 19633 CONNECT Connect req. (T22,
Node:'127.0.0.1', PID:8792)
2004-09-27 12:32:53 0x2F0 19677 CONNECT Client has released
connection, T22
Yeah - I saw that... but this
I'm trying to create a new diff for Solaris/x86 but I'm constantly getting
[EMAIL PROTECTED] ~cvs diff -Biur maxdb-76 diff_20040928
cvs [server aborted]: no such tag maxdb-76
It starts searching the harddisk and then sits there for about 10 minutes
before stopping with this error. Checking out
I still don't believe it's a MaxDB issue but more a W2K specific one...
I have found a document how to tune the TCPIP on Windows 2000:
http://www.microsoft.com/technet/itsolutions/network/deploy/depovg/tcpip2k.m
spx#EAAA
Maybe this registry parameters can help to keep the application running.
6. test with Windows Database Manager - ok
6a. load system tables (out of DBMgui)
Did you load them?
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
E-Mail: [EMAIL
This happens since yesterday:
OMS_AbstractObject.cpp fast
/home/sapdb/maxdb-76/sys/wrk/incl/SAPDB/Oms/OMS_SessionDef.hpp, line 2\
52: Error: inline is not allowed here.
/home/sapdb/maxdb-76/sys/wrk/incl/SAPDB/Oms/OMS_SessionDef.hpp, line \
252: Error: No storage class or type for this
3)Recovery-Recovery Wizard
Here you should choose Restore instance for recovery. If the DB comes
online it will write a timestamp into the logarea and your restored DB will
not work with this logpage.
The correct way would be:
- Create Instanz (new or initialize)
- NEVER bring it to online
Upon looking in knldiag file, I see a lot of DATACACH LRU
OVERFLOW:32.
can you increase the DATA_CACHE?
If have seen this once too here on our system but it didn't impact
performance.
Check with
# x_cons SID show active 1
what the DB is doing...
The partition where the archived logs
During hang situation, when I refresh my 'Activity' window on
DBM I see value 1 for Lock Owner and 1 for Lock Requester.
can you run
x_cons show active 1
when it locks up? This will show what the tasks are doing...
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
The naive approach (reconfigure XServer service, start it,
see what happens) results in error 18666, user missing privilege.
I think the users need the following priviledges:
- start as a batch job
- start as service
- allow to replace token on processlevel
Then it should work...
Greetz,
I think the users need the following priviledges:
- start as a batch job
- start as service
- allow to replace token on processlevel
That doesn't work either. The same error message is logged.
I have no further idea - just thought, this should work.
Maybe someone of the SAP team
dbmcli on C12db_warm
ERR
-24988,ERR_SQL: sql error
-9212,Message not available
check the file knldiag and/or knldiag.err and post the output here.
Greetz
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:+49 6503 917-152
Fax: +49 6503 917-7152
$ java -jar sapdbc.jar -V
-jar: illegal argument
Usage: java [-options] class
If you use IBM JDK try
$ jre -cp sapdbc.jar
Check you java version with
$ java -version
If it's lower than 1.4 you should consider upgrading, different java
versions can coexist in different directories
Just checked out java -version on the Unix host and found
that the version is 1.1.8, could that be a problem?
Yeah - I'm quite sure that this ancient version can't execute code that's
built with newer versions.
I'd at least download a recent 1.3.1 built:
Hi
I'm trying since weeks to get 7.6 built and started. All kernels I built
come up to the point when starting the first UKT, then it coredumps in
sqlwaitsem().
Here's the knldiag:
Date Time TID Typ
Thank you a lot for this hint, the problem seems to be the coroutine coding:
(dbx) lwp [EMAIL PROTECTED]
Current function is RTE_ContextPrepare
dbx: warning: can't find file
/home/sapdb/maxdb-76/sys/wrk/fast/tmp/RTE_Coroutine.cpp
[EMAIL PROTECTED] ([EMAIL PROTECTED]) stopped in makecontext at
my database server has two Intel Xeon processor (32-Bit) and
8 GB RAM with SuSE SLES 8.
I'm searching for a way to increase the size of the DATA
CACHE greater that
2.5 GB.
I've read that the shared memory size can't be greater than
2.5 GB on a 32-Bit processor.
So I have to use
Hi Tilo,
could you please check, whether SQL, TOOSMALL or NOMEDIA are
defined in your context by inserting something like:
#if defined(SQL)
#error SQL is already defined
#endif
into your DBMSrvMsg_Error.hpp, right in front of the enum ErrorID.
I did this:
45 class
2004-11-14 04:36:07 1131 ERR 11000 d0_aopen Error during
thread creation, resource limit.
2004-11-14 04:36:07 1225 ERR 52012 SAVE error occured,
basis_err 3700
We have exactly the same error since the update to 7.5.0-B019, Build 18
worked fine with our current configuration.
$ g++ test.cpp sqldbc/sdk/sqldbc/lib/libSQLDBC.a -I
sqldbc/sdk/sqldbc/incl/
libsqlthread.rel.o(.text+0x1576): undefined reference to
`sql57k_pfree'
sqldbc/sdk/sqldbc/lib/libSQLDBC.a(libsqlthread.rel.o): In
function `sqltimedwaitsem':
libsqlthread.rel.o(.text+0x1659):
I have one instance up in MaxDB 7.5.19 with MAXUSERTASKS =
10, but I see 25 processes under linux... Is that normal?
These are only the USERTASKS, the DB has some more itself (Servertask,
Utilitytask...)
Also, the DB is just started up and each process is 68MB in
size according to cli
Hey Daniel,
Our code requires a rather old version of bison. That version
should be part of both the binary tool distribution and the
source tool distribution. Try $TOOL/gnu/bin/bison --version,
this should emit GNU Bison version 1.25
Yeah.. but it seems that configure will check for
[...]
server. Especially as releases are available as tar balls.
...that are not building:
PHASE: MAKETARGET: dbmcli.lnk VERSION:fast
TARGET:
*Is there a recommended size for each data volume file? For
us each data volume is 200Mb. Ram is 1Gb.
*what should the 'data cache' be set to? The default is
1. I increased it to 15000 and performance increased
dramatically! Very impressive! Any general tips?
There is a rule of thumb
I have question,
the only way to commit the transaction log of SAPDb is
setting AutoLog ON?
With AutoLog OFF i have the problem that transaction logs
reach 100% and don't decrease..
It seams be the only way for many changes and small log area.
Declared log volume speace has been
Hey...
dbmcli on TSTbackup_start BACK_TST_SAPDB_TST ERR
-24920,ERR_BACKUPOP: backup operation was unsuccessful The
backup tool failed with 2 as sum of exit codes. The database
request failed with error -8020.
can you have a look in knldiag.err?
Greetz,
SIEGENIA-AUBI KG
1 - 100 of 298 matches
Mail list logo