Resi W wrote:
What could be the cause of the crash ? I suspect because it is full. But
why can't it be restarted ?
resi,
your right, the database is full.
On restart the database reads the redo entries from the log and will always
reach the same full situation.
And if it did crashed because db
Nick Chan wrote:
When I restart the db instance, or the computer, I see the kernel.exe (i
assume is the database instance) shoots up to almost 300MB RAM usage. Has it
something to do with autolog or something?
Nick,
the size of the kernel.exe in memory is (simplified) the sum of the code size
the
Resi W wrote:
It works, thanks for the very quick reply.
2. Where in the manual / website can I find all the command lines
available to SAP DB.
http://sapdb.org/7.4/htmhelp/cb/0a8d3b05e2fd6ae1000a114084/frameset.htm
Henrik
--
MaxDB Discussion Mailing List
For list archives:
Michael Rimov wrote:
I ran into a similar issue while trying to install maxdb on one system
(not at instance creation time like you).
The problem was that this system was not using shadow passwords. Running
'shadowconfig on' on this debian system fixed my problem. Your issue
might be similar.
Red Hat 9.0
Ok,
ran grpcnv, pwconv
LD_ASSUME_KERNEL
Still no go. Anybody with RH9 and MaxDB successful? [Sapdb 7.4 installs
and runs fine on that OS for me]
+++ Thu Dec 11 21:59:49 2003
./dbmcli -t protocol.txt -n mymachine db_create MYDB auser,*
sdb,***
+++ Thu
On Thu, Dec 18, 2003 at 01:44:44PM +0100, Pranas wrote:
Hello,
I have noticed exclamation sign in Database Manager in Data Cache Hit Rate
parameter visualization.
Is Data Cache Hit Rate 99% typical in normal/correct instillation?
Should I update some parameters?
99% is OK - depending on
On Fri, Jan 23, 2004 at 11:25:40PM +0100, Marten Feldtmann wrote:
According to MySQL, Germany: IF a commercial program (or to be more
precise: a program NOT under GPL) is using a MaxDB database server,
the user MUST have a commercial license for that database server.
This is also true for
On Fri, Feb 27, 2004 at 09:32:57PM +0100, Robert Karger wrote:
Hallo,
ich habe einen Apache Tomcat Application Server (Java) installiert, danach habe ich
einen
MySql 4 Server und MySql-Max (InnoDB Datenbankformat) mit rpm unter Linux
installiert.
- wrong language, please write in english
Andy Chan wrote:
i once found myself first removing the volume (definition only) and re-catalogue it.
i.e.
param_rmfile
param_addvolume (add only those needed)
not too sure this is a right approach though
Cheers,
Andy
-Original Message-
From: Steffen Fiedler [mailto:[EMAIL PROTECTED]
Falk Brügmann wrote:
Summary: We are using SAP DB 7.4.3, are unhappy with its performance, and
would greatly appreciate any hints and help leading to a better
configuration.
We have a SAP DB 7.4.3 database on Debian Linux, accessed by a Java web
application in a cluster setup. The database is
On Fri, Apr 30, 2004 at 08:34:59PM -0400, H wrote:
Can Windows XP running MAXDB be used as a production server?
H, please define 'production server'.
Real production servers are running on W2k server, Windows Server 2003
or any flavor of unix and not on desktop environments.
If Windows XP
Quoting [EMAIL PROTECTED]:
Hi to all,
I wrote the following mail to [EMAIL PROTECTED] but the only answer I
receive was
something about DNS-configuration.
I've tried all DNS-settings but without any performance advancement.
are your dns settings OK? how long does it actually take to
-Original Message-
From: Zabach, Elke [mailto:[EMAIL PROTECTED]
Sent: Thursday, 10 June 2004 5:07 PM
To: 'Dusan Kolesar'; SAP DB mailing list
Subject: AW: Database link in Oracle
Dusan Kolesar wrote:
Hello,
Is it posible to divide one database into 2 or more instances ??
Have I
Si Chen wrote:
Hello.
Are there any guidelines for recommended data and log volume sizes?
Specifically, do you recommend many data volumes of a modest size (say
20 - 50 MB each) for a database, or do you recommend a larger volume
chunks (of say 500 MB or 1 GB)?
As a rule of thumb, use exactly one
On Tue, Jul 06, 2004 at 04:43:52PM -0400, Lon Palmer wrote:
Hi all,
Thanks in advance for your help.
I'm running SAP DB 7.4 on RedHat Linux 8.0. Everything has been fine for
over a year until the last few days when the server slowed dramatically in
creating a connection. Even using SQL
Heiko Giesselmann wrote:
Hi all,
our MaxDB server (based on build 7.5.0 Build 014-123-073-298) seems to
have crashed - see attached knldiag.err. The crash seems to be related
to a B-Tree corruption. Are any checks other than the database check
from Database Manager recommended to verify
[EMAIL PROTECTED] wrote:
Hi,
I'm new to maxdb and use the debian packages
thankfully contributed by Martin Kittel.
I got stuck for some days, because it was unclear to me
that the maxdb-server package alone ist not sufficient,
but also the maxdb-server-7.5.00 package is needed
beside the other
Am 30.03.2005 um 18:02 schrieb Colby, Cyndi K.:
Server:
Max Db, Version 7.5.00.23 (Commercial License)
Windows 2K (win32) Server
Client:
MaxDb ODBC driver 7.05.00.00, SQLOD32.dll 12/28/2004
(Datasource is configured with the IP address for the server, not the
server name)
There is an approx. 30
Am 06.04.2005 um 17:56 schrieb Döhr, Markus ICC-H:
Hi,
I was finally able to activate the slowknl (!) on Solaris10/AMD64:
2004-04-06 17:50:1315 53070 SAVPOINT B20PREPARE_SVP: 2
2004-04-06 17:50:1315 8 PagerSVP(3) Start Write Data
---
schrieb:
But i also have some questions.
One,IS the logvolume in the hard disk or in the memory?
the 'logvolume' is on disk, it's the sum of all your configured
volumes used for logging.
Two, Do the savepoint activate the write process only?
data is written from the data cache to disk
Am 06.06.2005 um 20:12 schrieb [EMAIL PROTECTED]:
BLOBs, LOBs, CLOBs, ByteStrings, LONGs ...
If it does, were might I find the implementation in the sources?
vbd05 and following
Henrik
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
Quoting Olaf Döring [EMAIL PROTECTED]:
Hi list,
i want to create a database using maxdb 7.5.0.8 with suse linux. Two
databases are running on that server, while creating the third i get an
error:
-24973 param check failure/request [param_addvolume 1 DATA /dev/raw/raw1
R 19660799];
Quoting Florian Schmitz [EMAIL PROTECTED]:
So which would be the best way splitting volumens taken :
- No RAW-Devices wanted (Leading to another question : which FS for Lunix?)
keep it simple fast, use raw devices or an ext2 filesystem. We don't
rely on any 'advanced' filesystem features like
Michael Ruf schrieb:
Hello,
we got the following warnings in our knldiag ( no errors in knldiag.err )
2005-07-06 11:26:42 29823 WNG 53076 DATACACH LRU OVERFLOW: 95
2005-07-06 11:26:42 29820 WNG 53076 DATACACH LRU OVERFLOW: 92
2005-07-06 11:26:42 29788 WNG 53076 DATACACH LRU OVERFLOW: 60
Am 15.07.2005 um 19:10 schrieb Keith:
We have an application that requires maximum read performance from
the data
base. We have size data and catalog caches to near maximum and have
cache
hit rates of 99.99%.
Are there any additional parameter configuration settings we should
be look
Am 18.08.2005 um 20:41 schrieb Chris Barlow:
Hi,
I have 7.3.0.53 SAPdb installed in a sandbox
environment and
1) Change either or both the data and log volume sizes.
a. I'd like to be able to shrink a log down from, say 10gig to 1
gig.
sorry, you can't shrink
Quoting Stephane Davy [EMAIL PROTECTED]:
Hello everybody,
The documentation related to snapshot says that snapshots are made using
the DBMGUI. Is there anyway to make a snapshot with the DBMCLI?
http://dev.mysql.com/tech-resources/articles/maxdb-sap-hosting.pdf
Page 16
Henrik
--
MaxDB
Robert Klemme wrote:
2006/2/16, Kittel, Martin [EMAIL PROTECTED]:
Hi,
isnt the engine supposed to know the size of tables?
with release 7.6 it does. For tables created in release 7.6 they are always
available. However, if you have migrated from a lower release (e.g. 7.5) these
counters
[EMAIL PROTECTED] wrote:
Can i restore if i've got only the datafile?
You mean there is no backup and the logvolumes are lost?
Unfortunately there is no direct way to recreate an empty log
and restart to the last successful savepoint.
But you can recover the database from a backup, so you
On 24.03.2006, at 23:03, Döhr, Markus ICC-H wrote:
One current issue is this. Using Access as the front end and
ODBC it takes a long time to open an attached MaxDB table and
a table with only 5 records in it takes minutes to delete one
record. Is this an ODBC problem a MaxDB problem. What
On 25.03.2006, at 20:08, Scott Miller wrote:
ODBC uses ip address to connect to database and it does connect.
... and?
How long does it take to get a negative answer for resolving the name
of this IP-address?
Henrik
--
MaxDB Discussion Mailing List
For list archives:
Chancellor Sy wrote:
Hello,
I have a problem on my Maxdb 7.5 installation. I got this error after i
rebooted the server
here is the log file on my Knldiag
2006-03-29 15:38:02 0x1F0 ERR28 IOManCapacity of Data volume 1
is different
On 27.05.2006, at 09:28, Dmitry Key wrote:
Could anybody explain how to install SSL certificate to MaxDB 7.6.
The only documentation that i has found is http://dev.mysql.com/doc/
maxdb/en/3d/c14e4155f1db2be1000a1550b0/content.htm.
Dmitry,
due to license-, export control- and some
On 01.06.2006, at 15:39, Raimund Jacob wrote:
Hi * (including fellow sufferers of bad i/o-performance)!
Hello Raimund,
anyone suffering?
the latest 7.6 release seems to contain possible improvements of
the bad
i/o performance of maxdb (search for clustered in the changes list).
we're
Daniel Castro wrote:
Hi,
Login in the database is very slow.
I use 30 stations and they all login with the same user. It is an ERP and I
cannot change the user.
Can you help me?
Daniel,
how slow is slow? 1 second, 30 seconds, 50 seconds?
and what kind of ERP are you using?
Henrik
--
Daniel Castro wrote:
11 to 15 seconds.
It is a ERP developed in Powerbuilder to healthcare companies.
Best regards,
On 7/12/06, *Henrik Hempelmann* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Daniel Castro wrote:
Hi,
Login in the database is very slow
On 24.07.2006, at 15:25, Thorsten Rosenkranz wrote:
Hi
My database (maxdb 7.6.0.27) died with this message in the knldiag:
2006-07-24 14:46:29 6688 ERR 11801 TASKING T60 Bad resume count
detected:-2
what's that?
An error :-(
Could you please send the complete knldiag file for
On 08.09.2006, at 22:45, Cappellano, John J wrote:
dbmcli -d LCD -u control,password db_start
2006-09-08 15:40:48 1 ERR 8 RTEMem No more system pages for
12288 bytes available,BYTE_SIZE=4096,DESCRIPTION=mma
p,ERRORTEXT=ENOMEM ? out of memory
2006-09-08 15:40:48 1 ERR 11872
Daniel Castro wrote:
Hi,
I need to do a Kernel upgrade in SAPDB to solve a error. I never did it
before.
Can anybody send me a link with the instructions or a text file (step by
step)?
here we go:
http://dev.mysql.com/doc/maxdb/en/0e/70683c40e87520e1000a11402f/frameset.htm
henrik
On 20.10.2006, at 20:41, Döhr, Markus ICC-H wrote:
Should I set maxcpu=2 on DualCore (Pentium 945-D)? Advice welcome.
We set that - and we have no issues.
As far as I remember one should set MAXCPU to the number of cores,
not to
the hyperthreaded processors.
yes,
maxcpu=2 is a good
On 24.10.2006, at 06:08, Martin Cordova wrote:
Is it OK to mount a partition with the noatime attribute and use it
to store logs or data volumes? I am using MaxDB v7.6 in case that
matters.
the database does not evaluate the access time of a data or log file,
so it's no problem to mount a
Quoting [EMAIL PROTECTED]:
Hi,
we have a question...we want to shrink our SAP-Development Database.
Is it possible to do this with Maxdb 7.5.39 ? Is there somewhat special to
think about ???
Anette,
backup your database, recreate it in a smaller configuration
and recover the data.
In 7.6.
On 11.12.2006, at 19:43, Eckenfels. Bernd wrote:
Hello,
There is this cannot switch to sdb owner in dbmsrvctl which happens
often on Linux at install time for various reasons. I had a look at
the
maxdb-7.6 code to find out, what the reason for that can be. It is
actually printed if
On 26.02.2007, at 18:17, Robert Klemme wrote:
Hi,
just a quick check: does MaxDB need any updates because of the recent
DST rule changes for the US? I tried to find something on mysql.com
but to no avail.
no - no updates needed.
The underlying OS is reponsible for the correct time zone
On 13.03.2007, at 19:57, Steve Johnson wrote:
do you know what is maxdb size supported for this
database? we are in process of reviewing sapdb for SAP
landscapes, we want to know what is the max size
supported on maxdb or do you know any one using for
higher Terra bytes of db size.
Have a
Quoting Neil Brown [EMAIL PROTECTED]:
Hi,
I would like to be able to delete a volume but get the following error log.
Any advice on how to force through the deletion would be greatly
appreciated.
Thanks
Neil
2007-04-25 10:01:14 0x9F0 ERR 20006 Kernel+ Header [ 7608142 -
data -
Quoting Lukasz Misztal [EMAIL PROTECTED]:
Great :)
Is version 7.6.01.15 somehow freely available now?
If not, when will be?
Latest version I have found:
http://mirrors.easynews.com/mysql/downloads/maxdb/7.6.00.html
please don't access outdated mirror websites!
Check the original master
On 11.07.2007, at 20:01, Daniel Castro wrote:
Hi,
I get the following message:
I CONV2: collision rate 4.17%, 351 collisions, 326 waits (3.87%),
8425
accesses on region 6
CON: REGION_COLLISION_PERCENT[] 2
VAL: 4.17
What is this CONV2 region?
Regions protect the internal
On 11.07.2007, at 21:06, Daniel Castro wrote:
HI Henrik
Tha database parameter CONVERTER_REGIONS = 8.
Yes , I have backup at night and at noon with update statisctics
following
it.
I will cancel the noon task.
Should I increase the aprameter?
You can't change the parameter directly,
On 11.07.2007, at 21:20, Daniel Castro wrote:
HI Henrik
My Kernel version is KERNELVERSION string KERNEL7.4.3
BUILD 032-121-068-842.
I dont have this parameter in param_extgetall.
Daniel,
i'm sorry, XP_CONVERTER_REGIONS was introduced with 7.5.00.something.
Maybe it is an
On 09.08.2007, at 16:29, [EMAIL PROTECTED] wrote:
Hello,
i will stop the log writer with a script but i don't like store
user and password in the script.
dbmcli -d database_name -u dbm_user,password
util_connect dbm_user,password
util_execute suspend logwriter
Joerg,
how
51 matches
Mail list logo