Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

S04E Abend with REASON 00C200EC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rupa.srini

New User


Joined: 25 Nov 2008
Posts: 5
Location: Chennai

PostPosted: Fri Jan 30, 2009 11:37 am    Post subject: S04E Abend with REASON 00C200EC
Reply with quote

Hi,
I am trying to append the DB2 table having the below control card.

LOAD DATA LOG NO INDDN SYSREC00 RESUME YES NOCOPYPEND
ENFORCE CONSTRAINTS
INTO TABLE GNC.RTE_CD_DTL



Got the Abend S04E, and SQL status as -904 .

DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00C200EC
TYPE 00000200
NAME DGNCTYDB.TGNCRTCD

Here in this when tried to explore found the that TYPE 00000200 refers to tablespace.

What might be the cause for the Abend?


Kindly help out.
Back to top
View user's profile Send private message

Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Fri Jan 30, 2009 12:12 pm    Post subject:
Reply with quote

Quote:
DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00C200EC
TYPE 00000200
NAME DGNCTYDB.TGNCRTCD


This is the cause for the abend.

The database is DGNCTYDB
Tablespace is TGNCRTCD
Repair the tablespace if you have authority.

The command is
Code:
-start db(dbname) sp(tsname) access(force)


Run it as a DB2 command thru JCL.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2284
Location: @my desk

PostPosted: Fri Jan 30, 2009 1:43 pm    Post subject:
Reply with quote

Bharath Bhat,

The command you gave is for 'START'ing a tablespace. Is n't the 'REPAIR' command something like this.
Code:
 REPAIR SET TABLESPACE dbname.tsname NOCOPYPEND
I would suggest verifying the status of the tablespace and act accordingly. If it is in 'Copy Pending' status, you would need a NOCOPYPEND. The action to be taken depends on the current status of the tablespace.
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Fri Jan 30, 2009 1:56 pm    Post subject:
Reply with quote

arcvns wrote:
Bharath Bhat,

The command you gave is for 'START'ing a tablespace. Is n't the 'REPAIR' command something like this.
Code:
 REPAIR SET TABLESPACE dbname.tsname NOCOPYPEND
I would suggest verifying the status of the tablespace and act accordingly. If it is in 'Copy Pending' status, you would need a NOCOPYPEND. The action to be taken depends on the current status of the tablespace.



Thanks for correcting me. But in my shop, We rectify -904 errors in the way I described. It works for us.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us