DB2 for z/OS V8 - package name

Jim McAlpine

DB2 for z/OS V8 - package name
In the following message -

DSNT232I + SUCCESSFUL BIND FOR
PACKAGE = REMOTE_DB2B.CH30D.HZSE.(VFG1)
what does the VFG1 refer to.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Jim McAlpine

DB2 for z/OS V8 - package name
(in response to Roy Boxwell)
In the following message -

DSNT232I + SUCCESSFUL BIND FOR
PACKAGE = REMOTE_DB2B.CH30D.HZSE.(VFG1)
what does the VFG1 refer to.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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 for z/OS V8 - package name
(in response to Jim McAlpine)
The VERSION is my best friday afternoon guess...shortly before I depart
the office, take my blue pill, quaff my beer and eat my chips....

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



Jim McAlpine <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
14.01.2011 16:24
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
[DB2-L] DB2 for z/OS V8 - package name






In the following message -

DSNT232I + SUCCESSFUL BIND FOR
PACKAGE = REMOTE_DB2B.CH30D.HZSE.(VFG1)
what does the VFG1 refer to.

Jim McAlpine



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. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Jim McAlpine

Re: DB2 for z/OS V8 - package name
(in response to Jim McAlpine)
On Fri, Jan 14, 2011 at 3:26 PM, Roy Boxwell <[login to unmask email]> wrote:

>
> The VERSION is my best friday afternoon guess...shortly before I depart the
> office, take my blue pill, quaff my beer and eat my chips....
> *
> Roy Boxwell*
>


OK then, supplementary question. If I want to compile, link and bind the
same program to a CICS load library and an IMS load library and execute them
both against the same DB2 subsystem can I use a different package version to
accomplish this. Or should I use some other method.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Michael Turner

Re: DB2 for z/OS V8 - package name
(in response to Jim McAlpine)
Yes, its the version, as described in the messages manual under DSNT232I: package-name Name of the package in the following format: 'location.collection.package.(version)'.

Regards
Mike Turner
Email: [login to unmask email]
Tel: +44 (0)1565-873702
Web: www.michael-turner.ltd.uk
Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44.
----- Original Message -----
From: Roy Boxwell
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Friday, January 14, 2011 3:26 PM
Subject: Re: [DB2-L] DB2 for z/OS V8 - package name



The VERSION is my best friday afternoon guess...shortly before I depart the office, take my blue pill, quaff my beer and eat my chips....

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


Jim McAlpine <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
14.01.2011 16:24 Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An [login to unmask email]
Kopie
Thema [DB2-L] DB2 for z/OS V8 - package name







In the following message -

DSNT232I + SUCCESSFUL BIND FOR
PACKAGE = REMOTE_DB2B.CH30D.HZSE.(VFG1)
what does the VFG1 refer to.

Jim McAlpine


------------------------------------------------------------------------------


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 North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Jim McAlpine

Re: DB2 for z/OS V8 - package name
(in response to Michael Turner)
On Fri, Jan 14, 2011 at 3:42 PM, Mike Turner <[login to unmask email]> wrote:

> Yes, its the version, as described in the messages manual under DSNT232I:
> *package-name *Name of the package in the following format:
> 'location.collection.package.(version)'.
>
> Regards
> Mike Turner
>

Thanks, I did RTFM but for messages DSNT254I and DSN255I which didn't give
the format info above. Bummer.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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 for z/OS V8 - package name
(in response to Jim McAlpine)
You will enter a "world of pain" trying to do all that! A while ago some
other lister wrote up how they have written a universal connector and then
call the correct environment from within thus allowing mixed environment
calls with the same program. (Or you can wait for DB2 10 and the Universal
call stub) Of course if run with the same RLI and IMS has no complaints (I
havent worked with IMS for *years*) then you can have different versions
but the load libs must be correctly matched and of course the correct
versions bound.
On a personal note I *hate* versioning - All it does it create tons of
junk packages in the catalog that no-one remembers to manually FREE which
all have DB2 dependancies that then cause automatic and semi-automatic
rebinds which locks the catalog just as you are doing a production spufi
ALTER....and then it all goes pear shaped.... Yep I really really hate
versioning! If IBM removed it tomorrow I would buy 'em all a beer!


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



Jim McAlpine <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
14.01.2011 16:38
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] DB2 for z/OS V8 - package name






