Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

r3load arguments with LOAD_FORCED:SAMPLED_FULL_COMPRESS_ALL in DB2

Former Member
0 Kudos
232

Hello experts,

We are on AIX and DB2 9.5 fix pack 4

We are in the process of doing a Combine upgrade & Unicode conversion from R/3 4.7 to ECC 6.0 EHP 4.0, we are also planning to do compress our database using "Compressed load based on R3load sampling" . However on the IBM "DB2 Optimization Techniques for SAP Database Migration and Unicode Conversion" Page 174 they are only mentioned about using R3load arguments for import:

phase one "R3load -loadprocedure fast LOAD:SAMPLED_FULL_COMPRESS_ALL" and

phase 2: R3load -loadprocedure fast LOAD

No where in the document mentioned if I can use LOAD_FORCED instead of LOAD with SAMPLED_FULL_COMPRESS_ALL option to compress the database....

I understand that if I use DB2 LOAD API without FORCED option, the r3load still uses INSERT for some tables.

Does anyone know if I can use LOAD_FORCED option with SAMPLED_FULL_COMPRESS_ALL to compress the data?

Please advice...

Thanks

Kumar

1 REPLY 1

markus_doehr2
Active Contributor
0 Kudos
56

Check

Note 1058437 - DB6: R3load options for compact installation

Markus