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: 10457
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: 10457
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: 10457
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 Need better approach to create a sort... Vamshi Veludandi DFSORT/ICETOOL 8 Thu Mar 08, 2018 5:59 pm
No new posts Can we create REXX ouput in an Excel ... upendrasri CLIST & REXX 3 Wed Jan 17, 2018 8:19 pm
No new posts Unable to send mail with SMTP commands harsh.saxena579 JCL & VSAM 10 Tue Dec 12, 2017 1:58 pm
No new posts Looping REXX - unable to interrupt RAVISANKAR07 CLIST & REXX 3 Wed Dec 06, 2017 1:08 pm
No new posts unable to set RC = 4 when empty file migusd SYNCSORT 1 Tue Nov 21, 2017 1:21 am

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