RE: Mimixing pure SQL stored procedures.

["Kruse, Kat" <kkruse@xxxxxxxxxxxx>]

If you get a way to do this, pass it on.  We opened a ticket on this
over a year ago and they haven't been able to do this automatically.  I
have checked with the other replication/HA vendors (iTera/Vision -before
the merger-, Data Mirror, NoMax) and they couldn't do it either.

According to everyone I spoke to, this has to do with the way IBM stores
and defines these objects.

Anyway, if you get a solution, please pass it on. 

> -----Original Message-----
> From: midrange-l-bounces+kkruse=qualcomm.com@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces+kkruse=qualcomm.com@xxxxxxxxxxxx] 
> On Behalf Of rob@xxxxxxxxx
> Sent: Thursday, June 21, 2007 6:52 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Mimixing pure SQL stored procedures.
>
> I've opened up a ticket with Mimix, but since I am getting 
> some hairy IBM errors I was wondering your esteemed opinion.  
> I was waiting on calling IBM until I've heard from the HA vendor.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
> ----- Forwarded by Rob Berendt/DEKKO on 06/21/2007 09:49 AM -----
>
> support@xxxxxxxxxxxxxxxx 
> 06/21/2007 09:29 AM
>
> To
> rob@xxxxxxxxx
> cc
>
> Fax to
>
> Subject
> {[CASE#129898]} SQL stored procedures
>
>
>
>
>
>
> Product Selected:HALite
> Details about your inquiry:How do we transfer SQL stored 
> procedures?  We 
> have a pure SQL stored procedure.  It automatically created a 
> C-LE program 
> in a library that is mimixed.  However that program appears 
> on CMPOBJAUD 
> as not found on system 2.  Attempts to sync that object result in:
>
> SYNCOBJ DGDFN(SYSMGT GDISYS GDISYS2) OBJ((ROUTINES/DRPCODE))
>
> LVE37BA-0 objects synchronized; 1 objects not synchronized.
>
> Preceeded by some routine stuff, and some not so routine stuff like:
>
> CPD32BF-File QASZRA0002 in library QUSRSYS with constraint 
> Q_QUSRSYS_QASZRAIRF_COMPID_00001 is logically damaged.
>
> CPD32BF-File QASZRA0005 in library QUSRSYS with constraint 
> Q_QUSRSYS_QASZRAIRX_COMPID_00001 is logically damaged. 
>
> ...
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.