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
 

 

DB2 INTERVIEW QUESTIONS

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

New User


Joined: 18 Apr 2005
Posts: 67

PostPosted: Thu Jan 05, 2006 11:53 am    Post subject: DB2 INTERVIEW QUESTIONS
Reply with quote

11. Db2 table having 10,000 Records but one record error occurred how could I find that error?

2.how to improve the efficiency of Ur db2 program?

3.suppose one db2 program for execution purpose it can take 13 days but I want to execute only 2 day how to improve efficiency of Ur program?

4.In Cobol and cics program how it can compile and link edit.

5.restart logic where in Ur db2 program can be written?

6.in Cobol pgm A Pgm B and Pgm C (pgm b and c are subprograms) here pgm A can call Pgm B and Pgm C in single call statement how can it call plz write code for that.... It contains some condition that is IF age > 45?then how can u do?.

7.In expeditor list option useS??
Back to top
View user's profile Send private message

khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Thu Jan 05, 2006 12:18 pm    Post subject: Query
Reply with quote

Hi rambabu,

Quote:
11. Db2 table having 10,000 Records but one record error occurred how could I find that error?


It's little bit dificult only and it depends on the query ie., for example if v r having a range of values in a column and v can write a query for checking if any row is out of that range.. like that v can check it of.. and the error occured row is easily retrived only by the developer of the table only.

Quote:
2.how to improve the efficiency of Ur db2 program?

There are many possible ways. It purely depends on the query which is coded on the table to retrive the records. For example the time efficiend query if u need to use only two or three rows u should make a query with that condition alone instead of using select all query. like that u can make ur code efficient.

Quote:

3.suppose one db2 program for execution purpose it can take 13 days but I want to execute only 2 day how to improve efficiency of Ur program?


Since ur program takes 13 days purely then u can reduce to some 10 or 11 days i dont think u can suddenly reduce it to 2 days.. if so then u should consider my above solution ie., simple and less timing query...logic will help u to do so..
Back to top
View user's profile Send private message
rambabu
Currently Banned

New User


Joined: 18 Apr 2005
Posts: 67

PostPosted: Thu Jan 05, 2006 5:41 pm    Post subject: Re: DB2 INTERVIEW QUESTIONS
Reply with quote

any one give me the answers in the 4,5,6,7 questions
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Thu Jan 05, 2006 5:48 pm    Post subject: Query
Reply with quote

Hi rambabu,

Quote:
4.In Cobol and cics program how it can compile and link edit.


I think the JCL which u r using is enough...

Quote:
5.restart logic where in Ur db2 program can be written?


http://ibmmainframes.com/viewtopic.php?t=7691&highlight=restart+db2

View the above link for restart logic..

Remaining let any one help u.... i m sorry...i was not clear with the remaining queries....
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 Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am


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