A Coruña

What best describes your job role?

Database Administration


Comment Wall

You need to be a member of WorldofDb2 to add comments!

Join WorldofDb2


  • Hi Jose,

    Regarding "Statistics on empty partition (partitioned by range)" topic. It was already closed, but here is my suggestion. Are you using "Admin tool"? If so, then you can do the following -

    1. "GEN" at table side

    2. Choose "Y" for index and the rest can be set as "N".

    3. Search for "Generate catalog stats:" - Choose ONLY

    4. Search for "Execution mode:" - Chosse TSO or Batch.

    5. All done!

    Now you have all the information that you need. You can manually altered the stats and load it again.

    Another way is to use command "UR" at index side. Using this it you'll be able to edit the stats online!


    Thiago Rossetto.

This reply was deleted.

Friends (1)