A fix is available
APAR status
Closed as program error.
Error description
User had defined a stored procdure IQUEID under DB2PM ownership that resulted in an SQLCODE -104 during PWH database initialization, as seen in the OMPE Server SYSPRINT: . FPEV5009I PR13 Dropping stored procedure IQUEID FPEV5009I PR13 **************************************************************** FPEV5009I PR13 DB2 SQL operation failed: FPEV5009I PR13 SQL code ............. : - 104 FPEV5009I PR13 Detecting module ..... : DSNHPARS FPEV5009I PR13 PM Server function ... : DGOZSP FPEV5009I PR13 SQL state ............ : 42601 FPEV5009I PR13 SQL error message .... : FPEV5009I PR13 +--------------------------------------------------------------- FPEV5009I PR13 | DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL FPEV5009I PR13 | MIGHT BE LEGAL ARE: <END-OF-STATEMENT> RE FPEV5009I PR13 | DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE FPEV5009I PR13 | DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETE FPEV5009I PR13 | DSNT416I SQLERRD = 3 0 0 -1 150 502 SQL DI FPEV5009I PR13 | DSNT416I SQLERRD = X'00000003' X'00000000' X' FPEV5009I PR13 | X'FFFFFFFF' X'00000096' X'000001F6' SQL FPEV5009I PR13 | INFORMATION FPEV5009I PR13 +----------------------------------------------- FPEV5009I PR13 User action .......... : FPEV5009I PR13 +----------------------------------------------- FPEV5009I PR13 | SYNTAX ERROR IN PM SQL STATEMENT. CONTACT PROD FPEV5009I PR13 | SUPPORT. FPEV5009I PR13 +----------------------------------------------- FPEV5009I PR13 ************************************************ FPEV5004S PR13 DATABASE UPDATE FAILED. SEE JOB LOG FOR DETAILS FPEV5002I PR13 PWH IS STOPPING . Customer was told to DROP the DB2PM database and recycle the OMPE Server, which resulted in the same SQLCODE -104. . Customer was asked to verify that the PWH database bufferpool size was set to BP32K for ONLINE, BP8K for STAT, and BP32K for QRY in ICAT PWH configuration panel KD261PW, which are the ICAT defaults. . Customer changed the STAT database bufferpool size to BP8K and regenerated the lib members via ICAT and recycled the OMPE Server, which were verified in hlq.RKD2PAR(PWHRssss) member. . The results were repeated 0C4 abends seen in the OMPE Server joblog: . 13.36.08 STC17085 FPEV9999I **** DB2 PM/PE SYMPTOM RECORD **** 13.36.08 STC17085 FPEV9999I LVLS/OMEGAMON XE PE/PM 13.36.08 STC17085 FPEV9999I VALU/PCHK 13.36.08 STC17085 FPEV9999I AB/S/0C4 13.36.08 STC17085 FPEV9999I AB/U/000 13.36.08 STC17085 FPEV9999I RIDS/FPEZPMS#l 13.36.08 STC17085 FPEV9999I RIDS/ 13.36.08 STC17085 FPEV9999I PTFS/ IDENTIFY T 13.36.08 STC17085 FPEV9999I ADRS/ = 13.36.08 STC17085 FPEV9999I PSW /478D1000 9AFFF6E6 13.36.08 STC17085 FPEV9999I REGS 0-1/00000000 1C609581 13.36.08 STC17085 FPEV9999I REGS 2-3/0000001E 1C6173C6 13.36.08 STC17085 FPEV9999I REGS 4-5/1C609D9F 1C608DA0 13.36.08 STC17085 FPEV9999I REGS 6-7/0000E4D5 000000C8 13.36.08 STC17085 FPEV9999I REGS 8-9/0000E4F3 8001B350 13.36.08 STC17085 FPEV9999I REGS A-B/1AFFFD97 9AFFED98 13.36.08 STC17085 FPEV9999I REGS C-D/1C6092D1 1C608DA0 13.36.08 STC17085 FPEV9999I REGS E-F/9AFFF69C 00000000 13.36.08 STC17085 IEA995I SYMPTOM DUMP OUTPUT 040 040 SYSTEM COMPLETION CODE=0C4 REASON CODE=00000011 040 TIME=13.36.08 SEQ=07354 CPU=0000 ASID=00AF 040 PSW AT TIME OF ERROR 478D1000 9AFFF6E6 ILC 040 ACTIVE LOAD MODULE ADDRESS=1AF5F100 OF 040 NAME=FPEZPMS 040 DATA AT PSW 1AFFF6E0 - 1E364133 513CD208 3000 040 GR 0: 00FC6D00_00000000 1: 00000000_1C609581 040 2: 00000000_0000001E 3: 00000000_1C6173C6 040 4: 00000000_1C609D9F 5: 00000000_1C608DA0 040 6: 00000000_0000E4D5 7: 00000000_000000C8 040 8: 00000000_0000E4F3 9: 00000000_8001B350 040 A: 00000000_1AFFFD97 B: 00000000_9AFFED98 040 C: 00000000_1C6092D1 D: 00000000_1C608DA0 040 E: 00000000_9AFFF69C F: 00000000_00000000 040 END OF SYMPTOM DUMP 13.36.08 STC17085 FPEV5032S PR13 PWH TASK ABENDED 13.36.11 STC17085 FPEV0027E PR13 TASK FPEZPMS TERMINATED WITH ERROR CODE 16
Local fix
As a temporary workaround, suggest to DROP customer's stored procedure from DB2PM ownership and create that stored procedure under another schema that is not DB2PM.
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - PE Server subtask * * - Performance Database users * * - Performance Warehouse users * **************************************************************** * PROBLEM DESCRIPTION: Performance Warehouse database creation * * or migration process fails if DB2PM * * schema contains user-defined stored * * procedures under DB2PM ownership. * * * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: Existence of user-defined stored procedures under DB2PM schema and DB2PM ownership causes failures during Performance Warehouse database creation/migration process. The following messages indicate one of possible failure in the SYSPRINT data set of the OMEGAMON collector started task: FPEV5017I ... BINDING DBRM DGO@SP FPEV5009I ... Dropping stored procedure <procname> FPEV5009I ... *************************************************** FPEV5009I ... DB2 SQL operation failed: FPEV5009I ... SQL code ............. : - 104 FPEV5009I ... Detecting module ..... : DSNHPARS FPEV5009I ... PM Server function ... : DGOZSP . . . FPEV5009I ... *********************************** FPEV5004S ... DATABASE UPDATE FAILED... FPEV5002I ... PWH IS STOPPING In addition repeated ABEND S0C4-11 in FPEZPMS module may take place. PROBLEM CONCLUSION: Code of Performance Warehouse subtask has been correspondingly corrected to prevent the failures.
Problem conclusion
Code of Performance Warehouse subtask has been correspondingly corrected to prevent the failures. KEYWORDS : PWH DATABASE UPDATE FAILED SQLCODE -104 ABEND S0C4-11 in FPEZPMS
Temporary fix
Comments
APAR Information
APAR number
PM32948
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-02-16
Closed date
2011-03-23
Last modified date
2017-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK66060 UK66061
Modules/Macros
DGO@SP DGOVMSTR DGOZSP DUMM7KO2
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
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":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 February 2017