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,

2153

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 5916

How to insert more than one record using insert?

Atos Origin, IBM,

7 11030

How to update more then one record using update?

IBM,

5 8854

what are extents?

5 13437

what is consistency token

3 17525

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

IBM,

4 8748

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

4 8798

How can you split a table in to exactly half?

HSBC,

7 12892

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

Cap Gemini,

15 16843

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

Amdocs, HeadStrong,

8 12553

What is a view? Why use it?

2 6669

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,

1855

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 8057

what is the Foreign key? explain?

2 6177


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is universal database?

434


What are the uses of db2 optimizer?

623


What is difference between alias and synonym in db2?

426


can we view the access paths created by dbrm ? how ? thx

5871


What is reorg?

451






Mention some fields that are a part of sqlca.

468


Which is faster delete or truncate?

510


B37 abend during spufi?

724


How connect db2 database to datastage?

507


What is the maximum length of sqlca?

640


What is db2 connect?

426


What are the different types of base tables?

437


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

416


How many databases can be created inside an instance in db2 ?

443


What is a db2 package?

430