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
 

 

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: 10256
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: 10256
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: 10256
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 find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
No new posts READ A PACKED "NEGATIVE" FI... jdesouza CA Products 3 Tue May 02, 2017 11:43 pm
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 5 Thu Apr 27, 2017 1:15 am
No new posts RC 20 for Address ISPEXEC "ISRED... pkmurali CLIST & REXX 3 Sun Apr 16, 2017 11:30 pm


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