Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Batch db2 job throwing RC=330

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Mon Mar 23, 2009 3:48 am    Post subject: Batch db2 job throwing RC=330
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Mar 23, 2009 4:00 am    Post subject:
Reply with quote

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
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Mar 23, 2009 4:03 am    Post subject: Re: Batch db2 job throwing RC=330
Reply with quote

vebs wrote:
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.
Are you saying that
| -330 A STRING CANNOT BE USED BECAUSE IT CANNOT BE CONVERTED. REASON reason-code, CHARACTER code-point, HOST VARIABLE position-number
Explanation: A translation error occurred during the translation of a string to a different coded character set. The type of error is indicated by the reason-code:
8 Length exception (for example, expansion required for PC MIXED data exceeds the maximum length of the string).
12 Invalid code point (for example, use of the ERRORBYTE option of SYSSTRINGS).
16 Form exception (for example, invalid MIXED data).
| 20 Conversion procedure error (for example, an exit set the length control field of the string to an invalid value).
24 SBCS character found in string contained in a wchar_t host variable.

was not helpful?
Back to top
View user's profile Send private message
vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Mon Mar 23, 2009 4:10 am    Post subject:
Reply with quote

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
View user's profile Send private message
vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Mon Mar 23, 2009 4:13 am    Post subject:
Reply with quote

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
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Mar 23, 2009 4:25 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Mar 23, 2009 4:47 am    Post subject:
Reply with quote

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
View user's profile Send private message
vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Mon Mar 23, 2009 5:04 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Mar 23, 2009 6:16 am    Post subject: Reply to: Batch db2 job throwing RC=330
Reply with quote

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 icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How does a called pgm know if its cal... Graeme Westerman COBOL Programming 4 Tue Nov 29, 2016 9:25 pm
This topic is locked: you cannot edit posts or make replies. MIPS reduction for Batch job Virendra Shambharkar All Other Mainframe Topics 8 Mon Nov 07, 2016 4:02 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts How to show message using batch jobs madprasy TSO/ISPF 7 Fri Sep 09, 2016 6:55 pm
No new posts Don't allow CICS to submit batch jobs prino JCL & VSAM 5 Mon Jul 25, 2016 3:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us