Global variable for Archiving SYSIBMADM.MOVE_TO_ARCHIVE question

Joseph Roop

Global variable for Archiving SYSIBMADM.MOVE_TO_ARCHIVE question

I am trying to do a REORG DISCARD and expect the discarded data to go to the related Archive table.

Not happening because the global variable  SYSIBMADM.MOVE_TO_ARCHIVE flips back to 'N' for some reason.

I am setting the variable to 'E' in a previous step using DSNTEP2

Joe Roop

Scott Walker

RE: Global variable for Archiving SYSIBMADM.MOVE_TO_ARCHIVE question
(in response to Joseph Roop)

My guess is the variable is being reset after the step ends. I don’t see where it’s listed in reorg syntax. So, that leads me to believe it isn’t an option.


You could do this:

a) Reorg and discard to dataset (GDG might be good option). 
b) Then load resume. 

Take image copy or quiesce point for recovery purposes before and after as needed to remain comfortable at least for a bit until it’s tested. 

 

Keep me updated. I’m very interested in your findings. 

Joseph Roop

RE: Global variable for Archiving SYSIBMADM.MOVE_TO_ARCHIVE question
(in response to Scott Walker)

This red book (Page99)  seems to say that Archiving works with REORG DISCARD. But it is not very clear. Also not seeing anything in the manuals

http://www.redbooks.ibm.com/redbooks/pdfs/sg248316.pdf

Joe Roop

Joseph Roop

RE: Global variable for Archiving SYSIBMADM.MOVE_TO_ARCHIVE question
(in response to Joseph Roop)

Another interesting finding. An APAR where DB2 was unintentionally moving rows anyways. But they made code change to switch it off. So I guess UTILITY does not move rows. 
https://www.ibm.com/support/pages/apar/PH00459

Joe Roop

Haakon Roberts

RE: Global variable for Archiving SYSIBMADM.MOVE_TO_ARCHIVE question
(in response to Joseph Roop)

Joe,

Just to confirm, REORG DISCARD will not place discarded rows in the archive table. If you want this capability then I suggest you open a requirement through Aha.

Regards.

Joseph Roop

RE: Global variable for Archiving SYSIBMADM.MOVE_TO_ARCHIVE question
(in response to Haakon Roberts)

Thanks Haakon for confirming.
 For now we are planning to use deletes in small chunks to move data. I will consult with my team to see if  we can send in a request.

 

Joe Roop