Hi, it sounds so easy....
For two weeks, I try to transfer data from one database-server (Version 7.4.3.10) to another (Version 7.4.3.10 too).
Whatever I try, TABLOLOAD stops loading during execution, it loads just the half of my database.
This is what I did:
1. Step: Export Data (repmlci) ================================================ I called repmcli, because loadercli is not installed there. repmcli -u dba,dab -d testDB -b extract.command
Where extract.command looks like this: SET MAXERRORCOUNT 20 // USE USER dba dba SERVERDB testDB // DBEXTRACT CATALOG OUTSTREAM 'testDB.ddl' DATA OUTSTREAM 'testDB.data'
2. Step: Create Destination Database ================================================ dbmcli db_create testDB dbm,dbm dbmcli -d testDB -u dbm,dbm create.command
Where create.command looks like this:
(The size of the volumes of the desitination database equals the size of the volumes of the source database.)
param_startsession param_init param_put MAXUSERTASKS 5 param_put MAXDATADEVSPACES 5 param_put MAXARCHIVELOGS 2 param_checkall param_commitsession
param_addvolume 1 LOG testDB_1_log_001 F 12800 param_addvolume 1 DATA testDB_1_data_001 F 128000 param_addvolume 2 DATA testDB_1_data_002 F 256000
db_admin util_connect util_execute INIT CONFIG util_activate dba,dba load_systab -ud jboss
3. Step: Load Data To Destination Database (repmlci) ================================================ repmcli -d testDB -u dba,dba -b load.command
Where load.command looks like this:
SET MAXERRORCOUNT 20 // CATALOGLOAD ALL INSTREAM FILE 'testDB.ddl' // TABLELOAD ALL DATA INSTREAM FILE 'testDB.data0001'
4. Result ================================================ Tableload loads correctky the first 14 of 31 tables, then it stops. This is its output to loader.prt:
TABLELOAD ALL DATA INSTREAM FILE 'testDB.data0001'
// *
// M Number of tables to transform: 31
// *
// M Number of views to transform: 0
// *
// M Number of synonyms to transform: 0
// *
// M CONFIGURE TRANSFORMATIONPACKAGE
// *
// M EXECUTE PACKAGE TO TRANSFORM DATA
// *
// M Number of tables excluded during extract : 0
// *
// M Number of tables transformed : 14
// *
// M UNLOAD TRANSFORMATIONPACKAGE x'02000000BE98B040DD5A000069DC9702AAF0C0A8FFFFFFFF'
// *
// M Releasing user connection (USER: 'DBA').
Any ideas????
Claudia
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
