-904 error on DSNDB06.DSNADX01

Robert Reynolds

-904 error on DSNDB06.DSNADX01
Using DB2 5.1 under OS/390 2.7. While trying to drop a test database we
get a -904. Ran a successful recovery on database and all indexes but
-904 persists.

Any ideas on what to do next? Below is full text of error from SPUFI.

SET CURRENT SQLID = 'SYSADM';
---------+---------+---------+---------+---------+---------+---------+---------

DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------

DROP DATABASE RHIATTDB;
---------+---------+---------+---------+---------+---------+---------+---------

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90094, TYPE OF RESOURCE
00000201, AND
RESOURCE NAME DSNDB06.DSNADX01
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXIDDB SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 70 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000046' X'00000000' X'00000000' X'FFFFFFFF'

X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

Robert Reynolds
Indiana University
[login to unmask email]



Roger Miller

Re: -904 error on DSNDB06.DSNADX01
(in response to Robert Reynolds)
The next step is generally to look up the reason code in the Messages &
Codes.
That looks like your catalog index is in trouble. Start with a REBUILD of
DSNADX01.

Roger Miller



Hilton Tina

Re: -904 error on DSNDB06.DSNADX01
(in response to Roger Miller)
Robert,

Sounds like you have a problem in your catalog (DSNDB06.DSNADX01). Have
your sysprog check it out. It probably needs to be recovered.

00C90094



Explanation: A data set is in a state that is different from what DB2

expects. Possible causes are:



o A data set was deleted and redefined without DB2's knowledge.



o A previous DB2 failure involving the data set might have occurred.

Tina



-----Original Message-----
From: Robert Reynolds [mailto:[login to unmask email]
Sent: Tuesday, December 14, 1999 11:05 AM
To: [login to unmask email]
Subject: -904 error on DSNDB06.DSNADX01


Using DB2 5.1 under OS/390 2.7. While trying to drop a test database we
get a -904. Ran a successful recovery on database and all indexes but
-904 persists.

Any ideas on what to do next? Below is full text of error from SPUFI.

SET CURRENT SQLID = 'SYSADM';
---------+---------+---------+---------+---------+---------+---------+------
---

DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+------
---

DROP DATABASE RHIATTDB;
---------+---------+---------+---------+---------+---------+---------+------
---

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90094, TYPE OF RESOURCE
00000201, AND
RESOURCE NAME DSNDB06.DSNADX01
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXIDDB SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 70 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000046' X'00000000' X'00000000' X'FFFFFFFF'

X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

Robert Reynolds
Indiana University
[login to unmask email]








Leo Flores

Re: -904 error on DSNDB06.DSNADX01
(in response to Hilton Tina)
DSNDB06.DSNADX01 is an index (Grantor,Name) to the SYSDBAUTH DB2 Catalog table.

HTH
Leo Flores

Hilton Tina wrote:

> Robert,
>
> Sounds like you have a problem in your catalog (DSNDB06.DSNADX01). Have
> your sysprog check it out. It probably needs to be recovered.
>
> 00C90094
>
> Explanation: A data set is in a state that is different from what DB2
>
> expects. Possible causes are:
>
> o A data set was deleted and redefined without DB2's knowledge.
>
> o A previous DB2 failure involving the data set might have occurred.
>
> Tina
>
> -----Original Message-----
> From: Robert Reynolds [mailto:[login to unmask email]
> Sent: Tuesday, December 14, 1999 11:05 AM
> To: [login to unmask email]
> Subject: -904 error on DSNDB06.DSNADX01
>
> Using DB2 5.1 under OS/390 2.7. While trying to drop a test database we
> get a -904. Ran a successful recovery on database and all indexes but
> -904 persists.
>
> Any ideas on what to do next? Below is full text of error from SPUFI.
>
> SET CURRENT SQLID = 'SYSADM';
> ---------+---------+---------+---------+---------+---------+---------+------
> ---
>
> DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
> ---------+---------+---------+---------+---------+---------+---------+------
> ---
>
> DROP DATABASE RHIATTDB;
> ---------+---------+---------+---------+---------+---------+---------+------
> ---
>
> DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
> UNAVAILABLE RESOURCE. REASON 00C90094, TYPE OF RESOURCE
> 00000201, AND
> RESOURCE NAME DSNDB06.DSNADX01
> DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
> DSNT415I SQLERRP = DSNXIDDB SQL PROCEDURE DETECTING ERROR
> DSNT416I SQLERRD = 70 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
> DSNT416I SQLERRD = X'00000046' X'00000000' X'00000000' X'FFFFFFFF'
>
> X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
>
> Robert Reynolds
> Indiana University
> [login to unmask email]
>
>
>
>
>
>
>
>



Robert Reynolds

Re: -904 error on DSNDB06.DSNADX01
(in response to Leo Flores)
Thank you to all who replied. I did a RECOVER INDEX (SYSIBM.DSNADX01)
and then the drop worked fine.

Robert Reynolds
Indiana University