IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

-904 ERROR - Unavailable Resource


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
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
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
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
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
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
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
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
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
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
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10888
Location: italy

PostPosted: Sun Jul 13, 2008 4:58 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts IEW2315E 1369 Link error All Other Mainframe Topics 3
No new posts Help on IMS -API URL migrating from P... IMS DB/DC 1
No new posts JES datasets IO Error ABENDS & Debugging 3
No new posts Error to invoke MPP program through B... IMS DB/DC 3
No new posts PKZIP error ZPFM121E and ZPCE009E JCL & VSAM 6
Search our Forums:

Back to Top