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
 

 

Resource Unavailable on Index of DB2 table

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

New User


Joined: 13 Aug 2007
Posts: 12
Location: Pune, India

PostPosted: Wed May 12, 2010 12:46 pm    Post subject: Resource Unavailable on Index of DB2 table
Reply with quote

Hi,

I was loading data into table using batchjob.
While loading data, I encountered error.
Error message was 'Resource unavailable on Index.'
If I run reorg on Index for this table, index will be available for loading data or not?
Please reply to my query.

Regards,
Gopal
Back to top
View user's profile Send private message

Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed May 12, 2010 2:13 pm    Post subject:
Reply with quote

I am not DBA but it would help if you post exact error message with error code in the spool...
Back to top
View user's profile Send private message
gopalkulkarni

New User


Joined: 13 Aug 2007
Posts: 12
Location: Pune, India

PostPosted: Wed May 12, 2010 2:21 pm    Post subject:
Reply with quote

Error message is given below :
_______________________________________________________________
ERROR LOADING INDEX, ERROR = X'00E40322', INDEX = region.indexname
DSNUGSAT - RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DAUG.DSNDBC.DDW6DOMI.XDWDAGY1.J0001.A001
DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40322' CAUSE=X'00E40322'
DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347'
_______________________________________________________________
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed May 12, 2010 2:27 pm    Post subject:
Reply with quote

Is DAUG.DSNDBC.DDW6DOMI.XDWDAGY1.J0001.A001 is available and not migrated?
Refer
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.codes/n171.htm
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Wed May 12, 2010 3:12 pm    Post subject:
Reply with quote

most common causes :
index is defined to small (PRIQTY/SECQTY) for the number of rows you're loading
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Wed May 12, 2010 9:50 pm    Post subject:
Reply with quote

Check if DAUG.DSNDBC.DDW6DOMI.XDWDAGY1.J0001.A001 is available ?
I think running REORG on TS will probable give the same error; drop and recreate the index.
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 Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts How to find a CICS resource used in C... Arunkumar Chandrasekaran CICS 8 Thu Sep 29, 2016 1:45 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm


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