MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Interview Questions -3

 
Post new topic   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    MVSFORUMS.com Forum Index -> Interview Q & A
View previous topic :: View next topic  
Author Message
venkat
Guest






PostPosted: Mon Oct 25, 2004 11:47 pm    Post subject: Interview Questions -3 Reply with quote

Hi Kolusu,
I need answers for these questions since i have specifically mentioned Interview Questions.Thanks in advance for Your Help.

Venkat
Back to top
venkat
Guest






PostPosted: Mon Oct 25, 2004 11:57 pm    Post subject: Reply with quote

I am posting the questions below.

1) How is DB2 Data finally stored
2)What are the various commands available in Expediter.Explain in detail
3)There are two programs.Main Program is a cobol program.sub-program is a DB2 Program.what are the various steps involved in executing a pgm
4)how will you run a package in SQL.
5)How will you ensure that the functional spec is in sync with the end product.
6)How many queries we can run in QMF.
7)What is the Row function in db2?
8)What is the value of the LRECL when it is having a varying length record.
9)How will you pass parameters to cobol program from jcl other than sysin dd* and parm?
10)how is telon code generated.
11)can we read a file in cobol backwards
12)what is performance monitoring in DB2?
13)In DCB in jcl what is the blksize normally given.Is the blksize 10 times the LRECL.If i give LRECL as 80 can i give blksize as 80.Is it possible.
14)why we are using Parm length in the linkage section.what is the reason?
15)A cobol program is running successfully.i should get a return code of 100.what should i do for this?
16)What is the value of the file status clause allowed other than zero if it is successful?
17)How will you code restart Logic in a Program?
Back to top
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Tue Oct 26, 2004 5:38 am    Post subject: Reply with quote

Quote:

1) How is DB2 Data finally stored


Answer: In VSAM Linear Datasets
Quote:

2)What are the various commands available in Expediter.Explain in detail


Answer : Primary Commands:
AA SNAP - Displays the Abend-AID Snapshot report.
ACCEPT - For COBOL, assigns a value to a data item.
AFTER -Sets a breakpoint after the execution of an instruction.
Valid locations could be: statement-number, paragraph-name, program-name,
label-name, procedure-name, module-name, address, address-expression, CSECT
name, +/- offset, ALL STATE, ALL PARA, ALL PROG, ALL PROC, ALL LABELS, ALL
FUNC, a list separated by spaces or commas, or a range using the keyword THRU.
ALLOCATE - Dynamically accesses the file allocation utility (FAU) from the debugging session, or allocates an existing file allocation list contained in the named dataset.
AT - Sets a breakpoint in a program without source.
Valid locations could be: CSECT name, module-name, address, addressexpression,
or +/- offset.
BEFORE - Sets a breakpoint before the execution of an instruction.
Valid locations could be: statement-number, paragraph-name, program-name,
label-name, procedure-name, module-name, address, address-expression, CSECT
name, +/- offset, ALL STATE, ALL PARA, ALL PROG, ALL PROC, ALL LABELS, ALL
FUNC, a list separated by spaces or commas, or a range using the keyword THRU.
BOTTOM - Scrolls to the bottom of the currently displayed data.
BROWSE - Displays files or datasets.
CCHILITE - provides visual cues with annotation and a high-intensity background
to indicate which lines have or have not been executed.
COVER - Used in the input command stream (XPIN DD) to activate Code Coverage for a Current test. It also denotes a
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
venkat
Guest






PostPosted: Tue Oct 26, 2004 6:27 am    Post subject: Interview Questions-3 Reply with quote

Hi Kolusu,
Thanks for Your answers.still one more question is remaining.


why we are using Parm length in the linkage section.what is the reason?

Hi Kolusu,
I am posting some more questions. Thanks in advance for Your Help.


