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
 
Query on DB2 24X7 plan.

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

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sat Mar 12, 2011 8:46 pm    Post subject: Query on DB2 24X7 plan.
Reply with quote

I'm going to design a DB2 24X7 plan:
During batch mode, table should be updated by batch, while online transactions also update the table.
That is, the 24X7 plan should meet with below requirements:
1. table should always be available for online transactions with NO TIME OUT
2. everyday , the table will be used by online transactions.

I tried to design this plan with DB2 Clone tables:
1. During daylight, Clone table always keeps sync with base table, that is, when a transaction update the base table, it also update the clone table;
2. During night mode, clone table is used by batch jobs, while base table is used by transaction. So, I put these transactions that only update base table, into a ESDS file.
3. when the batch jobs complete, I want to APPLY these transactions in the ESDS file to Clone table , then unload data form clone table, and then make the Clone table used by online transactions via SQL EXCHANGE statement.
4. Load Clone table data to the previous base table, and then make the base table and the clone table sync again.

But there is AT LEAST ONE big problem with above solution:
In step 3 above, how can I apply all the transactions in ESDS file? Because transactions are continuously wrote into the ESDS file.


Please kindly advise.

Thanks in advance.
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: Sun Mar 13, 2011 10:56 am    Post subject:
Reply with quote

Hello,

I suspect the "24x7 requirement" is largely because someone (IT or User) wants to be able to say they have a 24x7 system.

No matter how you implement, there still someday be downtime. Suggest this be planned/managed rather than a surprise. There is probably no true business reason that this particular application must "always" be available.

Many times i've been invited to participate in discussions about some 24x7 requirement. The discussion quickly ended when the extra cost of doing this was presented. . .

Someone really needs to look into the "negatives" of shutting this down for a short amount of time.

If you intend to persist trying to turn this loose as a 24x7 application, suggest you get rid of the vsam file and use some other database table(s).
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Mon Mar 14, 2011 6:26 am    Post subject:
Reply with quote

Only DB2 database product is available for me, but since DB2 has all the functions that other database products have, why should I choose other products instead of DB2?

If you have 24X7 solution, would you please tell me? No matter what extra cost it will brings.
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: Mon Mar 14, 2011 9:41 am    Post subject:
Reply with quote

Hello,

Quote:
Only DB2 database product is available for me, but since DB2 has all the functions that other database products have, why should I choose other products instead of DB2?
Where in the world did you get this idea. . .

What i said was to get rid of the vsam file - and use other tables. . .

Quote:
If you have 24X7 solution, would you please tell me? No matter what extra cost it will brings.
I suspect that the people who are responsible for the $ would not agree. . .

As has been suggested several times in the past, your organization needs to hire/rent people with the proper experience to do this.

There have been several half-baked "solutions" that broke at the worst possible time. . . Hopefully whatever you implement will not be one of them.

I can tell you about one implementation that was a success, but it i most unlikely that you/your organization can do this.

The task was to receive manufacturing requirements from the order entry system that after some work actually automatically made the product, packaged the product, and caused them to be loaded onto train, trucks or moved to the warehouse for pickup.

The order entry system was on an IBM mainframe. All of the orders were passed on to an intermediate set of IBM mid-frames that were implemented locally at the manufacturing facilities. The mid-frames passed actual manufacturing info to "on-the-floor" Motorola machines that talked directly to the production control equipment.

Everything at a manufacturing location (IBM and Motorola) was "hot redundant" - a twin was running beside the primary and everything could be "moved over" by toggling a t-bar. There were also several "spare" machines that were not on the shop floor.

Every day, multile times all new regular and priority orders were sent "down the line". The mid-frames processed these and maintained multiple days of "work to do" (so there was no impact if the mid-frames cold not talk with the mainframe order entry system for a time). The midframes also sent down work orders to the production area computers multiple times a day.

In each facility where we used this implementation there were multiple fulltime hardware/network support technicials onsite.

I assure you that the management did not feel the cost of this effort, the ongoing people cost, and the considerable investment in hardware was "no matter". Indeed, to consider cost no matter iw quite irresponsible.

On the good side, i expect that what you want to support is far less involved and will possibly only be implemented to support one part of some organization. And (so far) no reason this should be 24x7 has been posted.
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 HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm

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