BMP Transaction oriented JCL in IMS DB

Future of SQL Career and Database Jobs
Future of SQL Career and Database Jobs

Many mainframe /IMS programmers think that BMP means batch. Actually there are two kinds of transactions. One is BMP(Batch) and the other one is BMP(Txn oriented).

Usually MPPs are scheduled by IMS. But BMP(txn) are scheduled by an operator through JCL.

Typically, you use a transaction-oriented BMP to simulate direct update online: Instead of updating the database while processing its transactions, an MPP sends its updates to the message queue.

A transaction-oriented BMP then performs the updates for the MPP. You can run the BMP as needed, depending on the number of updates. This improves response time for the MPP, and it keeps the data current. This can be more efficient than having the MPP process its transactions if the response time of the MPP is very important. One disadvantage in doing this, however, is that it splits the transaction into two parts which is not necessary.

If you have a BMP perform an update for an MPP, design the BMP so that, if the BMP terminates abnormally, you can reenter the last message as input for the BMP when you restart it. For example, suppose an MPP gathers database updates for three BMPs to process, and one of the BMPs terminates abnormally. You would need to reenter the message that the terminating BMP was processing to one of the other BMPs for reprocessing.

BMPs can process transactions defined as wait-for-input (WFI). This means that IMS allows the BMP to remain in virtual storage after it has processed the available input messages. IMS returns a QC status code, indicating that the program should terminate when one of the following occurs:

  • The program reaches its time limit.
  • The master terminal operator enters a command to stop processing.
  • IMS is terminated with a checkpoint shutdown.

The following commands you can use in BMP(Txn):

/PSTOP REGION, /DBD, /DBR, or /STA.

Related :

IMS DB – DL/I, BMP, MPP – Advanced Concepts

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.