List:MaxDB« Previous MessageNext Message »
From:frank_hischke Date:February 3 2004 10:26am
Subject:Aw: Re: Problems with DBEXTRACT and DBLOAD
View as plain text  
> Le lundi 02 février 2004, frank_hischke@stripped a écrit...
> 	bonjour,
> 
> 
> > Hi,
> 
> > I'm a new user of the MaxDB 7.5.0.5 and have a question referring to the
> SAP DB LOADER.
> 
> > 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' 
> 
> Don't you have to specify a medium type  ?
> 
> DBEXTRACT CATALOG OUTSTREM FILE 'catalogFilePath' DATA OUTSTREAM FILE
> 'dataFilePath' ?
> 

Hi Jean-Michel,
thanks for your answer.

It seems that medium type FILE is the default.
Specifying it explictly doesn't change anything on my problem. 

What I'm wondering about is:
1) Why does the loader split the resulting DATA OUTSTREAM FILE and which algorithm does it
use for this?
   (Some files have a size of 500MB, others have a size of 1GB)
2) If I use DBEXTRACT for a small database instance, only one DATA OUTSTREAM FILE is
crated, but again '0001' is appended to the specified dataFilePath.

Frank






Thread
Aw: Re: Problems with DBEXTRACT and DBLOADfrank_hischke3 Feb
Aw: Re: Problems with DBEXTRACT and DBLOADfrank_hischke3 Feb
RE: RE: Problems with DBEXTRACT and DBLOADfrank_hischke4 Feb
RE: RE: Problems with DBEXTRACT and DBLOADfrank_hischke4 Feb
RE: RE: Problems with DBEXTRACT and DBLOADSteffen Schildberg4 Feb
RE: RE: Problems with DBEXTRACT and DBLOADfrank_hischke10 Feb