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
 

 

Resetting DB2 Statistics

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

New User


Joined: 14 Sep 2009
Posts: 60
Location: Milan

PostPosted: Tue Dec 15, 2009 5:15 pm    Post subject: Resetting DB2 Statistics
Reply with quote

hi,is there a way to make a LOAD REPLACE without resetting the statistics db2?


thank you
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Dec 15, 2009 5:36 pm    Post subject:
Reply with quote

theONE,

Don't add the STATISTICS keyword to LOAD parmeters.

Why can i ask ?
Usually everybody wants their statistics to be up-to-date.

Sushanth
Back to top
View user's profile Send private message
theone1987

New User


Joined: 14 Sep 2009
Posts: 60
Location: Milan

PostPosted: Tue Dec 15, 2009 5:39 pm    Post subject:
Reply with quote

sushanth bobby wrote:
theONE,

Why can i ask ?

Sushanth


tnk you...
because I need to delete and reload a table.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Dec 15, 2009 6:49 pm    Post subject:
Reply with quote

depends on what "the statistics db2" is
if you mean the statistics in the catalog, then sushanth is right.
at least if you didn't drop and recreated the table.

if you mean RTS or Real time statistics, then : NO
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 Mainframe HTTP server statistics vasanthz All Other Mainframe Topics 2 Wed Apr 10, 2013 8:05 pm
No new posts Table statistics information required... amarjit singh DB2 14 Fri Mar 08, 2013 3:03 pm
No new posts Sticky: Batch printing of ISPF statistics Robert Sample COBOL Programming 7 Mon Oct 22, 2012 8:58 pm
No new posts Need PDS statistics pullaiah.cts JCL & VSAM 13 Sun Sep 23, 2012 10:31 am
No new posts How to obtain bind statistics for a p... Balaji Canabady DB2 8 Fri Jun 15, 2012 3:39 pm


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