DB2 Connect Package Names

Michael Deer

DB2 Connect Package Names
Does anyone know where I can look to find out how DB2 connect comes up
with the package names it uses? These are the packages that are in the
collection NULLID and are named SQLxxxxx. Is xxxxx a random set of
characters or is there some way to decode this to a specific release
level or server instance? I've looked at the manuals and searched the
DB2-L archive but cannot find anything on this.

I have a number of DB2 Connect servers that I would like to bind using a
different bind option. Before I can do this, I need to figure out
which packages correspond to which servers. Any ideas out there?

Mike Deer
DB2 Systems Programmer
United Airlines



Leonardo Nieva

Re: DB2 Connect Package Names
(in response to Michael Deer)
HI Michael,
Look at the topic Appendix E . List files, Bind Files and
Packages
Book : DB2 CONNECT QUICK Beginnings

Regards,
Leonardo


-----Original Message-----
From: Mike Deer [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 4:58 PM
To: [login to unmask email]
Subject: DB2 Connect Package Names

Does anyone know where I can look to find out how DB2 connect comes up
with the package names it uses? These are the packages that are in the
collection NULLID and are named SQLxxxxx. Is xxxxx a random set of
characters or is there some way to decode this to a specific release
level or server instance? I've looked at the manuals and searched the
DB2-L archive but cannot find anything on this.

I have a number of DB2 Connect servers that I would like to bind using a
different bind option. Before I can do this, I need to figure out
which packages correspond to which servers. Any ideas out there?

Mike Deer
DB2 Systems Programmer
United Airlines







**********************************************************************
The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only.

This email and any response may be monitored by Sony UK.
(05)
**********************************************************************



Dave Shapiro

Re: DB2 Connect Package Names
(in response to Leonardo Nieva)
Mike,

I looked for the same documentation a while ago. I really don't think it exists. You may be able to ask IBM regarding a particular package, but good luck getting an exhaustive list. We started keeping track of the output from running ddcspkgn @ddcsmvs.lst for each release and fixpack that we installed. ddcspkgn.exe is in the servers sqllib/bin folder.

Dave

-----Original Message-----
From: Mike Deer [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 9:58 AM
To: [login to unmask email]
Subject: DB2 Connect Package Names


Does anyone know where I can look to find out how DB2 connect comes up
with the package names it uses? These are the packages that are in the
collection NULLID and are named SQLxxxxx. Is xxxxx a random set of
characters or is there some way to decode this to a specific release
level or server instance? I've looked at the manuals and searched the
DB2-L archive but cannot find anything on this.

I have a number of DB2 Connect servers that I would like to bind using a
different bind option. Before I can do this, I need to figure out
which packages correspond to which servers. Any ideas out there?

Mike Deer
DB2 Systems Programmer
United Airlines






Michael Deer

Re: DB2 Connect Package Names
(in response to Dave Shapiro)
Thank you. We were first thinking this was some sort of randomized
name. There is some documentation in Appendix E of getting started
(thank you Leonardo), but it doenst quite jive with the packages we have
on our system. We were also hoping that each db2 connect server has
its own set of packages. Still not sure, but looks like there is
only one set of packages for a given release of db2 connect and all
servers (that are at the same release) use the same set of packages.
This means, if true, that if I change a bind option (ie: DYNAMICRULES),
it will affect all db2 connect servers running that release of connect.
I hope that isn't the case. I'll have to keep digging.

-Mike


----------
From: Shapiro.Dave
Sent: Thursday, December 20, 2001 11:34 AM
To: DB2-L
Cc: Shapiro.Dave
Subject: Re: [DB2-L] DB2 Connect Package Names

Mike,

I looked for the same documentation a while ago. I really don't
think it exists. You may be able to ask IBM regarding a particular
package, but good luck getting an exhaustive list. We started
keeping track of the output from running ddcspkgn @ddcsmvs.lst for
each release and fixpack that we installed. ddcspkgn.exe is in the
servers sqllib/bin folder.

Dave

-----Original Message-----
From: Mike Deer [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 9:58 AM
To: [login to unmask email]
Subject: DB2 Connect Package Names


Does anyone know where I can look to find out how DB2 connect comes
up
with the package names it uses? These are the packages that are in
the
collection NULLID and are named SQLxxxxx. Is xxxxx a random set
of
characters or is there some way to decode this to a specific release
level or server instance? I've looked at the manuals and searched
the
DB2-L archive but cannot find anything on this.

I have a number of DB2 Connect servers that I would like to bind
using a
different bind option. Before I can do this, I need to figure out
which packages correspond to which servers. Any ideas out there?

Mike Deer
DB2 Systems Programmer
United Airlines



visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
the list can



visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
the list can



Myron Miller

Re: DB2 Connect Package Names
(in response to Michael Deer)
Unfortunately, for OS/390, there is only one set of packages per fixpack for
all servers. So if you change any options on the binds, you impact
everyone.

-----Original Message-----
From: Mike Deer [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 2:03 PM
To: [login to unmask email]
Subject: Re: DB2 Connect Package Names


Thank you. We were first thinking this was some sort of randomized
name. There is some documentation in Appendix E of getting started
(thank you Leonardo), but it doenst quite jive with the packages we have
on our system. We were also hoping that each db2 connect server has
its own set of packages. Still not sure, but looks like there is
only one set of packages for a given release of db2 connect and all
servers (that are at the same release) use the same set of packages.
This means, if true, that if I change a bind option (ie: DYNAMICRULES),
it will affect all db2 connect servers running that release of connect.
I hope that isn't the case. I'll have to keep digging.

-Mike


----------
From: Shapiro.Dave
Sent: Thursday, December 20, 2001 11:34 AM
To: DB2-L
Cc: Shapiro.Dave
Subject: Re: [DB2-L] DB2 Connect Package Names

Mike,

I looked for the same documentation a while ago. I really don't
think it exists. You may be able to ask IBM regarding a particular
package, but good luck getting an exhaustive list. We started
keeping track of the output from running ddcspkgn @ddcsmvs.lst for
each release and fixpack that we installed. ddcspkgn.exe is in the
servers sqllib/bin folder.

Dave

-----Original Message-----
From: Mike Deer [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 9:58 AM
To: [login to unmask email]
Subject: DB2 Connect Package Names


Does anyone know where I can look to find out how DB2 connect comes
up
with the package names it uses? These are the packages that are in
the
collection NULLID and are named SQLxxxxx. Is xxxxx a random set
of
characters or is there some way to decode this to a specific release
level or server instance? I've looked at the manuals and searched
the
DB2-L archive but cannot find anything on this.

I have a number of DB2 Connect servers that I would like to bind
using a
different bind option. Before I can do this, I need to figure out
which packages correspond to which servers. Any ideas out there?

Mike Deer
DB2 Systems Programmer
United Airlines



visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
the list can



visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
the list can








[login to unmask email]

Re: DB2 Connect Package Names
(in response to Myron Miller)
Mike,

Try this link to the IBM Knowledge base

http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?last_page=list.d2w&fn=db2c021.htm



Carol Sutfin
Corporate DBA
AmSouth Bank
(205)326-5214 Fax:(205)326-5613
[login to unmask email]




"Shapiro, Dave"
<[login to unmask email] To: [login to unmask email]
CIPAL.COM> cc:
Sent by: DB2 Data Subject: Re: DB2 Connect Package Names
Base Discussion
List
<[login to unmask email]>


12/20/01 11:34 AM
Please respond to
DB2 Data Base
Discussion List





Mike,

I looked for the same documentation a while ago. I really don't think it
exists. You may be able to ask IBM regarding a particular package, but
good luck getting an exhaustive list. We started keeping track of the
output from running ddcspkgn @ddcsmvs.lst for each release and fixpack that
we installed. ddcspkgn.exe is in the servers sqllib/bin folder.

Dave

-----Original Message-----
From: Mike Deer [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 9:58 AM
To: [login to unmask email]
Subject: DB2 Connect Package Names


Does anyone know where I can look to find out how DB2 connect comes up
with the package names it uses? These are the packages that are in the
collection NULLID and are named SQLxxxxx. Is xxxxx a random set of
characters or is there some way to decode this to a specific release
level or server instance? I've looked at the manuals and searched the
DB2-L archive but cannot find anything on this.

I have a number of DB2 Connect servers that I would like to bind using a
different bind option. Before I can do this, I need to figure out
which packages correspond to which servers. Any ideas out there?

Mike Deer
DB2 Systems Programmer
United Airlines













teldb2kals

Re: DB2 Connect Package Names
(in response to csutfin@AMSOUTH.COM)
Mike,

I am sure the naming standard was mentioned in one of the manuals, but
cant remember exactly now. But the names r unique for a version. The
last 3 characters reflect the version/fixpack. And the packages r bound
in collection NULLID by default. U can use the "ddcspkgn" command to
get the list of packages for a server.

As a test, u can bind the utilities into a different collection (say
COLL01), where u specify ur own bind options. And then set the
CURRENTPACKAGESET in ur connection string in ur client code, so that it
uses the packages in COLL01. One drawback to this approach is, when u
upgrade ur Connect version, the new version's packages will not be
immediately reflected in COLL01.

I am not sure if u can make the collection COLL01 default for the
server instance itself.

Cheers,
Kals


-----Original Message-----
From: Mike Deer [SMTP:[login to unmask email]
Sent: Friday, December 21, 2001 6:03 AM
To: [login to unmask email]
Subject: Re: DB2 Connect Package Names

Thank you. We were first thinking this was some sort of randomized
name. There is some documentation in Appendix E of getting started
(thank you Leonardo), but it doenst quite jive with the packages we have
on our system. We were also hoping that each db2 connect server has
its own set of packages. Still not sure, but looks like there is
only one set of packages for a given release of db2 connect and all
servers (that are at the same release) use the same set of packages.
This means, if true, that if I change a bind option (ie: DYNAMICRULES),
it will affect all db2 connect servers running that release of connect.
I hope that isn't the case. I'll have to keep digging.

-Mike


----------
From: Shapiro.Dave
Sent: Thursday, December 20, 2001 11:34 AM
To: DB2-L
Cc: Shapiro.Dave
Subject: Re: [DB2-L] DB2 Connect Package Names

Mike,

I looked for the same documentation a while ago. I really don't
think it exists. You may be able to ask IBM regarding a particular
package, but good luck getting an exhaustive list. We started
keeping track of the output from running ddcspkgn @ddcsmvs.lst for
each release and fixpack that we installed. ddcspkgn.exe is in the
servers sqllib/bin folder.

Dave

-----Original Message-----
From: Mike Deer [mailto:[login to unmask email]
Sent: Thursday, December 20, 2001 9:58 AM
To: [login to unmask email]
Subject: DB2 Connect Package Names


Does anyone know where I can look to find out how DB2 connect comes
up
with the package names it uses? These are the packages that are in
the
collection NULLID and are named SQLxxxxx. Is xxxxx a random set
of
characters or is there some way to decode this to a specific release
level or server instance? I've looked at the manuals and searched
the
DB2-L archive but cannot find anything on this.

I have a number of DB2 Connect servers that I would like to bind
using a
different bind option. Before I can do this, I need to figure out
which packages correspond to which servers. Any ideas out there?

Mike Deer
DB2 Systems Programmer
United Airlines


----------------
Powered by telstra.com