IDB2 DC abends with CCSR010E NMSPRMVC S378 at 25F0C37A LMOD NSIGHTDC CSECT CSAAPI

book

Article ID: 192453

calendar_today

Updated On:

Products

CA Sysview Performance Management Option for DB2 for z/OS CA Database Management for DB2 for z/OS - Performance Suite CA Database Management for DB2 for z/OS - SQL Performance Suite CA-Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

After upgrading from R19 to R20, three(3) Datacollectors were started. One stays up but two(2) are abending with the following messages:
CCSR010E NMSPRMVC S378 at 25F0C37A LMOD NSIGHTDC CSECT CSAAPI +000112 DB2PDCS N/A DB2PDCS
 15.45.38 STC55429  CCSR021I OWNER = CA Database Management R20.0
 15.45.38 STC55429  CCSR022I MODULE = CSAAPI FMID = CINSK00 RMID = SO12904
 15.45.38 STC55429  CCSR060I BREAKING EVENT ADDRESS: 00000000 01820686
 15.45.38 STC55429  CCSR061I PSW: 07041000 80000000 00000000 01625C50
 15.45.38 STC55429  CCSR062I ILC: 02 INTERRUPT CODE: 0D
 15.45.38 STC55429  CCSR067I COMPLETION CODE S378 REASON CODE 00000014
 15.45.38 STC55429  CCSR064I DATA AT PSW 01625C4A : 00181610 0A0D18CE 18FB180C
 15.45.38 STC55429  CCSR065I HOME = 005C  PRIMARY = 005C  SECONDARY = 005C
 15.45.38 STC55429  CCSR070I GR00 - GR01  00000000_84000000 00000000_84378000
 15.45.38 STC55429  CCSR070I GR02 - GR03  00000000_001040C0 00000000_00007F03
 15.45.38 STC55429  CCSR070I GR04 - GR05  00000000_007F8588 00000000_007C7EF0
 15.45.38 STC55429  CCSR070I GR06 - GR07  00000000_81622BC8 00000000_00FBD300
 15.45.38 STC55429  CCSR070I GR08 - GR09  00000000_00000000 00000000_00000008
 15.45.38 STC55429  CCSR070I GR10 - GR11  00000000_00194078 00000000_7F6522E0
 15.45.38 STC55429  CCSR070I GR12 - GR13  00000000_00004001 00000000_000C2810
 15.45.38 STC55429  CCSR070I GR14 - GR15  00000000_000C26B8 00000000_00000014
 15.45.38 STC55429  CCSR071I AR00 - AR03  00000000 00000000 00000000 00000000
 15.45.38 STC55429  CCSR071I AR04 - AR07  00000000 00000000 00000000 00000000
 15.45.38 STC55429  CCSR071I AR08 - AR11  00000000 00000000 00000000 00000000
 15.45.38 STC55429  CCSR071I AR12 - AR15  00000000 00000000 00000000 00000000
 15.45.38 STC55429  CCSR066I SDWAEC2 078D0000 A5F0C37A from RB
 15.45.38 STC55429  CCSR062I ILC: 02 INTERRUPT CODE: 06
 15.45.38 STC55429  CCSR070I GR00 - GR01  00000000_0006C760 00000000_00062324
 15.45.38 STC55429  CCSR070I GR02 - GR03  00000000_0006C760 00000000_0009A4D8
 15.45.38 STC55429  CCSR070I GR04 - GR05  00000000_00062408 00000000_00000000
 15.45.38 STC55429  CCSR070I GR06 - GR07  00000000_0009A4C8 00000000_007F8708
 15.45.38 STC55429  CCSR070I GR08 - GR09  00000000_007F8170 00000000_25F01308
 15.45.38 STC55429  CCSR070I GR10 - GR11  00000000_0006B000 00000000_0006D000
 15.45.38 STC55429  CCSR070I GR12 - GR13  00000000_25F0B368 00000000_00062240
 15.45.38 STC55429  CCSR070I GR14 - GR15  00000000_00062470 00000000_267257B4
 15.45.38 STC55429  CCSR080I NMSPRMVC DUMP IN PROGRESS
 15.45.38 STC55429  CCSR082I NMSPRMVC DUMP UNSUCCESSFULLY COMPLETED. R15 = X'00000B08'
15.45.38 STC55429  IEA995I SYMPTOM DUMP OUTPUT  260
    260             SYSTEM COMPLETION CODE=378  REASON CODE=00000014
    260              TIME=15.45.38  SEQ=21265  CPU=4001  ASID=005C
    260              PSW AT TIME OF ERROR  070C1000   81625C50  ILC 2  INTC 0D
    260                NO ACTIVE MODULE FOUND
    260                NAME=UNKNOWN
    260                DATA AT PSW  01625C4A - 00181610  0A0D18CE  18FB180C
    260                GR 0: 84000000   1: 84378000
    260                   2: 001040C0   3: 00007F03
    260                   4: 007F8588   5: 007C7EF0
    260                   6: 81622BC8   7: 00FBD300
    260                   8: 00000000   9: 00000008
    260                   A: 00194078   B: 7F6522E0
    260                   C: 00004001   D: 000C2810
    260                   E: 000C26B8   F: 00000014
    260              END OF SYMPTOM DUMP
 15.45.38 STC55429  OEVN003I OPSEVENT State: DOWN
 15.45.38 STC55429  DBG39039I DB2P 15:45:38 TERMINATION COMPLETE FOR DATA COLLECTOR FOR DB2 SUBSYSTEM DB2P
 15.45.38 STC55429  IEF404I DB2PDCS - ENDED - TIME=15.45.38
 15.45.38 STC55429  $HASP395 DB2PDCS  ENDED - RC=0052

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

The second Data Collector(DC), DB2P, fails because it was trying to open the DB2T STATS file. This file is already open to the DB2T data collector.

Changing the following SYSPARMS to point to DB2P data sets should resolve the problem:

HSTSTATS-DSN='SYS2.CA.DB2TOOLS.IDB2.DB2T.HSTSTATS'
HSTACCTG-DSN='SYS2.CA.DB2TOOLS.IDB2.DB2T.HSTACCTG'
HSTSQLDB-DSN='SYS2.CA.DB2TOOLS.IDB2.DB2T.HSTSQLDB'