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
 

 

DB2 Questions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
mittalrishi
Currently Banned

New User


Joined: 19 Dec 2005
Posts: 12

PostPosted: Mon Jan 16, 2006 11:15 pm    Post subject: DB2 Questions
Reply with quote

hi frndz.

Plz can someone plese help me in giving the answers for the following
DB2 questions given below:


1) What is SSRANGE and NOSSRANGE ?
2) What is the difference between performing a SECTION and a PARAGRAPH?
3) What is Static,Dynamic linking ?
4) Why do we create a Unique index when we create a table with Primary key?
5) Where do we use this unique index in DB2.
6) What is the output of MAX on a CHAR column.
7) Is DECLARE CURSOR Executable, if NO, then why it is used inside EXEC SQL & END-EXEC
8) What does SQLERRM specify ?
9) What is the function of RUNSTATS IN DB2?
10)What is the function of REORG IN DB2?
11)When do we use //CNTL statement , plz give a simple JCL eg. For it

Thank you.

Rishikesh Mittal
Back to top
View user's profile Send private message

senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Wed Jan 18, 2006 12:47 pm    Post subject:
Reply with quote

Quote:
4) Why do we create a Unique index when we create a table with Primary key?


If you defined a primary for a table , you must create the unique index for the table the n only db2 allow you insert the values to the table .

suppose , if u not define unique inde x on table , you will get the error message '' declaration of table in not complete . lack in primary index" when you are trying to insert .


Quote:

Where do we use this unique index in DB2.


Actually unique index used on table in which columns which are defined for index is supposed to be unique .

it is mainly used for avoiding tablescan when you are retrieving the rows and others operations . performance is improved when you are having unique index on table .


Quote:
6) What is the output of MAX on a CHAR column


mac(char_column ) gives the highest value in terms of alpha numerical

Let us consider the values columns are

column1

aaaa
bbb
z
ddd
ee

max(column1) returns the e value z


[quote]9) What is the function of RUNSTATS IN DB2? [quote]

Runstats is the one of the Db2 utility which is used to collect the update and catalog statistics . normally we run the runstats after the large inserts and deletes on the data base objects


Quote:
10)What is the function of REORG IN DB2?


REORG is used to reclaim the space in db2 .


Quote:
When do we use //CNTL statement , plz give a simple JCL eg. For it


normally all jcl staements start with // .

eg:
//*TEST001 JOB(TRG,TRG,SSGSEN,D2,DT99X),NOTIFY=&SYSUID
//* CLASS=A,PRTY=6,MSGCLASS=(1,1)
//STEP01 EXEC PGM=IEFBR14
//FILE1 DD DSN=SSGSEN.DEMO.SS4
// DISP=(NEW,CATLG,DELETE),
// UNIT=DISK,VOL=SER=TRG001,
// SPACE=(CYL,(10,10),RLSE),
// DCB=(RECFM=FB,LRECL=500,BLKSIZE=2000)
//
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Wed Jan 18, 2006 3:27 pm    Post subject: Re: DB2 Questions
Reply with quote

HI,

Quote:
2) What is the difference between performing a SECTION and a PARAGRAPH?


Perform Paragraph:- will perform only That Para.

Perform Section:- Section is collection of Para. Perform Section will perform all para inside that Section.

Hope this helps

Regards
Rupesh
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am
No new posts File Aid DB2 Questions niks_jude Mainframe Interview Questions 1 Mon Aug 24, 2015 5:13 pm


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