View previous topic :: View next topic
|
Author |
Message |
chowdhrykapildev
New User
Joined: 05 Aug 2009 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
chowdhrykapildev
New User
Joined: 05 Aug 2009 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
if that is the case, You have already determined the source of Your issue
so... nothing we can do from here |
|
Back to top |
|
|
chowdhrykapildev
New User
Joined: 05 Aug 2009 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
your support... your support ... your support |
|
Back to top |
|
|
|