IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Mainframe DB2 Interview Questions


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
tamilgirl04

New User


Joined: 10 Sep 2004
Posts: 1

PostPosted: Fri Sep 10, 2004 11:48 pm
Reply with quote

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..
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1210
Location: India

PostPosted: Sat Sep 11, 2004 8:57 am
Reply with quote

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.
Back to top
View user's profile Send private message
harinadh

New User


Joined: 01 Sep 2004
Posts: 18

PostPosted: Thu Sep 30, 2004 12:12 pm
Reply with quote

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
Back to top
View user's profile Send private message
vikramkarthick

New User


Joined: 06 Oct 2004
Posts: 2

PostPosted: Wed Oct 06, 2004 11:30 am
Reply with quote

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
Back to top
View user's profile Send private message
chandrasekhar

New User


Joined: 29 Sep 2004
Posts: 35
Location: bangalore

PostPosted: Wed Oct 06, 2004 8:16 pm
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts Mainframe Programmer with CICS Skill... Mainframe Jobs 0
No new posts How to Reformat a file using File Man... All Other Mainframe Topics 14
No new posts NDM getting stuck - mainframe/JCL All Other Mainframe Topics 13
Search our Forums:

Back to Top