 | | | MaxDB | | Hi
I have an bi processor machine and have declared
2 procs to MaxDB.
But just a question about an information in the
Database Manager
In Check / DataBaseServer / section "MoveInfo Load balanciHi
one of our triggers produces the error
[-3024] Invalid numeric expression
when it is executed.
There are some divisions in the trigger but we are sure division by 0 is impossible.
And the curiHi Tilo
I started now from scratch and tried to attach a new raw-device to a blank database.
The problem seems to be the raw devices. On the currently running MAXDB 'raw -qa ' outputs
sapdb01 ~ # rHi all
I have a problem on restoring a full backup from an other (identical) MAXDB system into a new hardware.
System Data on both systems (SLES8)
sapdb01 /var/opt/sdb/data/wrk/SAPDB01A # uname -After changing cache_size and cat_cache_supply values do I have to restart
the db server or the instance?
Best regards
--
Daniel Castro
Website http //danielti.no-ip.info 2139
MSN danielti@(protected)Crash is not very stable but it is possible to reproduce it.
The statement is
SELECT
users.USERNAME ROLE CONNECTMODE MAXTIMEOUT COSTWARNING COSTLIMIT timestamp(users.CREATEDATE users.CREATETIME)
cHi
I have 2 warnings in dbanalyzer
* W3 Deletes selectivity 0% 8 deletes 6982 rows read 0 rows qualified
CON DelSel < 0.3
VAL 0 < 0.3
* W3 155968 physical reads for user tHi
it 's possibly related to Alexey 's post called "MaxDB 7.6.00.27 fetching
UTF8 data from LONG column ".
Well assume a simple select
SELECT col1 val1 col1 val2 LENGTH(col1) val3 FROM table1
The new Windows GUI installation worked great it updated my 76.0.16
instance and my software without any problem. I would suggest not
setting "create a new instance " as the default option when updatiHi
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 Hello
I 'm using MaxDb 7.6.0.16 on WinXp HE + SP2.
I need to convert Varchar ASCII variabl into Varchar BYTE inside stored
procedure.
Can you advice how to do this ??
Thanks Dusan
--
MaxDB DiscHi
I am getting the following message in dbanalyzer
* W3 Catalog cache hitrate (SQL Pages) 79.30% 1465 of 7077 accesses failed
CON Cat_Hit < 80 && ( SQL_Cmds ) > INTERVAL
VAL 79.30Hi
I have a client server application which logs in the database with the same
user (ex. USER) for all stations.
The access control is done by the app.
The question is that sometimes it takes a lot1.- Full backup on source database
2.- Create the instance in your laptop it might be 8-10GB for data volumes
3.- Recover with initialization on laptop
4.- Full backup in your laptop then activatHi
consider this query
SELECT TA1.propvalue AS COL1 VALUE(TA4.map_value TA1.propvalue) AS COL2
FROM ag_site TA1 LEFT OUTER JOIN mp_1149664790259_1 TA4 ON
TA1.propvalue TA4.map_key ag_url TA2 v_2006-06-07 18 27 09 0 ERR 12006 DBCRASH Kernel exited without core
and exit status 0xb
2006-06-07 18 27 09 0 ERR 12011 DBCRASH No stack backtrace since
signal handler was not called. This Hello Everbody !
I have a Linux server with a 40 giga maxdb database. (used 5 free 35) !
The data files are located on a SAN !
What is the easiest way to install transport copy... this database to Hello
how can install more than own MaxDB versions (7.5 + 7.6)
to own Server?
Thanks
Joerg Wenzel
--
MaxDB Discussion Mailing List
For list archives http //lists.mysql.com/maxdb
To unsubscribeHi *
one of my instances does not come up right now. after opening the log
volume the following error is shown in the log
ERR 11000 d0_vatta Error during fork Out of IPC semaphores for thread
synHello!
I got the following error message when I tried to connect to my database.
( -24988 SQL error [db_online -f] -902 I/O error )
Looked for a solution at
http //www.mysql.com/search/?q -24988+
I have a "LONG " column and I wish to insert a LF character in it.
I tried
INSERT INTO .... ( 'line1\nline2\nline3 ')
but it inserts the characters '\ ' and '\n '
How can I get an actual LF charaHi * (including fellow sufferers of bad i/o-performance)!
the latest 7.6 release seems to contain possible improvements of the bad
i/o performance of maxdb (search for "clustered " in the changes listHello List
we have a view defined on a basetable kind of
create view theview (
"c1 "
"c2 "
"c3 ") as select c1 null c3 from table
When we try to execute an insert-statement (insert into theview (2006-05-31 14 36 40 0 ERR 11330 COREHAND ABORTING due to signal 11
2006-05-31 14 36 40 0 ERR 11599 BTRACE ---- > Emergency Stack Back
Trace <----
2006-05-31 14 36 40 0 ERR 11599 BTRACE I am currently working on an ADO.Net Provider for MaxDB. The project is
registered in the SourceForge.net (see
http //sourceforge.net/projects/maxdbprovider) and the source code is stored
in the suhi
I am trying to create a database. This script is ok on one
machine but on another it stops
The script
param_startsession
param_init OLTP
param_put CACHE_SIZE 98304
param_put MAXUSERTASKS 20
paHi Ralf
Ralf L?wa [mailto ralfl28@(protected)] wrote
>
> I got the error -25247 but there isn 't any entry in the
> documentation for this message.
>
> The error occured by using the loadercli. How cHi
I 'm trying to install DBD-MaxDB-7.6.00.27 on a Power5 machine (64 bit)
I 've already installed maxdb-all-linux-64bit-ppc-7_6_00_27.tgz
perl -v reports This is perl v5.8.5 built for ppc-linux-thrHi
I got the error -25247 but there isn 't any entry in the documentation for this message.
The error occured by using the loadercli. How can I find out what the error means?
regards
Ralf
hi
I have a debian sarge installation working
with kernel 2.6.12.6-686 smp.
MaxDb 7.5.00.26 is installed and when i want
to start x_server i get the message
"
x_server error while loading sha |
|
|
