OPEN FAILED FOR DDNAME HSTSTATS ATTEMPTING TO FALL BACK FROM R19 to R18
search cancel

OPEN FAILED FOR DDNAME HSTSTATS ATTEMPTING TO FALL BACK FROM R19 to R18

book

Article ID: 8107

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

User tried to fallback from r19 to r18 Insight data collector failed with the following errors 

DBG21001I TEST 16:07:47 HISTORY: INITIALIZATION STARTING 

DBG21023E TEST 16:07:47 HISTORY: FILE HSTSTATS INVALID HISTORY FILE. 

DBG36017E TEST 16:07:47 OPEN FAILED FOR DDNAME HSTSTATS 

DBG11017I TEST 16:07:47 ESTAE EXIT IN NUHSTLOG INVOKED BY ABEND 

ABEND CODE IS 04138000 - EC PSW AT ABEND IS 070C2001 9651A600 - PRIMARY MODE, SUPR STATE, 64-BIT MODE, PASID/SASID=00070118, TCB 

ILC, INTERRUPT CODE 0002000D - TRANSLATE EXCEP 7F473400 

R0 00000000 R1 04138000 R2 00000247 R3 0042D680 

R4 00000000 R5 00000000 R6 7E90F238 R7 00000004 

R8 00000247 R9 7E90F238 R10 00000000 R11 00000000 

R12 1651AD10 R13 7E90ECD8 R14 1651A6DC R15 02470003 

AR0 2FFFFFFF AR1 00000000 AR2 00000000 AR3 00000000 

AR4 00000000 AR5 00000001 AR6 00000002 AR7 00000000 

AR8 00000000 AR9 00000000 AR10 00000000 AR11 00000001 

AR12 00000000 AR13 00000000 AR14 00000000 AR15 0671A740 

XR0 00000000_00000000 XR1 C4C2E4C7_04138000 XR2 00000050_00000247 XR3 00000050_0042D680 

XR4 00000000_00000000 XR5 00000000_00000000 XR6 00000000_7E90F238 XR7 00000000_00000004 

XR8 00000000_00000247 XR9 00000000_7E90F238 XR10 00000000_00000000 XR11 00000000_00000000 

XR12 00000000_1651AD10 XR13 00000000_7E90ECD8 XR14 00000000_1651A6DC XR15 00000000_02470003

 

What's wrong?

 

Environment

Release:
Component: CIDB

Resolution

Once you upgrade the product from the lower to the higher release and you take with you the history files of the lower release and start writing to them in the higher release, you can't use them if you fallback to the lower level again.

If you try to use them again with the lower level Datacollector, you'll get the following error:

DBG21023E TEST 16:07:47 HISTORY: FILE HSTSTATS INVALID HISTORY FILE. 

DBG36017E TEST 16:07:47 OPEN FAILED FOR DDNAME HSTSTATS 

 

The best option will be to create a new R18 files if you want to fall back.