1) what are the various options in File-Aid
2)How will You split one Input file into two output files
3)Difference between Plan & Package
4)How is the Boundary layer defined
5)There are 50,000 Lines in a Program.10,000 lines has to be added.what estimation model has to be followed.
6)what are the different types of Life-cycle model?
7)what is a steplib in a db2-cobol program.
8)In expediter how will you keep the 9 variables at a time without pressing F7 OR F8.
9)what is DDIO?
10)How will you execute the subprogram from a xpeditor.
11)How do we call the dataset as cataloged.explain the reason.
12)In singleton select what is the reason for SQLCODE -811.Is it due to duplicates or due to more than one record.
13)what is the use of the USE verb in cobol
14)what are the various functions in cobol


Once again Thanks

Venkat
Back to top
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Tue Oct 26, 2004 10:32 am    Post subject: Reply with quote

Venkat,

I expect you to follow the following Rules.


    1. Stop posting dozens of questions as a single topic.
    2. Do not post the questions which are already answered
    3. Please refer the manuals which will answer most of your questions
    4. Please search before posting your questions
    5. Do not rely on this helpboard to provide you with all the interview questions.


You will no longer receive any answers to your interview questions unless you follow ALL the rules mentioned above.

well you might as well check this legendary topic by MCMILLAN for more interview questions

http://www.mvsforums.com/helpboards/viewtopic.php?t=584&highlight=mcmillan


The answers to your last set of questions.

Quote:

Thanks for Your answers.still one more question is remaining.
why we are using Parm length in the linkage section.what is the reason?


The parm-length is provided to you by the system when running in batch. It represents the length of the parm that was passed to you. You can use that to perform error handling when the parm-length is less than the actual data being passed.

Quote:

1) what are the various options in File-Aid


Answer: Check this link which explains in detail about Fileaid

http://www.geocities.com/srcsinc/FILEAID.html

Quote:

2)How will You split one Input file into two output files


Answer: This question was answered in your previous interview questions . why do you keep asking the same question over and over again ?

Quote:

3)Difference between Plan & Package


Answer: What is a plan?

A plan is an executable module containing the access path logic produced by the DB2 optimizer. It can be composed of one or more DBRMs and packages. Before a DB2 for z/OS program (with static SQL) can be run, it must have a plan associated with it.

Plans are created by the BIND command. The plan is stored in the DB2 directory and accessed when its program is run. Information about the plan is stored in the DB2 catalog.

What is a package?

A package is a single, bound DBRM with optimized access paths. By using packages, the table access logic is "packaged" at a lower level of granularity than a plan -- at the package (or program) level.

To execute a package, you first must include it in the package list of a plan. Packages are not directly executed, they are only indirectly executed when the plan in which they are contained executes -- as discussed previously, UDFs and triggers are exceptions to this rule. A plan can consist of one or more DBRMs, one or more packages or, a combination of packages and DBRMs.

What is program preparation?

A DB2 application program must go through a process known as program preparation before it can run successfully. Program preparation requires a series of code preprocessors that when enacted in the proper sequence, create an executable load module and a DB2 application plan. The combination of the executable load module and the application plan is required before any DB2 program can be run, whether batch or online. CICS programs require an additional preprocessing step.

The first step is precompilation. DB2 programs must be parsed and modified before normal compilation. The DB2 precompiler performs this task. At a high level, the precompiler basically searches for SQL, strips it out of the program and puts it into a DBRM. The output of precompilation is a DBRM with SQL and a modified source program.

The DBRM is bound using the BIND command, which is a type of compiler for SQL statements. In general, BIND reads SQL statements from DBRMs and produces a mechanism to access data as directed by the SQL statements being bound.

The modified source is compiled using the language compiler of your choice. The compiled source then is link-edited to an executable load module. The appropriate DB2 host language interface module also must be included by the link edit step. This interface module is based on the environment (TSO, CICS, or IMS/TM) in which the program will execute.

At the end of this series of steps, if all goes well, you will have an executable DB2 program.


Quote:

4)How is the Boundary layer defined


Answer : No Idea as to what the question is

Quote:

5)There are 50,000 Lines in a Program.10,000 lines has to be added.what estimation model has to be followed.


Answer: Never code your pgm with line count barrier. All you need to make sure is that your pgm flow is following top-down programming approach.

Quote:

