TCS Mainframe interview Questions

suganthyprabha · New User Joined: 28 Jul 2005 Posts: 58

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.

sivamf · New User Joined: 28 May 2005 Posts: 6

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..!!!

mainframesguru · New User Joined: 24 Jun 2005 Posts: 36 Location: Hyderabad

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

suganthyprabha · New User Joined: 28 Jul 2005 Posts: 58

Hi Vamshi,

Thanks a lot for ur answers.

Thanks and Regards,
Suganthy.

gowtham_srgp · New User Joined: 09 Jun 2005 Posts: 38

ideas · New User Joined: 25 May 2005 Posts: 52 Location: India

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.

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

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

vijayamadhuri · Active User Joined: 06 Apr 2005 Posts: 180

anandbhushan1 · New User Joined: 12 Sep 2005 Posts: 2

WHAT IS HURBA ? why we use it?

anandbhushan1 · New User Joined: 12 Sep 2005 Posts: 2

mvanandkumar · New User Joined: 01 Sep 2005 Posts: 11

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.......

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

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

krk_2k · New User Joined: 31 Oct 2005 Posts: 1

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

Ramya A · Active User Joined: 26 Jul 2004 Posts: 104

I guess the first one is a tricky question

- 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....

Choudary · New User Joined: 03 Nov 2005 Posts: 2

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

monster · New User Joined: 18 Nov 2005 Posts: 1

ajayangrish · New User Joined: 08 Jun 2006 Posts: 2

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

Anuj Dhawan · Posted: Tue Jan 08, 2008 7:18 pm

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

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.