Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us