By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

problem setting up a client

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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" <yx**************@gmx.de> schrieb im Newsbeitrag
news:2n***********@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

Nov 12 '05 #2

P: n/a
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" <yx**************@gmx.de> schrieb im Newsbeitrag
news:2n***********@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" <yx**************@gmx.de> schrieb im Newsbeitrag
news:2n***********@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


Nov 12 '05 #3

P: n/a
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" <jo*****@douglas-informatik.de> schrieb im Newsbeitrag
news:ce**********@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" <yx**************@gmx.de> schrieb im Newsbeitrag
news:2n***********@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" <yx**************@gmx.de> schrieb im Newsbeitrag
news:2n***********@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



Nov 12 '05 #4

P: n/a
Ian
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! =-----
Nov 12 '05 #5

P: n/a
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
Nov 12 '05 #6

P: n/a
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" <yx**************@gmx.de> schrieb im Newsbeitrag
news:2n***********@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
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.