On Fri, Jan 14, 2011 at 3:26 PM, Roy Boxwell <[login to unmask email]> wrote:

The VERSION is my best friday afternoon guess...shortly before I depart
the office, take my blue pill, quaff my beer and eat my chips....

Roy Boxwell


OK then, supplementary question. If I want to compile, link and bind the
same program to a CICS load library and an IMS load library and execute
them both against the same DB2 subsystem can I use a different package
version to accomplish this. Or should I use some other method.

Jim McAlpine



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 *
* 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

Jim McAlpine

Re: DB2 for z/OS V8 - package name
(in response to Roy Boxwell)
On Mon, Jan 17, 2011 at 9:27 AM, Roy Boxwell <[login to unmask email]> wrote:

>
> You will enter a "world of pain" trying to do all that! A while ago some
> other lister wrote up how they have written a universal connector and then
> call the correct environment from within thus allowing mixed environment
> calls with the same program. (Or you can wait for DB2 10 and the Universal
> call stub) Of course if run with the same RLI and IMS has no complaints (I
> havent worked with IMS for *years*) then you can have different versions but
> the load libs must be correctly matched and of course the correct versions
> bound.
> On a personal note I *hate* versioning - All it does it create tons of junk
> packages in the catalog that no-one remembers to manually FREE which all
> have DB2 dependancies that then cause automatic and semi-automatic rebinds
> which locks the catalog just as you are doing a production spufi
> ALTER....and then it all goes pear shaped.... Yep I really really hate
> versioning! If IBM removed it tomorrow I would buy 'em all a beer!
>
> *
> Roy Boxwell*
> SOFTWARE ENGINEERING GMBH
> -Product Development-*
> *
>

I've not explained my problem sufficiently. I need to connect to the same
DB2 subsystem and same set of tables from both a program in a CICS loadlib
and a program in an IMS loadlib. Both programs have the same name an the
source is identical (apart from the CICS/IMS bits). So I therefore need to
be able to bind the package with the same program name twice. Is using
versioning the way to achieve this.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Mike Bell

Re: DB2 for z/OS V8 - package name
(in response to Jim McAlpine)

Cutting out the previous messae - short answers
1. yes, it can be done
2. no, it does not require versioning
3. yes, it does require custome link-edit process
4. depending on you source management tool, you may have to implement it
with versioning.

The basic issue is the version of DSNHLI that is included in the run time
module.

You can
1. convert all the calls to dynamic calls and make sure that the correct
DSNHLI is first for the correct implementation. This will let you use the
same load module for all environments.
2. link edit the program two times - once into the CICS library with DSNCLI
(for the DSNHLI entry point) and another into the IMS library with DFSLI00?
(for the IMS DSNHLI entry point). You now have 2 copies of the same load
module and you have to remember to change both of them.
3. compile the same source two times (once as CICS and another as IMS) and
hope the load module ends up in the correct places. This would require
versioning because each load module will have a different contoken.
4. Create a 'magic' DSNHLI stub that will look around, decide if it is
running in CICS or IMS and then call the correct DSNHLI entry point. I have
seen this debated at several companies but I never participated in one.
There is no standard IBM documented call that will tell you what environment
you are running in.

Note, options 2 and 3 will NOT make you a favored son of any source
management group. Either they will have to create a new structure that
supports splitting copies of a load module into mulitple locations or the
source management tool will never have full and complete information to
rebuild a module. This is a very old topic. I haven't seen it for years but
it looks like new people are running into old limitations.

Mike
HLS Technologies

-

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Jim McAlpine

Re: DB2 for z/OS V8 - package name
(in response to Mike Bell)
On Tue, Jan 18, 2011 at 1:49 PM, Mike Bell <[login to unmask email]> wrote:

>
> Cutting out the previous messae - short answers
> 1. yes, it can be done
> 2. no, it does not require versioning
> 3. yes, it does require custome link-edit process
> 4. depending on you source management tool, you may have to implement it
> with versioning.
>
> The basic issue is the version of DSNHLI that is included in the run time
> module.
>
> You can
> 1. convert all the calls to dynamic calls and make sure that the correct
> DSNHLI is first for the correct implementation. This will let you use the
> same load module for all environments.
> 2. link edit the program two times - once into the CICS library with DSNCLI
> (for the DSNHLI entry point) and another into the IMS library with DFSLI00?
> (for the IMS DSNHLI entry point). You now have 2 copies of the same load
> module and you have to remember to change both of them.
> 3. compile the same source two times (once as CICS and another as IMS) and
> hope the load module ends up in the correct places. This would require
> versioning because each load module will have a different contoken.
> 4. Create a 'magic' DSNHLI stub that will look around, decide if it is
> running in CICS or IMS and then call the correct DSNHLI entry point. I
> have
> seen this debated at several companies but I never participated in one.
> There is no standard IBM documented call that will tell you what
> environment
> you are running in.
>
> Note, options 2 and 3 will NOT make you a favored son of any source
> management group. Either they will have to create a new structure that
> supports splitting copies of a load module into mulitple locations or the
> source management tool will never have full and complete information to
> rebuild a module. This is a very old topic. I haven't seen it for years but
> it looks like new people are running into old limitations.
>
> Mike
> HLS Technologies
>
> -
>
> Mike, I don't have a problem with the CICS/IMS bits. I can compile and
link both programs to their respective loadlibs with the necessary CICS/IMS
bits included, no problem. The only problem I have is being able to
identify the 2 different packages to the DB2 subsystem which is the same for
both programs.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Mike Bell

Re: DB2 for z/OS V8 - package name
(in response to Jim McAlpine)
Step 1 - how does DB2 identify the correct package?

In the precompile SQL statements are removed (well commented out) and if
the statement requires DB2 processing, a call to DSNHLI is generated. The
parms to the DSNHLI call are generally called a PLIST. The mapping macro for
a PLIST is SDSNMACS(DSNXRDI). Part of the Plist is
1. the member name for the DBRM
2. the CONTOKEN value (connection token) which is a 8 byte unique value that
is generated at the time of the precompile. Yes, it is derived from the STCK
format but that really doesn't matter.

NOTE - the VERSION is generated at the same time but it is only placed in
the DBRM. The PLIST doesn't know or care about versioning.

So, at run time, DB2
1. already knows the plan name - that has to be specified for the
connection.
2. has the DBRM name and the contoken value from the PLIST.
3. searches the package list for that combination.

Now, for my options 1 and 2, the precompile only happened one time. This
means there is only one value for CONTOKEN. That means versioning is NOT
required.

Option 3 involves 2 precompiles, once in the CICS style link edit coming out
the end and the other with IMS link edit coming out the back. Now you have
two CONTOKEN values and to implement both load modules, you will have to use
versioning.

And, yes some of us have spent way to much time debugging DB2 calls.

Mike
HLS Technologies

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Tuesday, January 18, 2011 8:27 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS V8 - package name

On Tue, Jan 18, 2011 at 1:49 PM, Mike Bell <[login to unmask email]> wrote:



Cutting out the previous messae - short answers
1. yes, it can be done
2. no, it does not require versioning
3. yes, it does require custome link-edit process
4. depending on you source management tool, you may have to
implement it
with versioning.

The basic issue is the version of DSNHLI that is included in the run
time
module.

You can
1. convert all the calls to dynamic calls and make sure that the
correct
DSNHLI is first for the correct implementation. This will let you
use the
same load module for all environments.
2. link edit the program two times - once into the CICS library with
DSNCLI
(for the DSNHLI entry point) and another into the IMS library with
DFSLI00?
(for the IMS DSNHLI entry point). You now have 2 copies of the same
load
module and you have to remember to change both of them.
3. compile the same source two times (once as CICS and another as
IMS) and
hope the load module ends up in the correct places. This would
require
versioning because each load module will have a different contoken.
4. Create a 'magic' DSNHLI stub that will look around, decide if it
is
running in CICS or IMS and then call the correct DSNHLI entry point.
I have
seen this debated at several companies but I never participated in
one.
There is no standard IBM documented call that will tell you what
environment
you are running in.

Note, options 2 and 3 will NOT make you a favored son of any source
management group. Either they will have to create a new structure
that
supports splitting copies of a load module into mulitple locations
or the
source management tool will never have full and complete information
to
rebuild a module. This is a very old topic. I haven't seen it for
years but
it looks like new people are running into old limitations.

Mike
HLS Technologies

-



Mike, I don't have a problem with the CICS/IMS bits. I can compile and
link both programs to their respective loadlibs with the necessary CICS/IMS
bits included, no problem. The only problem I have is being able to
identify the 2 different packages to the DB2 subsystem which is the same for
both programs.

