A fix is available
APAR status
Closed as program error.
Error description
In PE Client display a list of threads. Right click on a thread and select the SQL Activity Trace from the pull down. User will receive 0FPEV5009I DB2Q DB2 SQL operation failed: 0FPEV5009I DB2Q SQL code ............. : - 304 0FPEV5009I DB2Q Detecting module ..... : DSNXROHB 0FPEV5009I DB2Q PM Server function ... : bldBtch 0FPEV5009I DB2Q SQL state ............ : 22003 0FPEV5009I DB2Q SQL error message .... : DSNT408I SQLCODE = -304, ERROR: A VALUE WITH DATA TYPE DECIMAL CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION 1 WITH DATA TYPE SMALLINT DSNT418I SQLSTATE = 22003 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXROHB SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -186 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF46' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Performance Expert Client * * - Batch CRD * **************************************************************** * PROBLEM DESCRIPTION: SQL Activity Trace function launched * * from PE Client fails with DGOK226 * * error. PE Server subtask doesn't create * * any output data set containing a * * corresponding report. * * * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: When a host DB2 subsystem, where DB2PM tables are located, operates in a time zone that differs for more than 3 hours from UTC (GMT) time, an internal overflow causes SQL Activity Trace to fail. PROBLEM CONCLUSION: The code of PE Server Subtask has been modified to solve this problem.
Problem conclusion
The code of PE Server Subtask has been modified to solve this problem. KEYWORDS : SQL CODE -304 DGOK226
Temporary fix
Comments
APAR Information
APAR number
PM41839
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-06-16
Closed date
2011-07-13
Last modified date
2017-06-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK69698
Modules/Macros
DGO@BTCH DGOVMSTR DGOZBTCH
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R510 PSY UK69698
UP11/07/14 P F107
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:
16 June 2017