Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am
This topic is locked: you cannot edit posts or make replies. Mainframe interview on 10th Oct 2015 ... kotesh Mainframe Jobs 0 Thu Oct 08, 2015 5:21 pm
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Sticky: Mainframe Developer Interview Questions Milin Mainframe Interview Questions 12 Wed Jan 07, 2015 8:58 pm

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