Error in Full Cache Refresh on DB2 Z/OS platform
[Cache] [Database] [DB2] [db2 sequence cache] [db2 sql error] [db2 sql error 811] [Full] [refresh] [z/OS]
- “Premature end of file” while mapping runtime cache refreshSymptom During the cache refresh of mapping runtime cache following error appears in defaultTrace: Processing HTTP request to servlet [MappingCacheRefresh] finished with error. The error is: javax.servlet.ServletException: Attempt to parse XML document...
- DB2-z/OS: Configure statement Cache Statistics HistorySymptom The SAP DB2 performance data collector RFCOSCOL (WebAS 6.20/6.40) / SAPCL (WebAS 7.00) periodically takes a snapshot of the DB2 statement cache statistics in order to collect a history of the...
- DB2-z/OS:CCMS: DB13: DB2 Utilities SHRLEVEL SyntaxSymptom The DB13 job templates to call DB2 Utilities contain a wrong syntax for SHRLEVEL. The value of SHRLEVEL is accidentally enclosed in brackets. This prevents the fix from IBM APAR PK87122...
- DB2-z/OS:CCMS: DB2 Utility job changesSymptom REORG jobs in transaction DB13 alter the primary and secondary space allocation, if the number of extents is greater than four. In addition, REORG and COPY jobs in DB13 are not...
- DB2-z/OS: CCMS corrections (6.10, 6.20, 6.40, 7.x)Symptom This note describes DB2 for z/OS-specific corrections and advance developments for the CCMS for R/3 Releases 6.10, 6.20, 6.40 and 7.00. Other terms DB2, z/OS, ABAP, transport, correction, fix, advance development,...
- DB2-z/OS: Service SQLSymptom You want to create the service SQL to extract the current SQL query scenario. Other terms DB2, OS/390, z/OS, PLI8, DSNPLI8 Reason and Prerequisites To reproduce problems in the area of...
- DB2-z/OS: Requirements – EhP installerSymptom The note lists corrections that need to be applied to your system before you start the EhP installer to the following target release(s): NW 7.02NW 7.20 Other terms DB2 z/OS DDIC...
- DB2-z/OS:CCMS: Enabling Sysplex MonitorSymptom The new OS07(n) needs to query the connected SAP system via RFC to find out details about the associated DB host. Other terms DB2, z/OS, CCMS, Sysplex Monitor, OS07, Configuration, DB...
Symptom
Full cache refresh does not works on PI system with DB2 database on Operating System Z/OS
During full cache refresh, a deadlock occurs on the database and J2EE engine needs to be restarted or deadlock condition needs to be manually resolved.
This issue occurs only on PI system with DB2 database on Operating System Z/OS.
Other terms
Full Cache Refresh, DB2 database, Z/OS
Reason and Prerequisites
Program Error
Solution
Apply this patch