IBM MainFrame Interview Questions
Questions Answers Views Company eMail

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

86

Discuss about db2 bind?

71

List out the data types available.

81




Define sqlca.

57

Explain packages.

57

Mention the definition of cobol in varchar field.

75

Explain the function done by data manager?

71

Define buffer pool.

65

Outputs of explain are with matchcols = 0. What does this signify?

69

Explain in detail about buffer manager and its functionalities?

68

Mention the various locks that are available in db2.

74

Explain about dbrm.

57

Can I redefine an x(200) field with a field of x(100) ?

60

What is comp-1?

59

How many bytes will a s9(8) comp field occupy ?

60







Un-Answered Questions { IBM MainFrame }

How do you stop a db2 database in linux?

17


When reorg is used?

60


What information does a dbd contain?

41


What is the Purpose of Pointer in the string?

65


what is the use of IEBGENER utility?

70






How to Save a Query?

622


What is db2 purescale?

22


When are scope terminators compulsory?

72


what is the role of the is numeric clause?

59


i want new rexx tool which will perform jcl chk without submitting it

927


What is meant by deadlock in db2?

41


What is plan in cobol db2?

19


What are the different rules for performing sort operation?

68


Why do we bind in db2?

15


Db2 what is the difference between a package and a plan. How does one bind 2 versions of a cics transaction with the same module name in two different cicsregions that share the same db2 subsystem?

41