Dear Heinrich,
Thanks, i look into the user right access permission of /dev/null, then i
set the group to root again also i set the group can write the /dev/null.
Then i create database from restore medium, the result works fine.
Thank you, your clue help to solve the problem.
Best Regards
Eko S
Dear Heinrich,
The access right for /dev/null set to root, group adm,
with o=rwx, should i set the right access permisson to other user ?
Regards
Eko Subagio
- Original Message -
From: "Heinrich, Tilo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 18, 2004 5:34 PM
Sub
Yes, here is the end of knldiag file:
2004-06-16 13:42:06 2634 11565 startup DEVi
started
2004-06-16 13:42:06 2454 52101 RESTORE Filetype:
file
2004-06-16 13:42:06 245246 Log
recovering log from tape from IOSeq 0 (MaxIOSeq from
tape: -1)
2004-06-16 13:42:06 2453 1100
> 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 o
Andris Spruds wrote:
Hello,
How can I tell what's the optimal size for log volume(s)? I know the
question has been asked before, but I could find no satisfactory answers,
also in MaxDB documentation there is information on log volumes in general,
but not about how to choose their size. Thank you in
I think that a very large log size has no other effects than waste of
disk space...
If you need a very really large log volumn, probably you are using wrong
backup strategies.
When anyone need a log > 60% data, is because it's running in ETL (data
import/export). In this case, you can deactiva
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 origina
You would be correct. If you have a sweet system that can handle the
additional load of duplicated resource allocations then have at it. I had to
go for the opposite.
-Original Message-
From: Filip Sergeys [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 9:18 AM
To: Kevin Wilson
Cc: [
But that is less flexible in terms of database backup. You are forced to
backup everything (all users) every time. (unless there is a way to do
userbased backup, which I was not aware of)
On Fri, 2004-06-18 at 15:55, [EMAIL PROTECTED] wrote:
> You are better off using different USERS to house the
Hi,
The sapdb.org sites mentions using sapdb with Microsoft cluter server
and says see
SAP Notes 319835 and 508979. Where are these available?
Regards,
Ajit
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
Hi ,
The sapdb.org sites mentions using sapdb with Microsoft cluter server
and says see
SAP Notes 319835 and 508979. Where are these available?
Regards,
Ajit
You are better off using different USERS to house the db objects in a single
instance. This will allow you to use less resources to accomplish the same
effect.
-Original Message-
From: Filip Sergeys [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 7:57 AM
To: [EMAIL PROTECTED]
Subject
Hi,
>>if you define a too small log size, you will have a lot of log backups,
decreasing general database performance.
I have just one question left: what are the consequences if I define too
large log size?
>>I expect this been helpful.
Thank you very much for your asnwer. Indeed, it helped me
Ok, 7.4.3.32 writes a savepoint if restore log is cancelled.
If any error occurs during log redo and cancel is treated like an error
then the kernel is switched to offline.
If you execute recover_cancel after log recovery then you should see some lines from a
running savepoint in the knldiag befo
> "/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 one by one. This way,
Hi, Andris.
There is no cake recipt for log size.
You should evaluate you app log consumption, and define the ideal values.
But, since there is tips every where (any decent SQL database
administration course will tell you):
1) For general purpose transaction related apps, use about 25% of data si
Hey,
these are just proposals/ideas:
- increase MAXLOCKS to 500.000 (and restart DB)
- copy the files to be imported locally
(mounted samba shares often lead to problems when > 2 GB)
Just a shoot...
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.:
Hi,
I have the following function (a version less complicated than the original one), in
INTERNAL MODE, MaxDb v.7.5.01.00.
CREATE FUNCTION ISEMPLOYEEINCONTEXT (DSTARTCHR TIMESTAMP) RETURNS NUMBER AS
VAR RES INT;
TRY
SELECT 1 INTO :RES
FROM
PSF.COMPANY_HUMAN_RESOURCE A
WHERE
DATE(A.D_START)=DAT
Hello,
How can I tell what's the optimal size for log volume(s)? I know the
question has been asked before, but I could find no satisfactory answers,
also in MaxDB documentation there is information on log volumes in general,
but not about how to choose their size. Thank you in advance,
Best rega
The documentation states that if one want to install multiple instances,
you better do it in separate software directories
Does that mean two or more times installation profile 10 (ALL) in
totally different directories? Or are there more efficient ways. Like
second time only the server, or ..
Fabio Pinotti wrote:
>
> Hi
> we have the following behaviour when passing parameters from java
> code. The sql statement is something like (executed in oracle mode):
>
> SELECT
>*
> FROM
> TABLE1 b
> inner join TABLE2 a on (b.e_key=a.key)
> WHERE
> b.D_START=to_DATE(?, 'dd/mm/') A
Hi,
May be you do not know that this list is for open-source-users of MaxDB only.
We (MaxDB'ler) are asked, NOT to answer here because of guarantee-reasons.
Sorry, please ask your local support.
Elke
SAP Labs Berlin
> -Ursprüngliche Nachricht-
> Von: rollo [mailto:[EMAIL PROTECTED]
> G
Hi!
I'm doing a migration to a SAP db ver 7.3 and I get an error message when the migration
gets to 77% then I get this error message
# R3load version @(#) $Id: //bas/40B/src/R3load.c#1 $ SAP
# R3load -i SAPAPPL2.cmd -p SAPAPPL2.log -r -nolog
### start of syntax check ###
### end of syntax c
Matteo Gattoni wrote:
>
> Hello,
> I'm using MaxDb version 7.5.01.00.
> I have a function TO_CHAR2 owned by user PPORTAL that receives a float and
> give me back a char value.
>
> The function is created like this in Oracle mode (the grant in Internal
> mode because they don't work in oracle mod
Hello Eko,
to repeat my question: What access rights do you have for /dev/null?
Best Regards,
Tilo Heinrich
SAP Labs Berlin
>-Original Message-
>From: Eko Subagio [mailto:[EMAIL PROTECTED]
>Sent: Friday, June 18, 2004 10:58 AM
>To: Heinrich, Tilo; [EMAIL PROTECTED]
>Subject: Re: -24994
It seems that when the parser concatenates parameters it has some problems
Here is the test case
create table mycity ( city varchar(100))
insert into mycity( city)values( 'rome' )
insert into mycity( city)values('berlin' )
insert into mycity( city)values('rome north' )
insert into mycity( city)valu
Hello List,
we have two independant Web Applications runnning,
one already on SAPDB, one still on Adabas (which we want to get rid off).
In the future the Database for the two applications should run on one
physical machine:
- Debian Linux 3.0
- 1 processor 2,8 GHz
- 2 GB RAM
- RAID 1 for OS and M
Hello Paul,
> 1. Best Version of MYSQL for very large Tables
>
> Can I get some tips for which MySQL version to use
> For maintaining a large DB with 100-200 million row master table
> With a lot of inserts.
If there is concurrency (i.e. multiple users) in the insert, either
of course MaxDB or
Hello Heinrich,
I am using user root as user to connect to remote machine and dbm as
database manager, do i should set something in remote machine ?
or i should set sapdb user as owner of database in order to access /dev/null
?
Thanks
Eko Subagio
- Original Message -
From: "Heinrich, Ti
29 matches
Mail list logo
