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
 

 

Some DB2 Interview questions

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

New User


Joined: 28 Jul 2005
Posts: 58

PostPosted: Thu Nov 17, 2005 4:10 pm    Post subject: Some DB2 Interview questions
Reply with quote

Dear Friends,

Can u please give the answer for the foll questions.

1. Which is best Static call or Dynamic call? What all are the advantages of using either Static call or Dynamic call? How will u get S0C4 when u are using CALL statement?

2. In which situation u will Rebind again for Package? and for Plan?

3. U are having 100000 records. U have processed 50000 records and now there is some problem, due to that the sytem is shut down.How can u avoid Processing the Records from the First step, as i have processed 50000 records.

4. I am using Cobol+Db2 program. In that i am pasing the input from Parm. What all are the other ways to pass the input? Then i said Sysin DD *. Then he asked how will u Accept it in Cobol+db2 Program. that is i am not going to use PARM. What all are other ways and How?

5. What is the need for giving Header and Trailer Records for the Input files and in my Output file i don't want to write the Header and Trailer Record, How will u code it?

I said using SORT we can do this, but he asked me to code it in the CObol+Db2 Program

Actually i couldn't able to Test in my system, SO can u guys please give me the answers?

Thanks and Regards,
Suganthy.
Back to top
View user's profile Send private message

reshma

New User


Joined: 10 Sep 2005
Posts: 9
Location: software engineer

PostPosted: Thu Nov 17, 2005 4:46 pm    Post subject: Re: Interview questions
Reply with quote

suganthyprabha,

u keep on posting questions in this forum.but no answers from ur side.
dont tell like tht u r not able to test in ur system.get a job first and then test it in ur company
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Tue Nov 22, 2005 2:32 pm    Post subject: Interview Questions
Reply with quote

Hi frnd,
Dear Reshma plz dont discourage any pals in this site. try to answer else leave it..

Here in i had explained the answers which is up to my knowledge.

1. Which is best Static call or Dynamic call? What all are the advantages of using either Static call or Dynamic call? How will u get S0C4 when u are using CALL statement?
Static is the best. since most of the thing which v r going to extract is known in advance whereas dynamic v need to get initialize it in runtime. where some exceptions may occur.
similarly S0C4 is Caused by subscript being out of range in general. it is caused in CALL statement when using call by reference i think so. check it.

2. In which situation u will Rebind again for Package? and for Plan?
during the compilation Bind process is being taken place na. then once u made any changes in the Cobol+db2 interface then it should affect the changes such that u go for rebinding a packages/plan. since package has the advantage of rebinding the particular plan.

3. U are having 100000 records. U have processed 50000 records and now there is some problem, due to that the sytem is shut down.How can u avoid Processing the Records from the First step, as i have processed 50000 records.
It's not a exact point that v had known already that at 100000th record the system get crashes. so just keep the checkpoint at some interval and do the commit process at the same.

4. I am using Cobol+Db2 program. In that i am pasing the input from Parm. What all are the other ways to pass the input? Then i said Sysin DD *. Then he asked how will u Accept it in Cobol+db2 Program. that is i am not going to use PARM. What all are other ways and How?
one way is PARAM said already. the another way is u can just give in SYSIN DD * and type the input value. use accept verb and move it to the DB2 defined variable. i think tat's the two way for batch process.

5. What is the need for giving Header and Trailer Records for the Input files and in my Output file i don't want to write the Header and Trailer Record, How will u code it?
The Header and Trailer is given inorder to find out the record sequences and the record desc in short. so if u need to eliminate that just v can skip the header and trailer by comparing to some variable. if any other solution plz place ...

if i get the coding then i will post... All the best for ur future interview
Back to top
View user's profile Send private message
suganthyprabha

New User


Joined: 28 Jul 2005
Posts: 58

PostPosted: Tue Nov 22, 2005 2:47 pm    Post subject: Re: Interview questions
Reply with quote

Dear Kamarudeen,

Thanks for ur Reply.

I was really hurted by Reshma's Reply.
If i could able to do it and i know the answer i wil not disturb others.
Really i couldn't able to test programs in my shop. We are using Changeman package,now that package is into Production. so i couldn't able to check it. In the Testing Region also i couldn't able to compile Normal Cobol programs also as 2 of the PDS are not Existing. i have tried to create it but it is giving error as Authorisation failiure.

Once again thank u so much.

Thanks and Regards,
Suganthy.
Back to top
View user's profile Send private message
sathish_rathinam

New User


Joined: 22 Aug 2005
Posts: 59
Location: india

PostPosted: Tue Nov 22, 2005 2:58 pm    Post subject: Re: Interview questions
Reply with quote

hi suganthy,

for ur 4th question,answer is u can pass paramets thru run jcl to the cobol-db2 program like


STEP EXEC PGM=IKJEFT01
DSN SYSTEM(REGION NAME)
SYSTSIN DD *
RUN PROGRAM(PRGNAME)
PLAN(PLANNAME)
LIB(LIBRARYNAME)
PARMS(GIVE THE PARAMETERS HERE)


REGARDS,
SATHISH
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Tue Nov 22, 2005 3:00 pm    Post subject: Questions
Reply with quote

hi frnd,
No problem...i too facing the same problem in my shop. i had sent the mail to my frnds. once i get the right code i will post it. b patient. i cant assure u but mean while i will try my level best. Reshma may b in some tension while she post the solution. dont mistake her and dont fix her words in ur heart. Leave it and prepare well. All the best.
Back to top
View user's profile Send private message
suganthyprabha

New User


Joined: 28 Jul 2005
Posts: 58

PostPosted: Tue Nov 22, 2005 4:21 pm    Post subject: Re: Interview questions
Reply with quote

Hi Kamarudeen,

Thanks a lot. I will do the best.

Hi sathish,

Thank u so much for ur reply.

Regards,
Suganthy.
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 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
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


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