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 6 of 129 1   2   3   4   5   6   7   8   9   10   Next 10   Next 100  

Maxdb restore without log file

Hello Rene Your email adress seems to be corrupt so I post the answer here. Kind regards Uwe -----Original Message----- From Mail Delivery Subsystem [mailto MAILER-DAEMON@(protected)] Se

Migration 7.6.00.16 to 7.6.00.37

Hello I want to migrate from LinuxSUSE MaxDb-7.6.0.16 to Win2003Server MaxDb-7.6.00.37 When I make data backup on 7.6.0.16 engine and then I recover data to 7.6.00.37 engine an error occures duri

After index creation

Daniel Castro wrote > Hi > > I have some queries doing a SCAN. I identify then and I > create a index. > > For example > > explain SELECT PSV.PSV_COD PSV.PSV_APEL > PSV.PSV_TRAT

After index creation

Hi I have some queries doing a SCAN. I identify then and I create a index. For example explain SELECT PSV.PSV_COD PSV.PSV_APEL PSV.PSV_TRAT PSV.PSV_TIPO FROM PSV

Runnable User tasks

Hi What does this warning mean? W1 Number of runnable user tasks 9 CON RunnableUserTasks > MAXCPU VAL 9 > 1 Should I do anything? -- Daniel Castro - ????? MSN d

AW: MaxDB availability check with Nagios

Dear Robert I have a really small script that meets my needs "dbmcli -d TL1 -u <user > <pw > db_state " but our "nagios "-Team would prefer a direct connect from the nagios server to the database

MaxDB availability check with Nagios

Dear all we are using Nagios for monitoring our systems. Now we newly introduced two MaxDB databases and would like to perform a check if they are up and running (availability check). By now

AW: Segmentation fault when importing data from a 7.4 databaseinstance into a 7.

Hello Johan Johan Hallgren [mailto johan.hallgren@(protected)] wrote > Betreff Segmentation fault when importing data from a 7.4 > databaseinstance into a 7.6 instance using loadercli > [snipp

UDF in WHERE clause causes an odd execution plan

CREATE TABLE GIS2.SERVICES ( ID INTEGER NOT NULL DEFAULT SERIAL(1) PRIMARY KEY CODE VARCHAR(10) NOT NULL UNIQUE ) CREATE TABLE GIS2.SERVICE_DATA ( ID INTEGER NOT NULL DEFAULT SERIAL(1) P

Segmentation fault when importing data from a 7.4 databaseinstance into a 7.6 i

Hello list I am attempting to export the data and catalog for a user in a 7.4.03.27 instance and import them into a 7.6.00.34 instance. The procedure I follow is this using the database tools on th

SQL Query monitoring

Hi I am using sapdb 7.4 Is there any way to do a SQL Query Monitoring. I want to see the queries which are doing a tabls scan. I dont have the system source code. It is not a SAP ERP. Best regards

DB crashes each day, cannot detect the table or index

Hi my database-server crashes each day at the same time (from about 01 40 to 01 50). The knldiag contains each time the messages

INSERT

Dear All I need to INSERT some field in a SAPDB table. Should I use the SQL Studio ? Which user and password should I use ? Cheers Carlos Marino SAP Netweaver Consultant GRC Member -- MaxDB Dis

escape syntax for outer join is not jdbc 3.0 compliant

in the jdbc 3.0 specification The escape syntax for an outer join is {oj <outer-join >} where <outer-join > has the form table {LEFT|RIGHT|FULL} OUTER JOIN {table | <outer-join >} ON searchcondition

Performance problem: how to detect which query ?

Hello We have a MaxDB 7.6 starting from 7.4 in web application environment since years with minor problems but now with the same level of activity we have a serious perfomance problem that i

SQL Statement needed (if possible)?

Hello Everybody I use Maxdb 7.6 I need an idea for the following problem Table xyz id unique key pnr auftrag jahr monat vorgabe1 vorgabe2 vorgabe3 vorgabe4 I have one record f

niserver defunct

We have a problem with a production 7.5.0.44 maxdb This db serves some j2ee portals After some day of normal working we se a lot (hundreds) of niserver defunct process After a while the server stop

Upgrade Question

Hello i am trying to upgrade maxdb 7.6.00.36 to 7.6.02.10 with the installation manager in windows when i select the option "Install software and upgrade existing database instance " it says me this

Subject: SAPDB to MaxDB Migration

Hi I am having some strange problems woth sapdb performance. Although I got a lot of tips and read a lot of papers about configuring SAPDB i dont think it is wrking as I need. (Probably is my fault

MAXDB recovery error

Hi. We are trying to recover a database using a proven process. However though we are following our standard process we are getting an error during a "Restore Database Instance with Initilizatio

Subject: AW: Subscriber id exists

Hello a SyncMan Client is a durable consumer in the MessageHub. If the MessageHub detects that a socket breaks down it should reset the state from the consumer to inactive. If this fails you could

Subject: Database Crash - please help

Hi we??ve got a database crash today. kndiag.err > 2007-05-02 11 02 13 0 ERR 11979 DBCRASH Kernel exited without core and > exit status 0x9 > 2007-05-02 11 02 13 0 ERR 11985 DBCRASH No stack backt

Database crash with select command !?????????????

Hello Everybody I want to extract material data from a structured table(instueckliste) with an recursive query! (all material needed for l_startstl) My application connects via odbc l_cmd

Re: AW: -9041 BD Index not accessible

Hi if you set the database parameter AUTO_RECREATE_BAD_INDEXES to YES bad indexes should be recreated at restart time. But be aware that this could slow down your restart. Kind regards Holger Holg

Subscriber id exists

Hello i am testing synchronization stability and when is disconnect from network or reboot the client machine with syncservice started when i try to relaunch it (after reboot for example) i have th

AW: -9041 BD Index not accessible

Hello Please recreate the indexes with the DBMGui (Recovery - > Index) Did you reboot your computer without changing the database to offline mode? This could have broken the index. Regards Wolfg

Subject: -9041 BD Index not accessible

Hello well i am going to explain all from the beginning i am testing the example databases dbmaster and dbclient i had all working after configure the sync in the gui activate the message server

AW: syncman_caller.py classpath fix

Hello Thank you very much. The problem is that the msgserverclient.jar missed some class needed for a version check. In newer versions the problem is fixed and this class is also included in the msg

syncman_caller.py classpath fix

Hello i am testing synchronization and i have found a problem in version 7.6.00.36 of file syncman_caller.py it doesnt set the classpath to the file /opt/sdb/programs/app/syncman/lib/msgserver.jar

Database crashed if I try recreate the dbproc

I 'm using MAXDB version 7.6.00.16 build 016-121-109-428 Database crashed if I try recreate the dbproc DROP DBPROC PACS.getProtocolFieldData // CREATE DBPROC PACS.getProtocolFieldData ( IN TableN
Page 6 of 129 1   2   3   4   5   6   7   8   9   10   Next 10   Next 100