ca.portal.admin

Re: [IDMSVENDOR-L] Database Procedures

Discussion created by ca.portal.admin on Apr 20, 2008
so then could one concevably issue (from a procedure) a #post against a
sleeping #waiting task to wake it up and do the required work (kind of like
a pre-defined application run unit) ???


Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com



The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you receive
this material/information in error, please contact the sender and delete or
destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Database Procedures
"At 11:12 PM 4/20/2008, you wrote:
Hey Chris,

Yep, been there, done that, works pretty good. Only problem is that your
sleep beauty needs to wake up every now and then and issue a COMMIT so that
CV doesn't time the task/rununit out and abort it.

I don't know if you want to have the posted task bind, ready, update and
finish on each post. Lot's of overhead in that scenario.

Keep one thing in mind, how will you communicate to the sleeping beauty?
If you use storage, how will you pass it? What happens if CV goes down
before the data in the storage is processed?

If you want to contact me off list I can give you some ideas if you are
thinking of doing something like this.

Chuck
not me - just offering an alternative to the DML from procedure dilema
LTV Steel had ""sleeping beauty"" code written to execute their
processes - this was at least 10 years ago .....



This is Chris Hoelscher and I approved this email
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Database Procedures
"I think you have the call DB on the STORE but your record will exist only after the DB is finished and then inside you cannot do the CONNECT for a non existing record.

HTH
Rene.

Outcomes