Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    26

    Unanswered: Need to estimate the time to export of table

    Hi All
    In my environment ( "DB2 v8.1.1.156" , 64 bit)
    nearly 18GB table is there
    i want to take export of that table and load into another tablespace
    i want to estimate the time which takes for export and load
    please let me know is any procedure

    Thanks

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    It depends.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103
    Do some testing using the same table/export criteria in lower environment to guestimate it

  4. #4
    Join Date
    Mar 2006
    Posts
    104
    Hi,

    I had a similar situation and this is what I did:

    Did a count of number of records in the table T1.

    Created a new table T1_N identical to T1 in new tablespace

    Used 'Load from cursor' to load 10% of the records from T1 to T1_N (used the 'fetch first xxxx rows' in the select statement in the 'load from cursor').

    Gestimated the actual time as 10 times the time taken for loading 10% of the records and requetsed outage for this period.


    During the outage:
    Dropped the T1_N

    Recreated T1_N

    Moved data from T1 to T1_N

    Renamed T1 to T1_O

    Renamed T1_N to T1

    After ensuring apps were running OK for a week, dropped table T1_O

    Harikumar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •