Re: Restoring SQL UDFs

Final sentence should read:

If I understand you correctly, you are saying that we should restore the HLL
service programs first, and then restore QSYS2?

Sam

"Saml" <none@xxxxxxxxxxxxxxx> wrote in message
news:OLadncFeR-1V9BDanZ2dnUVZ_o2vnZ2d@xxxxxxxxxxxxxx
On the production box we create the HLL service programs, then do the
Create Procedure to register them. As I recall, the registration
information ends up in QSYS2/SYSFUNCS. However we are managing to do the
restores on the test machines the UDFs don't turn up in QSYS2/SYSFUNCS.

If I understand you correctly, you are saying that we should restore the
HLL service programs first, and then restore QSYS2/SYSFUNCS?

Sam


"CRPence" <crpence@xxxxxxxxxxxx> wrote in message
news:478c2a74@xxxxxxxxxxx
Create the HLL [service] programs *before* creating the UDF. Then save
the UDF to be restored. Only in that manner can it be automatically
registered; else they must be registered by a new CREATE FUNCTION ..
EXTERNAL

This information should be well known by IBM support, so it seems
surprising, any alluding to "IBM doesn't seem to be able to help." Also
at CREATE time, there will be [¿an SQLWARN and/or?] a message logged in
the joblog that indicates the UDF will not transport due to the
referenced program not already existing. The registration information is
stored in the object itself, and is visible with PRTSQLINF if it exists.

Regards, Chuck
--
All comments provided "as is" with no warranties of any kind whatsoever
and may not represent positions, strategies, nor views of my employer

Saml wrote:
We've built test machines by restoring the backup tapes from
production machines. In all cases, our SQL UDFs registration got
lost and I've had to register them, and then they work fine.
These are external UDFs, running RPG and C code.

I'm not quite sure how the system programmers lay down the basic OS,
but they can't seem to figure out how to the get the UDFs right, and
IBM doesn't seem to be able to help. I don't know whether it is an
issue with the save or the restore, or it's too much work, or there
is a disconnect with IBM, or whether this genuinely just isn't
possible and you always have to register UDFs again.




.

Relevant Pages

  • Re: Restoring SQL UDFs
    ... On the production box we create the HLL service programs, ... Procedure to register them. ... test machines the UDFs don't turn up in QSYS2/SYSFUNCS. ... you are saying that we should restore the HLL ...
    (comp.sys.ibm.as400.misc)
  • Re: Restoring SQL UDFs
    ... We are building a test machine from scratch. ... UDFs that work on the production box do not work on the new machine. ... you are saying that we should restore the ... This information should be well known by IBM support, ...
    (comp.sys.ibm.as400.misc)
  • Re: Donkey Strikes Again !
    ... > Noting that Donkey cannot censure or close posting in this newsgroup, ... > As with f0dder, I would expect Donkey to correct this technical mistake ... explicitly save a register value and explicitly restore that value ...
    (alt.lang.asm)
  • Re: [Patch 00/12] Hardware Breakpoint Interfaces
    ... bp can be NULL due to lazy debug register switching ... the breakpoint structure for bp 0 will be deallocated. ... so we have to restore the old settings. ...
    (Linux-Kernel)
  • Re: Restoring SQL UDFs
    ... Do not ever restore into QSYS2 except into the empty library as part of a disaster recovery. ... Create the HLL program ... However we are managing to do the restores on the test machines the UDFs don't turn up in QSYS2/SYSFUNCS. ... This information should be well known by IBM support, so it seems surprising, any alluding to "IBM doesn't seem to be able to help." ...
    (comp.sys.ibm.as400.misc)
Loading