Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2006
    Posts
    4

    Question Unanswered: one DBRM bind into 2 or more pkgs/plans

    As the pic shown,if we bind one DBRM into two different PACKAGEs/PLANs:
    1. Will it do any impact on DB2 performance if bind one DBRM into 2 or more packages?
    2. When rebind the packages used for BATCH usage, does it any impact for the online ones?
    3. We can differ the bind frequency/options for online and batch rebind. Will it only
    change the access path for online/batch?
    4. How about the UT(RUNSTATS,COPY…) against the TS will harm the performance?

    Thanks in advance!
    Attached Thumbnails Attached Thumbnails 1.JPG  

Posting Permissions

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