- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Connect to IBM's DB2/MVS from HP-UX: code pages
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-04-2003 10:34 PM
тАО08-04-2003 10:34 PM
I??ve set up a connection from hpux 11.00 to the mainframe db2 via "Connect Enterprise Edition for HP-UX 7.1.0.43". The connection seems to work, at least login data is checked in the mainframe but I get this error message when I try to connect.
SQL0332N There is no available conversion for the source code page "1051" to
the target code page "UNKNOWN". Reason Code "3". SQLSTATE=57017
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2003 06:01 AM
тАО08-05-2003 06:01 AM
SolutionFor me, this issue is related to a codepage not correctly set on your HP-UX client box.
I made some google.com investigations and found out this :
http://www.developer.ibm.com/tech/faq/individual/0,1324,1%253A247%253A249%253A3%253A77935,00.html
Can you check if changing this setting might help ?
Also check this :
http://webdocs.caspur.it/ibm/web/udb-6.1/db2m0/sql0300.htm
(look for SQL0332N and look at the explanations)
Another thing. I recently faced a problem with DB2 code pages differences in a backup/restore problem where the user had to use :
db2set DB2CODEPAGE=819
db2set DB2COUNTRY=1
To correctly map the db2 database codepages.
Maybe a search on db2set DB2CODEPAGE might also help you. Maybe you need to set them accordingly to what has been defined on the mainframe before connecting from hp-ux ?
Hope this helps,
Bye.
Francis - HP-UX ASCE.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2003 09:51 PM
тАО08-05-2003 09:51 PM
Re: Connect to IBM's DB2/MVS from HP-UX: code pages
1.-I appended
[Common]
DisableUnicode=1
to the db2cli.ini and after db2stop/db2start I got the same error when I try to connect.
2.-I ran db2set DB2CODEPAGE=1141 (this is the mainframe SCCSID) but after that I couldn't run db2, I got 'SQL10007N Message "-1390" could not be retrieved. Reason code: "5"'. So I wasn't able to run the db2connect
Anyway I appreciate your information, I didn't knew that.
Regards,
Fernando
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2003 09:51 PM
тАО08-05-2003 09:51 PM
Re: Connect to IBM's DB2/MVS from HP-UX: code pages
1.-I appended
[Common]
DisableUnicode=1
to the db2cli.ini and after db2stop/db2start I got the same error when I try to connect.
2.-I ran db2set DB2CODEPAGE=1141 (this is the mainframe SCCSID) but after that I couldn't run db2, I got 'SQL10007N Message "-1390" could not be retrieved. Reason code: "5"'. So I wasn't able to run the db2connect
Anyway I appreciate your information, I didn't knew that.
Regards,
Fernando
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-09-2003 10:46 AM
тАО08-09-2003 10:46 AM
Re: Connect to IBM's DB2/MVS from HP-UX: code pages
SQL0332N There is no available conversion for the source code page "1051" to
the target code page "UNKNOWN". Reason Code "3". SQLSTATE=57017
For me means that your HP-UX box is using a code page different than the mainframe. HP-UX seems to be set as 1051 and the HP-UX setting for the target is not set at all.
I'm sorry to not be able to help you more. This issue should be raised to your IBM support, they certainly know the root cause of this.
Bye.
Francis.