Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1200
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 How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm
No new posts Allianz Technology - Mainframe 3+ Yea... sooraj184 Mainframe Jobs 0 Mon Jul 31, 2017 2:17 pm
No new posts Mainframe Opening in Chennai ( 2 to 4... muralikrishnan_new Mainframe Jobs 0 Tue Jul 18, 2017 2:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us