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
 

 

TCS 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: Fri Aug 05, 2005 12:05 pm    Post subject: TCS interview Questions
Reply with quote

Hi Friends,

Herewith i have attached some interview questions asked in TCS. Please give me the answer.



1. What will happen if i give sum fields=(1,4,CH,A)

2. Within the steps, without using physical storage how will you pass data
to subsequent steps?

3. Within 100 steps, I have an abend, But i want to restart.
But i should give the command, which is understood by pgm?
I should not mention this in JCL? What i have to do?


4. What is U3191, U4038 Abends?

5. Explain about HURBA?

6. Can you submit a JCL created by some other user?

7. From when you are not able to use Examine?

8. When there is one DB2 Program calling the another DB2 program.
Howmany plans and packages to be created

9. How will you compile two DB2 programs one calling the other?

10. I have a CICS program using 'A' as the VSAm file.
I create a new 'B' VSAM file and have made entries for the CICS
Program to Access the new VSAM file. What would I need to do if dont want the Old 'A' VSAM file to be accessed. In other words what should be done to disable the OLD VSAM file?

11. Details about Critical Parameter? (VSAM)

12. What is the order of System Library?

13. I am going to move the value 12345 to COMP-3. Write the PIC clause for this? COMP-SYNC?

14. * is not advised to use in DB2? Why?


15. How will you implement the performance tunning technique in COBOL DB2 Program?

16. Without condition checking how will you execute only a particular
proc if i have three procs?

17.What is IEBCOMPRESS ?



Thanks in advance,
Suganthy.
Back to top
View user's profile Send private message

sivamf

New User


Joined: 28 May 2005
Posts: 6

PostPosted: Mon Aug 08, 2005 10:38 am    Post subject: Re: TCS interview Questions
Reply with quote

It looks as though these questions were designed to satisfy the sadistic pleasure of the interviewer than to choose the efficent candidate to the company.
Abundant human resource for low cost has lead to these kind of memory testing interview questions. Instead of testing the needed knowledge and the ability to find productive solution , companies frame questions to filter out the candidates as much as possible.
Interview scene is very hostile in India. The class is lost..!!!
Back to top
View user's profile Send private message
mainframesguru

New User


Joined: 24 Jun 2005
Posts: 36
Location: Hyderabad

PostPosted: Tue Aug 16, 2005 2:19 pm    Post subject:
Reply with quote

Hi

There is no other way, to tackle such type of interviewers,except to
prepare in-depth.

6. Yes it is possible to submit other user's JCL, but the submitted job will
be shown in your spool area.It is like copying other user Jcl and
submitting by you.

7. EXAMINE was used in COBOL-85, but it cannot be used in VS COBOL-II.

8. One plan and Two Packages.Correct me,Not sure.

9.Create a Package for individual programs and then Make a Plan by binding the Packages.

10. Use "CEMT SET FILE(Logical-File Name of A)" to change the physical
file name to B VSAM FILE. or we can use "CEDA" also.

13. We cannot use SYNC with Comp-3, that is especially made for COMP,COMP-1,COMP-2 Usages

14. * will not be used with select, because we know what information we
need, when we are executing that query. i.e To avoid unnecessary
retrieval of columns data(unnecessary columns).

15. There are many factors that help in performance tuning
Few are:
1. Dont use * with select
2. Open and Close the cursor only when needed

Please do post other answers, if you come across them.

Thanks And Regards
Vamshi
ICC-ISH
Chennai
Back to top
View user's profile Send private message
suganthyprabha

New User


Joined: 28 Jul 2005
Posts: 58

PostPosted: Tue Aug 16, 2005 2:52 pm    Post subject: Re: TCS interview Questions
Reply with quote

Hi Vamshi,

Thanks a lot for ur answers.

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

New User


Joined: 09 Jun 2005
Posts: 38

PostPosted: Tue Aug 16, 2005 6:52 pm    Post subject: Re: TCS interview Questions
Reply with quote

suganthyprabha wrote:
Hi Friends,

Herewith i have attached some interview questions asked in TCS. Please give me the answer.



1. What will happen if i give sum fields=(1,4,CH,A)

2. Within the steps, without using physical storage how will you pass data
to subsequent steps?

3. Within 100 steps, I have an abend, But i want to restart.
But i should give the command, which is understood by pgm?
I should not mention this in JCL? What i have to do?


