| View previous topic :: View next topic |
| Author |
Message |
satya_mn_99
Beginner
Joined: 26 Sep 2005
Posts: 17
Topics: 5
|
 Posted: Mon Sep 26, 2005 2:17 pm Post subject: How to aviod Database inserts/updates in Production? |
 |
|
Hi,
we have bunch of cobol programs in production where they update/insert values into DB2 tables. But occationally we would not required to update/insert the values into tables when we execute those programs.
What would be the best and simple way for this ? any ideas ....
Please advice.
Thanks. |
|
| Back to top |
|
 |
SureshKumar
Intermediate
Joined: 23 Jan 2003
Posts: 211
Topics: 21
|
| Posted: Mon Sep 26, 2005 2:52 pm Post subject: |
|
|
satya_mn_99,
Your requirement is a business process logic, you may pass a Parm thru JCL and eveluate the parm in your code and have a bypass logic or any other appropriate logic in the code. Thanks |
|
| Back to top |
|
|
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Tue Sep 27, 2005 1:38 am Post subject: |
|
|
Satya_mn_99,
| Quote: |
But occationally we would not required to update/insert the values into tables when we execute those programs.
|
Can you give us more detail on when you get to do this ? Since you are talking about production, I believe this occasional run is not for any kind of testing.
As mentioned by Sureshkumar, if this is your business requirement that every few days, you need to run the same program without updating values then passing PARM would be the easiest way.
Thanks,
Phantom |
|
| Back to top |
|
|
a_seshu
Beginner
Joined: 30 Sep 2004
Posts: 16
Topics: 4
Location: Chennai
|
| Posted: Mon Oct 24, 2005 1:11 pm Post subject: |
|
|
Use a read only plan
_________________
I dont think I would ever stop learning. - Seshu. |
|
| Back to top |
|
|
bauer
Intermediate
Joined: 10 Oct 2003
Posts: 317
Topics: 50
Location: Germany
|
| Posted: Tue Oct 25, 2005 6:39 am Post subject: |
|
|
Start tablespace with acces type = ut / utility only.
Result of update, insert, read is of course negative sql code ...... |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
