Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

-551 - Authorization Failure - Help To reslove

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jeyan883

New User


Joined: 26 Apr 2010
Posts: 17
Location: Chennai

PostPosted: Tue May 18, 2010 2:22 pm    Post subject: -551 - Authorization Failure - Help To reslove
Reply with quote

Hi
I am getting -551 Error ( Authorization Failure )

but in SYSTSPRT Message Shows different one

TOKENS=DBTPIIM INSERT DBTPIIS.Tablename

Actually I am Accessing DBTPIIM Database but in the error message it is showing DBTPIIS.tablename ( I don't have access for DBTPIIS that's why it is showing -551 ) but why it is taking DBTPIIS how to find out ( there is no call statements in PGM , Listing also no where else DBTPIIS is used )

in PKG i have given the owner name as OWNER (DBTPIIM)
QUALIFIER (DBTPIIM)

Please kindly help .. Thanks in Advance [/quote][/quote]
Back to top
View user's profile Send private message

Ragav86

New User


Joined: 27 Jan 2010
Posts: 37
Location: chennai

PostPosted: Tue May 18, 2010 4:49 pm    Post subject:
Reply with quote

is the table available in DBTPIIM collection?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue May 18, 2010 5:02 pm    Post subject:
Reply with quote

cobol program with imbedded sql? SP,

if cobol program - what does dbrm look like,
what are bind statements and output?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue May 18, 2010 5:21 pm    Post subject:
Reply with quote

actually, what are you doing?
what is the sql?
if you are executing thru TMP (ikjeft...) what are the systin parms?
Back to top
View user's profile Send private message
jeyan883

New User


Joined: 26 Apr 2010
Posts: 17
Location: Chennai

PostPosted: Tue May 18, 2010 5:32 pm    Post subject:
Reply with quote

Ragav86 wrote:
is the table available in DBTPIIM collection?

Hi Ragav
Table is defined and data also available in the DBTPIIM Database but I am not aware about the Collection, I have created DBB, PKG , PRM Card in the Changeman to Promote this job.. Thanks
Back to top
View user's profile Send private message
jeyan883

New User


Joined: 26 Apr 2010
Posts: 17
Location: Chennai

PostPosted: Tue May 18, 2010 5:36 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
actually, what are you doing?
what is the sql?
if you are executing thru TMP (ikjeft...) what are the systin parms?


Hi

Please find the below SYSTSIN Parameters

//SYSTSIN DD DSN=Changeman Program path
DSN SYSTEM(DB81)
RUN PROGRAM(Program name ) PLAN(Program name )
END

PKG Info
OWNER (DBTPIIM)
QUALIFIER (DBTPIIM)
MEMBER (Program Name )

Thanks for your reply
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue May 18, 2010 5:57 pm    Post subject:
Reply with quote

dbrm?
Back to top
View user's profile Send private message
jeyan883

New User


Joined: 26 Apr 2010
Posts: 17
Location: Chennai

PostPosted: Tue May 18, 2010 6:16 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
dbrm?


Hi

Query

Delete from tablename where Class Followed by Condition

DBRM Cretaed in the changeman DBR Path ( Compilation Success failed only during execution time )

my Doubt is why it is Showing

TOKENS=DBTPIIM DELETE DBTPIIS.PROG_MSR ?
Back to top
View user's profile Send private message
jeyan883

New User


Joined: 26 Apr 2010
Posts: 17
Location: Chennai

PostPosted: Tue May 18, 2010 9:20 pm    Post subject:
Reply with quote

Ragav86 wrote:
is the table available in DBTPIIM collection?


Hi

Pls find More info

Delete from Tablename ( that is alias not table )

Defined as table in DBTPIIS, alias in DBTPIIM Pls help
Back to top
View user's profile Send private message
jeyan883

New User


Joined: 26 Apr 2010
Posts: 17
Location: Chennai

PostPosted: Wed May 19, 2010 2:20 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
dbrm?


Hi
Any Updates I Can able to execute the query in Spufi that is working Fine

Delete/Update from DBTPIIM.aliasname where class Condition ( bcz I have all access for DBTPIIM)

but in program -551 is showing ( As i Said previously )

is it possible to do that operation through PGM ( I hope U understand the scenario

Defined as table in DBTPIIS and the same should be the alias in DBTPIIM )
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 utilities, contention or failure? sheersh DB2 2 Fri Apr 21, 2017 6:18 pm
No new posts ALLOCATE REXX PDS to SYSPROC failure mambopras CLIST & REXX 4 Sat Apr 04, 2015 10:14 am
No new posts Authorization for compiling and linki... Abhi Nature All Other Mainframe Topics 5 Thu Mar 12, 2015 3:09 pm
No new posts OPC/Tivoli OCL failure (line 1560) David Robinson IBM Tools 14 Mon Dec 01, 2014 7:13 am
No new posts FTINCL failure code 20 Invalid contro... Steve Coalbran TSO/ISPF 2 Mon Aug 04, 2014 10:44 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us