View previous topic :: View next topic
|
Author |
Message |
santosh100678
New User
Joined: 21 Sep 2009 Posts: 55 Location: Kolkatta
|
|
|
|
Hi,
Please help is it any option in spufi where we can repair table sapce.
means when i face -904 then we have set of job which repair table space
so is there in option to repair that. |
|
Back to top |
|
|
lokesh vasanthi
New User
Joined: 19 Aug 2005 Posts: 17 Location: Chennai, India
|
|
|
|
Hi,,
You can remove the Check pending status through Platinum or JCL
Through Platinum: Use below command
-STA DB(Database Name) SPACE(Tablespace name) ACCESS(FORCE)
Through JCL:
//JSTY0060 EXEC PGM=DSNUTILB,REGION=4M,
// PARM='Subsystem name,Repair,'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSABEND DD SYSOUT=*
//SYSIN DD *
REPAIR SET TABLESPACE Database Name.Tablespace Name NOCOPYPEND
REPAIR SET TABLESPACE Database Name.Tablespace Name NOCHECKPEND |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you understand what caused the check pending before just "fixing" it . . . |
|
Back to top |
|
|
santosh100678
New User
Joined: 21 Sep 2009 Posts: 55 Location: Kolkatta
|
|
|
|
please suggest me any option in spufi, if any option in spufi then please provide me screen shot |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
not in spufi
-904 can have several reasons, only one being check pending |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
What is the reason code?
As Guy mentions, it might not even be a "check pending". . . |
|
Back to top |
|
|
santosh100678
New User
Joined: 21 Sep 2009 Posts: 55 Location: Kolkatta
|
|
|
|
Hi,
when i browse the table thru spufi then i face error -904 resource unavailable. then i know that table is in check pending status .regularly we made check the index name and submit the job for remove check pending state . |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
[condescending mode]Young man,
We all have different native languages, so misunderstandings happen often.
If you don't even bother to reread you messages and correct the simpliest typo's , you unnecessarily complicate our understanding of what you mean.
Answering is voluntary, and this kind of disrespect just might cost you some useful information.[/condescending mode] |
|
Back to top |
|
|
|