About

What best describes your job role?

Application Architecture, Application Development, Database Administration, IBM Employee / Business Partner


Events

Friends (11)

Photos

Db2portal.blogsspot

Comment Wall

You need to be a member of Mainframe User Community to add comments!

Join Mainframe User Community

Comments are closed.

Comments

  • carol goldberg January 27, 2021 at 1:24am

    Terry , 

    • Once  runstats are cleaned up, how do you determine if rebinds are needed, especially for static programs .  Also on a ongoing basis for when to rebind after the profile is updated, what do you recommend?  
    • Also is anyone using   Autonomic Statistic process via the IBM supplied stored procedures.  How has that been working ? Have their been any caveats in  using the process?
    •  Even when the  stats are updated. How do you determine which db2 packages need to be rebound or be bound?

     This table select * from SYSIBM.SYSTABLES_PROFILES  does contain the PROFILE_UPDATE and PROFILE_USED. Should that drive the rebinds?

    • Will that eventually be in the autonomics statistics flow?
    • I really want to know the good the bad of using this process.
    • In this Catalog Table, there are 2 columns SYSIBM.SYSTABLES_PROFILES, PROFILE_UPDATE , PROFILE_USED, of a profile is updated with a more current date of update, would you want to rebind for everthing reference this Table?
    • Also I was wondering about page sampling versus row sampling, Has the page sampling been successful?
This reply was deleted.

Earned points: 4600
Db2 Fan
Received:
Dec 3, 2021
0
Db2 Leader
Received:
Dec 3, 2021
0

Special