SMP/E ACCEPT of IBM Tivoli OMEGAMON XE for DB2 PE / PM / BPA PTFs UK65325 UK65399 UK65412 fails. EXPLAIN functionality not available because BIND fails

Flash (Alert)


Abstract

SMP/E ACCEPT CHECK is successful after APPLY of UK65325 UK65399 UK65412. However the actual ACCEPT will fail with message IEW2230S.


The DB2 BIND for the explain function will fail with a message indicating the DBRM are in an inconsistent state.

Content

(1) Do not SMP/E accept these PTFs.

(2) Explain functionality fails after install


Both issues will be resolved by replacement PTFs based on the PE resolving HIPER APARs PM35049, PM35051 and PM35052.

Issues have been found with the build of PTFs, UK65325 UK65399 UK65412 (associated APARs are PM24083,PM32638,PM32647).

1) MOD KO2ZZCC is incomplete.

2) DBRM DGO@TPL3 and DGO@TPL4 are in an inconsistent state.

1) MOD KO2ZZCC is incomplete

Attempting to SMP/E ACCEPT these PTFs will result in the following error messages:

IEW2322I 1220 1 INCLUDE SMPWRK3(KO2ZZCC) UK65325 SEQ # 0
IEW2322I 1220 2 SETSSI 01115325
IEW2322I 1220 3 NAME KO2ZZCC(R) MAX ACCEPTABLE RC=08
IEW2230S 0414 MODULE HAS NO TEXT.
IEW2650I 5102 MODULE ENTRY NOT PROVIDED. ENTRY DEFAULTS TO SECTION OMPEZCC.
IEW2008I 0F03 PROCESSING COMPLETED. RETURN CODE = 12.

Recovery from this issue requires that function HKDB510 must be completely reinstalled. This also applies to the function JKDB51J (Japanese) if installed.

Note: SMP/E ACCEPT CHECK is successful and returns return code 0. SMP/E ACCEPT fails.

2) DBRM DGO@TPL3 and DGO@TPL4 are in an inconsistent state.

If you have already APPLYed and installed but not yet ACCEPTed the PTF, explain will fail due to two corrupt DBRM files.

The messages seen will look like:


DSNT231I  -QSSA BIND DBRM ERROR
USING IS6X AUTHORITY
PACKAGE=HAMBURG_QSSA.KO2EX510.DGO@TPL3
DBRM DGO@TPL3 IS IN AN INCONSISTENT STATE

DSNT231I  -QSSA BIND DBRM ERROR
USING IS6X AUTHORITY
PACKAGE=HAMBURG_QSSA.KO2EX510.DGO@TPL4
DBRM DGO@TPL4 IS IN AN INCONSISTENT STATE


Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli OMEGAMON XE for DB2 Performance Expert for z/OS z/OS 5.1.0
Systems and Asset Management Tivoli OMEGAMON XE for DB2 Performance Monitor for z/OS z/OS 5.1
Information Management DB2 Tools for z/OS DB2 Buffer Pool Analyzer z/OS 5.1.0

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 Tools for z/OS
IBM Tivoli OMEGAMON XE for DB2 PE / PM / BPA

Software version:

5.1.0

Operating system(s):

z/OS

Reference #:

1472569

Modified date:

2011-03-18

Translate my page

Machine Translation

Content navigation