Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
interview queries

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

Active User

Joined: 17 Oct 2004
Posts: 190
Location: hyderabad

PostPosted: Wed Mar 02, 2005 7:18 pm    Post subject: interview queries
Reply with quote


i was asked following queries in an interview

1.Disadvantages of Runstats Utility

2.which system tables keeps the information of VIEWS

3. the alias is not deleted even if the table is deleted,what happens when i refer an alias name after the table is deleted,what will be the SQLCODE

Back to top
View user's profile Send private message


Active User

Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Fri Mar 04, 2005 2:31 pm    Post subject:
Reply with quote

1 Ans: The DB2 compiler reviews object statistics, gathered by the RUNSTATS command, to determine the best way to optimize the request. Absent or outdated statistics can cause the SQL compiler to make poor
optimization decisions about index access, join method and data refetching.

Object relationships and dependencies are also important to SQL tuning. For example, a trigger that executes every time a row is inserted could cause insert statements that take an unusual amount of time to process. Without a complete picture of the objects involved with a SQL
statement, tuning efforts may be dedicated to the wrong area.

2 Ans: views are stored in SYSVIEWS table.

select * from SYSIBM.SYSVIEWS; will show a list of views

3 Ans:
An alias can be defined for an object that does not exist at the time of the definition. If it does not exist, a warning is issued (SQLCODE 01522).

However, the referenced object must exist when a SQL statement containing the alias is compiled, otherwise an error is issued (SQLCODE 52004).

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 A couple of Interview Questions on Co... viplavmodi36 Mainframe Interview Questions 5 Fri Feb 23, 2018 6:21 pm
No new posts The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Need help with below queries ashek15 DB2 3 Thu Mar 23, 2017 1:38 am
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am

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