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
• mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• 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
• 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()
 
SAPDB to MaxDB Migration

SAPDB to MaxDB Migration

2007-05-03       - By Daniel Castro

 Back
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, but I hope to be easir with MaxDB).
Is there any tutorial on "How to migrate from SAPDB 7.403.32 to MaxDB

<maxdb@(protected)>

Do you think I should try more configurarion parameters or upgrade the
database is really necessary

My configurantion parameters:

KERNELVERSION          string    KERNEL    7.4.3    BUILD 032-121-068-842
INSTANCE_TYPE          string    OLTP
MAXARCHIVELOGS         int    2
MAXDATADEVSPACES       int    11
MAXBACKUPDEVS          int    2
LOG_MIRRORED           string    NO
MAXUKPS                int    1024
MAXCPU                 int    3
MAXUSERTASKS           int    300
MAXSERVERTASKS         int    21
_MAXTRANS              int    1292
_LOCK_REGIONS          int
MAXLOCKS               int    40000
DEADLOCK_DETECTION     int    4
SESSION_TIMEOUT        int    900
REQUEST_TIMEOUT        int    180
_PAGE_SIZE             int    8192
_PACKET_SIZE           int    36864
_MINREPLY_SIZE         int    4096
_CAT_CACHE_MINSIZE     int    262144
CAT_CACHE_SUPPLY       int    49152
INIT_ALLOCATORSIZE     int    237568
CACHE_SIZE             int    196608
OPTIM_MAX_MERGE        int    500
OPTIM_INV_ONLY         string    YES
OPTIM_CACHE            string    NO
OPTIM_JOIN_FETCH       int    0
JOIN_SEARCH_LEVEL      int    0
JOIN_MAXTAB_LEVEL4     int    16
JOIN_MAXTAB_LEVEL9     int    5
MEMTASK                int    406
MEMUKP                 int    293
MEMPROC                int    229
SHOW_MAX_STACK_USE     string    NO
LOG_SEGMENT_SIZE       int    12373
My Hardware :

cpuinfo:

processor    : 0
vendor_id    : GenuineIntel
cpu family    : 15
model        : 2
model name    : Intel(R) XEON(TM) CPU 2.00GHz
stepping    : 4
cpu MHz        : 1997.236

processor    : 1
vendor_id    : GenuineIntel
cpu family    : 15
model        : 2
model name    : Intel(R) XEON(TM) CPU 2.00GHz
stepping    : 4
cpu MHz        : 1997.236

bogomips    : 3989.50


free -m:
            total       used       free     shared    buffers     cached
Mem:          2026       1976         49          0         13        325
-/+ buffers/cache:       1637        388
Swap:          517        269        247



Please, If I am doing something wrong, please tell me.
Thank you very much !


--
Daniel Castro - ?????
MSN: danielti@(protected)
Skype: danielti2005
ICQ : 316727989
Jabber: danielti
Linux User: 387864
AOL User: Danielti2005
Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria