IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is release/acquire in bind?

641

Mention some fields that are a part of sqlca.

590

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

615

Explain the contents that are a part of dclgen.

649

Comment whether the cursor is closed during commit or not.

660

Define predicate?

634

Explain about cursor stability?

612

List out the buffer pools in db2

616

What is a storage group (stogroup)?

767

Explain dclgen.

713

What is sqlca’s maximum length?

662

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

630

Define declaration generator (dclgen).

658

Define data page.

623

Mention the different locking levels that are available in db2.

633


Un-Answered Questions { IBM MainFrame }

In a particular cics program, what is the procedure to allocate dynamic memory?

718


What does a cics translator do?

877


Define buffer pool.

616


What is the advantage of dynamic generation of acb?

555


In job processing, what happens in conversion stage?

725






How are type 1 and type 2 indexes different?

567


For what purpose steplib and joblib are used ?

678


What are catalog tables in db2?

600


When output dataset space is required, what quantity categories are used?

813


What is a db2 schema?

755


State the uses of syspring, sysin, sort fields, sum fields and dummy.

637


Are scope terminators compulsory? If they are, when?

482


explain in brief how you can create a vsam file?

649


What is the cics command level?

549


Explain the function of entry-sequenced data set?

528