Security-related problems with DTS package with HIS 2000 and
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Security-related problems with DTS package with HIS 2000 and

 
Post new topic   Reply to topic    Windows Server Forum Index -> Host Integration Server
Author Message
Dennis W
Guest
Posted: Wed Dec 01, 2004 5:18 am    Post subject: Security-related problems with DTS package with HIS 2000 and Reply with quote
I am trying to read some data from a mainframe DB2 in an SQL Server
2000 DTS package using HIS 2000 (also tried 2004). Test connection
works, but when I try to see the available tables on the Source tab of
a DTS transform, I get the following error:

The authorization given does not have the privilege BINDADD and cannot
invoke the subcommand BIND against the package
IPCMDB2L.DBXPROJ.MSCS001. SQLSTATE: 42501, SQLCODE: -567

What do I need to ask the DB2 people to do to make this work? They
don't seem to know - all they keep telling me is that they've granted
read permission to PUBLIC for the views we need to access. They don't
seem to know anything about packages or package collections (nor do
I).

Thanks,
Dennis
Back to top
Aaron Grady [MSFT]
Guest
Posted: Thu Dec 02, 2004 3:31 am    Post subject: Re: Security-related problems with DTS package with HIS 2000 Reply with quote
Dennis-

Our HIS providers use packages for the different isolation levels. The
following two KB articles are probably the best place to start then post
back any follow up questions you have:

216810 Creating Packages for Use with ODBC Driver for DB2 and OLE DB
Provider
http://support.microsoft.com/?id=216810

269626 INFO: Permissions Needed to Create Packages Using DB2OLEDB on DB2 and
http://support.microsoft.com/?id=269626

HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


"Dennis W" <djwilso_google@yahoo.com> wrote in message
news:813382fb.0411301518.536e3220@posting.google.com...
Quote:
I am trying to read some data from a mainframe DB2 in an SQL Server
2000 DTS package using HIS 2000 (also tried 2004). Test connection
works, but when I try to see the available tables on the Source tab of
a DTS transform, I get the following error:

The authorization given does not have the privilege BINDADD and cannot
invoke the subcommand BIND against the package
IPCMDB2L.DBXPROJ.MSCS001. SQLSTATE: 42501, SQLCODE: -567

What do I need to ask the DB2 people to do to make this work? They
don't seem to know - all they keep telling me is that they've granted
read permission to PUBLIC for the views we need to access. They don't
seem to know anything about packages or package collections (nor do
I).

Thanks,
Dennis
Back to top
cls
Guest
Posted: Fri Mar 18, 2005 1:27 pm    Post subject: problems with package with HIS 2000 and 2004 Reply with quote
How to manage isolation level, because we have problem with lock on tablespace.
The error is (mscS001 used to delete rows) :
1.45.16 STC00017 DSNT376I -DBAG PLAN=DISTSERV WITH 192
192 CORRELATION-ID=MSEIDRDA

192 CONNECTION-ID=SERVER

192 LUW-ID=C0A80079.GF14.BCB7C1B8A08D=154444

192 THREAD-INFO=DB2T09:*:*:*

192 IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS
PLAN=AR5Acls
192 WITH

192 CORRELATION-ID=0030AR5AGGDF

192 CONNECTION-ID=IMSB

192 LUW-ID=INPS.A2DBA.BCB7BE6DEA4B=157914

192 THREAD-INFO=WEBcls:*:*:*
192 ON MEMBER DBWW

192
Thanks,
CLS


"Aaron Grady [MSFT]" wrote:

Quote:
Dennis-

Our HIS providers use packages for the different isolation levels. The
following two KB articles are probably the best place to start then post
back any follow up questions you have:

216810 Creating Packages for Use with ODBC Driver for DB2 and OLE DB
Provider
http://support.microsoft.com/?id=216810

269626 INFO: Permissions Needed to Create Packages Using DB2OLEDB on DB2 and
http://support.microsoft.com/?id=269626

HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


"Dennis W" <djwilso_google@yahoo.com> wrote in message
news:813382fb.0411301518.536e3220@posting.google.com...
I am trying to read some data from a mainframe DB2 in an SQL Server
2000 DTS package using HIS 2000 (also tried 2004). Test connection
works, but when I try to see the available tables on the Source tab of
a DTS transform, I get the following error:

The authorization given does not have the privilege BINDADD and cannot
invoke the subcommand BIND against the package
IPCMDB2L.DBXPROJ.MSCS001. SQLSTATE: 42501, SQLCODE: -567

What do I need to ask the DB2 people to do to make this work? They
don't seem to know - all they keep telling me is that they've granted
read permission to PUBLIC for the views we need to access. They don't
seem to know anything about packages or package collections (nor do
I).

Thanks,
Dennis


Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Host Integration Server All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB