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

Splitting of tables in Unicode conversion

I have few questions, mentioned below, regarding splitting of tables in export/ import of large several terabyte database.

1- How do you create a file for split predefined tables

2- Can anyone provide a sample split file for predefined tables

3- How do you make export/import faster

4- What should the package unload order, be defined as?

5- What is different between package splitter and distribution monitor?

Points to be awarded for any kind of help.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 16, 2008 at 09:30 AM

    In the sapinst, there is the option SPLIT, so you can use it with the default values.

    After this, you can do other tests trying to modify the values of the SPLIT.

    In the DB02 you can see the biggest transactions.

    Otherwise you can use the distribution monitor/migration monitor if you want to do the export/import in paralell.

    Regards,

    Alfredo.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2008 at 10:43 AM

    Hi Abdul,

    I suggest you to use table splitting with appropraite where clause with the intelligent combination of columns. This needs a lot of reasearch on your data to identify which columns needs to be considered in where clause (Fields in primary key are manadatory) tehn create the index on the columns you used in where clause which improves the export performance. But needs a lot of research. For more information you use Distribution monitor (Use as many systems as possible) with the help of PAckage and table splitting.

    Thanks,

    Kiran.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kiran,

      Please let me know if the following points are true.

      Identify which columns needs to be considered in where clause

      1- What are the steps involved in identifying and then creating where clauses for specific columns?

      2- Is there any document or steps available to investigate the columns for those tables involved?

      This needs a lot of reasearch on your data to identify which columns needs to be considered in where clause (Fields in primary key are manadatory)

      3- If a table has 5 columns (1st column contains primary key) and 3 column is being selected in the where clause, then it would become mandatory to have 1 & 3 column in the where clause (since 1st column contains primary key and where clause on it becomes mandatory).

      I suggest you to use table splitting with appropraite where clause with the intelligent combination of columns.

      4- Can I do table splitting with R3ta on db host and different apps servers (both at the same time)?

      Then create the index on the columns you used in where clause which improves the export performance.

      5- How do I create the index on those above selected columns (1st primary key column and 3 column). Is it the same syntax used in Oracle SQL "create index <index_name> on <table_name>(<column_name>)?

      But needs a lot of research.

      6- Are there any links or docs available for this research?

      7- What are the ( structured ) steps recommended, to be followed, for doing the research?

      For more information you use Distribution monitor (Use as many systems as possible) with the help of PAckage and table splitting.

      8- Can I use distribution monitor in parallel with table splitting (through R3ta), with both at the same time?

      9- Can I use distribution monitor in parallel with package splitting, with both happening at the same time?

      It is better you go for data archiving and table reorganization of large tables rather than depending too much on R3ta

      10- I understand data archiving. But what is the best practice to be followed for table reorganization of large tables? (Should I use BR tools or is there any other specific recommended procedure).

      I very much appreciate your response.

      Thanks,

      Abdul

      Edited by: abdul haleem on Aug 4, 2008 11:28 PM

      Edited by: abdul haleem on Aug 4, 2008 11:29 PM

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2008 at 07:11 AM

    Hi,

    Use R3ta_hint.txt file for split predefined tables

    You have a option FASTLOAD make use of this optiion to make export/import faster

    It depends on size and aphabetical order

    if you need more clarity post message

    Regards

    Prithviraj Yadav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2008 at 09:31 PM

    I would appreciate if anyone answers, to the above 10 queries.

    Thanks once again in advance.

    Regards,

    Abdul

    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.