1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

Danske,

1 2907

Write a query to extract first 5 characters of a name in the column Stud_Name?

RBS,

1 1915

How to fetch the last row from the table in SQL (db2)?

 1025

What's The Percentage Free Space ?

IBM,

757

What's The Error Code For Unique Index Voilation?

IBM,

643

What is a Foreign Key?

Tavant Technologies, Zensar,

648

what is a corelated subquerry?

IBM,

647

can all users have the privilage to use the sql statement select * (dml)?

IBM,

629

What is the maximum number of columns in a db2 table?

IBM,

709

B37 abend during spufi?

IBM,

972

What is the maximum No of rows per page?

IBM,

618

Which are the db2 tools to protect integrity of the database?

IBM,

680

How to rename a table in DB2 ?

MCN Solutions,

626

Is it possible to create an Instance in DB2 using DB2 Control Center ?

MCN Solutions,

618

What is the difference between dbm cfg and db cfg file in db2 ?

MCN Solutions,

994

Post New DB2 Questions

Un-Answered Questions { DB2 }

Discuss about db2 bind?

659

What do you mean by cursor?

576

Explain how can you do the explain of a dynamic sql statement?

643

What does db2 stand for?

593

What is clone table?

587




How do you stop a db2 database in linux?

558

How to create db2 table in mainframe?

621

What is the picture clause of null indicator variable?

682

How to rename a table in DB2 ?

626

How would the varchar column remarks defined?

623

How to check last update on table in db2?

622

What parameters are used to control the free space in DB2?

635

What is bind and rebind in db2?

640

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1805

What is the clustering index in the db2 database?

574

For More Un-Answered { DB2 } Questions Click Here