View previous topic :: View next topic
|
Author |
Message |
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi,
We have got a new subsystem created. Its a very raw system with not much pre-configured settings are done.
I tried connecting this subsystem from IBM data studio, the connection succeeded but when I ran any query it failed with the below error
DSNT.NULLID.SYSSTAT.5359534C564C3031;DISTSERV;04
I think the default packages for remote connections are not created/bound.
Can any one please let me know how to create these packages in NULLID collection? is there any SDSNSAMP member which contains these bind statements? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
These packages get created from the client (during db2 connect installation or something).
Try connecting to the z/OS subsystem using a userid with (minimal) PACKADM authority.
PS.: if you have questions about installation it is always a good idea to mention the version of the product(s). In this case DB2 z/OS and datastudio. |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi,
I did not understand... You mean I should 1st grant PACKADM in COLLECTION NULLID TO MYUSERID?
Can you please elaborate a little more?
Version Numbers
DB2 Zos - V9.1 NFM
Data Studio for windows - Version 3.1.1.0, administration client |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
The first time you connect to db2 z/OS with datastudio (or at least db2Connect) it will try to do some binds on z/OS. So the user that does this will need at least packadm on that collection.
SYSADM is also good ;).
Once the package is there you can revoke that authority and just leave execauth.
I'm not 100% sure this is how you solve it, but it is definitely a good start. |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
I have SYSADM authority... But still when i try connecting from data studio
i get the below error
DSNT.NULLID.SYSSTAT.5359534C564C3031;DISTSERV;04 |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Code: |
select location, collid, name, hex(CONTOKEN), "VERSION", pdsname from sysibm.syspackage p where name like 'SYSSTAT%' |
|
|
Back to top |
|
|
|