6)what are the different types of Life-cycle model?


Answer: You need to search before posting. This has been covered earlier. check this links

http://www.mvsforums.com/helpboards/viewtopic.php?t=2748&highlight=life

Quote:

7)what is a steplib in a db2-cobol program.


Answer: YOu don't need a steplib for cobol-db2 program unless you are not specifying the loadlib in your SYSTSIN dataset

Quote:

8)In expediter how will you keep the 9 variables at a time without pressing F7 OR F8.


Answer : use the SET command

Code:

SET KEEP MAX 9


Quote:

9)what is DDIO?


ANSWER: DDIO file is a generic name for an XPEDITER source listing file.A DDIO file is required by XPEDITER during compile time to store source listings containing the information necessary for XPEDITER/TSO to reference various elements of your program during testing.

Quote:

10)How will you execute the subprogram from a xpeditor.


Answer: You need to search before posting. This has been covered earlier. check these links

http://www.mvsforums.com/helpboards/viewtopic.php?t=575&highlight=source

http://www.mvsforums.com/helpboards/viewtopic.php?t=2993

Quote:

11)How do we call the dataset as cataloged.explain the reason.


Answer: Check this link which explains in detail about DISP parameter in JCL

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IEA2B631/12.19?DT=20030423085347

Quote:

12)In singleton select what is the reason for SQLCODE -811.Is it due to duplicates or due to more than one record.


Answer: Check this link which explains in detail about -811 SQL CODE

Quote:

13)what is the use of the USE verb in cobol


Answer: Check this link which explains in detail about USE statement

Quote:

14)what are the various functions in cobol


Answer: Check this link which explains in detail about Intrinsic functions in COBOL

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
venkat
Guest






PostPosted: Tue Oct 26, 2004 11:58 pm    Post subject: Interview Questions-3 Reply with quote

Hi Kolusu,
Good Morning.The answer to this question previously asked was given like this.thats why i asked you again.They didn't give the site also.Hope You understood my Problem.

1)How will you split one Input file into two output files?
There are lot many examples in this site. Just give a search


Thanks & Regards

Venkat
Back to top
venkat
Guest






PostPosted: Wed Oct 27, 2004 12:08 am    Post subject: Interview Questions-3 Reply with quote

Hi Kolusu,
Good Morning.For some of the Questions Which were asked Previously I got the answers like this.Thats why I am asking you again.

1)How will you split one Input file into two output files?
There are lot many examples in this site. Just give a search



4)what is the maximum value that a subscript can use?


Look Compiler standards. Again give a search. Quote:

6)How will You change the column name in a table.explain the steps.


It its a COBOL table, then just open the program in edit mode change it and compile it back.
If its DB2, thru Alter. Mostly DML, DDL and DCL statements remain same in any Database DB2, Oracle, Sybase SQLServer etc...

i think with alter command we can add a column.I think with alter command we can't change the column name.i want to know how can we change the column name in a table.
Quote:

7)what are the do's and dont's of DB2?
8)What is performance monitoring in DB2?


Look for DB2 documentation links provided in the homepage. You need to read a lot Quote:

9)How will you pass parameters from JCL to a cobol program other than parm statement & sysin dd*?


As far as I know what you have indicated is actually what it is. But if you want you can get them either thru a file or read from DataBase. You can call it as passing parameters, but actually its not.

I didn't get a clear and specific answer for this question


Thanks & Regards

Venkat
Back to top
Cogito-Ergo-Sum
Advanced


Joined: 15 Dec 2002
Posts: 637
Topics: 43
Location: Bengaluru, INDIA

PostPosted: Wed Oct 27, 2004 1:53 am    Post subject: Reply with quote

Agreed, that you did not get "a clear and specific answer" to your question(s). But, did you atleast try the suggestions (search, look up manuals, etc)?
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Wed Oct 27, 2004 5:40 am    Post subject: Reply with quote

venkat,

*sigh* ! You just lost your privileges to post on this board.

Thanks

kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    MVSFORUMS.com Forum Index -> Interview Q & A All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group