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
 

 

-904 ERROR - Unavailable Resource

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

New User


Joined: 06 Aug 2006
Posts: 5

PostPosted: Wed Nov 08, 2006 12:10 pm    Post subject: -904 ERROR - Unavailable Resource
Reply with quote

I get this error when i try to display the contents of a table. I have posted the complete error. Plz help..

---------+---------+---------+---------+---------+---------+---------+---------+
SELECT * FROM CCC.T3046;
---------+---------+---------+---------+---------+---------+---------+---------+
MSG_ID_NO MSG_KEYSET_ID_NO MSG_VBL_ID_NO MSG_KEY_VAL_DS
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE610I NUMBER OF ROWS DISPLAYED IS 0
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C900A0, TYPE OF RESOURCE 00000200, AND
RESOURCE NAME D0155CCC.SZXPI
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 102 13172746 0 13223106 -974970876 12714050 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000066' X'00C9000A' X'00000000' X'00C9C4C2'
X'C5E32004' X'00C20042' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
Back to top
View user's profile Send private message

mano

New User


Joined: 23 Mar 2006
Posts: 17
Location: chennai

PostPosted: Wed Nov 08, 2006 12:28 pm    Post subject: -904 ERROR
Reply with quote

Hi

First check whether the utility is running behind in batch.If so terminate the utility and check whether the table has gone in recovery pending or copy pending.If so repair and rebuild the tablespace and try using the above query.It will work fine
Back to top
View user's profile Send private message
arunkumar81_t

New User


Joined: 06 Aug 2006
Posts: 5

PostPosted: Wed Nov 08, 2006 12:49 pm    Post subject:
Reply with quote

Hi

I checked the and the table has not gone recovery pending. In this case what should i do ?


Regards

Arun
Back to top
View user's profile Send private message
mano

New User


Joined: 23 Mar 2006
Posts: 17
Location: chennai

PostPosted: Wed Nov 08, 2006 2:21 pm    Post subject: Re: -904 ERROR - UNAVAILABLE RESOURCE
Reply with quote

Hi
I checked in google and it says the
TYPE OF RESOURCE 00000200 is for tablespace
REASON 00C900A0 - Exception Tablespace in Rebuild/Recovery pending mode
in DB2 COMMANDS please issue this command -DIS UTILITY(Utilityname)
and check the STATUS.If the status is running then
issue -TERM UTILITY(utilityname)

you can check the display of tablespace with using commands

-DIS DB(MMLPDDDB) SPACENAM(MMLPD61T) LIMIT(*)


********************************* Top of Data *********************************
DSNT360I - ***********************************
DSNT361I - * DISPLAY DATABASE SUMMARY
* GLOBAL
DSNT360I - ***********************************
DSNT362I - DATABASE = MMLPDDDB STATUS = RW
DBD LENGTH = 185744
DSNT397I -
NAME TYPE PART STATUS PHYERRLO PHYERRHI CATALOG PIECE
-------- ---- ----- ----------------- -------- -------- -------- -----
MMLPD61T TS 0001 RW UTUT

**********************
DSN9022I - DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION

If UTUT is found then follow the steps mentioned above
Back to top
View user's profile Send private message
arunkumar81_t

New User


Joined: 06 Aug 2006
Posts: 5

PostPosted: Wed Nov 08, 2006 3:06 pm    Post subject:
Reply with quote

This is what I get when i give the command -dis db


Code:
 DSNT360I  -DB2T ***********************************                     
 DSNT361I  -DB2T *  DISPLAY DATABASE SUMMARY                             
                 *    GLOBAL                                             
 DSNT360I  -DB2T ***********************************                     
 DSNT362I  -DB2T     DATABASE = D0155CCC  STATUS = RW                   
                    DBD LENGTH = 117092                                 
 DSNT397I  -DB2T                                                         
 NAME     TYPE PART  STATUS            PHYERRLO PHYERRHI CATALOG  PIECE 
 -------- ---- ----- ----------------- -------- -------- -------- ----- 
 SZXPI    TS         RW,RECP                                             
 ******* DISPLAY OF DATABASE D0155CCC ENDED      ********************** 
 DSN9022I  -DB2T DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION           

There is no UTUT as you have mentioned. Plz help....
Back to top
View user's profile Send private message
arunkumar81_t

New User


Joined: 06 Aug 2006
Posts: 5

PostPosted: Wed Nov 08, 2006 3:22 pm    Post subject:
Reply with quote

Hi mano,

From the status of the Tablespace. I see that its RECP. It is Recovery Pending. How can i rectify this.

Pls help

Regards

Arun
Back to top
View user's profile Send private message
yarran

New User


Joined: 01 Nov 2006
Posts: 1
Location: India

PostPosted: Wed Nov 08, 2006 3:59 pm    Post subject: 904 ERROR - UNAVAILABLE RESOURCE
Reply with quote

Try Starting the database using ACCESS(FORCE).

Cheers,
Yarra.
Back to top
View user's profile Send private message
mano

New User


Joined: 23 Mar 2006
Posts: 17
Location: chennai

PostPosted: Wed Nov 08, 2006 4:51 pm    Post subject: Re: -904 ERROR - UNAVAILABLE RESOURCE
Reply with quote

Try using the following JCL to repair the tablespace.It may solve your problem.

Code:
//UTIL EXEC DSNUPROC,SYSTEM=DSN,UID='',UTPROC=''
//*
//*
//DSNUPROC.SYSUT1   DD  UNIT=DASD,SPACE=(TRK,(1,1))
//DSNUPROC.SORTWK01   DD  UNIT=DASD,SPACE=(TRK,(1,1))
//DSNUPROC.SORTWK02   DD  UNIT=DASD,SPACE=(TRK,(1,1))
//DSNUPROC.SYSIN    DD  *
 REPAIR SET TABLESPACE BMBMR3DB.ITRTNTS NORCVRPEND
//
Back to top
View user's profile Send private message
arunkumar81_t

New User


Joined: 06 Aug 2006
Posts: 5

PostPosted: Thu Nov 09, 2006 10:01 am    Post subject:
Reply with quote

That solved the problem mano. Thanks a lot.

Regards

Arun
Back to top
View user's profile Send private message
Shivakumar_ip

New User


Joined: 18 Jul 2006
Posts: 2

PostPosted: Sun Jul 13, 2008 3:16 pm    Post subject: Error occured while tryimg to drop the table(Same with DMLs)
Reply with quote

Menu Utilities Compilers Help
-------------------------------------------------------------------------------
BROWSE SOFTAAA.OUTPUT.DATA Line 00000000 Col 001 080
Command ===> Scroll ===> HALF
********************************* Top of Data **********************************
---------+---------+---------+---------+---------+---------+---------+---------+
DROP TABLE SOFTAGS.P;
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C200B8, TYPE OF RESOURCE 00000300, AND
RESOURCE NAME DSNDB06.SYSDBASE.X'0000022C'
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXIDTB SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 130 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000082' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE601I SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72
DSNE620I NUMBER OF SQL STATEMENTS PROCESSED IS 1
F1=Help F2=Split F3=Exit F5=Rfind F7=Up F8=Down F9=Swap
F10=Left F11=Right F12=Cancel
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10257
Location: italy

PostPosted: Sun Jul 13, 2008 4:58 pm    Post subject: Reply to: -904 ERROR - UNAVAILABLE RESOURCE
Reply with quote

the resource type 00000300 is for a page,

the problem determination and resolution might not be just a couple of displays and a couple of commands

it would be better for You to start working on it with Your support group

here for future reference a link to the page with the resource types
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 DB2 Program abending without giving a... rahulgarg14 DB2 3 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


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