PI63191: SOAP DOES NOT WORK FOR SQL STATEMENT TEXT

Direct links to fixes

APAR status

Closed as program error.

Error description

SOAP does not work for SQL Statement Text.

Additional Information

When applying the PTF for this APAR, the APPLY CHECK / APPLY may
return message GIM43401W for module KO25H8AC. This message can
be safely ignored. Occasionally a new element will be picked up
in the maintenance stream before that element is introduced by
the PTF that will deliver new function or new feature.

Local fix

```
N/A
```

Problem summary

****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2M Users.           *
****************************************************************
* PROBLEM DESCRIPTION: SQL Text does not work using SOAP       *
*                      Server.                                 *
****************************************************************
* RECOMMENDATION: Apply the provided PTF.                      *
****************************************************************
SOAP XML could not use afilter clause because ACE address was
defined as character.

Problem conclusion

ACE address field in numeric format was added to allow use of a
filter in XML SOAP requests.

Temporary fix

Comments

APAR Information

APAR number
PI63191
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
530
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-05-27
Closed date
2017-06-05
Last modified date
2017-12-26

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

UI47792 UI47793

Modules/Macros

   KDPATR   KDPBAR   KDPCAT   KDPDOC   KDPJSTMS
KDPJSTPS KDPJSTPW KDPMAP   KDPMSMAN KDPVRTMS KD5AGENT KO2ABROW
KO2AFLTF KO2AFSAM KO2AHLR  KO2APC6A KO2APC6K KO2APC6S KO2APC62
KO2APHLR KO2CPUCL KO2NCSTB KO25ACCT KO25CHLD KO25DSQL KO25DSQ2
KO25DSTX KO25EDMP KO25FRTS KO25HACL KO25HACT KO25HBAC KO25HGLC
KO25HLAC KO25HLKC KO25HTHD KO25HWT1 KO25HWT2 KO25HXST KO25H8AC
KO25KPI  KO25LOGS KO25QBST KO25QDBP KO25QISE KO25Q3ST KO25Q8AC
KO25Q8ST KO25SQLT KO25SSQL KO25SSTX KO25SXST KO25TNAM KO25TXST
KO25WAT1 KO25WAT2 KO25ZPRM KO25225  KO252252 KO25230  KO25254
KO253162 KO25317  KO254012

Fix information

Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00

Applicable component levels

R530 PSY UI47792
UP17/07/13 P F707
R540 PSY UI47793
UP17/07/08 P F707

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.3.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 October 2022

Tips

PI63191: SOAP DOES NOT WORK FOR SQL STATEMENT TEXT

Direct links to fixes

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R530 PSY UI47792

R540 PSY UI47793

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.

Document Information

Share your feedback

Need support?