View previous topic :: View next topic
|
Author |
Message |
vebs
New User
Joined: 27 Oct 2007 Posts: 19 Location: UK
|
|
|
|
Hi, I need your assistance here..
I recently made a few changes to a batch-db2 job to get the CPU consumption. The changes included only - breaking an INNER JOIN into two queries, and including one Working storage table to use Result Set later in program.
Surprisingly, job started giving RC=330, its not throwing any Dump, no messages in log...just a 330. I observed that it happens after it processing a few input records.
The explanation in IBM Manual doesnt help much.... The program is compiled as DATA(24).
Please let me know any other information you may require on this. Thanks! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Do you mean a return code 330 or is this a -330 from sql?
If it is a return code 330, the code issued the return code and the code must be looked at to determine why.
Quote: |
The explanation in IBM Manual doesnt help much.... |
Post the part of the explanation that you don't understand.
If this is an sql return code, there is also a reason-code that you did not post.
It sounds like the new code has promlems. How extensively was it tested before being put into production?
Because you've chosen to post nearly nothing to help us help you, you may not get the replies you would prefer. . . |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
Back to top |
|
|
vebs
New User
Joined: 27 Oct 2007 Posts: 19 Location: UK
|
|
|
|
Thanks Dick for your quick turnaround.
This is not a SQL code. The batch step running the changed program is returning RC=330.
The code has not yet moved to production, it is in testing phase.
I would have liked to post CEEDUMP or whatever the job would have provided, but it is giving only this to me -
Code: |
PROCSTEP RC EXCP CONN
PS030 330 407 331
|
For other errors, the job used to write a dump, it helped us in research, but for this RC, job is not throwing any dump as well... No dump, no reason codes,... is there anyway I could force test job throw a dump..
I am sorry, i know I am not posting enough, but the only reason is, job isnt telling me anything about it..... Thanks... |
|
Back to top |
|
|
vebs
New User
Joined: 27 Oct 2007 Posts: 19 Location: UK
|
|
|
|
CICS guy,
nothing to do with -330, its a 330 from batch step -
IBM manual says this -
Code: |
Explanation: An unauthorized task attempted to use authorized options of the DEQ macro instruction during the processing of global resource serialization.
Register 15 may contain a reason code associated with this error
|
The job isnt throwing any dump, any reason code.... job isnt helping me.. let me know anything I can do to help you decipher this... Thanks, |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
vebs wrote: |
Code: |
Explanation: An unauthorized task attempted to use authorized options of the DEQ macro instruction during the processing of global resource serialization.
Register 15 may contain a reason code associated with this error
|
|
Sorry....
The word "authorized" would have me checking with the RACF/TS people and, if it was their refusal, look at their logs for more info..... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Has the code been checked to see if/where the rc 330 is being set?
Quote: |
IBM manual says this |
Which IBM manual? The 330 may be completely dependent on this code, not something generic from IBM.
It sounds like there is something going on besides the change to the inner join.
Is there any sql that is not being checked for a successful return code?
You might compare the new versioni of the code against the "old" code that worked and see if there are any "extra" differences. |
|
Back to top |
|
|
vebs
New User
Joined: 27 Oct 2007 Posts: 19 Location: UK
|
|
|
|
Hi all,
Thanks for your help.... I continued the testing..as following is the solution....... As strange as it may sound, it is true..
1. I observed that it was failing after processing a certain no. of input records..
2. VERY STRANGE OBSERVATION - when I started reducing the no. of input records in input file, and continued re-testing - The job step started giving following outputs :
For nearly 100 records - it gave 220 as RC = no Mention of 220 as a valid z/OS return code .
For nearly 75 records - it gave 200 as RC.
For nearly 50 records - it gave 12 as RC.
I have never seen RC of a step changing this drastically, w.r.t number of input records..
3. A scrutiny of code showed that I missed to check one certain Table overflow condition in the code.. I included the same, and everything was fine..
4. The strangest thing that I cant get my head around is - how can RC of a step change so drastically, and mis-lead us.....
Anyways, thanks all for your inputs.. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Scan the code for references of RETURN-CODE.
Quote: |
how can RC of a step change so drastically |
Because it is under control of the code.
I'm fairly sure that the rc is being set/calculated by the code. I'm also fairly sure this is none of the "standard" return codes issued/documented by IBM.
Good to hear it is working - thanks for letting us know
d |
|
Back to top |
|
|
|