IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error during DB2 load.
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Amsar

New User


Joined: 26 Sep 2008
Posts: 84
Location: Chennai
PostPosted: Wed Oct 20, 2010 10:21 pm
 Reply with quote
Hi All,

I was running the DB2 LOAD job which initialy failed with Resourece unavailable Error.
Then i have checked the database.tablespace which was in RW UT (forgot exact status).

Then i have start the database with
START DATABASE(xxxxxx) SPACE(xxxxx) ACCESS(FORCE) command
and it went into RW staus.

When i have restarted the job i am getting error message

Code:
DSNU018I  -DBT3 293 08:46:29.11 DSNUGASU - JOB IS NOT RESTARTABLE DUE TO -START DATABASE ACCESS FORCE COMMAND   

SNU016I    293 08:46:29.12 DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40018'



I have search thru google for this error message but did't got much

Please let me know your thought's!!!


Thanks,
Amsar
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
PostPosted: Wed Oct 20, 2010 10:35 pm
 Reply with quote
By using the START DATABASE ACCESS FORCE command, you have made the job non-restartable. Use -TERM UTILITY to terminate the utility icon_rolleyes.gif and resubmit the job ab initio.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts How to load to DB2 with column level ... DB2 6
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us