alt
Advertisement
Online Training
Career Series
Exforsys
Exforsys arrow Career Series arrow Interview Notes arrow Live DB2 Interview Questions
Site Search


Live DB2 Interview Questions

Please find the questions in DB2, actually i want answers for few queries in mainframes that is (DB2,CICS,JCL,VSAM).i am sending u the queries in the below ,please let me know if i can get solutions to these queries. These are the interview questions which were asked to me in some companies recently. Thanks, Sarala Devi

Latest Questions
1.  Can you display the index?
2.   At what stage db2 must be up?
3.   When do you use subroutines?
4.   Initial position of cursor of the exucuton of open statements?
5.   What is the index ,types of index ?
6.   How many clustering indexes are pasing for a table?
7.   When u will use curser with hold option?
8.   File opening modes in cobol and corresponding dispositions?
9.   What will happened .if the file is open in extend mode and corresponding is equal to old in jcl?
10.   How to know other person job status?
11.   What will happened ,if the subprogram is called second time?
12.   Can u see s9(4)comp3 data?
13.   Commenly facing errors?
14.   What is low values and high values?
15.   How to enter in xpediter?
16.   A dataset contains 1000 records ,I want to brouse particular record in file-id?
17.   There are two programs say A&B,A is only cobol program,B iscobol-db2 program, how to compile both programs?
18.   How to pass return codes from Cobol to jcl?
19.   In my jcl ,the 1st step is delete step, if the data set is existing, I want to delete, that one ,if dataset is no existing, I do not want abend the job, how can I code in disp?
20.   What is diff b/w check pending and copy pending?
21.   How to Repair the table?
22.   How to see the status of the table?
23.   How to load data to a table?
24.   What is diff b/w QMF & Spoofi?
25.   I have update Row in table using spoofi.how Revert that update Row it means original position?
26.   Quick Respendse and REspondce time in file-aid?
27.   File contains 5 records say D,E,F,C,A-I want to copy D and A records only by using file-aid?
28.   What is severity one error in production support?
29.   How to increase table space in db2?
30.   What is the indexset and sequence set in vsam ksds?
31.   How to read last record in vsam file.,I don't know how many records are there?
32.   I have 1000 records in vsam,I want to read records 500 to 900
33.   Explain Reuse and upgrade
34.   How do you read vsam file?
35.   How can we over come the same situation when using flat file.
36.   what r the compiler options we use?where the compiler option will be?What is the need of compiler options?
37.   Suppose there is cobol-db2 program.I made changes only in the cobol program.Is there need recomile the DBRM again?why?
38.   After bind i how can we run a cobol-db2 program?
39.   By using any condition is there any way to abend a program.?If so how?
40.   What is the diff bet plan,package,dbrm?
41.   After retrieving the elements from production,how can do the testing before moving the changes to production. Whether we have to create the JCL for testing or it will automatically tested and compiled?
42.   What is a packed decimal..?

Tags

See All Tags

Trackback(0)
Comments (0)add comment

Write comment

busy
 
< Prev   Next >
[ Back ]
Exforsys Offers
© 2008 Exforsys.com
Joomla! is Free Software released under the GNU/GPL License.
 Page copy protected against web site content infringement by Copyscape