View previous topic :: View next topic
|
Author |
Message |
TheAndroid
New User
Joined: 29 Apr 2010 Posts: 2 Location: Dallas, TX
|
|
|
|
Hi,
I am trying to deploy a stored procedure using Data Studio to a V8.1 instance. I am getting this error:
DB2 SQL Error: SQLCODE=-471, SQLSTATE=55023, SQLERRMC=SYSPROC.DSNTPSMP;00E7900C, DRIVER=4.8.86
I've looked up the 471 and the 55023 and they basically say the proc is not found. However, when I look into the database with SPUFI, it is there. My ID has all the rights and privileges possible, so I can't understand why I'm having this problem.
Is this equivalent to LUW's error stating a procedure without the same signature can't be found?
Thanks. |
|
Back to top |
|
|
TheAndroid
New User
Joined: 29 Apr 2010 Posts: 2 Location: Dallas, TX
|
|
|
|
Not five minutes after I posted....
The WLM address space for the SYSPROC.DSNTPSMP procedure was stopped.
So, if you see this error, take a look at that! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for posting the resolution
And you know that if you had not posted, the problem would still exist
d |
|
Back to top |
|
|
|