DB2 Interview Questions
Questions Answers Views Company eMail

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 3600

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

IBM, TRD,

2 6450

how to resolve -811

IBM,

2 4804

how to resolve -805. give clear explination for that

IBM,

2 5428

how to fetch first 100 rows in db2

IBM,

2 11957

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

IBM,

3 7000

how to resolve -811 sqlcode .give clear explaination

IBM,

3 11291

how to resolve -811 error. give clear explination

IBM,

4 7457

how to resolve -805 . how to see dbrm and package not found

IBM,

2 8705

when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

IBM,

5 10294

how to resolve -818 error. how to see timestamp token in load module and plan

IBM,

4 9395

What is PRIME TABLE and what are the uses of it

1 3436

What is Reorg Recovery? when will you run it?

2 4357

What is image copy?

Virtusa,

1 4935

What is reorg in DB2

Virtusa,

3 27458


Post New DB2 Questions

Un-Answered Questions { DB2 }

How can you count the number of rows from a table tab?

627


Which component is used to execute the sql statements?

609


What is alias in db2?

560


What is netezza database?

561


When do you specify the isolation level?

602






How do you concatenate the firstname and lastname from emp table to give a complete name?

594


Define buffer pool.

616


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

620


How to execute stored procedure in db2 command editor?

524


What is db2 bind process?

745


What is a bind in db2?

586


What is ibm db2 client?

512


What is a buffer in memory?

587


When reorg is used?

663


What is sqlca?

607