Jim McAlpine

________________________________


Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.
< http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Adrian Collett

Re: DB2 for z/OS V8 - package name
(in response to Mike Bell)
Jim,

I may be missing something really deep here.....but how about using different collections ???
One for the IMS package and one for the CICS package ??

Just a thought,
Ciao,
Adrian Collett





Il 18/01/2011 3:27 PM, Jim McAlpine ha scritto:


Mike,  I don't have a problem with the CICS/IMS bits.  I can compile and link both programs to their respective loadlibs with the necessary CICS/IMS bits included, no problem.  The only problem I have is being able to identify the 2 different packages to the DB2 subsystem which is the same for both programs.
 
Jim McAlpine


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.

Roy Boxwell

Re: DB2 for z/OS V8 - package name
(in response to Adrian Collett)
"great minds think alike" - That was just what I was going to send! Simply
two collections and bobs-your-related-male-person!

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



Adrian <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
18.01.2011 16:00
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] DB2 for z/OS V8 - package name






Jim,

I may be missing something really deep here.....but how about using
different collections ???
One for the IMS package and one for the CICS package ??

Just a thought,
Ciao,
Adrian Collett





Il 18/01/2011 3:27 PM, Jim McAlpine ha scritto:


Mike, I don't have a problem with the CICS/IMS bits. I can compile and
link both programs to their respective loadlibs with the necessary
CICS/IMS bits included, no problem. The only problem I have is being able
to identify the 2 different packages to the DB2 subsystem which is the
same for both programs.

Jim McAlpine



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 North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Jim McAlpine

Re: DB2 for z/OS V8 - package name
(in response to Roy Boxwell)
On Tue, Jan 18, 2011 at 3:00 PM, Adrian <[login to unmask email]> wrote:

> Jim,
>
> I may be missing something really deep here.....but how about using
> different collections ???
> One for the IMS package and one for the CICS package ??
>
> Just a thought,
> Ciao,
> Adrian Collett
>
>
>
>
Adrian, it's not easy for me to specify the collection id (please don't
ask) but I can easily specify the version. So the question remains, will
using different versions do what I want.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Sysdba AHE

Re: DB2 for z/OS V8 - package name
(in response to Jim McAlpine)
I don't understand.
Why don't you just give them different names?

---------------------------------------------------------------------------------------------------------------
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.
If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system.
If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
Please consider the environmental impact before printing this document and its attachment(s). Print black and white and double-sided where possible.
------------------------------------------------------------------------------

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Jim McAlpine

Re: DB2 for z/OS V8 - package name
(in response to Sysdba AHE)
On Tue, Jan 18, 2011 at 4:22 PM, Sysdba AHE <[login to unmask email]> wrote:

>
> I don't understand.
> Why don't you just give them different names?
>
>
> ---------------------------------------------------------------------------------------------------------------
>
Give what different names ???

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Adrian Collett

Re: DB2 for z/OS V8 - package name
(in response to Jim McAlpine)
Jim,

OK I won't ask :-)

I think using different Versions will do exactly what you want.
To keep it simple(me all over) you could just use 'CICS' and 'IMS' as the version ids to avoid proliferation....so you wouldn't need to worry about cleaning up old packages...,

HTH,
Ciao,
Adrian



Il 18/01/2011 5:14 PM, Jim McAlpine ha scritto:
On Tue, Jan 18, 2011 at 3:00 PM, Adrian <[login to unmask email]> wrote:
Jim,

I may be missing something really deep here.....but how about using different collections ???
One for the IMS package and one for the CICS package ??

Just a thought,
Ciao,
Adrian Collett



 
Adrian,  it's not easy for me to specify the collection id (please don't ask) but I can easily specify the version.  So the question remains, will using different versions do what I want.
 
Jim McAlpine 


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.

Sysdba AHE

Re: DB2 for z/OS V8 - package name
(in response to Adrian Collett)
Hi Jim

Why do they have to be the same package name?
Compile as proga for IMS and progb for CICS with different package names
accordingly.

Graham Clarke





Jim McAlpine <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
18/01/2011 16:27
Please respond to IDUG DB2-L

To: [login to unmask email]
cc:
Subject: Re: [DB2-L] DB2 for z/OS V8 - package name

Give what different names ???




