Skip to Content
author's profile photo Former Member
Former Member

R3ta/R3load : Creating a Temporary Index

Hello friends,

We are working on migration of very large DB2 z/OS database.

We are going to perform unsorted export for all non-cluster tables and want to test performance with Temporary index created as per some information provided in guide.

However, it is not clear - What SAP say.

First they say for DB2 z/OS create them with DB Tools only.

Next point say, it can be done with R3load commands also. Mentioned .STR, .TSK & .cmd files have been generated after running table splitting.

Can you please help me with guiding how can we use these files to create Index ? (they are not in Export/ABAP/DATA directory)

Do we have to run this R3load manually before starting DB export ?

And is this R3load going to create these index in ABAP DDIC also ? Or only in DB ?

For z/OS, what should be used ? R3load or DB tools ?



Capture.PNG (61.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 10, 2016 at 08:58 PM

    Hi Vikas.

    SAP system migration takes place in two different methods through DB based and SAP Standard methods, last week we have migrated from our production to sandbox system on IBM-i system using SAP standard method R3load(For upgrade to EHP7 ERP6), it went almost 14 hours DB size around 5.5 TB.

    R3load will create all the tables and index's in the target system. all depends on your hardware resources.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.