ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

IDB2 online History Files compatibility.

book

Article ID: 52476

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS 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 Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Fast Load for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

I am upgrading Insight for DB2 for z/OS from R11.5 to R12.0. Are the R11.5 VSAM KSDS online history files compatible with the new R12.0 product version? If not, can I copy the contents of the R11.5 A/B KSDS VSAM datasets to the new R12.0 Linear VSAM dataset?

No they are not, but the r12 post install job, ssid0625, will facilitate unloading the data from the r11.5 KSDS Vsam datasets and loading into the r12.0 Linear Vsam datasets.

Solution:

The R12 Insight for DB2 for z/OS product uses VSAM LINEAR datasets for its online history files, thus making it incompatible with previous Insight versions' (R11.5) VSAM KSDS structure. The R12 post install (ssid0625) job under the DB2 customization option provides the job stream to migrate previously existing history files by generating the HISTUNLD and HISTLOAD job steps in the ssidVSAM member created during this post-install process. The HISTUNLD unloads the old VSAM KSDS history files into an SMF flat file using a IDB2UNLD utility similar to the utility in r11.5, and loads the new history files with the new IDB2UIFI utility which is documented in the R12 Insight System Guide.

Environment

Release:
Component: IDB2