Symptom
When compressing an InfoCube as part of the InfoCube collapse step, the following error is reported in the tcode SM37 job log while updating Db2 database statistics:
------------------------------------------------------------------------------------------------------------------------------------------------
|05/05/2019|17:09:58|InfoCube ZAB_C002 Successfully Compressed Up To Request 1,748,079
|05/05/2019|17:09:58|Compression of InfoCube ZXX_C002 to request 1748079
|05/05/2019|17:09:58|statistic data written
|05/05/2019|17:09:58|Requirements check compelted: ok
|05/05/2019|17:09:58|enqueue set: ZAB_C002
|05/05/2019|17:09:58|compond index checked on table: /BIC/EZAB_C002
|05/05/2019|17:09:58|request statistics calculated for p-dimid 450
|05/05/2019|17:09:58|DB2-z/OS: Error 1 while updating database statistics
------------------------------------------------------------------------------------------------------------------------------------------------
The DSNUTILS output reports the following (/usr/sap/<SAPSID>/<INSTANCE>/work/DSNUTILS.err):
------------------------------------------------------------------------------------------------------------------------------------------------
> WP: 0034 Time: 05/05/2019 16:00:04 User: BIWREMOTE
1DSNU000I 125 17:09:22.13 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = BIP31973
DSNU1044I 125 17:09:22.13 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 125 17:09:22.13 DSNUGUTC - RUNSTATS TABLESPACE "FA40XDH0"."EZPPXC0" TABLE(SAPBI."/BIC/EZPP_C002")
SAMPLE 10 COLUMN(KEY_ZPP_C0021, KEY_ZPP_C002P, KEY_ZPP_C002T, KEY_ZPP_C002U) COLGROUP("KEY_ZPP_C002P") FREQVAL
COUNT 0 HISTOGRAM COLGROUP("KEY_ZPP_C002T") FREQVAL COUNT 0 HISTOGRAM COLGROUP("KEY_ZPP_C002U") FREQVAL COUNT 0
HISTOGRAM INDEX(KEYCARD FREQVAL NUMCOLS 1 HISTOGRAM NUMCOLS 1) SHRLEVEL CHANGE REPORT NO
DSNU055I -BIP2 125 17:09:22.14 DSNUGMAP - INDEX 'SIDDB2.KEYCARD' NOT FOUND
DSNU607I -BIP2 125 17:09:22.14 DSNUSVAL - ERROR OCCURRED IN ACCESSING INDEX SIDDB2.KEYCARD
DSNU012I 125 17:09:22.14 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
> WP: 0043 parallel: connection: R/3* DB2 User: SIDDB2 UtilId: BIP31973
> WP: 0043 Time: 05/05/2019 17:09:21 User: BIWREMOTE
------------------------------------------------------------------------------------------------------------------------------------------------
Read more...
Environment
- DB2 z/OS v12
- Netweaver AS configured with Db2 z/OS v12
Product
Keywords
mainframe BW BI SM37 RSRV , KBA , BC-DB-DB2 , DB2 for z/OS , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.