-loadprocedure FAST no more available?

[markus_doehr2]

According to

Note 1464560 - FAQ: R3load in MaxDB

4. What is the importance of the R3load option "-loadprocedure FAST"?
Data records are inserted via the Shared Library R3ldfldsdb.<shared>, 
rather than via the SAP system.

When loading e. g. table E071KF I get in the log

INFO: Fastload not available for SAP DB, DBSL will be used(IMP)

despite that table has no LONG fields and is smaller than 8 kb.

Was that switched off again? I remember that it was working some time ago.

R3load is from April 19th 2011

lib_dbls patch 142>

MaxDB 7.8.02.23

Markus

[steffen_schildberg]

Hi Markus,

sorry for the late answer.

The responsible developer is not available at the moment and to check this myself I need a bit more version information. Would you mind to run

R3load -V

and post the result. I can then check the relevant code for limits for the use of fastload. There should be no general limitation that prevents the use of this procedure during load.

Best regards,

Steffen

[markus_doehr2]

Hi Steffen,

$ R3load -v
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
This is R3load version R7.01/V1.4 [UNICODE]
Compiled Apr 19 2011 01:55:48

There is no more version information from the R3load itself. It's R3load patchlevel 51 from the service marketplace (the latest available version). SCCS information:

# what `which R3load` | more
/usr/sap/TTT/SYS/exe/run/R3load:
         $Id: //bas/701_REL/src/krn/rscp/rscpexmc.c#7 $ SAP
         $Id: //bas/701_REL/src/krn/rscp/rscpexmh.c#4 $ SAP
         $Id: //bas/701_REL/src/krn/rscp/rscpexmt.c#5 $ SAP
         $Id: //bas/701_REL/src/krn/rscp/rscpsumg.c#7 $ SAP
         $Id: //bas/701_REL/src/krn/rscp/rscpc.c#13 $ SAP
         $Id: //bas/701_REL/src/krn/rscp/rscpda.c#2 $ SAP
         $Id: //bas/701_REL/src/krn/rscp/rscpdabp.c#1 $ SAP
         $Id: //bas/701_REL/src/krn/rscp/rscpexcc.c#6 $ SAP, compiled Apr 18 2011 21:34:51
         $Id: //bas/701_REL/src/krn/rscp/rscpexcd.c#2 $ SAP, compiled Apr 18 2011 21:34:55
         $Id: //bas/701_REL/src/krn/rscp/rscpgdio.c#6 $ SAP, compiled Apr 18 2011 21:35:03
         $Id: //bas/701_REL/src/krn/rscp/rscpllow.c#1 $ SAP $Date: 2007/09/25 $
         [...]
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldbuf.c#2 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3lddb.c#6 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3lddfh.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3lddummy.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldoh.c#2 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldtoc.c#3 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldcmd.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldexp.c#8 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldimp.c#4 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#10 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldph.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldsh.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldtpl.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldtsk.c#7 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldcpcv.c#8 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldfilter.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldio.c#3 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldmk.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldtfh.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldtxtld.c#1 $ SAP
             Unicode
         $Id: //bas/701_REL/src/R3ld/R3load/R3ldesql.c#2 $ SAP
             Unicode
         $Id: //bas/BIN/src/R3ld/R3load/R3ldfldada.c#1 $ SAP
             Unicode
         $Id: //bas/BIN/src/R3ld/R3load/R3lddbada.c#1 $ SAP
             Unicode
         $Id: //bas/BIN/src/R3ld/R3load/R3ldtplada.c#1 $ SAP
             Unicode

Than you!

Markus

[steffen_schildberg]

Hi Markus,

I checked the sources and found that in this SAP basis version (7.01) the fastload procedure is not supported by R3load (by intention as the comments suggest) - which corresponds to the statement in the note you mentioned. Do you remember the version of R3load you used that supported fastload?

Best regards,

Steffen

[markus_doehr2]

> I checked the sources and found that in this SAP basis version (7.01) the fastload procedure is not supported by R3load (by intention as the comments suggest) - which corresponds to the statement in the note you mentioned.

Where is written in the mentioned noted that it is not supported? I dont see that... It says that with 7.20 this is the default but it does not say, that 7.01 is not supported... or am I missing something?

> Do you remember the version of R3load you used that supported fastload?

No, it's quite some time ago but it was 701.

Markus

[steffen_schildberg]

Hi Markus,

I'm sorry for my lack of precision: I meant that the comments in the sources I saw for this version 7.01 state that it is not supported in 7.01. There is of course no such comment in the note. Sorry again.

I'll check again.

Steffen

[markus_doehr2]

ah - ok - don't mind

I wonder if there is a reason why it's not supported. Maybe I should open an OSS call and ask "officially"

Markus

[steffen_schildberg]

Hmm, I think it was simply not ready up to 7.20 :-(. And furthermore I think this will be the official answer in an OSS call, too

Any chance to use another version? But if you already used it and even in 7.01 - did you have some specially built tool or was that the official release? And if the latter is the case, sure that it really was 7.01?

Regards,

Steffen

[markus_doehr2]

> Hmm, I think it was simply not ready up to 7.20 :-(.

> And furthermore I think this will be the official answer in an OSS call, too

> Any chance to use another version? But if you already used it and even in 7.01 - did you have some specially built tool or was that the official release? And if the latter is the case, sure that it really was 7.01?

I used this version to install/migrate a few systems, it was working.

So then the note is wrong

Markus

[steffen_schildberg]

Hi Markus,

yes, I will arrange a change of the note and remove the release independence hint from it. But don't expect it to be done before end of August - we have vacation time.

Sorry for the inconveniences,

Steffen

[markus_doehr2]

Hey Steffen,

I'd be more happy with the fastloader to be working than with the note change

Markus

[steffen_schildberg]

Hi Markus,

yeah, I got this already but wont make any promise. In this case I would indeed suggest to place an OSS call with an development request. Otherwise HANA will solve all your problems in the near future :-).

Is there a way to use a newer R3load for your purpose?

Regards,

Steffen

[markus_doehr2]

> yeah, I got this already but wont make any promise. In this case I would indeed suggest to place an OSS call with an development request.

Ok, I'll do that!

> Otherwise HANA will solve all your problems in the near future :-).

I see! Didn't know there was something existing what'd do that? Where can I get more information about that?

> Is there a way to use a newer R3load for your purpose?

I'm doing TDMS shell installations (system copies) of 7.01 systems, can R3load 7.20 be used for that too?

Markus

[markus_doehr2]

OSS call created (662073 2011)

[markus_doehr2]

According to the call loadprocedure FAST is not/no more available in releases < 720.

Markus