Re: Solaris/x86_64: loading system tables

Döhr, Markus ICC-H wrote: [EMAIL PROTECTED] ~/maxdb-7500/usr/lib>dbmcli -u dba,dba -d XXX dbmcli on XXX>load_systab -ud domain ERR -24964,ERR_EXECUTE: error in program execution 256,/home/sapdb/maxdb-7500/usr/bin/x_python /home/sapdb/maxdb-7500/usr/env/lsystab.py -R /home/sapdb/maxdb-7500/usr -d XX

Re: Performance in like queries

Edson Carlos Ericksson Richter wrote: select * from mytable where mydescription like '%something%' For this query, the execution plan doesn't uses the index containing mytable.mydescription, and take near to 68,09 secs (~32 times slower). Why the "explain" says index use for first query, and a tab

Re: BLOB's BLOB's and Blob's

M4rkuz! wrote: Well I'm a newbie using blobs, so my question is how can I Use Blobs fields to storage images into a MaxDB DB, and what is better to storage a link to a file in disk or to storage the whole image into the Database Advantages of storing files in the database: - any locking is done by

Re: Solaris/x86_64 - slowknl online :-)

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 --- curre

Solaris/x86_64: loading system tables

I'm struggling since some hours now and I think I'm running in circles. I had the same error when I initially tried to load the system tables. After copying all the python modules and redistributing them I had the problem of zlib not beeing available in python (although I remember this is from 7.6

Performance in like queries

Hi! I have a 65 records table with several fields, in MaxDB 7.5.0.24 for linux. Work pretty well. But, if I issue: select * from mytable where mydescription like 'something%' the execution plan uses the index containing mytable.mydescription, and take near to 2,07 secs. Good performance, goo

RE: about use schedule to backup a database on Maxdb76

Hello Zhouyan, So it seems indeed, that backup commands can currently not be executed successfully by MaxDB's scheduler. The 2nd and 3rd attempt fail, because util_connect and backup_start are executed in two separate DBM Servers. Until MaxDB's scheduler is improved I would like to suggest to use

Solaris/x86_64 - slowknl online :-)

Hi, I was finally able to activate the slowknl (!) on Solaris10/AMD64: [EMAIL PROTECTED] ~/maxdb-7500>dbmcli -u dbm,dbm -d XXX db_admin -s OK [EMAIL PROTECTED] ~/maxdb-7500>dbmcli -u dbm,dbm -d XXX db_activate dba,dba OK [EMAIL PROTECTED] ~/maxdb-7500>dbmcli -u dbm,dbm -d XXX db_state

[MaxDB] How to move a DB-instance from one server to an other?

Hi! How can I move a DB-instance from one server to an other? I work on a normal PC and now I would like to port the DB-instance from that PC to my notebook so I can demonstrate it to others. Of course I've installed the same versions of MaxDb on both of these PCs. I tried to back up the DB on t

Problem with DB Restore

Hello, IÂve a problem restoring a database. IÂm using a script that is tested an used since several months. During db_activate RECOVER dbRestore_PROD_R2 ERR -24988,ERR_SQL: sql error -71,connection broken server state 6 the database shut down and knldiag gives the following: 2005-04-06 12:38:05 92

about maxdb76 event

hello,everyone I have a question about event on maxdb76.Who may tell me the function about the dbm command --event_release.After I execute the command-event_wait,I execute event_release.I think the wait session would be stop,but event_wait can receive information of database all the same.Please