Post migration errors

About this task

If the migration from the previous release is incomplete, or if a wrong combination of files, jobs, or PARMLIB members are used between the two versions, then you might get the following errors:

  1. Running 9.1 HZASGKBL load job with a previous release of GKB SHZAGKB1 input file
    Db2:
DSNU3351 -DED1 177 14:54:04:47 DSNURWBG- INPUT FILED 'FGADATE' NOT ENTIRELY WITHIN INPUT RECORD
SQLSTATE: S0022 Native Error Code: -206
DSNU0171 177 14:54:04:57 DSNUGBAC - UTILITY DATABASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40347

SQLIte:
INSERT INTO MV91GKB3_GKB7.TVERSION(FPOVID,FVERSIONNAME,FPPNUMNAME, FPRODUCTID,FMODCNT.FEOSDATE,FVERSIONGUID,FFEATUREGID,FFMID,FSUITE_ID.FWFM DATE,FGADATE)VALUES(????????????)
COULD NOT DETERMINE TIMESTAMP FORMAT FOR

    Reason:

    The previous release of GKB SHSIGKB1 input file does not contain data for the new column.

    Solution

    1. HZASGKBL - run this job to populate with the 9.1 GKB SHZAGKB1 input file.
  2. Running 9.1 HZASIQIM (IQ Import) with a previous release of GKB.
    DBMS Version:       DSN13012 - 13.01.0002                                       
Sysplex:N                                                                       
zOS IQ file dated 2025-05-30-18.13.22 collected via APAR HHSI910                
Inquisitor version = 09.01.00                                                   
System start header extension records are supported.                            
The number of system start extension records found is:  2                       
Host IP address = 10.134.49.170                                                 
Host IP name = PTHOMU1.prod.hclpnp.com                                          
GKB Version = 250328                                                            
GKB architecture level for GKB: MVGKBY83_GKB7 = 1                               
GKB architecture level for IBM Z SW Asset Mgmt Version 9.1 must be 2 or greater 
Error during Importer initialization                                            
Number of records in MVREPY83.TMODULE    = 666525                               
Number of records in MVREPY83.TUSEMTD    = 0                                    
Number of records in MVREPY83.TLIBRARY   = 9828                                 
Number of records in MVREPY83.TLPAR      = 1                                    
                                                                                
Number of explicit commits = 0                                                  
HSIC020E Inquisitor Import encountered errors. Error code = 6074                
Elapsed time: 0 days 0 Hrs, 00 Mins, 01 Secs                                    
HSIC070I A full rematch will be performed                                       
HSIC020E Inquisitor Import encountered errors. Error code = 6074
    Reason:

    1. The GKB database structure has not been updated to V9.1 when migrating from a previous release.

    Solution

    1. HZASDB02 - run this job to drop the previous release of the GKB database and create a new 9.1 GKB.
    2. HZASGKBL - run this job to populate with the 9.1 GKB database.