View previous topic :: View next topic
|
Author |
Message |
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
---------+---------+---------+---------+---------+---------+---------+---------+ |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
arunkumar81_t
New User
Joined: 06 Aug 2006 Posts: 5
|
|
|
|
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 |
|
|
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 |
|
Back to top |
|
|
yarran
New User
Joined: 01 Nov 2006 Posts: 1 Location: India
|
|
|
|
Try Starting the database using ACCESS(FORCE).
Cheers,
Yarra. |
|
Back to top |
|
|
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.
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 |
|
|
arunkumar81_t
New User
Joined: 06 Aug 2006 Posts: 5
|
|
|
|
That solved the problem mano. Thanks a lot.
Regards
Arun |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
Back to top |
|
|
|