Windows Server

Cyrus Farzad · Guest

Hey there,

I'm using HIS 2004 to connect to a DB2 VPN, and hit a snag. First thought is
that the VPN is tripping us up, but our DBA tried to connect locally, and
got the same error.

The test connection works fine, but if I try the a package or sample query.
I get the following error:
"An operation was attempted on object QSYS.RMMM_X. This operation cannot be
performed without the required authoirty. SQLSTATE: 42051, SQLCODE: -551"

I'm assuming I need to change the permissions on the DB2 side. Can anyone
confirm this as well as let me know what the permissions settings should be?

If it's something else, what do you think?

Thanks!

Cyrus

Jeremy Remlinger [MSFT] · Guest

Cyrus,

Are you sure this isn't SQLSTATE 42501, and not 42051? I can not find the
IBM Sense code for 42051, but 42501 is:

The authorization ID does not have the privilege to perform the specified
operation on the identified object.

and -551 is:

auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON
OBJECT object-name

#############################
#Jeremy "Rem" Remlinger, MSCE
#SNA/HIS Engineer
#Microsoft
#
#This posting is provided
#'AS IS' with no warranties,
#and confers no rights.
#© 2004 Microsoft Corporation
#All rights reserved.
#############################

--------------------
Reply-To: "Cyrus Farzad" <cfarzad@princeton.com>
From: "Cyrus Farzad" <cfarzad@princeton.com>
Subject: AS400 Connection Suceeds, but read data hangs
Date: Wed, 10 Nov 2004 17:51:13 -0500
Lines: 21
Organization: Princeton Consultants
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <eRjMLf3xEHA.3024@TK2MSFTNGP14.phx.gbl>
Newsgroups: microsoft.public.hiserver.general
NNTP-Posting-Host: xd8392b92.ip.e-nt.net 216.57.43.146
Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.hiserver.general:4414
X-Tomcat-NG: microsoft.public.hiserver.general

Hey there,

I'm using HIS 2004 to connect to a DB2 VPN, and hit a snag. First thought
is
that the VPN is tripping us up, but our DBA tried to connect locally, and
got the same error.

The test connection works fine, but if I try the a package or sample query.
I get the following error:
"An operation was attempted on object QSYS.RMMM_X. This operation cannot be
performed without the required authoirty. SQLSTATE: 42051, SQLCODE: -551"

I'm assuming I need to change the permissions on the DB2 side. Can anyone
confirm this as well as let me know what the permissions settings should be?

If it's something else, what do you think?

Thanks!

Cyrus

Aaron Grady [MSFT] · Guest

Cyrus-

The DB2 provider needs to create some SQL packages in DB2 in order to
perform it's work. These can either be created on the fly or you can create
them once using the Packages button in the Data Access Tool. You do need to
have specific permissions to create these, the following KB article should
help:

269626 INFO: Permissions Needed to Create Packages Using DB2OLEDB on DB2
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

"Jeremy Remlinger [MSFT]" <jeremyr@online.microsoft.com> wrote in message
news:SDSGdH4xEHA.3388@cpmsftngxa10.phx.gbl...

	Windows Server Forum Index -> Host Integration Server	All times are GMT
Page 1 of 1