IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 INTERVIEW QUESTIONS


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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: 677
Location: NJ

PostPosted: Thu Jan 05, 2006 12:18 pm
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
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: 677
Location: NJ

PostPosted: Thu Jan 05, 2006 5:48 pm
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?


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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Comp interview questions Mainframe Interview Questions 5
No new posts Interview Questions on Cobol DB2 program Mainframe Interview Questions 5
No new posts The Last Two Question For You To Ask ... Mainframe Interview Questions 0
No new posts Mainframe Interview Questions CICS,CO... Mainframe Interview Questions 6
No new posts Viewing executing process in NDM .. q... IBM Tools 0
Search our Forums:

Back to Top