Re: Unicode on Demand problem
-Original Message- From: IBM Mainframe Discussion List On Behalf Of Mark Zelden On Tue, 16 Dec 2008 11:42:30 -0600, Chase, John wrote: [ snip ] You may find that, even with those fixes applied, you still need to code a CUNUNIxx member to cope with CP 1252. We had to do that at z/OS 1.7, and did not test without it when we upgraded to 1.9 so I don't know if it's still needed (doesn't seem to hurt anything). Did you open a PMR with IBM about this? We skipped 1.7, but I see that conversion in use here under 1.9 and I assume it was also used for z/OS 1.8. Yes; after applying the fix for OA19072 (z/OS 1.7), DB2 (8.1) wouldn't start with an empty Unicode environment. Turned out that if DB2 is the first requester of Unicode services after IPL, the Unicode environment cannot be empty. So we initially coded a one-line CUNUNI00 which made everything happy until one of the DB2 utilities tried to work with something that originated from a Windows box and used CP 1252. For some reason either unexplained or forgotten, the DB2 utility couldn't find a conversion table for CP 1252, so we just added five lines to CUNUNI00 to cover from/to CP 37, 1208 and 1252. Everything else does indeed get satisfied on demand (now on z/OS 1.9): CUN3000I 08.25.56 UNI DISPLAY 573 ENVIRONMENT: CREATED 12/14/2008 AT 06.10.00 MODIFIED 12/15/2008 AT 22.31.03 IMAGE CREATED --/--/ AT --.--.-- SERVICE: CHARACTER CASE NORMALIZATION COLLATION STRINGPREP BIDI STORAGE: ACTIVE 14 PAGES LIMIT 524287 PAGES CASECONV: DISABLED CASE VER: NONE NORMALIZE: DISABLED NORM VER: NONE COLLATE: DISABLED COLL RULES: NONE STRPROFILES: NONE CONVERSION: 01200(13488)-00037-E01047-01200(13488)-L 01047-01200(13488)-R01208-00037-E 01200(13488)-01047-L01200(13488)-01047-E 01208-00437-E 01208-01140-E 01208-01252-E 00037-00367-E 01252-00037-R 01252-00037-E 00037-01208-R 00037-01252-R 00037-01252-E 01252-01208-R 00367-00037-E 00037-01200(13488)-R 00819-01047-L 00819-01047-R 01047-00819-L 01047-00819-R 01200-01208-LMRE01140-01208-R -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Unicode on Demand problem
On Tue, 16 Dec 2008 11:42:30 -0600, Chase, John jch...@ussco.com wrote: -Original Message- From: IBM Mainframe Discussion List On Behalf Of Jim McAlpine On Tue, Dec 16, 2008 at 4:58 PM, Mark Zelden wrote: Jim, Do you have the SRB support APAR on? The original APAR / PTF was OA14231 / UA27251 but that one went PE and was fixed by OA19072 / UA32754 on z/OS 1.7. Mark, that looks spot on, I don't have either of those applied. You may find that, even with those fixes applied, you still need to code a CUNUNIxx member to cope with CP 1252. We had to do that at z/OS 1.7, and did not test without it when we upgraded to 1.9 so I don't know if it's still needed (doesn't seem to hurt anything). Did you open a PMR with IBM about this? We skipped 1.7, but I see that conversion in use here under 1.9 and I assume it was also used for z/OS 1.8. Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America / Farmers Insurance Group - ZFUS G-ITO mailto:mark.zel...@zurichna.com z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Unicode on Demand problem
Thanks to all who replied. Applying the fix resolved the problem. Jim McAlpine -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Unicode on Demand problem
Have you looked at the SETUNI command in MVS? It may do what you need. Have you opened an ETR to IBM? If you have established Unicode on Demand, then my understanding is that when a new code is requested, it gets built. Lizette -Original Message- From: Jim McAlpine jim.mcalp...@gmail.com Sent: Dec 16, 2008 11:48 AM To: IBM-MAIN@bama.ua.edu Subject: Unicode on Demand problem cross posted to IBM-MAIN and DB2-L. We have just converted from z/OS 1.4 to z/OS 1.7 and are now using unicode on demand. As a result one of our Java applications is failing as follows - E5MSG: 2008-12-15 17:05:01,770 DEBUG E5Config::getDatabasePrefixFor:System [M30D] Return [M30D] com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -332, SQLSTATE: 57017, SQLERRMC: 1208;1252;DSNXRST at com.ibm.db2.jcc.a.sf.d(sf.java:1396) The output of d uni,all on z/OS 1.7 shows - D UNI,ALL CUN3000I 16.24.31 UNI DISPLAY 343 ENVIRONMENT: CREATED 12/09/2008 AT 13.51.12 MODIFIED 12/15/2008 AT 17.53.52 IMAGE CREATED 12/09/2008 AT 13.51.12 SERVICE: CHARACTER CASE NORMALIZATION COLLATION STORAGE: ACTIVE116 PAGES LIMIT 524287 PAGES CASECONV: NONE NORMALIZE: DISABLED COLLATE: DISABLED CONVERSION: 01146-00367-E 01146-00367-E 01208-00285-E 01208-00500-E 01146-01208-R 01208-01146-E 00285-01208-R 00367-01146-E 00367-01146-E 00500-01208-R 01047-00819-L 01047-00819-R ie with no code page 1252. Previously for z/OS 1.4 that code page was part of an image that was built specifically for DB2 Version 8 as per apars II13048/II13049. Since CP1252 is defined in our DSNHDECP as the ASCII CCSID I would have expected that to be loaded by unicode on demand but obviously not. Is the only way round this to revert to a specific pre-built image. Seems a backward step. Jim McAlpine -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Unicode on Demand problem
On Tue, 16 Dec 2008 16:48:40 +, Jim McAlpine jim.mcalp...@gmail.com wrote: cross posted to IBM-MAIN and DB2-L. We have just converted from z/OS 1.4 to z/OS 1.7 and are now using unicode on demand. As a result one of our Java applications is failing as follows - E5MSG: 2008-12-15 17:05:01,770 DEBUG E5Config::getDatabasePrefixFor:System [M30D] Return [M30D] com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -332, SQLSTATE: 57017, SQLERRMC: 1208;1252;DSNXRST at com.ibm.db2.jcc.a.sf.d(sf.java:1396) The output of d uni,all on z/OS 1.7 shows - D UNI,ALL CUN3000I 16.24.31 UNI DISPLAY 343 ENVIRONMENT: CREATED 12/09/2008 AT 13.51.12 MODIFIED 12/15/2008 AT 17.53.52 IMAGE CREATED 12/09/2008 AT 13.51.12 SERVICE: CHARACTER CASE NORMALIZATION COLLATION STORAGE: ACTIVE116 PAGES LIMIT 524287 PAGES CASECONV: NONE NORMALIZE: DISABLED COLLATE: DISABLED CONVERSION: 01146-00367-E 01146-00367-E 01208-00285-E 01208-00500-E 01146-01208-R 01208-01146-E 00285-01208-R 00367-01146-E 00367-01146-E 00500-01208-R 01047-00819-L 01047-00819-R ie with no code page 1252. Previously for z/OS 1.4 that code page was part of an image that was built specifically for DB2 Version 8 as per apars II13048/II13049. Since CP1252 is defined in our DSNHDECP as the ASCII CCSID I would have expected that to be loaded by unicode on demand but obviously not. Is the only way round this to revert to a specific pre-built image. Seems a backward step. Jim McAlpine Jim, Do you have the SRB support APAR on? The original APAR / PTF was OA14231 / UA27251 but that one went PE and was fixed by OA19072 / UA32754 on z/OS 1.7. Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America / Farmers Insurance Group - ZFUS G-ITO mailto:mark.zel...@zurichna.com z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Unicode on Demand problem
On Tue, Dec 16, 2008 at 4:58 PM, Mark Zelden mark.zel...@zurichna.comwrote: Jim, Do you have the SRB support APAR on? The original APAR / PTF was OA14231 / UA27251 but that one went PE and was fixed by OA19072 / UA32754 on z/OS 1.7. Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America / Farmers Insurance Group - ZFUS G-ITO mailto:mark.zel...@zurichna.com z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.htmlhttp://home.flash.net/%7Emzelden/mvsutil.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html Mark, that looks spot on, I don't have either of those applied. Thanks Jim McAlpine -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Unicode on Demand problem
-Original Message- From: IBM Mainframe Discussion List On Behalf Of Jim McAlpine On Tue, Dec 16, 2008 at 4:58 PM, Mark Zelden wrote: Jim, Do you have the SRB support APAR on? The original APAR / PTF was OA14231 / UA27251 but that one went PE and was fixed by OA19072 / UA32754 on z/OS 1.7. Mark, that looks spot on, I don't have either of those applied. You may find that, even with those fixes applied, you still need to code a CUNUNIxx member to cope with CP 1252. We had to do that at z/OS 1.7, and did not test without it when we upgraded to 1.9 so I don't know if it's still needed (doesn't seem to hurt anything). Here's what we coded: BROWSESYS1.PARMLIB(CUNUNI00) - 01.01 Command === * Top of Data ** ADD FROM=37 TO=1208 ADD FROM=37 TO=1252 ADD FROM=1208 TO=1252 ADD FROM=1252 TO=1208 ADD FROM=1252 TO=37 Bottom of Data And add an entry in IEASYSxx: UNI=00 -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Unicode on Demand problem
Jim, we use unicode on demand but z/OS R9 without any problem. Perhaps you miss some service? AFAIR SRB mode was supported in the first version of unicode on demand. Maybe you should raise a PMR Roland cross posted to IBM-MAIN and DB2-L. We have just converted from z/OS 1.4 to z/OS 1.7 and are now using unicode on demand. As a result one of our Java applications is failing as follows - E5MSG: 2008-12-15 17:05:01,770 DEBUG E5Config::getDatabasePrefixFor:System [M30D] Return [M30D] com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -332, SQLSTATE: 57017, SQLERRMC: 1208;1252;DSNXRST at com.ibm.db2.jcc.a.sf.d(sf.java:1396) The output of d uni,all on z/OS 1.7 shows - D UNI,ALL CUN3000I 16.24.31 UNI DISPLAY 343 ENVIRONMENT: CREATED 12/09/2008 AT 13.51.12 MODIFIED 12/15/2008 AT 17.53.52 IMAGE CREATED 12/09/2008 AT 13.51.12 SERVICE: CHARACTER CASE NORMALIZATION COLLATION STORAGE: ACTIVE116 PAGES LIMIT 524287 PAGES CASECONV: NONE NORMALIZE: DISABLED COLLATE: DISABLED CONVERSION: 01146-00367-E 01146-00367-E 01208-00285-E 01208-00500-E 01146-01208-R 01208-01146-E 00285-01208-R 00367-01146-E 00367-01146-E 00500-01208-R 01047-00819-L 01047-00819-R ie with no code page 1252. Previously for z/OS 1.4 that code page was part of an image that was built specifically for DB2 Version 8 as per apars II13048/II13049. Since CP1252 is defined in our DSNHDECP as the ASCII CCSID I would have expected that to be loaded by unicode on demand but obviously not. Is the only way round this to revert to a specific pre-built image. Seems a backward step. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html