Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011

    Exclamation Unanswered: is runstats required after migration ??

    Hi All,
    We have tested db2 migration from version 8.2 to 9.7 (by restoring the offline backup of 8.2 to 9.7) and after that when we tested our batch jobs we were getting junk data but after runstats we got the correct data.

    And when I un-installed db2 9.7 and again installed 8.2 and restored the same backup again ,we again got junk data and after runstats we got correct data.....have i missed something....I am facing this issue for the first time and dont know how to cope up with the issue...any help would be largely appreciated

    DB :- db2 8.2 fp 12
    OS:- AIX 5.3
    Known Maintenance Levels:

    Harsh Verma

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    with or without runstats : you should always get the same data (faster or slower) if not modified in between
    junk data : ??
    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

  3. #3
    Join Date
    Aug 2011
    we got different values (junk data) having no relation with original data for each and every record before runstats...but after runstats every thing got OK.


Posting Permissions

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