---------------------------------------------------------------------------------------------------------------
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.
If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system.
If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
Please consider the environmental impact before printing this document and its attachment(s). Print black and white and double-sided where possible.
------------------------------------------------------------------------------

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Mike Bell

Re: DB2 for z/OS V8 - package name
(in response to Sysdba AHE)
Lets try a couple on sample configurations out.


Program name = testxxxx , for good programming practices DBRM name is also
testxxxx.

NOTE, DBRM name is what is included in the PLIST not the program source
name, not the CSECT, and not the composite load name.


Option 1.

For IMS, precompile (no versioning), compile and

BIND PACKAGE(imscoll) MEMBER (testxxxx)

LKED the result module into IMS library.

For CIS, precompile (no versioning), compile and

BIND PACKAGE(cicscoll) MEMBER (testxxxx)

LKED the result module into CICS library.

The result is 2 modules with two different CONTOKEN values and it you bind
the PLAN for the program calling testxxxx with the correct collection it
will all work.

NOTE - I did not make an effort to save the DBRM from the IMS version, if
you only have one DBRM library, it is toast (but lives in the DB2 catalog in
imscoll.testxxxx).

Option 2

For IMS, precompile (version AUTO), compile and

BIND PACKAGE(shrcoll) MEMBER (testxxxx)

LKED the result module into IMS library.

For CIS, precompile (version AUTO), compile and

BIND PACKAGE(shrcoll) MEMBER (testxxxx)

LKED the result module into CICS library.

The result is 2 modules with two different CONTOKEN values and it you only
have bind the PLAN for the program calling testxxxx with collection shrcoll
and it will still all work.

Now I have two version's in collection shrcoll. And I still didn't try to
save the physical DBRM from the IMS version, yada, yada,

It is pretty much defined by the capabilities of whatever tool you use for
production source and compiles.

The important variables are.
1. CONTOKEN value
2. DBRM name
3. LKED to the correct DSNHLI

Mike
HLS technologies



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Tuesday, January 18, 2011 10:27 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS V8 - package name

On Tue, Jan 18, 2011 at 4:22 PM, Sysdba AHE <[login to unmask email]> wrote:



I don't understand.
Why don't you just give them different names?




----------------------------------------------------------------------------
-----------------------------------


Give what different names ???

Jim McAlpine







________________________________


Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.
< http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Jim McAlpine

Re: DB2 for z/OS V8 - package name
(in response to Mike Bell)
On Tue, Jan 18, 2011 at 4:35 PM, Sysdba AHE <[login to unmask email]> wrote:

>
> Hi Jim
>
> Why do they have to be the same package name?
> Compile as proga for IMS and progb for CICS with different package names
> accordingly.
>
> Graham Clarke
>
>
> Graham, because that is the whole point of the exercise. The programs are
part of a commercial software package that runs under both CICS and IMS. I
don't have the possibility of changing the program names.

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Mike Bell

Re: DB2 for z/OS V8 - package name
(in response to Jim McAlpine)
If they are part of a comercial package, you should already have a mass
link edit process for the install and I don't see the issue.

Precompile, compile one time - one dbrm - one NCAL load module.

At installation time - LKED all the DB2 modules with correct DSNHLI.
BIND all the DBRM's into a collection.

For IMS, use the IMS loadlib with correct DSNHLI.

For CICS, use the CICS loadlib with correct DSNHLI.

What am I missing? Or do you ship composite load modules?

Mike



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Tuesday, January 18, 2011 10:59 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS V8 - package name

On Tue, Jan 18, 2011 at 4:35 PM, Sysdba AHE <[login to unmask email]> wrote:



Hi Jim

Why do they have to be the same package name?
Compile as proga for IMS and progb for CICS with different package
names accordingly.

Graham Clarke




Graham, because that is the whole point of the exercise. The programs are
part of a commercial software package that runs under both CICS and IMS. I
don't have the possibility of changing the program names.

Jim McAlpine

________________________________


Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.
< http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Jim McAlpine

Re: DB2 for z/OS V8 - package name
(in response to Mike Bell)
On Tue, Jan 18, 2011 at 5:22 PM, Mike Bell <[login to unmask email]> wrote:

