View previous topic :: View next topic
|
Author |
Message |
Lijo
New User
Joined: 24 Aug 2008 Posts: 41 Location: Cochin
|
|
|
|
Hi,
When we ran a reorg job the table space went to REORG PENDING status and that reorg utility got terminated.
Then when we tried START ACCESS (FORCE) it was giving ABNORMAL TERMINATION
Please suggest, how to recover from the this status.
DSNT360I - ***********************************
DSNT361I - * DISPLAY DATABASE SUMMARY
* GLOBAL
DSNT360I - ***********************************
DSNT362I - DATABASE = LESCODD2 STATUS = RW
DBD LENGTH = 2160320
DSNT397I -
NAME TYPE PART STATUS PHYERRLO PHYERRHI CATALOG PIECE
-------- ---- ----- ----------------- -------- -------- -------- -----
LESCODS2 TS RW,AREO*
AK01101G IX RW
AK0110GY IX RW
AK0110SM IX RW |
|
Back to top |
|
|
tarun_bhardwaj
New User
Joined: 18 Jul 2003 Posts: 39 Location: delhi
|
|
|
|
Hi Lijo,
You can use the following step:
Code: |
//JS010 EXEC PGM=DSNUTILB,PARM='DB2,AXX.TS',
// REGION=3000K,COND=(4,LT)
//STEPLIB DD DISP=SHR,DSN=DNDDB2.DB2.SDSNLOAD
//DSNTRACE DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SORTWK01 DD UNIT=SYSDA,SPACE=(TRK,(1,5))
//SYSIN DD *
REPAIR SET TABLESPACE XXXXXXXX.YYYYY NOAREORPENDSTAR |
|
|
Back to top |
|
|
Lijo
New User
Joined: 24 Aug 2008 Posts: 41 Location: Cochin
|
|
|
|
Thanks Tarun... |
|
Back to top |
|
|
|