Interview questions for DBA

rajulan · New User Joined: 11 Jan 2008 Posts: 66 Location: India

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.

Ketan Varhade · Posted: Wed Oct 21, 2009 10:11 am

What have you answered for all this ?

ajeshrn · New User Joined: 25 Mar 2009 Posts: 78 Location: India

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.

ajeshrn · New User Joined: 25 Mar 2009 Posts: 78 Location: India

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.

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

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.

guptae · Posted: Wed Oct 21, 2009 3:46 pm

Hi,