This article describes the use of the XDB Link utility in Mainframe Express to access DB2 zLinux, sometimes resulting in a bind error.
Problem:
Because Mainframe Express does not support DB2 zLinux directly, customers attempt to use XDB Link to access it using the DB2 mainframe as a gateway via Distributed Relational Database Architecture (DRDA) and thereafter create a bind of the default package. This practice sometimes returns the following bind error:
L332: SYSSTRINGS does not define a translation CSSID 0 to 1208
Resolution:
For customers who are not yet running new function mode on their mainframe, Mainframe Express version 3.1, WebSync 04 and later contain an update that changes the DRDA flows from EBCDIC to Unicode. This was done at the request of IBM to make Mainframe Express capable of working around a problem IBM has with their extended diagnostic information flow feature.
Regardless of the settings contained in the GPRF40N file, you must have your Single code page specification set to 911 to ensure that FOR BIT DATA columns work properly through XDB Link. Mainframe Express version 3.1, WebSync 05 and later set this code page to 911 by default. If your Single code page is not currently set to 911, follow these steps:
- In Mainframe Express, click Options > SQL For DB2 > XDB Link.
- On the Gateway Profile Utility dialog box, click Local.
- Set the Workstation Code Pages as follows:
Single 911 Mixed 850 Double 301 - Save your changes and exit the Gateway Profile Utility.
- Stop and restart the XDB Server.
This should resolve the problem.
Incident Number: 2257361
#MFDS
#EnterpriseDeveloper