Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Unable to have access of "CREATE IN" on a Package

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

New User


Joined: 05 Aug 2009
Posts: 44
Location: Hyderabad

PostPosted: Thu Aug 20, 2009 7:03 pm    Post subject: Unable to have access of "CREATE IN" on a Package
Reply with quote

Hi all,

I have a Java based tool (which is installed on my workstation) which has an option of loading data from mainframes DB2 table to Java. Java is connected to mainframes through some connectivity(I guess its through JDBC). When I click the option, the process of loading data from DB2 to Java starts wherein it checks for the below sequence of steps.

Step1: remoteurl=jdbc:db2:tso2tcp //connect to remote

Step2: qmysaccs0=SELECT USERID FROM GDB2MYS.MYS_ACCESS_CONTROL WHERE USERID^='' //check the access

Step3: qbanks2=SELECT BANK_ACCOUNT,ABI,CAB,BANK_CODE,BANK_NAME,DESCRIPTION,USERID FROM T05.BANKS WHERE USERID=?

Step4: ........and so on.

After few secs, I get the below error msg on the Java tool.

[IBM][CLI Driver][DB2] SQL0551N "I134808" does not have the priviledge to perform operation "CREATE IN" on object "MVSADM1_DBI6.NULLID.SQLLF402.()". SQLSTATE=42501.

I134808 is the mainframe Id. MVSADM1 is the node id. DBI6 is the DB2 sub-system. NULLID is Collection which is already created in DBI6.

Can anyone please help me out the access issue for the id I134808. What query do I need to run in order to allow the access of CREATE IN to the id I134808.

Thanks in Advance.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Thu Aug 20, 2009 7:07 pm    Post subject: Reply to: Unable to have access of "CREATE IN" on
Reply with quote

Quote:
I have a Java based tool (which is installed on my workstation) which has an option of loading data from mainframes DB2 table to Java. Java is connected to mainframes through some connectivity(I guess its through JDBC). When I click the option, the process of loading data from DB2 to Java starts wherein it checks for the below sequence of steps.


did You coordinate with Your support to check if all the required permissions are defined/granted ?
Back to top
View user's profile Send private message
chowdhrykapildev

New User


Joined: 05 Aug 2009
Posts: 44
Location: Hyderabad

PostPosted: Thu Aug 20, 2009 7:16 pm    Post subject:
Reply with quote

Hi Enrico,

The bad part is that we only support the tool and install the tool even for the users. As the Users id has more priviledges, they dont face any such problem. Its the first time we are trying to test the tool in our workstations.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Thu Aug 20, 2009 8:06 pm    Post subject: Reply to: Unable to have access of "CREATE IN" on
Reply with quote

if that is the case, You have already determined the source of Your issue icon_biggrin.gif
so... nothing we can do from here
Back to top
View user's profile Send private message
chowdhrykapildev

New User


Joined: 05 Aug 2009
Posts: 44
Location: Hyderabad

PostPosted: Thu Aug 20, 2009 11:12 pm    Post subject:
Reply with quote

Ya. That's true. But I'm not sure what query I need to give for the id I134808 in order to get through the access issue. Can any one please give me some tip on this issue?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Thu Aug 20, 2009 11:16 pm    Post subject: Reply to: Unable to have access of "CREATE IN" on
Reply with quote

your support... your support ... your support
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 User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us