SAP Knowledge Base Article - Preview

2789794 - InfoCube collapse step reports error 'DB2-z/OS: Error 1' while updating database statistics"

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

SAP NetWeaver all versions

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.