Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 193
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 Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
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

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us