[z/OS] -911 and called program updates

Mark Vickers

[z/OS] -911 and called program updates
Short of setting up a test, I am hoping someone knows the answer to this:
This feels like a DBA 101 question, but I am just not sure !

Program A reads STG table, passes the rows, as data to a called program B that updates a different table, WHI.
Update ok, B returns good return code to A and the next row is passed to B.
A reads another batch of STG rows and gets a -911

If A fails, are the updates in WHI by called program also rolled back ?

Thanks,
Mark.

From: Shay Miller [mailto:[login to unmask email]
Sent: Tuesday, January 28, 2020 10:57 AM
To: [login to unmask email]
Subject: [DB2-L] - Stored objects life cycle management


Hello.

In the last few months we are implementing more and more native sql objects in DB2 (User defined functions, native stored procedures, table functions).

For the 2 first objects, DB2 has it's own version management.

We are using a standard Software change management product (Endevor) for application objects (COBOL programs, JCLs, parms, etc.) and we are not sure if to use DB2 mechanism or to manage these objects in endevor as well.

Also, we have an automated tool to propagate changes in DB2, but we are currently defininig said objects manually because the tool doesn't support them.

Can anyone share what is the policy/ process of life cycle management/source control/ change tracking for these objects in your shops?



Thanks, shay.

-----End Original Message-----

Philip Sevetson

[z/OS] -911 and called program updates
(in response to Mark Vickers)
Yes. Program calls occur within a unit of work (I’m speaking to z/OS Batch and Online). This can be fixed, if it’s a problem, with an explicit COMMIT within the sequence of execution.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

From: Vickers, Mark <[login to unmask email]>
Sent: Wednesday, January 29, 2020 10:35 AM
To: [login to unmask email]
Subject: [DB2-L] - [z/OS] -911 and called program updates

Short of setting up a test, I am hoping someone knows the answer to this:
This feels like a DBA 101 question, but I am just not sure !

Program A reads STG table, passes the rows, as data to a called program B that updates a different table, WHI.
Update ok, B returns good return code to A and the next row is passed to B.
A reads another batch of STG rows and gets a -911

If A fails, are the updates in WHI by called program also rolled back ?

Thanks,
Mark.

From: Shay Miller [mailto:[login to unmask email]
Sent: Tuesday, January 28, 2020 10:57 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Stored objects life cycle management


Hello.

In the last few months we are implementing more and more native sql objects in DB2 (User defined functions, native stored procedures, table functions).

For the 2 first objects, DB2 has it's own version management.

We are using a standard Software change management product (Endevor) for application objects (COBOL programs, JCLs, parms, etc.) and we are not sure if to use DB2 mechanism or to manage these objects in endevor as well.

Also, we have an automated tool to propagate changes in DB2, but we are currently defininig said objects manually because the tool doesn't support them.

Can anyone share what is the policy/ process of life cycle management/source control/ change tracking for these objects in your shops?



Thanks, shay.

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Suresh Sane

[z/OS] -911 and called program updates
(in response to Philip Sevetson)
The whole transaction is a single unit of unless the called "program" is an autonomous stored procedure (V11 I think) which will commit independently and its updates will not be rolled back.

Thx
Suresh

________________________________
From: Sevetson, Phil <[login to unmask email]>
Sent: Wednesday, January 29, 2020 6:34 PM
To: [login to unmask email] <[login to unmask email]>
Subject: [DB2-L] - RE: [z/OS] -911 and called program updates


Yes. Program calls occur within a unit of work (I’m speaking to z/OS Batch and Online). This can be fixed, if it’s a problem, with an explicit COMMIT within the sequence of execution.





Philip Sevetson

Computer Systems Manager

FISA-OPA

5 Manhattan West

New York, NY 10001

[login to unmask email]<mailto:[login to unmask email]>

212-857-1688[cid:7100bd48-3df3-46dc-881d-6aedf35c6b1d] w

917-991-7052[cid:64e9d340-cc07-4e14-92d6-0fd63f9034db] m

212-857-1659[cid:ba6c32ec-5640-40da-ac76-7110b296f2cd] f

[cid:[login to unmask email]



From: Vickers, Mark <[login to unmask email]>
Sent: Wednesday, January 29, 2020 10:35 AM
To: [login to unmask email]
Subject: [DB2-L] - [z/OS] -911 and called program updates



Short of setting up a test, I am hoping someone knows the answer to this:

This feels like a DBA 101 question, but I am just not sure !



Program A reads STG table, passes the rows, as data to a called program B that updates a different table, WHI.

Update ok, B returns good return code to A and the next row is passed to B.

A reads another batch of STG rows and gets a -911



If A fails, are the updates in WHI by called program also rolled back ?



Thanks,

Mark.



From: Shay Miller [mailto:[login to unmask email]
Sent: Tuesday, January 28, 2020 10:57 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Stored objects life cycle management



Hello.

In the last few months we are implementing more and more native sql objects in DB2 (User defined functions, native stored procedures, table functions).

For the 2 first objects, DB2 has it's own version management.

We are using a standard Software change management product (Endevor) for application objects (COBOL programs, JCLs, parms, etc.) and we are not sure if to use DB2 mechanism or to manage these objects in endevor as well.

Also, we have an automated tool to propagate changes in DB2, but we are currently defininig said objects manually because the tool doesn't support them.

Can anyone share what is the policy/ process of life cycle management/source control/ change tracking for these objects in your shops?



Thanks, shay.



-----End Original Message-----



-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
Attachments

  • Outlook-otj2ene4.png (<1k)
  • Outlook-5scstxgb.png (<1k)
  • Outlook-mubottx4.png (<1k)

Michael Hannan

RE: [z/OS] -911 and called program updates
(in response to Philip Sevetson)



In Reply to Philip Sevetson:

Yes. Program calls occur within a unit of work (I’m speaking to z/OS Batch and Online). This can be fixed, if it’s a problem, with an explicit COMMIT within the sequence of execution.

Rollback to a Syncpoint is another option.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Mark Vickers

[z/OS] -911 and called program updates
(in response to Michael Hannan)
Thanks for your replies.

Yes to z/OS batch process.

So if program A checks the sql RC for -911 and does a wait loop, the UOW is still intact right ?

From: Michael Hannan [mailto:[login to unmask email]
Sent: Wednesday, January 29, 2020 7:29 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: [z/OS] -911 and called program updates



In Reply to Philip Sevetson:
Yes. Program calls occur within a unit of work (I’m speaking to z/OS Batch and Online). This can be fixed, if it’s a problem, with an explicit COMMIT within the sequence of execution.

Rollback to a Syncpoint is another option.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

-----End Original Message-----

Walter Jani&#223;en

RE: [z/OS] -911 and called program updates
(in response to Mark Vickers)

I would say: no, because all updates are rolled back to the last commit-point and have to be redone.

Michael Hannan

RE: [z/OS] -911 and called program updates
(in response to Michael Hannan)

In Reply to Michael Hannan:

Rollback to a Syncpoint is another option.

That was a red herring.

Actually since -911 rolls back to previous Commit, a SAVEPOINT would be useless in this case. Explicit rollback to a SAVEPOINT is an option for for more minor errors, including application unexpected conditions.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Shay Miller

RE: [z/OS] -911 and called program updates
(in response to Mark Vickers)

No.

 

The program recieves control back only after the rollback process is completed - so changes are undone.

This is for allowing the program to exit gracefully - close files, write to log, etc.

The changes are gone and you should exit with an error (unless it's ok to lose the changes) asap.