DB2 z/OS V8 -> 10 Migration question - a.k.a. I am being stupid?

Roy Boxwell

DB2 z/OS V8 -> 10 Migration question - a.k.a. I am being stupid?
Hi!

I am running the V8 EXPLAIN data and other migration pre-check job
DSNTIJPA and the very last report is title



= The following collection IDs and package names were bound by a =

= remote client system. After migrating to DB2 V10, when a remote =

= client system upgrades to a version that supports the flow of =

= Unicode (UTF-8) DRDA character type data, these collection IDs and =

= package names will not be found by DB2 V10. Therefore, the remote =

= client system needs to bind these collection IDs and package names =

= after it upgrades to a version that supports the flow of Unicode =

= (UTF-8) DRDA character type data to a DB2 V10 system. =



COLLID NAME
-------------------- ----------
C KVVDANBI
IIVPCOLL IIVPPG32
IIVPCOLL IIVPPG32
IIVPCOLL IIVPPG88
IIVPCOLL IIVPPG88
IQA_IDUGCOLL_610 IQADBACP
.
.
.



Can someone translate that into english please? I just dont get it.... The
way I read it is

I am going from V8 to 10 so the above collections/packages have all been
remotely bound at my local V8 DB2 - OK so far...
When another system that uses these remote packages is upgraded to V9 or
V10 then suddenly they will not find these pacakges here on my migrated
DB2 10 system? They have to "know" that my local system has "gone 10" and
then do a new bind.....weird...

Are my assumtions correct or is the report text just "genuine frontier
gibberish"???

Thanks in advance for any help...




Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: DB2 z/OS V8 -> 10 Migration question - a.k.a. I am being stupid?
(in response to Roy Boxwell)
Hi Roy

Anyway it seems from doc (it's the only reference to UTF-8 I've found):

"Existence of package names and collection IDs that contain special
characters that might cause package-not-found errors. The errors might
occur when those packages are accessed from remote client drivers that
support the sending of DRDA character type parameter data in UTF-8
Unicode. Those packages need to be bound with the ACTION(REPLACE) option
from the remote client drivers. "

But I don't see any special character in your list....Apar PM15965 could
help ?

Just an idea.

Max Scarpa
Happily passing 'The Stargate' (for DB2 10)


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Roy Boxwell

Re: DB2 z/OS V8 -> 10 Migration question - a.k.a. I am being stupid?
(in response to Max Scarpa)
Hi Max!

The apar looks excellent and I have not got it yet applied - that email
is winging its way to our sysprogs as we speak...However the real question
is "What does the text actually mean?" I really do not understand what the
report 25 title is trying to tell me... Perhaps when the APAR is applied
there will be new improved, cheaper, faster, better text and then all is
well...I will keep the list posted on this one!

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert



Max Scarpa <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
26.01.2011 15:11
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] DB2 z/OS V8 -> 10 Migration question - a.k.a. I am being
stupid?






Hi Roy

Anyway it seems from doc (it's the only reference to UTF-8 I've found):

"Existence of package names and collection IDs that contain special
characters that might cause package-not-found errors. The errors might
occur when those packages are accessed from remote client drivers that
support the sending of DRDA character type parameter data in UTF-8
Unicode. Those packages need to be bound with the ACTION(REPLACE) option
from the remote client drivers. "

But I don't see any special character in your list....Apar PM15965 could
help ?

Just an idea.

Max Scarpa
Happily passing 'The Stargate' (for DB2 10)




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: DB2 z/OS V8 -> 10 Migration question - a.k.a. I am being stupid?
(in response to Roy Boxwell)
Hi Roy

Something in (more or less) detail:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z10.doc.char/db2z_drdacharparmuni.htm

and maybe this description (search in this web page the string 'UTF':

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z10.doc.inst/db2z_relincompatapplsqlfromv9.htm

I think if you dig more in this manuals you *could* find some answer. For
sure if there's any IBMer suggesting some paper/manual she/he'd be
welcome

-69
Just my 10 cents

Max Scarpa

DB2 for z/Stargate sysprog




> Hi Max!
>
> The apar looks excellent and I have not got it yet applied - that
> email is winging its way to our sysprogs as we speak...However the
> real question is "What does the text actually mean?" I really do not
> understand what the report 25 title is trying to tell me... Perhaps
> when the APAR is applied there will be new improved, cheaper,
> faster, better text and then all is well...I will keep the list
> posted on this one!
>
> Anyway it seems from doc (it's the only reference to UTF-8 I've found):
>
> "Existence of package names and collection IDs that contain special
> characters that might cause package-not-found errors. The errors
> might occur when those packages are accessed from remote client
> drivers that support the sending of DRDA character type parameter
> data in UTF-8 Unicode. Those packages need to be bound with the
> ACTION(REPLACE) option from the remote client drivers. "
>
> But I don't see any special character in your list....Apar PM15965
> could help ?
>
> Just an idea.
>
> Max Scarpa
> Happily passing 'The Stargate' (for DB2 10)
>
>

>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.
>

> [image removed]
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Roy Boxwell

Re: DB2 z/OS V8 -> 10 Migration question - a.k.a. I am being stupid?
(in response to Max Scarpa)
yep just all about "special characters"...perhaps the report is either

a) A bit hard on what a special character is (eg A - Z and 0 - 10...)
or
b) Completely crazy

ho hum....guess I will soldier on with REXX rewrites....


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert



Max Scarpa <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
27.01.2011 10:16
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] DB2 z/OS V8 -> 10 Migration question - a.k.a. I am being
stupid?






Hi Roy

Something in (more or less) detail:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z10.doc.char/db2z_drdacharparmuni.htm


and maybe this description (search in this web page the string 'UTF':

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z10.doc.inst/db2z_relincompatapplsqlfromv9.htm


I think if you dig more in this manuals you *could* find some answer. For
sure if there's any IBMer suggesting some paper/manual she/he'd be
welcome

-69
Just my 10 cents

Max Scarpa

DB2 for z/Stargate sysprog




> Hi Max!
>
> The apar looks excellent and I have not got it yet applied - that
> email is winging its way to our sysprogs as we speak...However the
> real question is "What does the text actually mean?" I really do not
> understand what the report 25 title is trying to tell me... Perhaps
> when the APAR is applied there will be new improved, cheaper,
> faster, better text and then all is well...I will keep the list
> posted on this one!
>
> Anyway it seems from doc (it's the only reference to UTF-8 I've found):
>
> "Existence of package names and collection IDs that contain special
> characters that might cause package-not-found errors. The errors
> might occur when those packages are accessed from remote client
> drivers that support the sending of DRDA character type parameter
> data in UTF-8 Unicode. Those packages need to be bound with the
> ACTION(REPLACE) option from the remote client drivers. "
>
> But I don't see any special character in your list....Apar PM15965
> could help ?
>
> Just an idea.
>
> Max Scarpa
> Happily passing 'The Stargate' (for DB2 10)
>
>

>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.
>

> [image removed]
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv