View previous topic :: View next topic
|
Author |
Message |
tiger_wen
New User
Joined: 24 Jun 2005 Posts: 22 Location: BeiJing,China
|
|
|
|
As the pic(attached) 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! |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Tiger_wen,
Is the collections different for batch & online (or) same collection is used in batch & online plans ?
Regards,
Sushanth |
|
Back to top |
|
|
tiger_wen
New User
Joined: 24 Jun 2005 Posts: 22 Location: BeiJing,China
|
|
|
|
sushanth bobby wrote: |
Tiger_wen,
Is the collections different for batch & online (or) same collection is used in batch & online plans ?
Regards,
Sushanth |
Hi Sushanth
Thanks for your reply.
The colloection,package and plan are differenct from each other accroding to the batch/online side.
Any comments are welcomed.
Thanks. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Tiger_wen,
1. Will it do any impact on DB2 performance if bind one DBRM into 2 or more packages?
Binding one dbrm into two collections, can give you better control, like access paths can be different for online and batch, for example you may prefer matching columns in online using OPTHINTS but for batch TS scan is fine, those kind of stuff you can do. Thing is you may have lots of packages, access path review has to be done for both separately.
2. When rebind the packages used for BATCH usage, does it any impact for the online ones?
NO
3. We can differ the bind frequency/options for online and batch rebind. Will it only change the access path for online/batch?
YES.
And just want to know how often do you BIND/REBIND program in production ?
4. How about the UT(RUNSTATS,COPY…) against the TS will harm the performance?
COPY has nothing to do with application program performance, its basically for backup/recovery purposes.
RUNSTATS updates catalog with statistics of the data in the tablespace/table. Its good to runstat before doing an rebind.
Regards,
Sushanth |
|
Back to top |
|
|
tiger_wen
New User
Joined: 24 Jun 2005 Posts: 22 Location: BeiJing,China
|
|
|
|
sushanth bobby wrote: |
3. We can differ the bind frequency/options for online and batch rebind. Will it only change the access path for online/batch?
YES.
And just want to know how often do you BIND/REBIND program in production ?
4. How about the UT(RUNSTATS,COPY…) against the TS will harm the performance?
COPY has nothing to do with application program performance, its basically for backup/recovery purposes.
RUNSTATS updates catalog with statistics of the data in the tablespace/table. Its good to runstat before doing an rebind.
Regards,
Sushanth |
Hi Sushanth
Thanks great for your post.
3....
I am an application engineer,an know a bit about DB2.I am not sure how ofter the DBA will BIND/REBIND our DBRMs.
4....
It should be better to run RUNSTATS ut before we rebind our DBRMs.
It might be also needed to REORG the TS,I think.How the REORG ut will
impact the online performance as they share the same table for online and batch?
Thanks very much! |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hello tiger_wen,
TS's can be reorg'd if they are unclustered, but that will be usually taken care during the weekly house-keeping.
Reorg's are not recommended during the online day, can be done after the batch, if lots of rows have been added or deleted.
Regards,
Sushanth |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
What is a "ut" - apart from confusing? |
|
Back to top |
|
|
tiger_wen
New User
Joined: 24 Jun 2005 Posts: 22 Location: BeiJing,China
|
|
|
|
Nic Clouston wrote: |
What is a "ut" - apart from confusing? |
UT -- Utility
David |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
No - Utility is Utility unless you are talking motor vehicles when Ute is Utility. There is no 'ut' in mainframe language. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Quote: |
There is no 'ut' in mainframe language. |
Unless one considers the "old" SELECT/ASSIGN in COBOL . . .
Code: |
FILE-CONTROL.
SELECT CARDFILE ASSIGN TO UT-S-CARDFILE. |
Which also stood for "Utility" as in utility device . . .
d |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Ah well, never did understand all that, being a PL/1 guy to start with. |
|
Back to top |
|
|
|