How can we see the status of the transaction

somapradeep1 · New User Joined: 07 Sep 2010 Posts: 22 Location: hyderabad

i started the transaction px15, it onvokes another transaction px99 with start command

Exec cics start
trans(PX99)
from(ws-data)
length(length of ws-data)
queue('phpp0001')
reqid('php1')
end-exec

exec cics retrieve
into(ws-data)
length(length of ws-data)
end-exec

how can i check the status of the PX99 transaction?

Please advice me....

michael baker · Posted: Sun Oct 23, 2011 6:26 pm

per manual on the world wide web:

publib.boulder.ibm.com/infocenter/cicsts/v3r2/topic/com.ibm.cics.ts.doc/dfha7/transactions/cemt/dfha7mk.html

(as of Sept 2011)

I'm new here too...seems STFM is a good answer to give.

Internet didn't exist when I went to school...at least, not the way it is now (If my memory serves me correctly..Internet was originated by the Military... )

Bill O'Boyle · Posted: Sun Oct 23, 2011 6:53 pm

Are you looking for the task status assigned to this started PX99 transaction or the overall status (health check) of transaction PX99 itself?

The previous post will give you the status of the actual PX99 transaction-id (via CEMT), but not the status of a task assigned to a given/individual PX99.

In other words, if the task-number assigned to your posted START of PX99 was 1234, do you need to know the status of task 1234?

More information is needed.

BTW, your RETRIEVE will raise an ERROR (most likely, ENVDEFERR) because you've omitted the QUEUE keyword, which you specified in the START and TRANS needs to be spelled-out as TRANSID in the START (unless you were prototyping these API's using CECI, where abbreviations can be used).

Mr. Bill

krishna rao M · New User Joined: 10 Feb 2011 Posts: 9 Location: India

I am also having the same trouble, i don't have authorization to use CEMT comand in my proj, I want to see the status of the second transaction(as per example RX99).

Is there any chance to check the status of the RX99 by using CECI or LOG messages or entering Same terminal id/task/queue in application program(both start and retrieve programs). If there any chance Please suggest me.

dick scherrer · Posted: Mon Oct 24, 2011 7:06 am

Hello,

You both may need to simply work with your cics support. . . They should have all of the keys to the cics kingdom.

Many organizations restrict the use of lots of cics transactions, so the only way to have them used is with the cics support.

Most developers find a way to diagnose problems without using the restricted transactions. If you explain what problem you are trying to deal with, someone may have a suggestion.

krishna rao M · New User Joined: 10 Feb 2011 Posts: 9 Location: India

Hi,

I have the authorization to use both the transactions(i mean to run the transaction). But, the second transaction is involved the process of updating the tables in database, it is failing in updating, i hope it is abending with some sql error.

To check the error status of the current transaction , i am using the following code:
move sqlcode to ws-error
EXEC CICS
ABEND ABCODE(ws-error)
END-EXEC

Even both the transactions have above code, but i am only able to check only the status of the first transaction.

I don't have the authorization to use any options in CEMT. I have authorization to use CECI only.

so, Where can i check the error status of the second transaction which is invoked by the first transaction with start command.

Please suggest me.

dick scherrer · Posted: Mon Oct 24, 2011 10:12 am

Hello,

I don't know how to check the status of the second transaction, but if it is your code, you might put a bit of diagnostic code in the second program to show what is happening. Then remove it when the problem is resolved.

Hopefully, the problem can be caused in the development/test environment. . .

krishna rao M · New User Joined: 10 Feb 2011 Posts: 9 Location: India

Hi,

yes, I am working in development.I tried to code only the following code to check status, but second transaction is not showing any message related to to the second transaction in current terminal.

move sqlcode to ws-error
EXEC CICS
ABEND ABCODE(ws-error)
END-EXEC
EXEC CICS
RETURN
END-EXEC

Is ther any other alternative to code in program?
or
Is there any chance to mention current terminal information in Retrieve and start(i already coded terminal id here) so that any hope to see the notification of the second transaction?

dick scherrer · Posted: Tue Oct 25, 2011 12:52 am

Hello,

Bill O'Boyle · Posted: Tue Oct 25, 2011 1:02 am

Because you're not assigning the PX99 Transid to a terminal, before invoking the task that issues the start of PX99, enter (from a clear screen) -

CEDX PX99

When PX99 is invoked, you'll be able to step through it (CICS commands only) and check its execution status.

If this is Production, then you probably don't have authority.

However, if this is non-production, the CICS version/release must be (at a minimum) CICS/ESA 4.1, which was introduced 12-14 years ago, where CEDX was first included.

Mr. Bill

krishna rao M · New User Joined: 10 Feb 2011 Posts: 9 Location: India

Hi,

Thanks for both Mr. Bill and Mr. dick scherrer for valuable information, CEDX is working.

Dick scherrer, I have Debug tool DTCN and other panel to give new copy(i don't have CEMT authorization). I think, i can only debug current transaction only. Is there any option either in Xpediter or DTCN to debug both the transactions(the second transaction is invoked by the first transaction with start command).

shaqeel.mohds · New User Joined: 06 Jul 2010 Posts: 8 Location: Chennai

Only CICS admintrators will have access to CEMT.

Robert Sample · Posted: Sat Oct 29, 2011 8:28 am

Mohammed Shoaib, a blanket statement such as you made is rarely correct. Many sites allow programmers access to the CEMT transaction in test regions so they can compile / newcopy / execute their programs repeatedly. At these sites, you cannot say

krishna rao M · New User Joined: 10 Feb 2011 Posts: 9 Location: India

Bill, whatever you told is correct, CEDX is not allowing me to debug because these transactions are global(prod N test).

Good news, I passed same terminal id, so i can able to Debug both trans in my debug tool.

Thanks all.