Serge Rielau <sr*****@ca.eye-be-em.com> wrote in message news:<c8**********@hanover.torolab.ibm.com>...
Take a look at SYSCAT.PACKAGEDEP for these two procedures.
(package name = SUBSTR(SYSCAT.ROUTINES.IMPLEMENTATION, 1, 8))
That may give you a hint. I don't think there is such a thing as getting
invalidated because of being nested.
Cheers
Serge
A little more info on this issue:
I rebound the two packages that were invalid, everything ran fine for
some time and then - voila - one of them became invalid again!
I have NO idea what the scoop is...
We're getting this error:
17May04 16:47:49:177 CDT TIBIM.5.0.1V5.aimOfflineImage.aimOfflineImage
Error [IM_TASK] AEIM-ADB Agent Results Job-12
[Process-cacheImages,Task-ADBTASK3|validateResultset] "the error
encountered by the ADB agent is
[IBM][CLI Driver][DB2/6000] SQL0727N An error occurred during
implicit system action type "1". Information returned for the error
includes SQLCODE "-551", SQLSTATE "42501" and message tokens
"AMROBI2|EXECUTE|AIM.UPDATEEXPIRATIONDATE". SQLSTATE=56098
The only thing I can think of is that the userid we use to create the
stored procedures is AMROBI2. That user is also the owner and the
binder of all packages. It has full rights: BIND, EXECUTE, and
CONTROL.
The user id that is calling the stored procedure is different than
AMROBI2.
Could this be an issue where the userid calling the stored procedure
needs to be the same as the creator?
I may be grasping at straws here...