-904 Error: UNAVAILABLE RESOURCE

IBM Mainframe Forums -> CICS

Quick References

View previous topic :: View next topic

Author

Message

sijayapal

New User

Joined: 23 Dec 2008
Posts: 69
Location: India

Code:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90082, TYPE OF RESOURCE 00000210,
AND RESOURCE NAME RMDB01 .RMC2TS .00000001
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 102 13172746 0 13223106 -974970878 12714050 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000066' X'00C9000A' X'00000000' X'00C9C4C2'
X'C5E32002' X'00C20042' SQL DIAGNOSTIC INFORMATION

I tried to load the database using FILE AID load TAble from dataset option. There was a mismatch in the data layout and it got abend. And now the table is not available. I purged the jobs. Even now its not available. When i try to browse the table i am getting the above error.

Code:

//UTIL EXEC PGM=DSNUTILB,PARM='DB2T,N196516',REGION=4096K
//STEPLIB DD DSN=SYICMD1.DB2T.SDSNEXIT,
// DISP=SHR
// DD DSN=SYICMD1.DB2T.SDSNLOAD,
// DISP=SHR
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//*
//SORTWK01 DD DSN=N196516.SORTWK01,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSDA
//SORTWK02 DD DSN=N196516.SORTWK02,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSDA
//SORTWK03 DD DSN=N196516.SORTWK03,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSDA
//SORTWK04 DD DSN=N196516.SORTWK04,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSDA
//SYSREC DD DSN=&LOADTMP,
// DISP=(OLD,DELETE,DELETE)
//SYSUT1 DD DSN=N196516.SYSUT1,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSDA
//SORTOUT DD DSN=N196516.SORTOUT,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSDA
//SYSERR DD DSN=N196516.SYSERR,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSDA
//SYSMAP DD DSN=N196516.SYSMAP,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(16384,(20,20),,,ROUND),
// UNIT=SYSDA
//SYSIN DD *
LOAD DATA
REPLACE
ENFORCE NO
INTO TABLE
"Creator"."Table name"
(All the table fields here )

So how can i solve the problem. What would have happend???
Please help me...

GaganGarg

Active User

Joined: 31 Mar 2010
Posts: 134
Location: India

Hi Sijayapal,

You need to run the following step in a jcl, only then you will be able to access the table:

Code:

//REPAIR01 EXEC PGM=DSNUTILB,
// PARM=(DB2T,'N196516'),
// REGION=0M
//ABNLIGNR DD DUMMY
//DSSPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
REPAIR SET INDEX (ALL) TABLESPACE database.tablespace NOCOPYPEND
/*

Code:

//CHECK01 EXEC PGM=DSNUTILB,
// PARM=(DB2T,'N196516'),
// REGION=0M
//ABNLIGNR DD DUMMY
//DSSPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSUT1 DD SPACE=(CYL,(50,25),RLSE),VOL=(,,,20)
//SORTOUT DD SPACE=(CYL,(50,25),RLSE),VOL=(,,,20)
//SYSERR DD SPACE=(CYL,(50,25),RLSE),VOL=(,,,20)
//SYSIN DD *
CHECK DATA TABLESPACE database.tablespace SCOPE ALL
//*

run both the steps. you will be able to access the table.
And, always make it a good habit to use repair step after LOADING the table. And one more thing, if repair step is used, DONOT use the steplib while loading as Job will throw S04E abend at the repair step & It will lead you to face -904 again while accessing the table

Thanks

View previous topic :: :: View next topic

View Bookmarks
All times are GMT + 6 Hours

Forum Index -> CICS

Topic		Forum	Replies
Similar Topics
	Error to read log with rexx	CLIST & REXX	11
	Error when install DB2	DB2	2
	CLIST - Virtual storage allocation error	CLIST & REXX	5
	Error while running web tool kit REXX...	CLIST & REXX	5
	Getting Error while trying to establi...	DB2	3

Search our Forums:

IBMMainframes.com is not an official and/or affiliated with IBM^® in anyway
Board Rules \| FAQ \| Downloads \| Wiki \| SiteMap \| Contact Us