Sorry, I forgot to reply to the mailing list ...
----- Original Nachricht ---- Von: "Schildberg, Steffen" <[EMAIL PROTECTED]> An: [EMAIL PROTECTED] Datum: 03.02.2004 16:31 Betreff: RE: Problems with DBEXTRACT and DBLOAD Hi Steffen, thanks for your detailed hints. > > I want to make a full unload of a large database instance > > "DEMO" (nearly 5GB) using the statement: > > LOADERCLI -d DEMO -u dba,dba -b DBExtract.txt -E 20 > > where DBExtract.txt has the folowing contents: > > DBEXTRACT CATALOG OUTSTREAM 'catalog.out' DATA OUTSTREAM > > 'data.out' > > > > The result is one file 'catalog.out' with the catalog > > information and seven splitted files 'data.out0001' to > > 'data.out0007' with the application data. > > > Yep, that's alright. The loader sets a limit of 1 GB size for data > files. If the content of a table to extract would make the file 'overflow' > the loader closes this file and opens a new one. > Unfortunately there is an error when reading these multiple files (see > below > for a workaround). > > > Now i want to load this data into another database instance > > "DEMO_2" using the corresponding DBLOAD-Command. > > But this command accepts only a single file as DATA INSTREAM. > > Also, sequential calls of DBLOAD with all the different > > 'data.out*"-Files will result in a "Duplicate Table > > Name"-Error due to the multiple catalog definitions. > > > Well, as written there is a bug that prevents the Loader from reading > the multiple files. The workaround would be to extract the data again > with a slightly modified command. > > To do this first delete all entries in system table TRANSFORMATIONMODEL. > This table is used by the Loader to process the commands. It logs there > tables to process and tables already processed. In the version you deploy > the Loader does not in any case delete all unnecessary entries after > successful command processing which may lead to double > CREATE TABLE statements in catalog files when issuing subsequent > CATALOGEXTRACT > commands. You say "In the version you deploy ..." (i.e. 7.5.0.5) there are some problems. Does this mean, that this bug is fixed in the newest versin 7.5.0.8 ??? > Then run the following command > DBEXTRACT CATALOG OUTSTREAM 'catalog.out' DATA OUTSTREAM PIPE 'data.out' > > Here it is extremely important to use the PIPE medium and to NOT create a > pipe > on OS level beforehand. > The command will use an internal bug of the used file interface. > It (the interface) doesn't recognize a given pipe to open > as pipe (on Linux/Unix) as long as it is not created by operating system > means. > But the Loader treats the medium as pipe and doesn't split it ;-) (if this > sounds > weird - it is weird). > Thus the Loader will create only one simple file (if not limited by your OS > parameters) > which can subsequently be loaded in the same manner (using the pipe medium > without ...). Does this workaround still work in version 7.5.0.8 or is it perhaps not necessary anymore??? In some futher posting you stated that there are other problem in 7.5.0.8. concerning the Loader. So, would you recommend an upgrade or not ??? Thanks for your advise, Frank -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