4. What is U3191, U4038 Abends?

5. Explain about HURBA?

6. Can you submit a JCL created by some other user?

7. From when you are not able to use Examine?

8. When there is one DB2 Program calling the another DB2 program.
Howmany plans and packages to be created

9. How will you compile two DB2 programs one calling the other?

10. I have a CICS program using 'A' as the VSAm file.
I create a new 'B' VSAM file and have made entries for the CICS
Program to Access the new VSAM file. What would I need to do if dont want the Old 'A' VSAM file to be accessed. In other words what should be done to disable the OLD VSAM file?

11. Details about Critical Parameter? (VSAM)

12. What is the order of System Library?

13. I am going to move the value 12345 to COMP-3. Write the PIC clause for this? COMP-SYNC?

14. * is not advised to use in DB2? Why?


15. How will you implement the performance tunning technique in COBOL DB2 Program?

16. Without condition checking how will you execute only a particular
proc if i have three procs?

17.What is IEBCOMPRESS ?



Thanks in advance,
Suganthy.




16. condition checking is done through the cond parameter. in this case, the cond should be specified in the exec statement. it should be coded properly. remember that, when the condition is satisified, that particular step will be bypassed.

14. * is not advisible with embeded sql as it may lead with i/o overheads and requires high maintainance on program changes.

10. if you don't require the old VSAM file to be accessed, you should change the FILE/DATASET entry in your cics program. also don't forget to update the loadlib in cics region through the CEMT macro.


corrections are welcomed. do post the answers if you've.......


gowtham
Back to top
View user's profile Send private message
ideas

New User


Joined: 25 May 2005
Posts: 53
Location: India

PostPosted: Mon Aug 22, 2005 5:31 pm    Post subject:
Reply with quote

4-4038 is cics abend due to LE problem..
1- should be fine.
2-using referbacks I guess..
3- requires more depth...
* in Db2 causes overhead so not advised.
15-using SPUFI we can run diff SQL queries and know the tuning...
10-old VSAM can be disabled in CICS, FCT, RDO if reqd..using CEMT/CEDA.
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Mon Aug 22, 2005 6:31 pm    Post subject: Re: TCS interview Questions
Reply with quote

Hi,

1) It will work fine.

2) You can use Temperory dataset or referback

6) If you have authority to submit other JCL than only u can submit the JCL created by other user

17) It is an utility which is used to compress dataset.


Regards
Rupesh
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Mon Aug 22, 2005 6:42 pm    Post subject:
Reply with quote

Quote:

6. Can you submit a JCL created by some other user?



u can submit it provided u change the other user datasets into u r datasets as u cannot wirite into other user datasets or it will result in ACF2 VIOLATION.

LIKE IF THE USER IS TXNR055. DATASET.
THEN CHANGE ALL SUCH DATASETS TO U R USER ID.It is ok to read data from other user's datasets but u cannot write into them.
Back to top
View user's profile Send private message
anandbhushan1

New User


Joined: 12 Sep 2005
Posts: 2

PostPosted: Wed Sep 28, 2005 5:13 pm    Post subject: about HURBA
Reply with quote

WHAT IS HURBA ? why we use it?
Back to top
View user's profile Send private message
anandbhushan1

New User


Joined: 12 Sep 2005
Posts: 2

PostPosted: Wed Sep 28, 2005 5:32 pm    Post subject:
Reply with quote

icon_redface.gif icon_cry.gif icon_cry.gif
Back to top
View user's profile Send private message
mvanandkumar

New User


Joined: 01 Sep 2005
Posts: 11

PostPosted: Wed Oct 12, 2005 7:08 am    Post subject:
Reply with quote

Hi all.

12. What is the order of System Library?

Ans - For batch programs - Steplib, Joblib, SYS1.*, .... * because it depends for Procs it is SYS1.PROCLIB, for pgms SYS1.PGMLIB etc.etc...

For CICS programs it is DFHRPL concatenation libraries....... icon_wink.gif

DFHRPL.....pl read scan this discussion board / manual for more details icon_wink.gif

15. How will you implement the performance tunning technique in COBOL DB2 Program?

