Mainframe DB2 Interview Questions

tamilgirl04 · New User Joined: 10 Sep 2004 Posts: 1

Hello,

I need to prepare for interview for QA testing job. Could you please explain following terms:

DB2,
Mainframe skills (JCL/ISPF)
batch mainframe applications
DB2 - requires use of SPUFI or Oracle SQL

Especially can someone explain me batch mainframe applications,

Thank you for your help,
chinna..

mcmillan · Site Admin Joined: 18 May 2003 Posts: 888 Location: India

DB2 - Data Base 2 (Relational database used in mainframe like oracle)

JCL - Job Control Language (To schedule your programs - priority processing)

ISPF - Interactive System productivity Facility (like an editor)

We are using SPUFI to input SQL queries to DB2.

Batch means, executing your programs one by one. Application you can say Banking environment.

harinadh · New User Joined: 01 Sep 2004 Posts: 16

Hai,

Batch application means there will be no user intervention while the job is running...

Online...means ....The end user has to give some information.

But in batch jobs everthing is through files only.

regards,
hari

vikramkarthick · New User Joined: 06 Oct 2004 Posts: 2

Batch Porc is done when a large quantum of processing is done .. sequentially .. requires more processing power ...
example .. report writing at night when there are minimal no. of users

JCL is the language of Mainframe ...
Any process to mainframe system is initiated thru the JCL code .. which makes use of certain utilities for each functionality

ISPF is the IDE / sort of navigator for mainframe operating system MVS (Multiple Virtual Storage)

VIKRAM

chandrasekhar · New User Joined: 29 Sep 2004 Posts: 35 Location: bangalore

DB2 :: DATABASE 2 OR IBM DATABASE 2

JCL::JOB CONTROL LANGUAGE ::IT IS USED TO SUBMIT YOUR JOB

ISPF::INTERACTIVE SYSTEM PRODICTIVITY FACILITY
IT IS A EDITOR PANEL
BATCH::IT MEANS TO COLLECT THE JOBS AND SUBMIT OR RUN ONE BY ONE
THERE IS NO USERSINTERVENTION LIKE ONLINE