mainframe discussion forum - cobol, db2,cics, interview questions, quizs
Interview Questions 1 |  Interview Questions 1 |  Interview Questions 2 |  Interview Questions 3 |  Interview Questions 5 | 
Interview Questions 6 |  Interview Questions 7 |  Interview Questions 8 |  Interview Questions 9 |  Interview Questions 10 | 
Interview Questions 11 |  Interview Questions 12 |  Interview Questions 13 |  Interview Questions 14 |  Interview Questions 15 | 
Interview Questions 16 |  Interview Questions 17 |  Interview Questions 18 |  Interview Questions 19 |  Interview Questions 20 | 
Interview Questions 21 |  Interview Questions 22 | 

DB2 INTERVIEW QUESTIONS - Page 9
Java inteview questions
DB2 SQL Tutorial
Mainframe inteview questions
DB2 Discussion Forum


 

41) How is a typical DB2 batch pgm executed ?

1. Use DSN utility to run a DB2 batch program from native TSO. An example is shown:

DSN SYSTEM(DSP3)

RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB('ED 01T.OBJ.LOADLIB')

END

2. Use IKJEFT01 utility program to run the above DSN command in a JCL.

Assuming that a site’s standard is that pgm name = plan name, what is the easiest way to find out which pgms are affected by change in a table’s structure ?

Query the catalogue tables SYSPLANDEP and SYSPACKDEP.

42) Name some fields from SQLCA.

SQLCODE, SQLERRM, SQLERRD

43) How can you quickly find out the # of rows updated after an update statement?

Check the value stored in SQLERRD(3).

44) What is EXPLAIN? – drona questions

EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ).

45) What do you need to do before you do EXPLAIN?

Make sure that the PLAN_TABLE is created under the AUTHID.

 
DB2 INTERVIEW QUESTIONS - advertisement

Previous Page -  DB2 Interview Questions faqs Next Page - DB2 Interview Questions faqs





Java inteview questions     DB2 SQL Tutorial     Mainframe inteview questions >    Mainframe inteview questions


DB2 DISCUSSION TOPICS IN MAINFRAMEGURUKUL.COM

DB2 query !!
DB2 Certification
db2 703 application developmetn certification
DB2
db2 query
How to know the Primary and Foriegn keys?
Inserting NULL
bulk insert
Call & Execute a COBOL-DB2 from a COBOL program?
Important Links Mainframes
SQL update query - need help urgently please
Reg: DCLGEN copybook compilation
Testing a field in db2.
Using Index
doubt in db2
Locking Heirarcy and Compatibility?
what s the difference between DB2 & ADB2?
Performance tuning..
Various Locking mechanism for cursors and other SQL?
IJKEFT01 or IJKEFT1A
Calling a COBOL DB2 subroutine using non-DB2 program
PERFORMANCE TUNING.
Finding PLAN(or Package)
Updating a Table?
DB2 References
SINGLE ROW
A query in DB2 with "<>".
Query on SQL
How to handle the null indiactor
Reg: CASE usage in DB2
Reg : DB2 700 certification
DB2 table -selective download to a flat file
db2 certification
latest and best DB2 certification
DB2 Questions - answers required.
DB2 catalog tables
Reg:Performance of a DB2 query
S0C6 Abend while Opening a Cursor in a DB2-PLI Proram - Sugg
S0C6 Abend while Opening a Cursor in a DB2-PLI Proram
Reg : DB2 certifications
DSNTIAUL
Deleting large numbers of rows quickly
NULL value
DB2 Certification Guidelines
date -updation
DB2 PERFORMANCE TUNING TIPS
DB2 Certification
how to reteieve the cursor randomly??
Db2 DBA training needed
current date,time
Stored procedure parm limit
chords---help
db2
db2 doubt
FOREIGN KEY
VSAM LDS used in DB2
PACKAGE VS PLAN ?
to overcome -407 error in Db2
ROWID
SQLCA
CURSOR
To update a Comment in Lower case in DB2
What is the diff between declaring a cursor in WSS or PD?
How to display in SYSOUT?
DB2 Cursor
new member
query on sql
how to proceed
which is the best
pls help me abt these questions..
foreign key
CAST function
thanks
DB2 checkpoint-restart doubts
db2 begginer
cursors
cursors
how to resolve abends
CONSTRAINT with ON DELETE CASCADE
DB2 Query
with Hold cursor in a stored procedure
Difference between IBMLOAD and BMCLOAD
How you add column in between a table?
Partition 1 is in Copy Pending
I am beginer in db2 , why r using bind ,plan & packge?
sql query required
DB2 SQL CODE -904 Explainations
how to see VSAM DATASET
Hi, query for table structure?
Array setup
can any one tel something about db2 loading
Get week from date
How to add two coloumns of table inm DB2
Db2 Certificaiton Info needed
DB2 certification
DB2 basic
DB2 COMMIT??
Regarding Host variables
Doubt in cursor
HOME
DB2 Interview Questions  |  COBOL Interview Questions  |  JCL interview questions  |  JCL interview questions  |  vsam Interview Questions  |  cics Interview Questions  
|
DB2 Interview Questions  |  COBOL Interview Questions  |  JCL interview questions  |  JCL interview questions  |  vsam Interview Questions  |  cics Interview Questions 1