Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Mainframe DB2 Interview Questions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Mainframe DB2 Interview Questions
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: 1202
Location: India

PostPosted: Sat Sep 11, 2004 8:57 am    Post subject: Re
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    Post subject: hai
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    Post subject: Batch Processing
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
No new posts Interface from Mainframe to Confluenc... hblun CLIST & REXX 4 Tue Sep 20, 2016 5:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us