Does unload utility support SYSIBMADM.GET_ARCHIVE?

Eugene Zeev

Does unload utility support SYSIBMADM.GET_ARCHIVE?

Hi community members.
Does unload utility support global system variable SYSIBMADM.GET_ARCHIVE?

 

Lizette Koehler

Does unload utility support SYSIBMADM.GET_ARCHIVE?
(in response to Eugene Zeev)
What version of DB2?



Lizette





From: Eugene Zeev [mailto:[login to unmask email]
Sent: Tuesday, January 02, 2018 7:16 AM
To: [login to unmask email]
Subject: [DB2-L] - Does unload utility support SYSIBMADM.GET_ARCHIVE?



Hi community members.
Does unload utility support global system variable SYSIBMADM.GET_ARCHIVE?





-----End Original Message-----

Jørn Thyssen

RE: Does unload utility support SYSIBMADM.GET_ARCHIVE?
(in response to Eugene Zeev)

Hi Eugene,

What is the business problem you are trying to solve? 

Why not unload the main table first (DISP=SHR) and then the archive table to the same dataset (DISP=MOD) ?

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Eugene Zeev

RE: Does unload utility support SYSIBMADM.GET_ARCHIVE?
(in response to Lizette Koehler)

 

Hi Lizette,

 Now we use DB2 V11 and we are planning to upgrade to V12.

Best regards

 

 

Eugene Zeev

RE: Does unload utility support SYSIBMADM.GET_ARCHIVE?
(in response to Jørn Thyssen)

Hi Jorn,
My problem is: could a DB2 tables be converted to Transparent Archiving without modifying existed Unload batch steps, in the similar way as it is transparent for application programs.
Best regards

Jørn Thyssen

RE: Does unload utility support SYSIBMADM.GET_ARCHIVE?
(in response to Eugene Zeev)

Hi Eugene,

If you have a table with 1,000,000 rows, and you want to start using transparent archiving to get rid of, say, 900,000 old rows, but you want the UNLOAD to contain the 100,000 active rows plus the 900,000 archived rows I believe the answer is no. You would have to run two separate UNLOADs of the active and archive table.

Why do you want all 1,000,000 rows in the UNLOAD? Presumably the 900,000 archived rows are read-only and rarely accessed?

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

venkata rama rajesh mallina

RE: Does unload utility support SYSIBMADM.GET_ARCHIVE?
(in response to Eugene Zeev)

Hi,

SET SYSIBMADM.GET_ARCHIVE is the SQL statement. How does it will work for UNLOAD utilities. DSNUTILB utility program can understand utility control cards only. not SQL statements.

But I hope still chance is there. Use DSNTIAUL program for UNLOAD.  Provide the select with SET  SYSIBMADM.GET_ARCHIVE statement in SYSIN. I hope it will work

Venkata Rama Rajesh

DB2 DBA for Z/OS

Eugene Zeev

RE: Does unload utility support SYSIBMADM.GET_ARCHIVE?
(in response to venkata rama rajesh mallina)

Thanks for Venkata and Jorn for  replies.

Chris Muncan

RE: Does unload utility support SYSIBMADM.GET_ARCHIVE?
(in response to venkata rama rajesh mallina)

venkata, unfortunately DSNTIAUL does not recognize the SET SYSIBMADM.GET_ARCHIVE = 'Y' parameter.  It is accepted, but does not work with DSNTIAUL.  Using something like SPUFI does take it into account and retrieves from the archive-enabled table AND the archive table.  You could always use DSNTIAUL to directly unload from the archive table.