|
View previous topic :: View next topic
|
| Author |
Message |
P.RAJESH
Currently Banned
New User
.jpg)
Joined: 20 Mar 2008
Posts: 54
Location: chennai
|
|
|
|
Hi all,
I searched the forum for my answer but i couldn't find exactly so that I'm posting this question.
I got sqlcode -818 while exeuting JCL, it is trying to download from a table using DSNTIAUL utality.
The spool message shown below,
| Code: |
DSNT408I SQLCODE = -818, ERROR: THE PRECOMPILER-GENERATED TIMESTAMP 183CF9C0045
FROM THE BIND TIMESTAMP 1874B82B00A2B823 BUILT FROM THE DBRM DSNTIAUL
DSNT418I SQLSTATE = 51003 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -200 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF38' X'00000000' X'00000000' X'FFFFFFFF' X'0000
INFORMATION |
Details of subsystem,Planname,library.
| Code: |
DSN SYSTEM(DB01)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB81) PARM('SQL') -
LIBRARY(DB01S.PROD.RUNLIB.LOAD) |
Please let me know if more information need and Please tell me what's wrong this.
Edited: Please use BBcode when You post some code/error, that's rather readable, Thanks... Anuj |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| What did it say in the manual about the error code and the corrective actions ? |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
BIND the program again & try. |
|
| Back to top |
|
|
P.RAJESH
Currently Banned
New User
Joined: 20 Mar 2008
Posts: 54
Location: chennai
|
|
|
|
Hi Expat/Anju,
Thanks for you replies.
The problem got solved but i am not clear so i want to be clear.
I will you how it was solved,The loadmodule of DSNTIAUL is there in DB01S.PROD.RUNLIB.LOAD but while exuting the JCL it referring to USERID.DB01S.PROD.RUNLIB.LOAD so i hard coded the DB01S.PROD.RUNLIB.LOAD with single quotes insided the control card.
But still i'am bit confused and not cleart what are all the reasons of getting -818 and how to resolve.If possbile can any of you please explain ? |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| P.RAJESH wrote: |
| Hi Expat/Anju, |
'am getting insane..  |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
| P.RAJESH wrote: |
| The loadmodule of DSNTIAUL is there in DB01S.PROD.RUNLIB.LOAD but while exuting the JCL it referring to USERID.DB01S.PROD.RUNLIB.LOAD so i hard coded the DB01S.PROD.RUNLIB.LOAD with single quotes insided the control card. |
This does not sound like a solution for the problem asked in the very first post of this thread - please show us the JCL used & tell us what change was done to get it executed successfully. |
|
| Back to top |
|
|
Cristopher
New User
Joined: 31 Jul 2008
Posts: 53
Location: NY
|
|
|
|
RAJESH,
You will get -818 when the DBRM consistency token (i.e. the time stamp) does not match the load module.
This can occur when a compile is partially successful and the load module consistency token doesn’t match the current DBRM. If a recompile doesn’t resolve the problem, it may be necessary to STEPLIB over to the proper load libraries.
So, in your case -818 got resolved when you pointed to the correct loadlib for DSNTIAUL.
Hope this helps.
Cris |
|
| Back to top |
|
|
P.RAJESH
Currently Banned
New User
Joined: 20 Mar 2008
Posts: 54
Location: chennai
|
|
|
|
Hi Anuj, First of all I'm sorry for misplacing yourname and late reply.
In our LPAR the loadmodule of DSNTIAUL is there in DB01.PROD.RUNLIB.LOAD, In my execution it is refering to USERID.DB01S.PROD.RUNLIB.LOAD. i saw this message in JESMESSAGES.
Spool is cleared now i can't show the message, I will back again with message by executing th job loacally ( I'm off for the last two days ) |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi Rajesh,
| P.RAJESH wrote: |
| Hi Anuj, First of all I'm sorry for misplacing yourname and late reply. |
Not to worry, that day couple of people used it this way so.. 
| Quote: |
| Spool is cleared now i can't show the message, I will back again with message by executing th job loacally ( I'm off for the last two days ) |
Can you please show the JCL used instead? |
|
| Back to top |
|
|
|
|
