Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Mainframe DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vignesh_2222

New User


Joined: 19 Aug 2009
Posts: 1
Location: chennai

PostPosted: Thu Nov 05, 2009 2:11 pm    Post subject: Mainframe DB2
Reply with quote

Hi Can any one tell me what happens if we run load modules for mainframe database that is not taken backup?
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Nov 05, 2009 4:01 pm    Post subject:
Reply with quote

Hi Vignesh,

Welcome to the forums!.

Are you asking 'A program having DB2 statements (DML) against a database which doesn't have a backup ?'.

It depends,
If it is a test database, no one else is working on it. No will ask you what you did ?

If it is a test database and development team has built new policy numbers and your program has manipulated something. And development team might build the policy numbers again or raise a issue to dba. DBA might look into the log and probably can find your name and tell it the development team. They might come and say HI to you.

Story might go on.


Sushanth
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Nov 05, 2009 8:49 pm    Post subject:
Reply with quote

Hello and welcome to the forum,

If the sql only reads, there should be no worry about the data.

If the sql does any kind of update, it is inappropriate/unacceptable to run the code without having a backup. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm
No new posts Allianz Technology - Mainframe 3+ Yea... sooraj184 Mainframe Jobs 0 Mon Jul 31, 2017 2:17 pm
No new posts Mainframe Opening in Chennai ( 2 to 4... muralikrishnan_new Mainframe Jobs 0 Tue Jul 18, 2017 2:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us