Installation verification phases and programs
In each phase of the installation verification procedure (IVP), you must run specific programs. These programs need to be run sequentially by phase because the output of some jobs is used as input for subsequent jobs.
The IVP consist of eight phases: seven verification phases and one cleanup phase that drops sample objects (Phase 0). Each of the seven verification phases tests one or more Db2 functions or attachment facilities. Certain phases of the verification procedure might not apply to the environment in which your Db2 subsystem operates, so you might not need to complete all phases. In some cases, the steps and return codes differ when you run the fallback release and Db2 12 phases. These differences are noted under the proper phase.
Run Phase 0 (job DSNTEJ0) only if you want to remove all the verification processing that you have completed so that you can begin the verification procedure again. Phases 1-3 test the TSO and batch environments, including user-defined functions. Phase 4 is for IMS users only, and Phase 5 is for CICS® users only. Phase 6 sets up the sample tables and stored procedures for distributed processing. Phase 7 tests the LOB feature with sample tables, data, and programs.
prefix.SDSNSAMP contains the program source.
Each phase consists of one or more batch jobs and some phases also consist of online activities. You run the same jobs regardless of whether you are installing Db2 for the first time or migrating to Db2 12. The installation CLIST tailored and loaded these jobs into prefix.NEW.SDSNSAMP, which you created during installation or migration to Db2 12. The verification jobs use source code and data from the untailored prefix.SDSNSAMP library. Most Db2 sample objects have unique names to differentiate them from objects of previous releases. This allows sample programs for multiple releases to coexist. The JCL that is provided for IMS sets up transaction identifiers for the sample applications.
The following table shows the programs and jobs that are run in each phase of the verification procedure. These jobs are designed to run with minimal interaction on your part. However, before running these jobs, you should make any modifications that are suggested in the information about each job.
Phase | Job | Program | Description |
---|---|---|---|
0 | DSNTEJ0 | DSNTIAD | Remove sample applications and sample schema authorizations |
1 | DSNTEJ1 | DSNTIAD | Create tables |
DSN8CA | Assembler interface to call attach facility | ||
DSN8EAE1 | Edit exit routine | ||
DSN8HUFF | Huffman compression exit routine | ||
DSNUTILB | Utilities | ||
DSNTEJ1L | DSNTEP2 | Dynamic SQL program | |
DSNTEJ1P | DSNTEP2 | Dynamic SQL program | |
DSNTEJ1S1 | DSNHSP | See note 1 | |
DSNTEJ1T2 | DSNUPROC | See note 2 | |
DSNTEJ1U | DSNTIAD | Create Unicode table | |
DSNUTILB | Load Unicode table | ||
DSNTEP2 | Select Unicode table | ||
2 | DSNTEJ2A | DSNTIAD | Grant execution |
DSNTIAUL | Unload and load tables | ||
DSNUTILB | Utilities | ||
DSNTEJ2C | DCLGEN | Generate declarations | |
DSNTIAD | Grant execution | ||
DSN8BC3 | COBOL phone application | ||
DSNTEJ2D | DSNTIAD | Grant execution | |
DSN8BD3 | C phone application | ||
DSNTEJ2E | DSN8MDG | Prepare error message routine | |
DSN8BECL | Prepare classes used by C++ phone application | ||
DSNTIAD | Grant execution | ||
DSN8BE3 | C++ phone application | ||
DSNTEJ2F | DSNTIAD | Grant execution | |
DSN8BF3 | Fortran phone application | ||
DSNTEJ2H | DSN8EDXR | Sample application to format and display an XML record | |
DSN8EDXU | Sample application to format and update an existing XML record | ||
DSN8EDXI | Sample application to insert an XML record | ||
DSN8EDXD | Sample application to delete an XML record | ||
DSNTEJ2P | DCLGEN | Generate declarations | |
DSNTIAD | Grant execution | ||
DSN8BP3 | PL/I phone application | ||
DSNTEJ2U | DSNTIAD | Register sample user-defined functions | |
DSN8DUAD | C program for ALTDATE function (current date) | ||
DSN8DUCD | C program for ALTDATE function (given date) | ||
DSN8DUAT | C program for ALTTIME function (current time). | ||
DSN8DUCT | C program for ALTTIME function (given time) | ||
DSN8DUCY | C program for CURRENCY function | ||
DSN8DUTI | C program for TABLE_NAME, TABLE_SCHEMA, and TABLE_LOCATION functions | ||
DSN8EUDN | C++ program for DAYNAME function | ||
DSN8EUMN | C++ program for MONTHNAME function | ||
DSNTEP2 | Dynamic SQL program | ||
DSN8DUWF | User-defined table function sample | ||
DSN8DUWC | C program on client for user-defined table function sample | ||
3 | SPUFI | Sample SPUFI input | |
DSNTEJ3C | DSNTIAD | Grant execution | |
DSN8CC | COBOL interface to call attachment facility | ||
DSN8SCM | COBOL connection manager | ||
DSN8SC3 | COBOL phone application | ||
DSN8HC3 | COBOL organization application | ||
DSNTEJ3M | DSNTIAD | Drop sample MQT objects, create sample MQT objects, grant authority to MQT objects, and populate sample MQT tables | |
DSNUTILB | Produce statistics for MQT | ||
DSNTEP2 | Process EXPLAINs on sample MQT tables | ||
DSNTEJ3P | DSNTEP2 | Dynamic SQL application | |
DSNTIAD | Grant execution | ||
DSN8SPM | PL/I connection manager | ||
DSN8SP3 | PL/I phone application | ||
4 | DSNTEJ4C | DSNTIAD | Grant execution |
DSN8ICx | Organization application | ||
DSN8MCx | Copy code | ||
DSNTEJ4P | DSNTIAD | Grant execution | |
DSN8IPx | Organization, project applications | ||
DSN8MPx | Copy code | ||
5 | DSNTEJ5A | DSNTIAC | CICS SQLCA formatter front-end |
DSNTEJ5C | DSNTIAD | Grant execution | |
DSN8CCx | Organization application | ||
DSN8MCx | Copy code | ||
DSNTEJ5P | DSNTIAD | Grant execution | |
DSN8CPx | Organization, project applications | ||
DSN8MPx | Copy code | ||
6 | DSNTEJ6 | DSNTIAD | Update location column in the department table to the sample location entered at installation time |
DSNTEJ6D | DSN8ED1 | Compile, link-edit, bind, and run a sample application program that calls a stored procedure | |
DSNTEJ6O | DSN8DTS1, DSN8DTS2 | Create and run sample for IBM® Text Search for Db2 for z/OS® | |
DSNTEJ6P | DSN8EP1 | Invoke the sample stored procedure | |
DSNTEJ6R | DSN8ED8 | Compile, link-edit, bind, and run a sample application that calls DSNUTILU, the Db2 Utilities Unicode parser stored procedure | |
DSNTEJ6S | DSN8EP2 | Create sample stored procedure | |
DSNTEJ6T | DSN8ED2 | Register, prepare, and bind the stored procedure sample application | |
DSNTEJ6U | DSN8EPU | Compile, link-edit, bind, and run a sample application that calls DSNUTILS, a stored procedure for executing Db2 utilities | |
DSNTEJ6V | DSN8EE0 | C++ class that calls DSNTIAR | |
DSN8EE1 | C++ class that calls DSNUTILS | ||
DSN8EE2 | C++ client for DSN8EE1 | ||
DSNTEJ6W | DSN8ED6 | Call the WLM_REFRESH stored procedure | |
DSNTEJ6X | DSN8EDA | Compile, link-edit, bind, and run a sample application that calls DSNUTILS, a stored procedure for executing Db2 utilities | |
DSNTEJ6Z | DSN8ED7 | C class that calls ADMIN_INFO_SYSPARM stored procedure | |
DSNTEJ61 | DSN8EC1 | Create sample ODBA stored procedure | |
DSNTEJ62 | DSN8EC2 | Invoke sample ODBA stored procedure | |
DSNTEJ63 | DSN8ES1 | Run sample external SQL procedure that calculates employee earnings. | |
DSNTEJ64 | DSN8ED3 | Call the sample external SQL procedure, DSN8ES1 from a client | |
DSNTEJ65 | DSN8ED4 | Call the external SQL procedure processor, DSNTPSMP | |
DSN8ES2 | Run external SQL procedure that calculates employee bonuses | ||
DSN8ED5 | Call external SQL procedure, DSN8ES2 | ||
DSNTEJ66 | DSN8ES3 | Create and alter a sample native SQL procedure | |
DSN8ED9 | Prepare and execute a sample caller of the sample native SQL procedure | ||
7 | DSNTEJ7 | DSNTIAD | Create sample LOB table |
DSNTIAD | Create synonyms, grant access to LOB tables | ||
DSNUTILB | Load sample LOB table | ||
DSNUTILB | Produce statistics for LOB table spaces | ||
DSNTEJ71 | DSNTIAD | Grant access to plans | |
DSN8DLPL | Populate sample LOB table with BLOB data | ||
DSN8DLTC | Verify contents of LOB table | ||
DSNTEJ73 | DSNTIAD | Grant access to plans | |
DSN8DLRV | C employee resume application | ||
DSNTEJ75 | DSNTIAD | Grant access to plans | |
DSN8DLPV | C employee photo application | ||
DSNTEJ76 | DSN8CLPL | Create COBOL LOB sample table | |
DSN8CLTC | Create synonyms, grant access to COBOL LOB tables | ||
DSNTEJ77 | DSN8CLRV | Load sample COBOL LOB table | |
DSNTEJ78 | DSN8CLPV | Produce statistics for COBOL BLOB table spaces | |
Notes:
|