Post migration errors

About this task

If migration from 8.2 to 8.3 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:

Running 8.3 HSISGKBL load job with 8.2 GKB SHSIGKB1 input file

Db2:                                                 
        DSNU3351 -DEC1 177 14:54:04:47 DSNURWBG- INPUT FILED 'FGADATE' NOTE 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 TFSQGKBZ_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 8.2 GKB SHSIGKB1 input file does not contain data for the new column, TVERSION.FGADATE.

Solution:

HSISGKBL - run this job to populate with the 8.3 GKB SHSIGKB1 input file.

Running 8.3 HSISIQIM (IQ Import) with 8.2 GKB

Mandatory boolean key:UNX is missing from:TFGKBZ83_GKB7.TPARAM      
Error occurred when checking the GKB type against the IQ file type  
Error during Importer initialization
Number of explicity commits = 0
HSIC020E Inquisitor Import encountered errors. Error code = 6068
Elapsed time:  0 days 0 Hrs, 00 Mins, 00 Secs
HSIC070I A full rematch will be performed
HSIC020E Inquisitor Import encountered errors. Error code - 6068

SQL for FAILED SQL Prepare:
    SELECT "FMODECNT","FPOVID","FPPNUMNAME","FORIDYCTUD", "FVERSIONNAME",
    "FFMID","FSUITE_ID","FE0SDATE","FGADATE" FROM TFGKBZ83_GKB7.TVERSION WHERE
    FPOVID=?
    ERROR - RC = 1 Reported from//"HSI83OS.BASE.C(CLIRS',line 272-
    SOLSTATE S0022
    Native Error Code: -206
    {DB2 FOR OS/390}{ODBC DRIVER}{DSN 12010}
    DSNT4081 SQLCODE= -206,
    ERROR FGADATE IS NOT VALID IN THE CONTEXT WHERE IT IS USED

Reason:

The parameter 'USS' is no longer valid in V8.3. It has been renamed to 'UNX'.
The new column TVERSION.FGADATE is not defined in 8.2 GKB.

Solution

HSISDB02 - run this job to drop the 8.2 GKB and create a new 8.3 GKB.
HSISGKBL - run this job to populate with the 8.3 GKB database.