Archiv: Mai, 2014

25

Mai2014

DB2 11 for z/OS and new stored procedure to support EXPLAIN

/ DB2 for z/OS
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. Mai 2014Gernot

25

Mai2014

DSNTIAUL and XML

/ DB2 for z/OS
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