r3load arguments with LOAD_FORCED:SAMPLED_FULL_COMPRESS_ALL in DB2

171 Views

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