Hi, Sapdb [[EMAIL PROTECTED]] wrote:
> > I am trying to replicate from one linux server to another. > Both running > version 7.3 of sapdb. Source server is redhat 7.2, target > server is redaht > 8.0. > Hmm, should work. Nothing contrary known - so far. > Running repmcli -u user,pass -d DBNAME -b export.dat works fine, with > export.dat containing the following: > // > CATALOGEXTRACT USER OUTFILE '/usr/catalog.outfile' > // > TABLEEXTRACT USER OUTFILE '/usr/table.outfile' > > This generated 3 files, one for the catalog and two for the > table. The > table .0001 file is just over 50mb in size. It exported > about 20 tables. > Ok, what does the log say in this case. Really 20 exported tables? May be the single table (that gets imported later on) is about 50 MB in size? No? Is it possible to post the content of the /usr/table.outfile0000 file to me. This is a mapping file and contains the exported table names and the positions of their data in the 'real' data files. In addition it would be interesting to see the content of the created catalog file. Both files are text and thus readable. All this only if your policy does not forbid. Well in case of the mapping there is nothing interesting in for the public I think. > > On the target server, I ran repmcli -u user,pass -d DBNAME -b > import.dat -E 0 where import.dat contains the following: > // > TABLELOAD USER INFILE '/usr/table.outfile' OUTFILE 'restart.dat' > // > CATALOGLOAD USER INFILE '/usr/catalog.outfile' > Seems you've read the wiki. Great ;-) > This generated the following message on the console: > Opened connection to REPLICATION SERVER at node local host. > REPLICATION SERVER Log File: > '/usr/sapdb/indep_data/wrk/repserver.log' > > User USER connected to database DBNAME on local host. > TABLELOAD USER INFILE '/usr/table.outfile' OUTFILE 'restart.dat' > Successfully executed > > CATALOGLOAD USER INFILE '/usr/catalog.outfile' > Successfull > > The problem is, it imported one complete table, and the schema for the > second table (no data), and that is all that is in the target > database for > that user. Following is the contents of repserver.log. > Hmm, there is nothing interesting in the log. Seems all run without problems. Even the lines > > // M START 20030206 00115001 > // * > TABLELOAD USER INFILE '/usr/table.outfile' OUTFILE 'restart.dat' > > // * > // M Input data file used: /usr/table.outfile0001 > // * > // M Sum of loaded tables 1, sum of rejected tables 0 > // * > // M TABLE LOAD successfully executed > // * > state that the RepMan loaded the table data found. It looks as if there is only one table to import, though. So the export files would really be interesting. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
