Results 1 to 6 of 6

Thread: roerg timings

  1. #1
    Join Date
    Dec 2011
    Posts
    30

    Unanswered: roerg timings

    when i do offline reorg it takes 3.5 hours
    after that when i checked actual reorg done on each table and sum the time taken to reorg the each table..its actualy only (1/2)half an our..


    for reorg tiime taken...i used the command


    db2pd -d <dbname> -reorg


    please help me why this time difference

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    can you state in more detail which timing you collect for which operation and how you get to the statement..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Dec 2011
    Posts
    30

    reorg timings

    Ex:

    Complete time taken for 4 table (A,B,C,D) in db1.

    i scheduled the cronjobs for this and get the email for successfull completion.
    its getting after 3 hours(No delay in mail).


    After this i checked for each table by using "db2pd -d <dbname> -reorg"
    it gives

    Address TableName Start End


    1 A 09/26/2011 04:32:12 09/26/2011 04:32:13

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    maybe : checking stats_time in catalog and see when this was done
    in the crontab job-generate log and time of start and end for each table
    according to db2pd = 1 sec ????
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    when I start a reorg - the table is not reflected in the db2pd output list
    I presume this is for automatic maintenance -
    has to be checked..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    reorg

    checked again - seems ok
    (0)[db2inst1@dlx00005 ump]$ date;db2 "reorg table pip.access"; date
    Thu Dec 8 08:55:38 CET 2011
    DB20000I The REORG command completed successfully.
    Thu Dec 8 08:55:50 CET 2011

    db2pd..
    0x00002AD316418528 ACCESS 12/08/2011 08:55:39 12/08/2011 08:55:50 12/08/2011 08:55:40 3
    I suggest - you print the times in the job executing the reorg to check
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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