What you produce: Db2 distribution and target libraries
During SMP/E processing, Db2 is loaded into the distribution and target libraries. Db2 uses the distribution libraries to maintain Db2 and contain the master copy of all elements for your Db2 subsystem.
The target libraries contain the various Db2 components. Db2 target libraries are updated when you apply corrective service.
Remember: If you copy Db2 library data sets from one system to another, such as for installing a related test or production subsystem, ensure that you copy all of the Db2 library data sets to the same location. For example, if you copy the SDNSLOAD data set from one system to another but omit the DBRMLIB data set, the resulting mismatch can cause job DSNTIJRT to fail with SQLCODE -812.
The following table describes all the Db2 distribution libraries. The distribution libraries contain the master copy of all elements for your Db2 system.
Distribution libraries | Description |
---|---|
prefix.ADSNBASE | This library contains all jobs that are required to complete SMP/E installation. |
prefix.ADSNENU or ADSNDKF | This library contains the Db2 English or Kanji task panels, respectively. |
prefix.ADSNLOAD | This library contains an individual object module for every Db2 load module. It contains the IRLM load modules if you choose to install IRLM into the same distribution libraries as Db2. This library must be a PDSE data set. |
prefix.ADSNLOD2 | This library contains a PDSE data set, which contains DLLs for products and features like IBM® Data Server Driver for JDBC and SQLJ, Db2 for z/OS® ODBC, XML Toolkit for z/OS, the HDFS_READ function, and others. |
prefix.ADSNHFS | This library contains the data that is to be copied into z/OS UNIX System Services. |
prefix.ADSNIVPD | This library contains the IVP input data and expected output for sample applications. |
prefix.ADSNMACS | This library contains the Db2 macros, sample programs, sample data, initialization data, TSO CLISTs, ISPF panels, and ISPF messages. |
prefix.ADXRLOAD | This library contains an individual object module for every IRLM load module. |
prefix.ADXRSAMP | This library contains the installation procedures for installing IRLM Version 2. |
The following table describes all Db2 target libraries.
Target libraries | Description |
---|---|
prefix.SDSNBASE | This library contains all jobs that are required to complete SMP/E installation. |
prefix.SDSNC.H | This library contains the header files. The command-line interface (CLI) requires header files. C language application programs can use header files. |
prefix.SDSNCLST | This TSO CLIST library contains code that simplifies the process of installing and migrating, aids program preparation and the use of Db2 utilities, and allows the use of Db2 Interactive (Db2I). |
prefix.SDSNDBRM | This library contains the system DBRMs for Db2 13. |
prefix.SDSNEXIT | This program library is empty when first created. The installation jobs put the DSNZPxxx subsystem parameters load module, application defaults load module (dsnhdecp), and user exit modules into this library. |
prefix.SDSNIVPD | This library contains the IVP input data and the expected output for sample applications. |
prefix.SDSNLINK | This library contains early code of Db2 13. |
prefix.SDSNLOAD | This library contains Db2 13 load modules. This library must be a PDSE data set. |
prefix.SDSNLOD2 | This library contains the PDSE data set, which contains DLLs for products and features like IBM Data Server Driver for JDBC and SQLJ, Db2 for z/OS ODBC, XML Toolkit for z/OS, the HDFS_READ function, and others. |
prefix.SDSNMACS | This macro library contains macros that are needed for the CICS® and IMS attachment facilities, the initialization parameter macros, and some data-mapping macros that are needed for some applications. |
prefix.SDSNPFPE or prefix.SDSNPFPK | prefix.SDSNPFPE contains the English task and help panels, and prefix.SDSNPFPK contains the Kanji task and help panels. |
prefix.SDSNSAMP | This initialization library contains the sample applications and data, the jobs for installing and migrating, the default installation and migration parameters, and catalog initialization data for Db2. The JCLIN for each FMID is stored in this library. |
prefix.SDSNSPFM | This Db2 ISPF message library contains messages that are issued during installation or migrate processing. |
prefix.SDSNSPFP | This library is the Db2 ISPF library for installation task and help routing panels. |
prefix.SDSNSPFS | This library is the Db2 ISPF skeleton library that is used to produce EDITJCL. |
prefix.SDSNSPFT | This library is the Db2 ISPF command table library. |
prefix.SDXRRESL | This library contains the IRLM load modules. This library might be empty if you chose to install IRLM elsewhere. |
prefix.SDXRSAMP | The IRLM samples library might be empty if you chose to install IRLM elsewhere. |
For a description of each SMP/E job that Db2 provides, see the following table. These jobs allocate the Db2 libraries and load them with the data from the installation tapes or cartridges.
Job name | Description |
---|---|
DSNTIJAA | This job creates the Db2 target and distribution zones, and defines the SMP/E control data sets in these zones and in the SMP/E global zone. |
DSNACEP1 | This job invokes SMP/E to accept all the required and additional FMIDs into the Db2 distribution libraries (DLIBs). |
DSNALLOC | This is the SMP/E allocation job. It creates the Db2 target and distribution libraries and defines the libraries in the SMP/E target and distribution zones for Db2 for the required and optional FMIDs. |
DSNISMKD | This sample job invokes the supplied DSNMKDIR EXEC to allocate HFS paths for JDBC and SQLJ. |
DSNLSMKD | This sample job invokes the supplied DSNLMKDR EXEC to allocate HFS paths for MQListener. |
DSNWSMKD | This sample job invokes the supplied DSNWMKDR EXEC to allocate HFS paths for Web Services Object Runtime (WORF). |
DSNAPPL1 | This job invokes SMP/E to apply all the FMIDs to the Db2 target libraries for the required and additional FMIDs. |
DSNRECV1 | This job invokes SMP/E to receive all the required FMIDs (from both tapes or cartridges) from the base tape into the SMP/E control data sets. |
DSNRECV2 | This job invokes SMP/E to receive all the required FMIDs (from both tapes or cartridges) for IRLM into the SMP/E control data sets. |
DSNRECV3 | This job invokes SMP/E to receive all the additional FMIDs (from both tapes or cartridges) for ODBC, JDBC, and SQLJ into the SMP/E control data sets. |
DSNRECV4 | This job invokes SMP/E to receive FMIDs (from both tape or cartridge) for the Kanji DB2I panels into the SMP/E control data sets. |
DSNTIJUD | This job invokes SMP/E to delete all Db2 12 entries from the SMP/E libraries. |
DSNDDEF1 | This job creates DDDEF entries for the SMP/E target and distribution libraries. |