Connectivity Problem

Viswanathan N

Connectivity Problem


Hi !!
I have a problem on connectivity !!

The problem is in the connectivity to Japanese Database in OS/390 DB2 V5.1
from Japanese NT running Japanese database.

Windows NT Server configuration :

1. Windows NT Japanese.
2. DB2 UDB V5.2 Enterprise version

OS/390 running DB2 V5.1
Database enabled for DBCS support.

The Codepage sequence in Os/390 Db2 v5.1 is


DSNHDECM CHARSET=KATAKANA,
ASCCSID=0,
AMCCSID=65534,
AGCCSID=65534,
SCCSID=290,
MCCSID=930,
GCCSID=300,
ENSCHEME=EBCDIC,
DATE=ISO,
DATELEN=0,
DECARTH=DEC31,
DECIMAL=PERIOD,
DEFLANG=IBMCOB,
DELIM=DEFAULT,
MIXED=YES,
SQLDELI=DEFAULT,
DSQLDELI=APOST,
SSID=JPDD,
STDSQL=NO,
TIME=ISO,
TIMELEN=0
The code page variable in NT is set as 943.

With this combination of code pages we are not able to connect to the
Os/390 japanese subsystem.
The error given is

(Embedded image moved to file: pic05168.pcx)

If we change the code page to 1252 on the NT by setting DBCODEPAGE=1252
environment variable
then we are able to connect to japanese subsystem on Os/390 .

But still when we query a field with graphic for Kanji support . It gives
code page conversion error.

The output is below.

(Embedded image moved to file: pic16854.pcx)

So thats the status. !! If we get the configuration of the NT as to what
codepage has to be set there then we can see / or what point we are missing
at the NT/mainframe side.
Now after this there is a requirement for connecting to the japanese
database on the mainframe thru a websphere application. This will connect
thru JDBC. There too it gives the same error and even with the codepage set
as 1252. on the NT. It does not even connect thru the JDBC. Same codepage
error.

Can anybody help !!

regards
Vishy

N.Viswanathan
L & T Information Technology Ltd.
COE- Systems.
Gate No-2
Saki Vihar Road,Powai Mumbai - 400072.
Ph : 91-22-8581940 Ext : 8068/8069/8070
Email : [login to unmask email]
: [login to unmask email]
Attachments

  • pic05168.pcx (8.5k)
  • pic16854.pcx (27.8k)