MVSFORUMS.com

MFdigger

Hi All,

I'm facing with -904 SQLCODE when trying to execute my program. When I debugged the program, its a simple SELECT query which causing the error.

EXEC SQL
SELECT
I_DKM
INTO
:DKM-MON-T
FROM
A.KVKDKMT
WHERE
I_DKM_LIST = 'ABCD'
END-EXEC

When I run the query in QMF its retreving the results with out any issues.

The error message showing up as:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C900AE, TYPE OF RESOURCE 00000201, AND RESOURE NAME K211 .KVKDKMT1

DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR

Could some one please guide on how I can proceed on this?

Thank you
Rolling Eyes

_________________
Tx
Digger

warp5 · Posted: Mon Aug 25, 2008 12:35 am Post subject:

K211 .KVKDKMT1T is not available for you. It is not in the databank, or maybe you misspelled, or maybe you are using the wrong databank system, or .....

acevedo · Posted: Mon Aug 25, 2008 4:26 am Post subject:

is there any other job wich updates (update,delete,insert) at the time your program is running (or even your own program) without a COMMIT control?

acevedo · Posted: Mon Aug 25, 2008 4:28 am Post subject:

ooops, I think that the COMMIT issue is for -911.

Wink

jsharon1248 · Posted: Mon Aug 25, 2008 8:07 am Post subject:

So when you looked up the error code in the manual and saw this, is there something specific that you didn't understand?

[code:1:79fb6c23b5]00C900AE
Explanation: An attempt was made to allocate or access an index that is in the rebuild pending status.

System Action: The use of the object is not allowed.
User Response: Determine when the resource is available for use and rerun the job.

Operator Response: Determine whether the REBUILD utility should be run to complete recovering the object.

Problem Determination: The requested operation is not performed because the index may be in an inconsistent state. An SQLCODE -904 and/or message DSNT501I and/or message DSNI005I is issued. For more information, refer to Part 2,

MFdigger · Posted: Mon Aug 25, 2008 3:48 pm Post subject:

Hi All

Thank you for your quick resonponse. I came to know that there were some jobs which were doing the RUNSTATS for the table, at the same time I was trying to test my program.

I ran my job a little later and it worked for me.

Thank you once again.

Smile

_________________
Tx
Digger