Post migration errors

If migration from version 1.1 to version 2.2 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 V2.2 HZASIQIM (IQ Import) with V1.1 GKB 

 SQL for FAILED SQLPrepare:
 SELECT 
 FMODCNT","FPOVID","FPPNUMNAME","FPRODUCTID","FVERSIONNAME","
 FFMID","FSUITE_ID" FROM
 &GKBZSCHM_GKB7.TVERSION WHERE FPOVID = ?
 ERROR -- RC = -1 Reported from //'HZA910S.COMMIT.C(CLIRS)', line 262 -----
 SQLSTATE: S0022 Native Error Code: -206
 DB2 FOR OS/390}{ODBC DRIVER}{DSN12015} DSNT408I SQLCODE = -206,
 ERROR: FSUITE_ID IS NOT VALID IN THE CONTEXT WHERE IT IS USED
Reason

New tables and columns have been defined in version 2.2 GKB.

Solution
  1. HZASDB02 - run this job to drop the version 1.1 GKB and create a new version 2.2 GKB.
  2. HZASGKBL - run this job to populate the version 2.2 GKB database.

Running V1.1 HZASIQIM (IQ Import) with V2.2 GKB 

 =ERROR= SELECT
 "FPRODUCTID","FPRODUCTNAME","FOPTIONNAME","FVENDORID",
 "FCATEGORY","FDESCRIPTION","FPRODSTATUS" FROM
 TFREPZ8.TPRODUCT
 WHERE FPRODUCTNAME = ? AND FOPTIONNAME = ?
 m_hstmt=17 IsOpen()=0 m_rc=-1 autocommit=0
 ERROR -- RC = -1 Reported from //'HZA810S.FMPROM.C(CLIRS)', line 385
 ----------
 SQLSTATE: 22001
 Native Error Code: -302
 {DB2 FOR OS/390}{ODBC DRIVER}{DSN12010}
 DSNT408I SQLCODE = -302,
 ERROR: THE VALUE OF INPUT VARIABLE OR PARAMETER
 NUMBER 1 IS INVALID OR TOO LARGE FOR THE TARGET COLUMN
OR THE TARGET VALUE
Reason

Version 2.2 GKB columns defined with expanded sizes contain data that are too large to be processed by the version 1.1 code.

Solution

Version 1.1 repository must use a version 1.1 GKB.

Running V1.1 HZASIQIM (IQ Import) with V2.2 IQ scanned file 

 Abort: UNZIP(DD:INQDATA ) failed on open. HZASHRNK rc=12
 ** 00008 IS UNSUPPORTED COMPRESSION METHOD
 Error occurred in opening: DDNAME INQDATA to do iqimport
 Error during Importer initialization
 Number of explicit commits = 0
 HZAC020E Inquisitor Import encountered errors. Error code = 6209
 Elapsed time: 0 days 0 Hrs, 00 Mins, 00 Secs
 HZAC023E Inquisitor Import error occurred in opening: DDNAME INQDATA
 HZAC020E Inquisitor Import encountered errors. Error code = 6209
Reason

New compression routine in version 2.2 is not supported in version 1.1.

Solution

Version 1.1 IQ Import must use version 1.1 IQ scanned files.

Running V1.1 HZASUIMP (Usage Import) with V2.2 Usage files 

 Abort: UNZIP(DD:UIMPDATA) failed on open. HZASHRNK rc=12
 ** 00008 IS UNSUPPORTED COMPRESSION METHOD
 Error occurred in opening input file.
 Number of times uzstream::getline() called = 0(Pass 1)
 Usage Import file Pass1 check return code = 6016
Reason

New compression routine in version 2.2 is not supported in version 1.1.

Solution

Version 1.1 Usage Import must use version 1.1 Usage files.