Hycel: I did run into a "similar" problem few months ago, in my case data was exported but it could not be imported (between two 7.6 instances). I received some advise from SAP-personnel in this list:
Set the COLUMN_COMPRESSION parameter to false on both instances, then repeat the export/import process. This is an extended or support parameter (can't remember right now). You may have to restart your instances after resetting this parameter. Hope it helps. Best regards, Martin Cordova -------------- http://martincordova.com/docs/recipe-maxdb-linux-en.pdf > Hello, > > I have just moved from MaxDB 7.5 to MaxDB 7.6. I installed version 7.6 > on a new box, created my database and ran a set of java classes to load > data from my ASA database to my MaxDB database instance > (50,000,000 rows, in 111 tables). The migration when fine just like it > always did with version 7.5. I then tried to do an export just like I > would do with version 7.5. > > The commands I use are the following: > >> loadercli -d TEST -u DBA,SYSDBA > >> DBEXTRACT CATALOG OUTSTREAM FILE'C:\apps\xport\TEST.LOG' DATA > OUTSTREAM FILE'C:\apps\xport\TEST.DATA' > > After logging into the loadercli, and executing the second command, in > version 7.5, all of the data from the TEST database instance is > exported successfully. When I execute these exact same commands for > version 7.6, nothing gets exported. In the log file, I get the > following information: > > // M Loader 7.6.00 Build 012-123-102-632 > // * > // M Module: C:\Program Files\sdb\programs\bin\loadercli.exe > // * > // M Loader instance started at MALCOMI for database TEST > // * > // M Starting protocol at 2005092100070540 > // * > // M START 20050921 00070540 > // * > SET > // * > // M START 20050921 00070540 > // * > USE USER "DBA" * SCHEMA DBA SERVERDB "TEST" > // * > // M USER: 'DBA' on DB: 'TEST' ISOLATION LEVEL: 3 > // * > // M START 20050921 00070635 > // * > DBEXTRACT CATALOG OUTSTREAM FILE 'C:\apps\xport\TEST.LOG' DATA > OUTSTREAM FILE 'C:\apps\xport\TEST.DATA' > // * > // M Import PACKAGE > x'01000000BBCF41F964010000A931000091D733E126F2D19D' // * > // M Execute PACKAGE to transform CATALOG > / * > // M Number of TABLES to transform: 0 > // * > // M Number of VIEWS to transform: 0 > // * > // M Number of SYNONYMS to transform: 0 > // * > // M Number of TABLES transformed : 0 > // * > // M Import PACKAGE > x'01000000BBCF41F964010000A931000091D733E126F2D19D' // * > // M Execute PACKAGE to transform DATA > // * > // M Number of TABLES to transform: 0 > // * > // M Number of TABLES transformed : 0 > // * > // M Export PACKAGE > x'01000000BBCF41F964010000A931000091D733E126F2D19D' // * > > Does any one know why this is happening and what I must do to fix it? > > Thanks, in advance to anyone who can help me solve this issue. > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