Adding to Vamshi's answer....
Run DB2 utility RUNSTATS to get Access Path used to get the DB2 data from the DATABASE.....if you know the DB2 stuff in depth...then you can instruct the DB2 to use the specific index etc..

CA, CI parameters.....
BUFND, BUFNI paramters,
TABLESPACE, index space etc....etc...

If your site is having third party utilities then use them.....
the answer is very long......

experience is the best teacher icon_cool.gif
Back to top
View user's profile Send private message
krk_2k

New User


Joined: 31 Oct 2005
Posts: 1

PostPosted: Mon Oct 31, 2005 5:36 pm    Post subject: Re: TCS interview Questions
Reply with quote

1. What will happen if i give sum fields=(1,4,CH,A)

Ans: The above condition in the JCL will eliminate duplicates by considering only first four chars of the data.

Thanks,
Ram
Back to top
View user's profile Send private message
Ramya A

Active User


Joined: 26 Jul 2004
Posts: 104

PostPosted: Tue Nov 01, 2005 3:26 am    Post subject:
Reply with quote

I guess the first one is a tricky question icon_surprised.gif - the answer should be this :

SUM FIELDS=(1,4,CH,A) would abend with a U0016 error because:

1. The syntax for SUM FIELDS is SUM FIELDS=(start position,length,format,start position,length,....). So a SUM field should not have a A as the fourth parameter (It is applicable for SORT fields to specify if Sorting is ascending or descending).

2. Also, a SUM field does not accept CH format. Only numeric types are allowed in SUM fields.

Correct me if I'm wrong....
Back to top
View user's profile Send private message
Choudary

New User


Joined: 03 Nov 2005
Posts: 2

PostPosted: Fri Nov 04, 2005 8:52 pm    Post subject: Re: TCS interview Questions
Reply with quote

Ramya got it right.

Sum statement doesn't accept CH format .

It should be PD, FI, BI, FL, OR ZD.

It works this way:

SUM
The SUM control statement deletes records with equal control
fields and optionally summarizes specified numeric fields on
those records. If numeric fields are to be summarized, the
data in the summary fields is added, the sum is placed in one
of the records, and the other record is deleted. Provided
arithmetic overflow does not occur, the SUM statement produces
only one record per sort key in the output data set.

The format of the SUM statement is
SUM {FIELDS={NONE} }
SUM {FIELDS=(p1,l1,f1 {,p2,l2,f2) ... ) }
SUM {FIELDS=(p1,l1 {,p2,l2) ... ),FORMAT=f } {,XSUM}

where
NONE means duplicate records will be eliminated.

XSUM means the deleted records are to be written to the data
set defined by the SORTXSUM DD statement.


The answer will be, JOB with this statement will abend with U0016.
The same statement with SORT instead of SUM will work fine(sorts first 4 characters in ascending format).

Regards,
Choudary
Back to top
View user's profile Send private message
monster

New User


Joined: 18 Nov 2005
Posts: 1

PostPosted: Tue Nov 22, 2005 9:53 am    Post subject: Re: about HURBA
Reply with quote

anandbhushan1 wrote:
WHAT IS HURBA ? why we use it?



Hi AnandBhushan,

HURBA is nothing but HIGHLY USED RBA which is related to VSAM
so, it is said that,whenever u delete all contents in a KSDS Vsam file, after that u are using the same VSAM file for other purpose, the IO routne will check this HURBA if it as high value that IO operation will not be taken place. Am I correct... If iam wrong can any body can correct me...???
Back to top
View user's profile Send private message
ajayangrish

New User


Joined: 08 Jun 2006
Posts: 2

PostPosted: Tue Jan 08, 2008 5:22 pm    Post subject: Reply to: TCS interview Questions
Reply with quote

4. U4038 ---> when you dont write stoprun in your program then you will get this error
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Jan 08, 2008 7:18 pm    Post subject: Re: Reply to: TCS interview Questions
Reply with quote

ajayangrish wrote:
4. U4038 ---> when you dont write stoprun in your program then you will get this error

Not always, it can also be due to File attribute mismatch. (LRECL mismatch).
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Wed Jan 09, 2008 4:13 am    Post subject:
Reply with quote

HURBA is an acronym for "high use relative byte address". It points to the last physical record in the file.

By counting the bytes from the 1st byte in the file to the beginning (I think - it may be the last byte) of the last record in the file.
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 The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
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


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