A fix is available
APAR status
Closed as new function.
Error description
New function for provisioning enhancements
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of the Db2 12 for z/OS * * installation CLIST are affected by this * * change. * * . * * All users of DSNTIJRV (DSNTRVFY), the * * validation job and program for Db2- * * supplied routines are affected by this * * change. * **************************************************************** * PROBLEM DESCRIPTION: * * Users of the CLIST observe one or * * more of the following concerns: * * . * * (1) Default buffer pools specified * * . during Db2 installation might not * * . be activated during Db2 * * . installation. This can cause * * . CREATE TABLESPACE requests, * * . CREATE TABLE requests without an * * . IN clause, and CREATE INDEX * * . requests to fail with * * . SQLCODE = -647 (BUFFERPOOL * * . bp-name FOR IMPLICIT OR * * . EXPLICIT TABLESPACE OR * * . INDEXSPACE name HAS NOT * * . BEEN ACTIVATED) * * . when the CREATE statement does * * . not specify a BUFFERPOOL clause. * * (2) All Db2 non-data sharing * * . subsystems instantiated using the * * . Db2 provisioning process share a * * . single application defaults * * . (DSNHDECP) module. * * . * * Users of DSNTIJRV (DSNTRVFY), receive * * return code 12 because validation of * * Db2-supplied stored procedure * * SYSPROC.ADMIN_INFO_HOST returns * * message DSNA626I. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** This APAR addresses the following Db2 installation, migration, and provisioning concerns: . (1) Default buffer pools specified during Db2 installation . might not be activated during Db2 installation. This can . cause CREATE TABLESPACE requests, CREATE TABLE requests . without an IN clause, and CREATE INDEX requests to fail . with SQLCODE -647 when the CREATE statement does not . specify a BUFFERPOOL clause. . (2) All Db2 non-data sharing subsystems instantiated using . the Db2 provisioning process share a single application . defaults (DSNHDECP) module. . (3) DSNTIJRV (program DSNTRVFY) ends with return code 12 . because the call to SYSPROC.ADMIN_INFO_HOST returns . the following message: . DSNA626I DSNADMIH THE getnameinfo() FUNCTION . CALL IS UNSUCCESSFUL, IP Address=nnn.nnn.nnn.nnn, . EDC9501I The name does not resolve for the supplied . parameters. . ============================================================== (1) Default buffer pools not activated during Db2 installation ============================================================== When the CREATE statement for a table space, a table created without an IN clause, or an index does not specify a BUFFERPOOL option, Db2 will select a default buffer pool from one of the following Db2 subsystem parameters in DSN6SYSP: . - TBSBPOOL: The default buffer pool to use for 4 KB page . size table spaces that are created implicitly or created . explicitly without the BUFFERPOOL clause. . - TBSBP8K: The default buffer pool to use for 8 KB page . size table spaces that are created implicitly or created . explicitly without the BUFFERPOOL clause. . - TBSBP16K: The default buffer pool to use for 16 KB page . size table spaces that are created implicitly or created . explicitly without the BUFFERPOOL clause. . - TBSBP32K: The default buffer pool to use for 32 KB page . size table spaces that are created implicitly or created . explicitly without the BUFFERPOOL clause. . - TBSBPLOB: The default buffer pool that is to be used for . LOB table spaces that are created implicitly or created . explicitly without the BUFFERPOOL clause. . - TBSBPXML: The default buffer pool that is to be used for . XML table spaces that are created implicitly or created . explicitly without the BUFFERPOOL clause. . - IDXBPOOL: The default buffer pool that is to be used . for indexes on user data. . If the buffer pool selected by Db2 has not been activated then the request will fail with SQLCODE -647. . Currently, when you install Db2, the default buffer pool names are specified on panel DSNTIP1. There is no check or enforcement to ensure that those names refer to an activated buffer pool, that is one that has a non-zero VPSIZE. This can result in use of non-activated buffer pools as the default buffer pools. . ============================================================== (2) Provisioned Db2 subsystems share a single DSNHDECP module ============================================================== Currently, Db2 provisioning supplies a single application defaults module, having the standard name of DSNHDECP, for all subsystems provisioned on the same LPAR. This limitation reduces the flexibility of provisioned subsytems. . Db2 already supports a user-specified name for this module but assumes that this module always has an alias of DSNHDECP. This approach is not viable in provisioning because there's not a convenient way for our automation to detect and avoid name and alias collisions. And, in deprovisioning, there's not a convenient way for automation to avoid removing an application defaults module that is the base for the DSNHDECP alias. . ============================================================== (3) DSNTIJRV (program DSNTRVFY) ends with rc=12 because the . call to SYSPROC.ADMIN_INFO_HOST returns message DSNA626I ============================================================== DSNA626I in this context indicates only that the user's DNS information is not current. SYSPROC.ADMIN_INFO_HOST is otherwise validated as properly installed. .
Problem conclusion
Temporary fix
Comments
In response, this APAR makes the following modifications: . (1) Installation panels DSNTIP1 and DSNTIP2 are modified as . follows to ensure that default buffer pools specified . during Db2 installation are also defined as part of . Db2 installation: . . - All 4-KB buffer pool size fields are now specified on . a single panel, DSNTIP1 instead of both DSNTIP1 and . DSNTIP2. . . The 8-KB, 16-KB, and 32-KB buffer pool size fields . remain entirely on panel DSNTIP2 as before. . . - The default buffer pool names are now specified on . panel DSNTIP2 instead of DSNTIP1. . . - DSNTIP2 validates that each specified default buffer . buffer pool corresponds to a buffer pool that has a . specified VPSIZE of greater than 0. . . - DSNTIP2 reports validation errors by means of an . existing message, DSNT566I. For example: . DSNT566I An entry of BP1 in the DEFAULT 4-KB BUFFER . POOL FOR USER DATA field requires an entry of 1 or . greater in the BP1 field. . . - DSNTIVxx: In the z/OSMF input variable files, all . variables for 4-KB buffer pool sizes are now noted as . found on panel DSNTIP1 and all variables for default . buffer pool names are now noted as found on panel . DSNTIP2. In DSNTIVIA and DSNTIVIE only, all field . names for specifying 8-KB, 16-KB, and 32-KB buffer . pools are corrected. . (2) Db2 provisioning is modified to supply a distinct . application defaults module for each subsystem. . . The application defaults module name is generated as . <software-service-instance-name>DECP where . <software-service-instance-name> is the Db2 . provisioning generated subsystem name. By default, . the name is now DY00DECP rather than DSNHDECP. . . The application defaults module name is specified in the . APPL DEFAULTS field of panel DSNTIPO3. Prior to this . APAR, in PROVISION mode, APPL DEFAULTS was set by . default to DSNHDECP and could be updated. This APAR . modifies DSNTIPO3 to present APPL DEFAULTS with the . generated name (as described in the preceding paragraph) . and blocks that field from modification. . . Prior to this APAR, when specified name of the . application defaults module is not DSNHDECP, job . DSNTIJUA creates that module with an ALIAS of DSNHDECP. . This APAR modifies the CLIST so that, in PROVISION mode . only, the ALIAS is no longer created. This change . allows complete and independent provisioning and . deprovisioning of each Db2. However, it is now . recommended, when precompiling applications that contain . embedded SQL, to use the precompiler's DECP option to . specify the name of the application defaults module . (because the precompiler otherwise assumes the name is . DSNHDECP). Examples of using the DECP option can be . found in the DSNTIJTM, DSNTEJ1, and DSNTEJ2A job . artifacts produced by running the Db2 installation . CLIST in PROVISION mode. . . The following parts are affected: . * DSNACTON - Action file for Db2 provisioning: . DSNCLIST and DSNHDECP are defined as workflow . variables in the "deprovision" action. . * DSNDEPRV - Workflow file Db2 deprovisioning: . - DSNCLIST and DSNHDECP are defined as variables. . - stepDJUZ (removes the Db2 subsystem parameter . module during deprovisioning) add variableValue . element with name DSNCLIST. . - stepDJUA (removes the Db2 application defaults . module during deprovisioning) is added with prereq . stepDJUZ. . - stepDJRW (removes the Db2-supplied WLM . environments during deprovisioning) now has prereq . of stepDJUA instead of stepDJUZ. . * DSNTICDM - CLIST to delete a member from a specified . data set or alias of a data set: . This CLIST is added to prefix.SDSNCLST. Prior to . this APAR, DSNTICDM was embedded in job DSNTDJUZ. . * DSNTDJUA - Job to remove the Db2 application defaults . module during deprovisioning: . This job is added to prefix.SDSNSAMP. It uses the . DSNTICDM CLIST to remove the Db2 application . defaults module. . * DSNTDJUZ - Job to remove the Db2 subsystem parameter . module during deprovisioning: . - Job step DSNTGEN (copies instream CLIST DSNTICDM) . is removed . - Job step DSNTICDM (executes CLIST DSNTICDM) now . allocates the prefix.SDSNCLST target library to . execute the DSNTICDM CLIST. . * DSNTIDXC - Db2 CLIST default input member for . provisioning: . This member is modified to specify DY00DECP instead . of DSNHDECP as the default setting for the DSNHDECP . entry. . * DSNTINST, DSNTINM1, DSNTINM3, and DSNTINMF - Db2 . installation CLIST members: . The following changes pertain only in PROVISION mode . - The Db2 application defaults module is now named . <software-service-instance-name>DECP where . <software-service-instance-name> is the Db2 . provisioning generated subsystem name. . - Editing of job DSNTIJUA no longer includes an . ALIAS of DSNHDECP for the application defaults . module name. . - Editing of job DSNTIJTM (job step DSNTIAD) now . includes the DECP precompiler option with the . application defaults module name in the PARM.PC . override for preparing program DSNTIAD. . - Editing of job DSNTEJ1 (job step PH01S10) now . include the DECP precompiler option, with . the application defaults module name specified, in . the PARM.PC override for preparing program DSN8CA. . - Editing of job DSNTEJ2A (job step PREPUNL) now . include the DECP precompiler option, with . the application defaults module name specified, . in the PARM.PC override for preparing program . DSNTIAUL. . - Editing of DSNTDJUA, the job added by this PTF to . remove the Db2 application defaults module during . deprovisioning, is added. . * DSNTIPO3 - DEFAULT STARTUP MODULES panel: . Modified as discussed earlier. . * DSNTIVIN - Db2 z/OSMF variable input file for . installation and provisioning: . DSNHDECP, the z/OSMF variable that contains the name . of the Db2 application defaults module, is moved . from . "Section 10: Variables with recommended default . values for provisioning, but user specified for . install" . to . "Section 9: Variables whose values are generated . during provisioning, but user specified for . install" . * DSNTIWIN - Db2 z/OSMF workflow file for installation . and provisioning: . - Step s00SETVP (Set variables for provisioning) . adds a statement to set variable DSNHDECP when . provisioning Db2. . - Steps step16 (DSNTIJTM), step22b (DSNTEJ1), and . step22d (DSNTEJ2A) each add DSNHDECP as a variable . value. . * DSNTPNDX - PAX file for Db2 provisioning: . Refreshed to include all applicable changes . described above. . (3) DSNTRVFY is modified to treat message DSNA626I from . validation of SYSPROC.ADMIN_INFO_HOST as acceptable . rather than an error. DSNTRVFY will now return code . 0 rather than code 12 when it encounters this situation.
APAR Information
APAR number
PH12117
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-05-15
Closed date
2019-12-17
Last modified date
2020-01-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI67067
Modules/Macros
DSNTINMF DSNWZIFC DSNTIVMD DSNTIP1 DSNTINST DSNTIDXC DSNTIP2 DSNTIWIA DSNTIVIA DSNTDJUZ DSNTIWIE DSNTIVIE DSNACTON DSNTINM3 DSNTIPO3 DSNDEPRV DSN@RVFY DSNTDJUA DSNTICDM DSNTINM1 DSNTIVMN DSNTPNDX DSNTIVAF DSNTIVIN DSNTIVMS DSNTIWIN DSNTRVFY
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI67067
UP19/12/24 P F912
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 January 2020