DB2 11 for z/OS:
The SYSPROC.ADMIN_EXPLAIN_MAINT stored procedure maintains EXPLAIN tables under a specified schema. It can be used to:
bring all existing EXPLAIN tables to current release format;
create missing EXPLAIN tables;
create a new set of EXPLAIN tables;
create a new set of aliases on the EXPLAIN tables;
drop existing EXPLAIN tables; or
drop existing ... weiterlesen
25
Mai2014
The DB2 sample program DSNTIAUL is dynamic SQL processing application that is often used to unload data from DB2 tables to an externalized format.  DSNTIAUL also generates a LOAD control statement that can be used in by  the DB2 LOAD utility to load the externalized data back into DB2.
Currently DSNTIAUL ... weiterlesen
25. Mai 2014Gernot