IBM MainFrame Interview Questions
Questions Answers Views Company eMail

How do you filter out the rows retrieved from a Db2 table ?

1 8365

What is a clustered index?

1 11331

When will you chose to run RUNSTATS?

1 8405

What does DML stand for and what are some examples of it?

IBM,

3 8005

What is meant by a unit of recovery?

1 5368

What is CHECK PENDING ?

5 17656

What is a thread?

3 6446

What is filter factor?

2 9454

What's the maximum number of volumes that can be added to a STOGROUP?

IBM,

1 8147

What are PACKAGES ?

3 7742

Which catalog tables contain authorization information?

1 5263

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 8306

How does one remove entries from the SCT02 table?

1 3847

what is the difference between join and union?

IBM,

4 16991

I use CS and update a page. Will the lock be released after I am done with that page?

2 8599


Un-Answered Questions { IBM MainFrame }

What are some of the cics commands associated with interval control?

571


What is the max length of sqlca?

752


Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?

708


What are the types of processes to create a map in cics?

570


What is the default page size of buffer pools?

637






How to define a vsam file in cics getting into cics to define a vsam file.

591


what are the differences between temporary storage queue (tsq) and transient data quene (tdq)?

665


in order to execute step2 a job after a return code of 8 in step1, what condition you will code in step2?

2038


What do you mean by commit and rollback?

583


What is check constraint in db2?

592


What do you understand by jcl?

614


Sync points cannot be requested by the application programs? State true or false

662


If a ceo wants to see all employees of the company from an online screen. How will be the design of the map from the developer point of view?

573


Explain how do you access storage outside your cics program?

500


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

733