RE: Storing source as DDL instead of DDS

FWIW our SQL server folks have been creating stored procedures on the system and accidentally nuked one of them and didn't have a copy of the source & didn't retrieve the proc source from the object prior to deletion so my recommendation was for them to start saving their source code vs restoring stuff from backup on a consistent basis...and it proved to be a good idea since they done that on several occasions since then.


Thanks,
Tommy Holden

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Monday, February 27, 2017 9:43 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Storing source as DDL instead of DDS

I can understand your skepticism, especially since I gave you an exact example of that occurring to me<sarcasm intended>. And detailed how.

And Birgitta kind of laid her example out also.

But I do respect the questioning of whether keeping the source as a backup is more risk than gain if people think the source is accurate when there's no guarantee that it is.



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 02/27/2017 10:00 AM
Subject: RE: Storing source as DDL instead of DDS
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



So IBMi backups are insufficient to restore a PF? You'll have to forgive
my skepticism.



-----Original Message-----
From: Birgitta Hauser [mailto:Hauser@xxxxxxxxxxxxxxx]
Sent: Sunday, February 26, 2017 3:54 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Subject: RE: Storing source as DDL instead of DDS

Backups

Good luck!

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown) "If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
„Train people well enough so they can leave, treat them well enough so
they don't want to.“ (Richard Branson)