IMS DB2 program getting SQL error -925

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Hi,
I am facing one problem in my IMS-DB2 program .Need some guidance.
Issue :
My program is just using IMS for reading data i.e. no Insert or Update is done ,but I am doing Update and Insert on DB2 tables .
Now when I gave explicit commit to save my DB2 transaction inside my program , I am getting SQL error -925 . I checked the manual and understand that , I can't use COMMIT keyword .
But my requirement is I need to do commit after every 500 records read from my Input file.Please suggest how to issue COMMIT statement inside IMS-DB2 program .
I just need to commit by DB2 data as I am only doing read operation on IMS

don.leahy · Posted: Mon Oct 05, 2015 11:21 pm

In the situation that you describe, all Commits are coordinated by IMS. It does not matter whether IMS data is being updated or not. The recommended way to issue a Commit under IMS (I am assuming this is a batch function) is to use a CHKP call.

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Hi Sir ,
Can you please tell me the simplest way to do a CHKP call .
I searched and everywhere it's saying use a CHKP call , please let me know how I need to modify my program for this call and any reference will be of great help for me .
And yes it's a batch function only.
thanks

PeterHolland · Posted: Tue Oct 06, 2015 2:23 pm

Something like this :

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Hi,
Thanks for your help .
Actuall the CHKP call for Commit is working fine but issue is with the Rollback .
I am using 'ROLB' call but job is abending with System abend 04E . And DB2 reason code X'00D44056' .
I checked the manuals which says Backoout Option has to be set to Yes, but I don't know how to do this .

don.leahy · Posted: Tue Oct 06, 2015 7:50 pm

Is there a BKO parameter in your batch JCL?

Rohit Umarjikar · Posted: Tue Oct 06, 2015 8:16 pm

Please have a look.
www-01.ibm.com/support/knowledgecenter/#!/SSEPEK_11.0.0/com.ibm.db2z11.doc.apsg/src/tpc/db2z_itemsbatchdli.dita

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Rohit Umarjikar · Posted: Wed Oct 07, 2015 11:02 am

Do need for code now? Then try this and many links can be useful on this forum or Google.

ibmmainframes.com/about33768.html

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Hi Rohit,
Issue is not with Syntax , My ROLB call is failing .

Rohit Umarjikar · Posted: Wed Oct 07, 2015 11:46 pm

Ravi,
Have you tried the same parms as shown in the above link (I assume as per the comments they work) and if you could not get further with BKO = Y parm (as suggested) then it raises some serious questions,
1. Are you the first person writting this piece/CHKP/ROLL logic, if not then how does existing stuff works check your region(dev) specific parm?
2. Would you not find any existing programs?
3. None of you co-workers knows about this?
4. Where is your support team on this, have you approached them?
5. pick any prod version which does ROLB and execute it in development env. and if it works then you are making some mistakes else talk to your support team.

PeterHolland · Posted: Thu Oct 08, 2015 2:23 pm

BKO parameter is described here :

DB2 10 for z/OS

Application Programming and SQL Guide

SC19-2969-02

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Hi,
I tried by giving the parameter to Y in 17 position of parm .but it failed again.

Nic Clouston · Posted: Thu Oct 08, 2015 6:04 pm

PeterHolland · Posted: Thu Oct 08, 2015 6:09 pm

What position 17 of which parm?

Did you read the manual i pointed you to?

You show totally nothing what you are doing, except whining about failing/not working.

You think we are clairvoyant?

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Hi ,
I gave below parm in my JCL
// EXEC PGM= PGMNAME
// PARM='XXX,XXXXXXX,PGMNAME,,,,,,,,,XXXX,,,,,,Y,DB2REGION',

The 'Y' given in 17 position is to turn Backout Option as YES .

Error Info From Spool :

A system abend 04E occurred in module DSNMTV02 CSECT DSNMTV05 at offset X'48A'.

A DB2 reason code X'00D44056' is associated with this abend and indicates that:

The DB2-DL/I batch support cannot continue because an ROLL or ROLB call
problem was detected by .

=====
Analysis : After doing the analysis , I am able to Understand My ROLB call as shown below is failing and I am getting System abend '04E'

CALL ‘CBLTDLI’ USING ‘ROLB’
IO PCB

thanks

PeterHolland · Posted: Thu Oct 08, 2015 9:07 pm

So and why don't you use the IBM provided procedure, in stead of counting commas and making a count mistake?

Are you just fooling around with stripped supplied procedures?

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Hi Peter ,
I am not able to get any proper reference for this.I am reading on google and trying to implement .

All these days I hAve worked in DB2 only. I am reading and trying to do stuff. I understand it wlll be a very easy for someone who has done it before but I am struggling.

Nic Clouston · Posted: Thu Oct 08, 2015 10:58 pm

Why use Google/ Why not use the official documentation?

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Can you please provide the link.

ravi.singh · New User Joined: 05 Oct 2013 Posts: 18 Location: india

Can you please provide the link.

Rohit Umarjikar · Posted: Thu Oct 08, 2015 11:44 pm

Look at this, check ROLL Vs ROLB and BKO options along with the restriction ( Point #7) , comply to the restriction mentioned.
www-01.ibm.com/support/knowledgecenter/#!/SSEPEK_10.0.0/com.ibm.db2z10.doc.apsg/src/tpc/db2z_planrecoveryimsprograms.dita

Also this,
www-01.ibm.com/support/knowledgecenter/#!/SSEPH2_13.1.0/com.ibm.ims13.doc.sdg/ims_sdrmst03.htm
www-01.ibm.com/support/knowledgecenter/api/content/SSEPH2_13.1.0/com.ibm.ims13.doc.sdg/ims_parameter_descriptions_for_procedures_02.htm
www-01.ibm.com/support/knowledgecenter/#!/SSEPH2_13.1.0/com.ibm.ims13.doc.dag/ims_dynbkout.htm

Akatsukami · Posted: Thu Oct 08, 2015 11:45 pm

The IBM Knowledge Center

Nic Clouston · Posted: Fri Oct 09, 2015 7:15 pm

Why not search for links yourself? There are links to the IBM manuals from the forum (at the very top of the page even before the forum logo).