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
 

 

RUNSTATS Utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
nitinkumar.v

New User


Joined: 11 Oct 2007
Posts: 2
Location: india

PostPosted: Fri Aug 14, 2009 12:02 pm    Post subject: RUNSTATS Utility
Reply with quote

RUNSTATS TABLESPACE DB2CERTDB.MYTBLSPC1
TABLE (MYTABLE1) COLUMN(ALL)
INDEX

REPORT YES
UPDATE ALL

HISTORY ALL

which of the following statements is true?

A. Cardinality statistics will only be collected on all columns of all indexes on table MYTABLE1.
B. Cardinality statistics will only be collected on the first column of each index on table MYTABLE1.
C. Cardinality statistics will only be collected on all columns of each index associated with table space MYTBLSPC1.
D. Cardinality statistics will only be collected on the first column of each index associated with table space MYTBLSPC1.
[/b]
Back to top
View user's profile Send private message

Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Fri Aug 14, 2009 12:15 pm    Post subject: Answer
Reply with quote

A is the correct answer
Back to top
View user's profile Send private message
nitinkumar.v

New User


Joined: 11 Oct 2007
Posts: 2
Location: india

PostPosted: Fri Aug 14, 2009 12:22 pm    Post subject:
Reply with quote

But what i came to know is that...

this will give the statistics of all the columns of the table MYTABLE1 plus the first column of the index...

according to which ans B is correct but partially ....

but surprisingly the given ans is D

icon_confused.gif
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Fri Aug 21, 2009 3:42 pm    Post subject: Reply to: RUNSTATS Utility
Reply with quote

Hi

If the question given in the forum is correct, then there is no correct answer. Because the utility will throw an error.

RUNSTATS TABLESPACE DB2CERTDB.MYTBLSPC1

The length of database name and tablespace name is greater than 8 character.

Raghu
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm


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