Hello All,

we tried to set up a DB2-client for one customer.
The situation was as follows:
There are already DB2-Clients which are configured for the relevant
DB2-databanse.
We exported the client-configuration from one of these machines via db2cfexp
<filename> template.
We installed a DB2-Client on the new machine.
We imported the client-configuration-profile on the new machine via the
client configuration assistant.

On the new machine it is possible to connect to the database.
After issuing a SELECT we get the error message:

SQL0805N Package dc2j.NULLID.SQLC2D01.4141414141350 not found.

I don't know what the problem is. Where may I get information?

Thanks for Your help in advance!

Bye!
Oli

Sorry!
I forgot the versions.

DB2-Version Client we copied the configuration from: 7.2.3
DB2-Version Client we installed on the new machine: 7.2.0
DB2-Version Server: DB2 OS/390 7.1.1

Bye!
Oli

"Oliver Stratmann" <yxcsstratmoqwert@gmx.de> schrieb im Newsbeitrag
news:2nekr8F1me1U1@uni-berlin.de...
> Hello All,
>
> we tried to set up a DB2-client for one customer.
> The situation was as follows:
> There are already DB2-Clients which are configured for the relevant
> DB2-databanse.
> We exported the client-configuration from one of these machines via
db2cfexp
> <filename> template.
> We installed a DB2-Client on the new machine.
> We imported the client-configuration-profile on the new machine via the
> client configuration assistant.
>
> On the new machine it is possible to connect to the database.
> After issuing a SELECT we get the error message:
>
> SQL0805N Package dc2j.NULLID.SQLC2D01.4141414141350 not found.
>
> I don't know what the problem is. Where may I get information?
>
> Thanks for Your help in advance!
>
> Bye!
> Oli
>
>

Oliver,

you have to bind the packages to the database-server.

cd .../sqllib/bnd

db2 bind @db2cli.lst ...
db2 bind @db2bind.lst ...

regards,

Joachim Müller

"Oliver Stratmann" <yxcsstratmoqwert@gmx.de> schrieb im Newsbeitrag
news:2nelugF21fiU1@uni-berlin.de...
> Sorry!
> I forgot the versions.
>
> DB2-Version Client we copied the configuration from: 7.2.3
> DB2-Version Client we installed on the new machine: 7.2.0
> DB2-Version Server: DB2 OS/390 7.1.1
>
> Bye!
> Oli
>
> "Oliver Stratmann" <yxcsstratmoqwert@gmx.de> schrieb im Newsbeitrag
> news:2nekr8F1me1U1@uni-berlin.de...
> > Hello All,
> >
> > we tried to set up a DB2-client for one customer.
> > The situation was as follows:
> > There are already DB2-Clients which are configured for the relevant
> > DB2-databanse.
> > We exported the client-configuration from one of these machines via
> db2cfexp
> > <filename> template.
> > We installed a DB2-Client on the new machine.
> > We imported the client-configuration-profile on the new machine via the
> > client configuration assistant.
> >
> > On the new machine it is possible to connect to the database.
> > After issuing a SELECT we get the error message:
> >
> > SQL0805N Package dc2j.NULLID.SQLC2D01.4141414141350 not found.
> >
> > I don't know what the problem is. Where may I get information?
> >
> > Thanks for Your help in advance!
> >
> > Bye!
> > Oli
> >
> >
>
>

Hello Joachim,

Thanks for Your help.
We got the following error-messages:

-- START QUOTE

LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.

LINE MESSAGES FOR db2ajgrt.bnd
------ --------------------------------------------------------------------
SQL0551N "S052RESV" does not have the privilege to perform
operation "BIND" on object "DC2J.NULLID.SQLABD01".
SQLSTATE=42501

LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0040N An error occurred on one or more bind files in list
"db2ubind.lst". The following files were not bound: "1".
SQL0082C An error has occurred which has terminated
processing.
SQL0091N Binding was ended with "3" errors and "0" warnings.

-- END QUOTE

Do we need DBA-rights to perform this on our client-machine?
Could it be enough to be a Administrator of the client-machine itself?

Thanks for Your help in advance!

Bye!
Oli

