Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Subject: Re: Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
MaxDB
Page 10 of 129 1   2   3   4   5   6   7   8   9   10   Next 10   Next 100  

RE How to use a recursive query as subquery ???

Hallo Elke Thank you for your help. This suggestion works from sql studio ! First select creates rname as resultset which can be used in a second select.

Configuration changes crashed Database

Hello Everbody ! I need more power for my production database. For testing I have a 7.6.00.34 database with default configuration on an suse linux system with 8 giga ram Now I changed some paramete

How to use a recursive query as subquery ???

Hello Everybody I use a recursive query to get all rbobjektideid from structured data (bill of material with up to 99 levels each rbobjekteid belongs to an oberobjektid) DECLARE RNAME CURSOR

problem during installation DB instance on SAP ERP 2005

Good evening. I 'm tryng to install a SAP ERP system with MAXDB on a centOS Linux distribution. During SAP ERP2005 installation process I received the following error Execute Command /sapdb/prog

AW: MAXDB crashes with some kind of meory error

Hi the CACHE_SIZE is set to 1.6 GB (200.000 pages) / CAT_CACHE_SUPPLY is set to 154 MB -----Urspr?ngliche Nachricht----- Von Robert Klemme [mailto shortcutter@(protected)] Gesendet Freitag 02

MAXDB crashes with some kind of memory error

Hi we tested MAXDB 7.6 on Linux 32 bit. DB crashes every 10 minutes and writes the following into error log 2007-01-14 18 41 39 4868 ERR 8 RTEMem No more system pages for 134221824 bytes availab

Subject: backup check impossible

Hi I 've trouble by checking my networker backups. (MaxDB 7.6.00.12) dbm.ebp says

Problem with external backup ID 's

Hello we are using the external backup tool networker. Since an upgrade of the networker client to version 7 the MaxDB (7.6.00.12) can 't get the external backup id 's. In dbm.ebp are entries as belo

Please help me with unicode problem

Hello I am Korean. My name is Lee Minwoo. I appreciate that you made good tools for maxdb. I use python interface module and I use that very well. But I have a problem when I excute inser

MAXDB crashes with some kind of meory error

Hi we tested MAXDB 7.6 on Linux 32 bit. DB crasehs every 10 minutes and writes the following into error log 2007-01-14 18 41 39 4868 ERR 8 RTEMem No more system pages for 134221824 bytes availab

Subject: Refresh Maxdb instance

Hi All Can you take a backup on a LC target with the name of LCQ and restore to a different machine (same machine type etc..) with a LC target name of LCC? I am getting an I/O error from header page.

Subject: CHAR(a,t) AND LIMIT functions

MaxDB 7.6.00.34 (linux 32) SQLStudio 7.6.00.27 Good afternoon List When querying my database I get unexpected results in using the CHAR and LIMIT functions. About the CHAR(a t) function. The he

Antwort: RE: Recover from lost log volume

Hi David I think the best is to create a new DB-Instance. In the creation dialog you have the option to generate the instance from backup then the log-volume will be initialized a you have the poss

Restore log backups using external backup tool

Is it possible to specify more than one external backup ID to the dbmcli command recover_start? The help indicates that you can only pass one EBID. When restoring a full data backup from a parallel me

poor join performance

Eduard M wrote > I have a query that does a simple join from 2 tables on a > foreign key. Both > tables are about 1 000 000 rows each. The query takes about > 11 seconds. It > seems like way too lo

Subject: poor join performance

I have a query that does a simple join from 2 tables on a foreign key. Both tables are about 1 000 000 rows each. The query takes about 11 seconds. It seems like way too long. select kar.id from per

Subject: Recover from lost log volume

How do I recover from total loss of my log volume? I can restore database backups ok but when after restoring the backups I try to change the database to online mode (from dbmgui) I get -24988 sq

SAP DB

HI Iam working as SAP R/3 Basis Admin. since from last 2 years. I have nil knowledge on SAP Database I need to get improve in SAP DB. As i gone through the SAP DB website I couldn 't understand whe

A fatal error caused EMERGENCY SHUTDOWN

Hi all we work with maxdb V. 7.6.00.34. A job deleting records from a table causes the following messages in knldiag.err 2007-01-21 07 08 58 0x7C4 ERR 53000 B*TREE IdxOrder.SubNode inval

backup_history_list command returns CONTINUE

backup_history_list and backup_ext_ids_list can both return CONTINUE in their output meaning that they could not return all the output. You then have to call backup_history_listnext or backup_ext_ids

Log backup with external backup tool

When backing up archived logs with an external backup tool we see - backint invoked to save one log - backint invoked to save dbm.ebf and dbm.knl - backint invoked to save one log - backint invoked

AW: SET MAXERRORCOUNT problem with loadercli input file

Hi Jo?l Jo?l Reungoat [mailto jreungoat@(protected)] wrote > > But this means that there is probably no solution to my problem. Am I > right ? > I simply want in a script (as mentionned in my first m

7.6.1.10: dbmsrv holding Vsleep?

Hi all We just upgraded one of our testsystem to 7.6.1.10. I see in the console that one task is in state "Vsleep " and that task is a dbmsrv $ x_cons SOP show ac SERVERDB SOP ID UKT UNIX T

Incremental Backup: -104 DBM - DBM command impossible at this time

Hello Ralf Are you sure that the database is still running ( "11 ERR 11000 d0_vatta Cannot open volume database Shutdown ")? If the database can not open devices because it run out of administration

Full-Text Search

Hello List mySQL offers full-text search as seen on http //dev.mysql.com/doc/refman/5.1/en/fulltext-search.html . Is there anything comparable in maxdb? Flo -- MaxDB Discussion Mailing List For

Incremental Backup: -104 DBM - DBM command impossible at this time

Hello I have a problem with an incremental backup by starting the backup command the following error occured ____________ 0 DBM command backup_start maxdb03_ink1 PAGES ERR -24988 DBM

Again strange behaviour with JDBC driver

Hi! I communicated with Marco Paskamp some weeks ago about something I noticed when testing my application http //lists.mysql.com/maxdb/28061 In an off-list discussion we found out that the JDBC dr

I/O error trying to recover log backup

Now I get the following error trying to recover log backup. The log files are present they are called BURVIS_LOG.001 and BURVIS_LOG.002 owner sdb user. I have a suspicion that this is because there

Invalid trigger after upgrade from 7.4 to 7.6 (AK Catalog information not fou

Kolja Kleist wrote >Hello List >After upgrading my database from sapdb 7.4.3.32 to maxdb 7.6.0.34 >I got an error when deleting a row from a specific table >AK Catalog information not found >I

Subject: Error: (-8033) on Log Backups

Hello All I am getting the error -8033 every time a log backup (auto log on) executes. I looked up the error and it says -8033 Incomplete log segment <http //dev.mysql.com/doc/maxdb/en/bb/549e
Page 10 of 129 1   2   3   4   5   6   7   8   9   10   Next 10   Next 100