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