-904 ERROR - Unavailable Resource

arunkumar81_t · New User Joined: 06 Aug 2006 Posts: 5

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
---------+---------+---------+---------+---------+---------+---------+---------+

mano · New User Joined: 23 Mar 2006 Posts: 17 Location: chennai

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

arunkumar81_t · New User Joined: 06 Aug 2006 Posts: 5

Hi

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

Regards

Arun

mano · New User Joined: 23 Mar 2006 Posts: 17 Location: chennai

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

arunkumar81_t · New User Joined: 06 Aug 2006 Posts: 5

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

arunkumar81_t · New User Joined: 06 Aug 2006 Posts: 5

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

yarran · New User Joined: 01 Nov 2006 Posts: 1 Location: India

Try Starting the database using ACCESS(FORCE).

Cheers,
Yarra.

mano · New User Joined: 23 Mar 2006 Posts: 17 Location: chennai

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

arunkumar81_t · New User Joined: 06 Aug 2006 Posts: 5

That solved the problem mano. Thanks a lot.

Regards

Arun

Shivakumar_ip · New User Joined: 18 Jul 2006 Posts: 2

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

enrico-sorichetti · Posted: Sun Jul 13, 2008 4:58 pm

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