Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

one DBRM bind into 2 or more pkgs/plans

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
tiger_wen

New User


Joined: 24 Jun 2005
Posts: 22
Location: BeiJing,China

PostPosted: Wed Apr 24, 2013 7:16 am    Post subject: one DBRM bind into 2 or more pkgs/plans
Reply with quote

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
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Apr 24, 2013 8:46 am    Post subject:
Reply with quote

Tiger_wen,

Is the collections different for batch & online (or) same collection is used in batch & online plans ?

Regards,
Sushanth
Back to top
View user's profile Send private message
tiger_wen

New User


Joined: 24 Jun 2005
Posts: 22
Location: BeiJing,China

PostPosted: Wed Apr 24, 2013 11:27 am    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Apr 24, 2013 12:01 pm    Post subject:
Reply with quote

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
View user's profile Send private message
tiger_wen

New User


Joined: 24 Jun 2005
Posts: 22
Location: BeiJing,China

PostPosted: Thu Apr 25, 2013 6:31 am    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Apr 25, 2013 8:29 am    Post subject:
Reply with quote

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
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Thu Apr 25, 2013 1:30 pm    Post subject:
Reply with quote

What is a "ut" - apart from confusing?
Back to top
View user's profile Send private message
tiger_wen

New User


Joined: 24 Jun 2005
Posts: 22
Location: BeiJing,China

PostPosted: Fri Apr 26, 2013 2:54 pm    Post subject:
Reply with quote

Nic Clouston wrote:
What is a "ut" - apart from confusing?


UT -- Utility icon_razz.gif

David
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Fri Apr 26, 2013 10:01 pm    Post subject:
Reply with quote

No - Utility is Utility unless you are talking motor vehicles when Ute is Utility. There is no 'ut' in mainframe language.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Apr 27, 2013 12:24 am    Post subject:
Reply with quote

Quote:
There is no 'ut' in mainframe language.
Unless one considers the "old" SELECT/ASSIGN in COBOL . . . icon_cool.gif

Code:
FILE-CONTROL.                                   
    SELECT CARDFILE   ASSIGN TO UT-S-CARDFILE.   
Which also stood for "Utility" as in utility device . . . icon_wink.gif

d
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Sat Apr 27, 2013 1:30 pm    Post subject:
Reply with quote

Ah well, never did understand all that, being a PL/1 guy to start with.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts What is Bind Error? Chetan Kumar Mainframe Interview Questions 1 Fri Oct 16, 2015 7:00 pm
No new posts Related to BIND parameters in DB2 sivareddy123 ABENDS & Debugging 2 Fri Jan 30, 2015 4:12 pm
No new posts DB2 BIND on a FOCUS Program Sumeendar DB2 2 Wed May 21, 2014 11:56 am
No new posts DB2 Bind error -206 raviprabhu COBOL Programming 3 Wed Apr 09, 2014 10:35 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us