RE: Mimixing pure SQL stored procedures.

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.