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.
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.
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.
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.