My Oracle Support Banner

ORA-02063 AND SQLCODE -301 WHEN DATABASE UPGRADED TO 10204 (Doc ID 970764.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for DB2 - Version 10.2.0.3 and later
IBM z/OS on System z
***Checked for relevance on 07-Jul-2011***


Symptoms

-- Problem Statement:
The following query fails after upgrade 10.2.0.4. This query executes a query through transparent gateway for DB2 and does an implicit comparison.

select NR_KREIS,
  JAHR,
  REGNR_VON,
  REGNR_BIS,
  REGNR_BIS - REGNR_VON AS DIFFERENCE
from RPT.VRPSNK@db2x_rpt
  where ((NR_KREIS='A1' AND JAHR='2008') OR (NR_KREIS='DG'
AND JAHR='2008')
  OR (NR_KREIS='HH' AND JAHR='2008') OR (NR_KREIS='MU'
AND JAHR='2008')
  OR (NR_KREIS='RR' AND JAHR='2008'))
  and REGNR_VON <= '2854120280' and REGNR_BIS >= '2854120280'
  order by DIFFERENCE asc;

The error message raised is :

SQLCODE = -301 AFTER UPGRADING DATABASE TO 10204


The definitions in the DB2 and Oracle have stayed the same

desc VRPSNK;
Name Null Type
------------------------------ -------- --------------------
U NOT NULL CHAR(2)
JAHR NOT NULL CHAR(4)
NR_KREIS NOT NULL CHAR(2)
REGNR_VON NOT NULL CHAR(10)
REGNR_BIS NOT NULL CHAR(10)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.