"Joachim Müller" <jom0309@douglas-informatik.de> schrieb im Newsbeitrag
news:cete7o$t0b$1@news.dtag.de...
> Oliver,
>
> you have to bind the packages to the database-server.
>
> cd .../sqllib/bnd
>
> db2 bind @db2cli.lst ...
> db2 bind @db2bind.lst ...
>
> regards,
>
> Joachim Müller
>
> "Oliver Stratmann" <yxcsstratmoqwert@gmx.de> schrieb im Newsbeitrag
> news:2nelugF21fiU1@uni-berlin.de...
> > Sorry!
> > I forgot the versions.
> >
> > DB2-Version Client we copied the configuration from: 7.2.3
> > DB2-Version Client we installed on the new machine: 7.2.0
> > DB2-Version Server: DB2 OS/390 7.1.1
> >
> > Bye!
> > Oli
> >
> > "Oliver Stratmann" <yxcsstratmoqwert@gmx.de> schrieb im Newsbeitrag
> > news:2nekr8F1me1U1@uni-berlin.de...
> > > Hello All,
> > >
> > > we tried to set up a DB2-client for one customer.
> > > The situation was as follows:
> > > There are already DB2-Clients which are configured for the relevant
> > > DB2-databanse.
> > > We exported the client-configuration from one of these machines via
> > db2cfexp
> > > <filename> template.
> > > We installed a DB2-Client on the new machine.
> > > We imported the client-configuration-profile on the new machine via
the
> > > client configuration assistant.
> > >
> > > On the new machine it is possible to connect to the database.
> > > After issuing a SELECT we get the error message:
> > >
> > > SQL0805N Package dc2j.NULLID.SQLC2D01.4141414141350 not found.
> > >
> > > I don't know what the problem is. Where may I get information?
> > >
> > > Thanks for Your help in advance!
> > >
> > > Bye!
> > > Oli
> > >
> > >
> >
> >
>
>

Oliver Stratmann wrote:
> Hello Joachim,
>
> Thanks for Your help.
> We got the following error-messages:
>
> -- START QUOTE
>
> LINE MESSAGES FOR db2ubind.lst
> ------ --------------------------------------------------------------------
> SQL0061W The binder is in progress.
>
> LINE MESSAGES FOR db2ajgrt.bnd
> ------ --------------------------------------------------------------------
> SQL0551N "S052RESV" does not have the privilege to perform
> operation "BIND" on object "DC2J.NULLID.SQLABD01".
> SQLSTATE=42501
>
> LINE MESSAGES FOR db2ubind.lst
> ------ --------------------------------------------------------------------
> SQL0040N An error occurred on one or more bind files in list
> "db2ubind.lst". The following files were not bound: "1".
> SQL0082C An error has occurred which has terminated
> processing.
> SQL0091N Binding was ended with "3" errors and "0" warnings.
>
> -- END QUOTE
>
> Do we need DBA-rights to perform this on our client-machine?
> Could it be enough to be a Administrator of the client-machine itself?
>

First of all, you need to bind the correct packages for the mainframe -
i.e.

db2 bind @ddcsmvs.lst ...

You will need your MainFrame DBA's assistance to bind these packages --
you'll need to do this for each database on the mainframe that you will
connect to.

FYI, you only need to do this once per database / client code release
combination -- so you won't have to do this on all of your clients,
but the binds need to be done from both the 7.2.3 client (which may
already be working), and the 7.2.0 client.





-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Ian wrote:

> You will need your MainFrame DBA's assistance to bind these packages --
> you'll need to do this for each database on the mainframe that you will
----------------------------------********-------------------------------

....

> FYI, you only need to do this once per database / client code release
-----------------------------------------********------------------------

I think on z/OS database is an logical grouping; did you mean "for each location"?

Jan M. Nelken

Oliver Stratmann wrote:
> Sorry!
> I forgot the versions.
>
> DB2-Version Client we copied the configuration from: 7.2.3
> DB2-Version Client we installed on the new machine: 7.2.0
> DB2-Version Server: DB2 OS/390 7.1.1
>
> Bye!
> Oli
>
> "Oliver Stratmann" <yxcsstratmoqwert@gmx.de> schrieb im Newsbeitrag
> news:2nekr8F1me1U1@uni-berlin.de...
>
>>Hello All,
>>
>>we tried to set up a DB2-client for one customer.
>>The situation was as follows:
>>There are already DB2-Clients which are configured for the relevant
>>DB2-databanse.
>>We exported the client-configuration from one of these machines via
>
> db2cfexp
>
>><filename> template.
>>We installed a DB2-Client on the new machine.
>>We imported the client-configuration-profile on the new machine via the
>>client configuration assistant.
>>
>>On the new machine it is possible to connect to the database.
>>After issuing a SELECT we get the error message:
>>
>>SQL0805N Package dc2j.NULLID.SQLC2D01.4141414141350 not found.
>>
>>I don't know what the problem is. Where may I get information?
>>
>>Thanks for Your help in advance!
>>
>>Bye!
>>Oli
>>
>>
>
>
>
Every time you install a fixpack or introduce a new Client version, you
need to bind a set of packages. In the Client Configuration Assistant,
select the target database and click on the BIND button on the right.

Norm