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
 

 

Interview questions for DBA

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

New User


Joined: 11 Jan 2008
Posts: 66
Location: India

PostPosted: Tue Oct 20, 2009 8:46 pm    Post subject: Interview questions for DBA
Reply with quote

Hi All,

I faced the below interview questions. Can anyone answer for this?

1.Table has 1M record. Every month it will get 4LK record. For that table space, how do you calculate PRIQTY & SECQTY?

2. You are facing resource unavailable issue(-904). But the object is in RW status. What you will do?

3. In load, if you give Load Replace with Sharelevel change, what thing needs to be considered?

4. Without using unload utility, how do you unload data from the table?


Thanks,
Raj.
Back to top
View user's profile Send private message

Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Wed Oct 21, 2009 10:11 am    Post subject:
Reply with quote

What have you answered for all this ?
Back to top
View user's profile Send private message
ajeshrn

New User


Joined: 25 Mar 2009
Posts: 78
Location: India

PostPosted: Wed Oct 21, 2009 12:27 pm    Post subject: Question 2
Reply with quote

Hi rajulan,

I have faced the scenario in qn 2 .I will explain, might be will be useful for you.

I was working on a COBOL-DB2 stored procedure and when I executed the same through front end, I got -904.When I checked, I could understand that one of my tables had the same problem.I did a display on the status of the table and found that its in RW status, but later I could understand that issue was coming because the index of the table was stopped somehow. I had to manually start the index on the table forcefully to resolve the issue.
Back to top
View user's profile Send private message
ajeshrn

New User


Joined: 25 Mar 2009
Posts: 78
Location: India

PostPosted: Wed Oct 21, 2009 12:31 pm    Post subject: Question 4
Reply with quote

Hi rajulan,

Question 4, I have unloaded the data from the table through Db2-File Aid.We need to specify two dataset one for control card and another for data, in the file aid option.This will get the down load of the same in the datasets.

Am not sure whether this is the reply which they were expecting.In case you have any other method,please let us know.
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Wed Oct 21, 2009 3:38 pm    Post subject:
Reply with quote

Hi

for Q3:
You can't use LOAD Replcae with SHRLEVEL Change, you can't use the following options when you do a Load Replace:

you cannot specify the following LOAD parameters: INCURSOR, RESUME NO, REPLACE, KEEPDICTIONARY, LOG NO, ENFORCE NO, STATISTICS, COPYDDN, RECOVERYDDN, MAPDDN, PREFORMAT, REUSE, or PART integer REPLACE

and for Q4:
You can get the data to a dataset using a SQL with DSNTEP2, the program would be IKJEFT01 and data will be copied in SYSREC dataset, load control card will be in SYSPUNCH dataset.

for Q1:
You have to ask for more data, like the record length, once they specify a recordlengt. The PRIQTY should be something like (recordlength*1M)bytes + 25% the extra 25% value is taking in to consideration the spcae for free page, free space parameter. SECQTY should be some thing like 4Lac*reclength + 20% and then you should also say considering the requirement here you have to schedule a job that will perform a Alter tablespace monthly and increase the PRIQTY to accomidate more data and make sure that the number of secondary extents will not be beyond 10, you should also have a REORG job after the alteration of tablespace. If you need the exact formula for caliculation of PRIQTY and SECQTY you can refer IBM SQL Reference.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Oct 21, 2009 3:46 pm    Post subject:
Reply with quote

Hi,

Code:
2. You are facing resource unavailable issue(-904). But the object is in RW status. What you will do?


I have faced this scenerio many timesbecause of migrated tablespace or indexspace datasets.
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 The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
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


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