Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

IBM,

1832

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

IBM,

3 5242

How to insert more than one record using insert?

Atos Origin, IBM,

7 9766

How to update more then one record using update?

IBM,

5 7961

what are extents?

5 12393

what is consistency token

3 16160

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

IBM,

4 7962

what is the input to PLAN? what is the input to DBRM?

4 7914

How can you split a table in to exactly half?

HSBC,

7 11609

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

Cap Gemini,

15 14060

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

Amdocs, HeadStrong,

8 11227

What is a view? Why use it?

2 6149

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

TATA,

1593

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

Wipro,

6 6984

what is the Foreign key? explain?

2 5578


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is alias in db2?

154


How to resolve deadlock issue

12700


What is the difference between using bind () and rebind () methods of naming class?

170


What is a bind in db2?

155


What is the use of runstats in db2?

148






What is the physical storage length of the data types: date, time, timestamp in the db2 database?

180


How do I delete a table in database?

151


Where can you declare a cursor in a cobol-db2 program?

190


What is lock escalation in db2?

168


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

1793


What is reorg?

179


How do you simulate the explain of an embedded sql statement in spufi/qmf?

184


What is a collection in db2?

163


How is a typical db2 batch pgm executed?

192


Differentiate between cs and rr isolation levels? Where do you specify them?

186