PM80648: EXECUTION OF DB2 DB000001 generated for UK90261 causes problems

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During post installation steps for PTF UK90261 (WBIFN Base
  FP1) the DB2 Job generated to update the runtime database
  can fail. There are 2 potential root causes identified:
  1. If the placeholder DNIvSN is substituted by the maximum
  allowed length of 8 characters, some lines may exceed into line
  73 and thus causing e.g. error SQLCODE = -199, SQLState 42601
  during creation of the Java stored procedures.
  2. If the locale setting of the DB2 environment is set to a
  locale, which uses the comma as decimal seperator (not the
  point), some lines fail due to a missing blank
  after the comma of a database column definition, as the number
  is interpreted as a decimal number. This is causing an SQLCODE =
  -104, ERROR: ILLEGAL SYMBOL "(".
  
  Both errors can happen when using the generated job or when
  running the generated SQL using SPUFI.
  

Local fix

• If you hit the first problem, please remove a blank at the
  beginning of the failing line.
  If you hit the second problem, please add a blank after the
  comma in the column definition (e.g. (19, 0)).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: EXECUTION OF DB2 INSTRUCTION.TXT JOB    *
  *                      DB000001                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Formerly, the following errors could occur when DB000000 or
  DB000001 was deployed during migration or installation:
  - An SQL error with SQLCODE -199, if the customization
    placeholder DNIvSN was substituted by a DB2 schema name
  of 8 characters.
  - An SQL error with SQLCODE -104, if the DB2 subsystem used
    a comma (',') as the delimiter in decimal numbers.
  

Problem conclusion

• Now, this has been corrected
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  PM82230

Modules/Macros

• DNI00024
  

Fix information

• Fixed component name

  WBI FOR FN ZOS

• Fixed component ID

  5655FIN00

Applicable component levels

• R11B PSY UK91963

     UP13/02/28 P F302

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.