DB2 Connect, Bind Error

Steve Grimes

DB2 Connect, Bind Error
Hello,

We get repeated messages similar to the following when we attempt to bind
DB2 connect on our Peoplesoft Application Server. Any thoughts?

LINE MESSAGES FOR db2arxcs.bnd
------
--------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0031C File "C:\PROGRA~1\SQLLIB\BND\db2arxcs.bnd" could
not be opened.
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.

Thanks in advance!

Stg



Dave Shapiro

Re: DB2 Connect, Bind Error
(in response to Steve Grimes)
Steve,

You've probably looked at this already but..double-check your path, and file permissions. Try and open the file in notepad first?

SQL0031C File "<name>" could not be
opened.
Explanation: The file "<name>" is required but
could not be opened.
Precompilation is terminated.
User Response: Ensure that the file name
specified is correct and exists in the file system,
and that the file permissions are correct.

Dave

-----Original Message-----
From: [login to unmask email]
[mailto:[login to unmask email]
Sent: Tuesday, September 24, 2002 3:32 PM
To: [login to unmask email]
Subject: DB2 Connect, Bind Error


Hello,

We get repeated messages similar to the following when we attempt to bind
DB2 connect on our Peoplesoft Application Server. Any thoughts?

LINE MESSAGES FOR db2arxcs.bnd
------
--------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0031C File "C:\PROGRA~1\SQLLIB\BND\db2arxcs.bnd" could
not be opened.
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.

Thanks in advance!

Stg






Steve Grimes

Re: DB2 Connect, Bind Error
(in response to Dave Shapiro)
Hi there.

Thanks for the suggestions. I should provided that detail in my original
note. Yes, we could open the files, from the location that came from the
message, using UltraEdit. (A great product, btw.) We eventually found
error messages both on our DB2 Connect server and in the DDF address space,
so we cycled them both. This seemed to clear up everything. I'm still
not sure why it happened, but I'm back to being fat, dumb and happy! :-)

Thanks again.

Stg



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


09/25/2002 10:32
AM
Please respond to
DB2 Data Base
Discussion List






Steve,

You've probably looked at this already but..double-check your path, and
file permissions. Try and open the file in notepad first?

SQL0031C File "<name>" could not be
opened.
Explanation: The file "<name>" is required but
could not be opened.
Precompilation is terminated.
User Response: Ensure that the file name
specified is correct and exists in the file system,
and that the file permissions are correct.

Dave

-----Original Message-----
From: [login to unmask email]
[mailto:[login to unmask email]
Sent: Tuesday, September 24, 2002 3:32 PM
To: [login to unmask email]
Subject: DB2 Connect, Bind Error


Hello,

We get repeated messages similar to the following when we attempt to bind
DB2 connect on our Peoplesoft Application Server. Any thoughts?

LINE MESSAGES FOR db2arxcs.bnd
------
--------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0031C File "C:\PROGRA~1\SQLLIB\BND\db2arxcs.bnd" could
not be opened.
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.

Thanks in advance!

Stg



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



http://listserv.ylassoc.com. The owners of the list can be reached at
[login to unmask email]



Jodi Murawski

Re: DB2 Connect, Bind Error
(in response to Steve Grimes)
Give me a call when you get in on Thursday.

Jodi




[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
09/24/2002 03:31 PM
Please respond to DB2 Data Base Discussion List


To: [login to unmask email]
cc:
Subject: DB2 Connect, Bind Error


Hello,

We get repeated messages similar to the following when we attempt to bind
DB2 connect on our Peoplesoft Application Server. Any thoughts?

LINE MESSAGES FOR db2arxcs.bnd
------
--------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0031C File "C:\PROGRA~1\SQLLIB\BND\db2arxcs.bnd" could
not be opened.
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.

Thanks in advance!

Stg



the reached at
[login to unmask email]


Edie Richardson

DB2 Connect error
(in response to Jodi Murawski)
We have set distributed data on all three of our regions. As far as I can
tell everything is set up correctly on the mainframe side. We have
successfully connected using DB2 connect personal edition v5.2 (it may be
6.1, not sure) in two regions but we seem to be having problems connecting
in our production region. The error message we are getting is:

[IBM][CLI Driver] SQL0332N There is no
available conversion for source code
page "1252" to the target code page
"UNKNOWN". Reason Code "3".
SQLSTATE=57017

I checked the sysibm.sysstrings tables and they have the same data in all
three regions. Has anyone come across this one before? I tried looking
in the archive but couldn't connect this am.

Any help is appreciated. We are on DB2 v5.

Thanks,

Edie Richardson,
DB2 DBA, WSRC

Marco Poma

Re: DB2 Connect error
(in response to Edie Richardson)
Hi Edie,
You didn´t told us which is the operating system where you are using DB2 Connect.
If it is Windows, you have a system variable called db2codepage that shoul be set to a code pages that is understood by the main-frame side. Usually mainframe uses code page 530, and code page 1252 is used by windows. I had this problem two years ago, and I solved it setting the db2codepage = 1252 at windows side.

Best regards,


--
Marco Poma
IBM Certified Solutions Expert
email: [login to unmask email]
<[login to unmask email]> wrote in message news:[login to unmask email]

We have set distributed data on all three of our regions. As far as I can tell everything is set up correctly on the mainframe side. We have successfully connected using DB2 connect personal edition v5.2 (it may be 6.1, not sure) in two regions but we seem to be having problems connecting in our production region. The error message we are getting is:

[IBM][CLI Driver] SQL0332N There is no
available conversion for source code
page "1252" to the target code page
"UNKNOWN". Reason Code "3".
SQLSTATE=57017

I checked the sysibm.sysstrings tables and they have the same data in all three regions. Has anyone come across this one before? I tried looking in the archive but couldn't connect this am.

Any help is appreciated. We are on DB2 v5.

Thanks,

Edie Richardson,
DB2 DBA, WSRC

Mark Buzzard

Re: DB2 Connect error
(in response to Marco Poma)
Hi Edie,

I would move to at least v7.1 for your PE version. I had a lot of problems
with 5.2 and 6.1 that went away with 7.1. 7.1 also seemed to work fine
with DB2 v5 for me.

Buzz




[login to unmask email]
S.GOV To: [login to unmask email]
cc:
Sent by: DB2 Data Subject: DB2 Connect error
Base Discussion
List
<[login to unmask email]
ASSOC.COM>


09/26/2002 08:44
AM
Please respond to
DB2 Data Base
Discussion List







We have set distributed data on all three of our regions.  As far as I can
tell everything is set up correctly on the mainframe side.  We have
successfully connected using DB2 connect personal edition v5.2 (it may be
6.1, not sure) in two regions but we seem to be having problems connecting
in our production region.  The error message we are getting is:

[IBM][CLI Driver] SQL0332N There is no
available conversion for source code
page "1252" to the target code page
"UNKNOWN". Reason Code "3".
SQLSTATE=57017

I checked the sysibm.sysstrings tables and they have the same data in all
three regions.  Has anyone come across this one before?  I tried looking in
the archive but couldn't connect this am.

Any help is appreciated.  We are on DB2 v5.

Thanks,

Edie Richardson,
DB2 DBA, WSRC






Marco Poma

Fw: DB2 Connect error
(in response to Mark Buzzard)
Hi Edie,
You didn´t told us which is the operating system where you are using DB2 Connect.
If it is Windows, you have a system variable called db2codepage that shoul be set to a code pages that is understood by the main-frame side. Usually mainframe uses code page 530, and code page 1252 is used by windows. I had this problem two years ago, and I solved it setting the db2codepage = 1252 at windows side.

Best regards,


--
Marco Poma
IBM Certified Solutions Expert
email: [login to unmask email]
<[login to unmask email]> wrote in message news:[login to unmask email]

We have set distributed data on all three of our regions. As far as I can tell everything is set up correctly on the mainframe side. We have successfully connected using DB2 connect personal edition v5.2 (it may be 6.1, not sure) in two regions but we seem to be having problems connecting in our production region. The error message we are getting is:

[IBM][CLI Driver] SQL0332N There is no
available conversion for source code
page "1252" to the target code page
"UNKNOWN". Reason Code "3".
SQLSTATE=57017

I checked the sysibm.sysstrings tables and they have the same data in all three regions. Has anyone come across this one before? I tried looking in the archive but couldn't connect this am.

Any help is appreciated. We are on DB2 v5.

Thanks,

Edie Richardson,
DB2 DBA, WSRC

Edie Richardson

Re: Fw: DB2 Connect error
(in response to Marco Poma)
oops, it is windows. We'll try this, thanks!




Marco Poma <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>


09/27/02 08:47 AM
Please respond to DB2 Data Base Discussion List


To: "Edith W. Richardson" <[login to unmask email]>
cc:
Subject: Fw: DB2 Connect error


Hi Edie,
You didn´t told us which is the operating system where you are using
DB2 Connect.
If it is Windows, you have a system variable called db2codepage that
shoul be set to a code pages that is understood by the main-frame side.
Usually mainframe uses code page 530, and code page 1252 is used by
windows. I had this problem two years ago, and I solved it setting the
db2codepage = 1252 at windows side.

Best regards,


--
Marco Poma
IBM Certified Solutions Expert
email: [login to unmask email]
<[login to unmask email]> wrote in message news:[login to unmask email]

We have set distributed data on all three of our regions. As far as I can
tell everything is set up correctly on the mainframe side. We have
successfully connected using DB2 connect personal edition v5.2 (it may be
6.1, not sure) in two regions but we seem to be having problems connecting
in our production region. The error message we are getting is:

[IBM][CLI Driver] SQL0332N There is no
available conversion for source code
page "1252" to the target code page
"UNKNOWN". Reason Code "3".
SQLSTATE=57017

I checked the sysibm.sysstrings tables and they have the same data in all
three regions. Has anyone come across this one before? I tried looking
in the archive but couldn't connect this am.

Any help is appreciated. We are on DB2 v5.

Thanks,

Edie Richardson,
DB2 DBA, WSRC