DB2 - L

  • 1.  DSNTIJRT dropping SPs

    Posted Oct 13, 2021 10:36 AM
    when trying to run DSNTIJRT mode(install) as advised in HOLD DATA, it attempts to drop IBM supplied routines. The issue is these IBM SPs have application SPs dependent on them  making it very difficult.
    If many applications end up using these IBM supplied routines, as they should, needing to drop them causes a major impact.
    Has anyone had this problem?
    How should this be managed?
    thanks
    Bill

    ------------------------------
    williamgiannelliMe
    ------------------------------


  • 2.  RE: DSNTIJRT dropping SPs

    Posted Oct 13, 2021 10:47 AM

    I've seen this before. DSNTIJRT attempts to refresh ALL of your system-supplied routine definitions, but when HOLDDATA asks you to run it, they usually only need certain routines to be refreshed.

    You may get lucky like we did and the routines that the HOLDDATA needs refreshed are NOT the ones that have application routines depending on them. If that's the case, make sure that:

    > DSNTIJRT shows THOSE routines that the HOLDDATA is for are successfully refreshed, and are not the same routines that failed to DROP.
    > DSNTIJRV shows that any routines that DID fail to DROP still work properly.

    If the routines that the HOLDDATA applies to are the same ones that are failing to drop due to a dependency, then you may need to reach out to IBM. But if the routine def HAS changed, the applications calling it may need to account for this anyway in their CALLs.

    -Mark



    ------------------------------
    MarkWieczorkowskiUS Social Security Admin
    ------------------------------



  • 3.  RE: DSNTIJRT dropping SPs

    Posted Oct 13, 2021 11:33 AM
    Thank you for your reply!
    Unfortunately, our management, in their great wisdom, saw fit to remove "usage" support from IBM to save costs. So, when I posted a case IBM said the issue was a "usage" question and not a "defect".
    But how is one to implement maintenance when their job fails?
    thanks
    Bill

    ------------------------------
    williamgiannelliMe
    ------------------------------



  • 4.  RE: DSNTIJRT dropping SPs

    Posted Oct 14, 2021 12:05 AM
    SDSNSAMP(DSNTESR) contains, what appears to be, the DDL etc used by DSNTIJRT.

    Depending on what the problem actually is, you might be able to use that as a way to work
    around the problem.

    James Campbell


    On 13 Oct 2021 at 15:32, william giannelli via Interna wrote:

    > Thank you for your reply!
    > Unfortunately, our management, in their great wisdom, saw fit to remove "usage" support from IBM to save costs. So, when I posted a case IBM said the issue was a "usage" question and not a "defect".
    > But how is one to implement maintenance when their job fails?
    > thanks
    > Bill
    >
    > ------------------------------
    > williamgiannelliMe
    > ------------------------------
    > -------------------------------------------
    > Original Message:
    > Sent: Oct 13, 2021 10:47 AM
    > From: Mark Wieczorkowski
    > Subject: DSNTIJRT dropping SPs
    >
    >
    > I've seen this before. DSNTIJRT attempts to refresh ALL of your system-supplied routine definitions, but when HOLDDATA asks you to run it, they usually only need certain routines to be refreshed.
    >
    > You may get lucky like we did and the routines that the HOLDDATA needs refreshed are NOT the ones that have application routines depending on them. If that's the case, make sure that:
    >
    > > DSNTIJRT shows THOSE routines that the HOLDDATA is for are successfully refreshed, and are not the same routines that failed to DROP.
    > > DSNTIJRV shows that any routines that DID fail to DROP still work properly.
    >
    > If the routines that the HOLDDATA applies to are the same ones that are failing to drop due to a dependency, then you may need to reach out to IBM. But if the routine def HAS changed, the applications calling it may need to account for this anyway in their CALLs.
    >
    > -Mark
    >
    >
    > ------------------------------
    > MarkWieczorkowskiUS Social Security Admin
    > ------------------------------
    >
    > Original Message:
    > Sent: Oct 13, 2021 10:36 AM
    > From: william giannelli
    > Subject: DSNTIJRT dropping SPs
    >
    > when trying to run DSNTIJRT mode(install) as advised in HOLD DATA, it attempts to drop IBM supplied routines. The issue is these IBM SPs have application SPs dependent on them making it very difficult.
    > If many applications end up using these IBM supplied routines, as they should, needing to drop them causes a major impact.
    > Has anyone had this problem?
    > How should this be managed?
    > thanks
    > Bill
    >
    > ------------------------------
    > williamgiannelliMe
    > ------------------------------
    >
    >
    > Reply to Sender : https://www.idug.org/eGroups/PostReply/?GroupId=253&MID=172746&SenderKey=f6908bee-a76f-4c75-90f9-54eaf7d47d99&MDATE=7576465468&UserKey=0e114382-b62d-4df5-8bae-216292fc0091&sKey=KeyRemoved
    >
    > Reply to Discussion : https://www.idug.org/eGroups/PostReply/?GroupId=253&MID=172746&MDATE=7576465468&UserKey=0e114382-b62d-4df5-8bae-216292fc0091&sKey=KeyRemoved
    >
    >
    >
    > You are subscribed to "DB2 - L" as jacampbellaus@gmail.com. To change your subscriptions, go to http://www.idug.org/preferences?section=Subscriptions&MDATE=7576465468&UserKey=0e114382-b62d-4df5-8bae-216292fc0091&sKey=KeyRemoved. To unsubscribe from this community discussion, go to http://www.idug.org/HigherLogic/eGroups/Unsubscribe.aspx?UserKey=0e114382-b62d-4df5-8bae-216292fc0091&sKey=KeyRemoved&GroupKey=37484667-8556-4529-8eb2-a1404f7c5c5f.



    --
    This email has been checked for viruses by AVG.
    https://www.avg.com