> If they are part of a comercial package, you should already have a mass
> link edit process for the install and I don't see the issue.
>
> Precompile, compile one time - one dbrm - one NCAL load module.
>
> At installation time - LKED all the DB2 modules with correct DSNHLI.
> BIND all the DBRM's into a collection.
>
> For IMS, use the IMS loadlib with correct DSNHLI.
>
> For CICS, use the CICS loadlib with correct DSNHLI.
>
> What am I missing? Or do you ship composite load modules?
>
> Mike
>
>
>
>
You aren't missing anything. I've already stated a number of times that the
compile/link side of things is not a problem, only the fact that I need to
bind both packages to the same DB2 subsystem. Your last post answered my
original question regarding versioning.

Thanks

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Michael Turner

Re: DB2 for z/OS V8 - package name
(in response to Jim McAlpine)
Hi Jim

I think the important thing about Mike B's suggestion below is that you only need one package, not two. There is nothing in the package that is CICS or IMS specific. All the CICS or IMS specific stuff is in the load module.

Regards
Mike Turner
Email: [login to unmask email]
Tel: +44 (0)1565-873702
Web: www.michael-turner.ltd.uk
Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44.
----- Original Message -----
From: Jim McAlpine
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Tuesday, January 18, 2011 5:29 PM
Subject: Re: [DB2-L] DB2 for z/OS V8 - package name


On Tue, Jan 18, 2011 at 5:22 PM, Mike Bell <[login to unmask email]> wrote:

If they are part of a comercial package, you should already have a mass
link edit process for the install and I don't see the issue.

Precompile, compile one time - one dbrm - one NCAL load module.

At installation time - LKED all the DB2 modules with correct DSNHLI.
BIND all the DBRM's into a collection.

For IMS, use the IMS loadlib with correct DSNHLI.

For CICS, use the CICS loadlib with correct DSNHLI.

What am I missing? Or do you ship composite load modules?

Mike




You aren't missing anything. I've already stated a number of times that the compile/link side of things is not a problem, only the fact that I need to bind both packages to the same DB2 subsystem. Your last post answered my original question regarding versioning.

Thanks

Jim McAlpine


------------------------------------------------------------------------------



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. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Michael Turner

Re: DB2 for z/OS V8 - package name
(in response to Michael Turner)
Hi Jim

I just went back and read one of your previous posts where you described the original problem:
>>
I've not explained my problem sufficiently. I need to connect to the same DB2 subsystem and same set of tables from both a program in a CICS loadlib and a program in an IMS loadlib. Both programs have the same name an the source is identical (apart from the CICS/IMS bits). So I therefore need to be able to bind the package with the same program name twice. Is using versioning the way to achieve this.
<<

I now see that Mike B's solution will not work for you as you have, in effect, 2 different programs with the same name, the differences being the CICS/IMS bits.

I also see from a later post that you cannot specify the collection ID in the plan or plans which scuppers my preferred alternative solution. You said 'don't ask', so I won't!

Regards
Mike Turner
Email: [login to unmask email]
Tel: +44 (0)1565-873702
Web: www.michael-turner.ltd.uk
Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44.
----- Original Message -----
From: Mike Turner
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Tuesday, January 18, 2011 5:39 PM
Subject: Re: [DB2-L] DB2 for z/OS V8 - package name


Hi Jim

I think the important thing about Mike B's suggestion below is that you only need one package, not two. There is nothing in the package that is CICS or IMS specific. All the CICS or IMS specific stuff is in the load module.

Regards
Mike Turner
Email: [login to unmask email]
Tel: +44 (0)1565-873702
Web: www.michael-turner.ltd.uk
Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44.
----- Original Message -----
From: Jim McAlpine
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Tuesday, January 18, 2011 5:29 PM
Subject: Re: [DB2-L] DB2 for z/OS V8 - package name


On Tue, Jan 18, 2011 at 5:22 PM, Mike Bell <[login to unmask email]> wrote:

If they are part of a comercial package, you should already have a mass
link edit process for the install and I don't see the issue.

Precompile, compile one time - one dbrm - one NCAL load module.

At installation time - LKED all the DB2 modules with correct DSNHLI.
BIND all the DBRM's into a collection.

For IMS, use the IMS loadlib with correct DSNHLI.

For CICS, use the CICS loadlib with correct DSNHLI.

What am I missing? Or do you ship composite load modules?

Mike




You aren't missing anything. I've already stated a number of times that the compile/link side of things is not a problem, only the fact that I need to bind both packages to the same DB2 subsystem. Your last post answered my original question regarding versioning.

Thanks

Jim McAlpine


----------------------------------------------------------------------------



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 North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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