On Tue, 16 Dec 2008 16:48:40 +0000, 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: ACTIVE 116 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
