SQL code 804

m_v_anita · New User Joined: 21 Nov 2005 Posts: 1

Hi,

one of our production jobs that was running fine till now is failing with SQL CODE -804.

The DBA says

Load Module Name. . . . . . : SWP.PAN.LOAD(CS004982)
At Address. . . . . . . . : 22D04E48
Load Module Length. . . . : X'921B8'
Link-Edit Date and Time . : 2010/11/04 07:26:34

Can you check this ?? Are you using the correct load module ??

FROM SYSIBM.SYSPACKAGE
QUALIFIER: PACKAGE=SDB23CLST.CS004982
Column Name Column Value
----v----1----v----2----v----3----v----4----v----5----v----6
ISOLATION . . . . . . . . . .
RELEASE . . . . . . . . . . .
EXPLAIN . . . . . . . . . . . Y
QUOTE . . . . . . . . . . . . Y
COMMA . . . . . . . . . . . . N
HOSTLANG . . . . . . . . . . . 3
CHARSET . . . . . . . . . . . A
MIXED . . . . . . . . . . . . N
DEC31 . . . . . . . . . . . . N
DEFERPREP . . . . . . . . . . B
SQLERROR . . . . . . . . . . . N
REMOTE . . . . . . . . . . . . N
PCTIMESTAMP . . . . . . . .2010-11-08-07.59.46.256038 [/size][/size][/size]
IBMREQD . . . . . . . . . . . L

the link edit timestamp is 04/11 while the PCtimestamp is 08/11

we tried recompiling the program but it still fails

Akatsukami · Posted: Thu Nov 11, 2010 4:10 pm

Did you also re-bind the package?

Suthagar · New User Joined: 01 Jul 2005 Posts: 26 Location: Chennai

Hi Anita,

The problem here, timestamp mismatch. Please re do the bind with this package and run it.

Cheers,
Suthagar.S

Rahul Agrawal · New User Joined: 19 Jul 2010 Posts: 9 Location: Noida

Hi,

Shouldn't the job mentioned throw -818 error if its related to time stamp mismatch?

dick scherrer · Posted: Sat Nov 20, 2010 10:50 pm

Hello,

There is a "reason code" associated with the -804 that has not been posted.

sushanth bobby · Posted: Tue Nov 23, 2010 11:00 am

Hi Anita,

This happens to be your first post in 5 years of joining. WOW!!

You have used the search engine, very well i guess.

I dont think -804 is related load module, consistency token or timestamp mismatch. Best way to find out the solution is to check the reason code as dick mentioned.

Sushanth