OnDemand Users Group

Support Forums => CMOD for z/OS Server => Topic started by: plb3945 on June 18, 2012, 09:33:11 AM

Title: Information about deleting application group
Post by: plb3945 on June 18, 2012, 09:33:11 AM
Hi,
I have to delete an application group which contents 500 millions of files. If i force the delete  of application group (without to unload each loadid) is it DB2 and OAM K7 files will be delete automatically?
If not, do you know a practical way to do this? without to reduce the number of the day in "the live of data and indexes" for each arsmaint.
Thanks for your cooperation
Best regards
Philippe
Title: Re: Information about deleting application group
Post by: Alessandro Perucchi on June 18, 2012, 08:25:54 PM
Hello Philippe,

I don't know for z/OS and OAM, but normally yes, it should remove everything -> DB2 segment tables and each objects.

Sincerely yours,
Alessandro
Title: Re: Information about deleting application group
Post by: Ed_Arnold on June 22, 2012, 01:37:06 PM
Philippe - yours was an excellent question so we ran a test on one of our systems.

The first set of these jobs is for 8.4.1.  The second set is for 8.5.0:

1.  ARSL841  JOB09607 ODV793      1 P
2.  ARSL841  JOB09611 ODV793      1 P
3.  OSREQL   JOB09613 ODV793      1 P
4.  OSREQL   JOB09614 ODV793      1 P

5.  ARSL85X  JOB09615 ODV793      1 P
6.  ARSL85X  JOB09617 ODV793      1 P
7.  OSREQL   JOB09619 ODV793      1 P
8.  OSREQL   JOB09620 ODV793      1 P

1 ) First ARSL841 job loads 3 objects to OAM, resource object R2, Doc object 1FAAA and index object 1FAA1

2 ) 2nd  ARSL841 job loads 2 new objects to OAM, resource object R2 (reloaded) , Doc object 2FAAA and index object 2FAA1

3 ) First OSREQL does a query and retrieve against all 5 OAM objects.

Then we used the admin client to delete the app group (system log shows 1 object deleted)

4 ) Next OSREQL shows *only* the resource object deleted.  <<<<!!!



Now to retry with 8.5.0

5)  First ARSL85X job loads 3 objects to OAM, resource object R2, Doc object 1FAAA and index object 1FAA1

6 ) 2ndt ARSL85X job loads 2 new objects to OAM, resource object R2 (reloaded) , Doc object 2FAAA and index object 2FAA1

7 ) First OSREQL does a query and retrieve against all 5 OAM objects.

Then we used the admin client to delete the app group (system log shows 5 objects deleted)

8 ) Next OSREQL shows ALL 5 objects have been deleted.     


Conclusion:  As of 8.5.0 all objects will be deleted.   Not in 8.4.1.